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.

Recent Posts

Start typing and press Enter to search