Tuesday, 23 May 2017

E-Business Autoconfig Issues/Autoconfig Issues seen after a Patch, Clone, Migration or Installation

While doing the cloning of Oracle Application and after that  run auto config, then getting the  following error occurs. 

ERROR
-----------------------
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 456
ORA-06512: at "APPS.FND_PROFILE", line 110
ORA-06512: at "APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR", line 2
ORA-04088: error during execution of trigger
'APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR'
ORA-06512: at line 43
ORA-06512: at line 123 

Error Codes
---------------------------------------------------
ORA-04091,ORA-06512,ORA-04088

Solution:

Run the below query and check triggers status:

SELECT * FROM DBA_TRIGGERS WHERE TABLE_NAME = 'FND_PROFILE_OPTION_VALUES' AND TABLE_OWNER = 'APPLSYS';

If below trigger status enable then I suggested to disable the triggers and retest the issue.

ALR_FND_PROFILE_OPTIO_0_84_UAR
ALR_FND_PROFILE_OPTIO_0_84_IAR
-----------------------



Saturday, 4 March 2017

[Solved]Automatically objects are getting invalid after some days.

Issue:
we have facing some issue that some objects are automatically gets invalid after some days.
after running script utlrp.sql it will get valid but issue comes again after some days.

Solution:
Please follow the below steps.
1) Run 'Re-create grants and synonyms for APPS schema' in adadmin.
2) As sysdba, run the following twice in order to compile any dependent objects
SQL > @?/rdbms/admin/utlrp.sql
3) Run 'Compile APPS Schema' in adadmin
4) Run 'Validate APPS Schema' in adadmin
5) Run the following report:
$AD_TOP/sql/adutconf.sql


I hope issue has been resolved invalid objects.