Description:
Table of Contents
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
Pingback: Latest Interview Questions for Oracle APPS DBA - SuggestCloud