Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Errors/Workarounds-Applications

January 13, 2023 Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request
APPS DBAErrors/Workarounds-Applications

ERROR

The Concurrent Manager fails to start with the Error:

The ICM is already running. Contact you system administrator for further assistance.

(more…)

January 6, 2023 How to clean FND_NODES table in Oracle Applications
APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

How to clean FND_NODES table in Oracle Applications

[edsanimate_start entry_animation_type= “fadeIn” entry_delay= “0” entry_duration= “1.5” entry_timing= “linear” exit_animation_type= “” exit_delay= “” exit_duration= “” exit_timing= “” animation_repeat= “infinite” keep= “yes” animate_on= “load” scroll_offset= “” custom_css_class= “”]

Note: Remember That All the Latest Cloning Patches Should Be Applied to avoid Any Ambiguity.

[edsanimate_end]

Step 1: Login to Database with Apps User

$ sqlplus apps/apps

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;

SQL>COMMIT;

SQL>EXIT;

It will delete all old data from the table.

Step 2: Run AutoConfig on all tiers, first on the DataBase Tier and then on APPS Tier to repopulate the required system tables.

December 16, 2022 ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors
APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors
ORA-06508: PL/SQL: could not find program unit being called:
“APPS.AP_ACCTG_DATA_FIX_PKG”
ORA-06512: at line 38
(more…)

December 9, 2022 The persistent store “_WLS_AdminServer” could not be deployed: weblogic.store.PersistentStoreException
APPS DBAErrors/Workarounds-Applications

ERROR

<Error> <Store> <BEA-280061><The persistent store “_WLS_AdminServer” could not be deployed: weblogic.store.PersistentStoreException:
[Store:280105]The persistent file store “_WLS_AdminServer” cannot open file _WLS_ADMINSERVER000000.DAT.

(more…)