Issue:
After enabling unified auditing feature in EBS R12.2.5 with 19c database version , getting “APP-FND-01564: ORACLE error in afpodbinit” when opening a ebs form or when a responsibility is selected.
Cause of the issue:
Enabled “Unified Auditing ” feature in or 19c database (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0).
After enabling unified auditing feature in EBS R12.2.5 with 19c database version , getting “APP-FND-01564: ORACLE error in afpodbinit” when opening a ebs form or when a responsibility is selected.
Solution:
Step 1: Disable “Unified Auditing”
(i) Shutdown ebs application
(ii) Shutdown ebs Database
(iii)cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk uniaud_off ioracle
(iv) Startup ebs Database
(v) Start ebs application
(vi) select value from v$option where parameter=’Unified Auditing’; ==> value should be “FALSE”
Step 2: Apply Patch 31864846
(i)Download and review the readme and pre-requisites for “Patch 31864846:R12.FND.C FNDMDGEN IS CRASHING WHILE GENERATING MESSAGE FILE IN WINDOWS 2016” and apply it.
(ii)After applying the patch Confirm the following file versions (or higher):
$Header: afupi.lc 120.16.12020000.3 2013/12/12 22:25:58 emiranda ship $
(iii) Perform sanity check whether ebs application is working fine.
Step 3:Enable “Unified Auditing”
(i) Shutdown ebs application
(ii) Shutdown ebs Database
(iii)cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk uniaud_on ioracle
(iv) Startup ebs Database
(v) Start ebs application
(vi) select value from v$option where parameter=’Unified Auditing’; ==> value should be “TRUE”
(vii)Perform sanity check whether ebs application is working fine.
Conclusion:
When A EBS Form Is Called Or Responsibility Selected if we get “APP-FND-01564 AND ORA-1455 Error” after enablement of “Unified Auditing” then check whether the Patch 31864846 is applied or else apply the patch to resolve the error.