Description:

When you run autoconfig in EBS 12.2 or EBS 12.1.3 and you get error. Autoconfig error : ORA-06512: at “APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR.
This issue comes when you run adautocfg.sh on apps tier.

Error:

1. Login to EBS Tier as applmgr user.
2. Go to $ADMIN_SCRIPTS_HOME
3. Run ./ adautocfg.sh and supply apps password
4. Log of autoconfig-
$INSTALL_BASE/inst/apps/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.log
($INST_TOP/admin/log/[$MMDDhhmm])

Autoconfig Log will have these error snippet.
Autoconfig error : ORA-06512: at “APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR

ERROR at line 1:
ORA-04091: table APPLSYS.FND_PROFILE_OPTION_VALUES is mutating,
trigger/function may not see it
ORA-06512: at “APPS.FND_CORE_LOG”, line 45
ORA-06512: at “APPS.FND_CORE_LOG”, line 462
ORA-06512: at “APPS.FND_PROFILE”, line 61
ORA-06512: at “APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR”, line 1
ORA-04088: error during execution of trigger
‘APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR’
ORA-06512: at line 47
ORA-06512: at line 218

Solution:

Follow the steps to resolve the error:

1. Check the status of Trigger
select TRIGGER_NAME,STATUS from DBA_TRIGGERS where
TRIGGER_NAME=’ALR_FND_PROFILE_OPTIO_0_84_UAR’;

TRIGGER_NAME STATUS
————————————————————————
ALR_FND_PROFILE_OPTIO_0_84_UAR ENABLE

2. Here this trigger is causing the issue. We have to disable the trigger

3. alter trigger APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR disable;

4. Now again run autoconfig script

5. After successful run of autoconfig disable the enable the trigger

6. alter trigger APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR enable;
Trigger altered.

Oracle DBA Skills have become important and critical. Up skill your knowledge with our Online Sessions on Oracle DBA , Oracle Application DBA, Oracle Performance

Related Post:
AWS EC2 Concept – Amazon EC2
AWS IAM Concept- AWS IAM
Amazon S3 – AWS S3

Join our FREE Telegram Group and Part of Knowledge Sharing Group.
1. If you are already using Telegram, just add group name- @suggestcloud
2. If you are not using Telegram, Download from App Store or Google Play and Click 
Suggest Cloud