APPS DBA

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.

January 5, 2023 How to Change Weblogic Password in Oracle APPS R12.2

APPS DBA

How to Change Weblogic Password in Oracle APPS R12.2

Today we will explore how to change Weblogic Admin Password in Oracle E-Business Suite 12.2.x, we will explore 2 different scenarios according to the Patch Level available in the System.

Scenario 1: You are on R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 or later, we can change the Weblogic admin server password using the below script.

A) Shutdown the Application Services using below:

$ADMIN_SCRIPTS_HOME/adstpall.sh

B) Start Weblogic Admin Server. Do not start any other services

$. ./EBSapps.env RUN
$ cd $ADMIN_SCRIPTS_HOME
$adadminsrvctl.sh start

C) Run the below Script to Update the Password

perl $FND_TOP/patch/115/bin/txkUpdateEBSDomain.pl -action=updateAdminPassword

^{[The script will prompt for Current and New Weblogic Password and restarts the Weblogic Admin Server.]}

D) Start the Application MiddleWare services using

$ADMIN_SCRIPTS_HOME/adstrtal.sh

E) Login to the Weblogic Admin Console to verify that the new WebLogic user password works.

F) Run fs_clone to Propagate the changes to the file system (Patch File system).

$adop phase=fs_clone

Scenario 2: You are on Earlier than R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 , we can change the Weblogic admin server password using the below method.

A) Log into the WebLogic Administrative Console.

B) Click Lock & Edit and click Domain.

C) Click on the Security tab and click on the Advanced tab.

D) Enter the New password you want for the WebLogic Admin User in the Node Manager Password.

E) Click Save and verify that the settings were updated successfully. Then click on Activate Changes.

F) Click Security Realms and Click Myrealm.

G) Select Users and Groups, select Weblogic User, and enter the new password for the WebLogic user.

H) Make sure that the settings have been updated successfully.

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…)