Search This Blog

Tuesday, January 31, 2017

Concurrent request fails: ORACLE error 1722 in FDPSTP: SELECT R.Conc_Login_Id, R.Re

Error message:

ORACLE error 1722 in FDPSTP

Cause: FDPSTP failed due to ORA-01722: invalid number
ORA-06512: at "APPS.XX_CUSTOM_PKG", line 216
ORA-06512: at line 1
.

The SQL statement being executed at the time of the error was: SELECT R.Conc_Login_Id, R.Re

Solution:
This issue is usually because EBS user preference has a number format 10.000,00.
Use a user which has number 10,000.00. This works fine!

For solution details, please check Doc ID 2220885.1 where additional steps are provided to get rid of this issue.

Friday, December 30, 2016

Hiding Vacation Rules Tip and OAF Personalization

These are the steps to hide Vacation Rule Tip:

1. Make sure personalization profile options are enabled.
FND: Personalization Region Link Enabled = Yes
Personalize Self-Service Defn = Yes
2. Log in to the home page and click personalize page in upper right corner.
3. Select Complete View and Expand All.
4. Locate line for "Tip: (Notifications.vacationRulesTip)".
5. Click on pencil and change property Rendered at level you want (Site / Function / Resp) from Inherit to False.

I, by mistake, chose Admin Personalization to False at site level in step 5. This made the pencil (for changing property) disappear from personalization page. To get rid of such incorrect personalization, followed the following steps:

1) Login to Oracle Applications as SYSADMIN
2) Select Functional Administrator [resp] > Personalization [tab]
3) Fill in the criteria to locate the OA Framework page and press Go
    Tip: Check 'Personalized' checkbox to only query the pages having a personalization
    In my case, path = /oracle/apps/fnd/wf/worklist/webui/AdvancWorklistRG
4) Identify the correct page from the results returned
5) Deleted the site level personalization.

Reference:
How to Hide Vacation Rules Tip or Worklist Access Tip in Workflow Notifications Screen (Doc ID 972361.1)
How to Remove / Disable an OA Framework Personalization (Doc ID 304670.1)