Oracle Web ADI Error: Web ADI Invalid Integrator Key

Error: Web ADi Invalid Integrator Key


For Specific user level, we have to set the following profile option 'YES', If user not having System Administrator Responsibility

Solution: 'BNE Allow No Security Rule' as Yes at the User level

Oracle First and Last Date of current year & previous year query

–> First Day of Current Year:

SELECT TRUNC (SYSDATE , ‘YEAR’) FROM DUAL;

–> Last Day of Current Year:

SELECT ADD_MONTHS(TRUNC (SYSDATE ,’YEAR’),12)-1 FROM DUAL;

–> First Day of Previous Year:

SELECT ADD_MONTHS (TRUNC (SYSDATE,’YEAR’), -12) FROM DUAL;

–> Last Day of Previous Year:

SELECT ADD_MONTHS (TRUNC (SYSDATE, ‘YEAR’), -1 ) +30 FROM DUAL;

Oracle profile option required to enable OAF Page Personalization

---------------------------------
Profile Name     --  Value
---------------------------------

System Administrator Responsibility > Profile > System


1) FND: Personalization Region Link Enabled   - Yes

2) Personalize Self-Service Defn - Yes

3) Disable Self-Service Personal - No