The issue started after cloning the Oracle Database from an earlier release of 12.1.0.2 to 12.1.0.2 [ODA to ODA]
This issue was caused by the newly enabled Unified Auditing feature in the target database server.
Error:
Cause: afpodbinit failed due to ORA-01455: converting column overflows integer datatype.
The SQL statement being executed at the time of the error was: begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :org_id); fnd_profile.put('MFG_ORGANIZATION_ID', :mfg_org_id); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :coa); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end; and was executed from the file &ERRFILE.
Fix:
With Oracle Database 12c, Unified Auditing is introduced. Prior to Oracle Database 12c, auditing is configured using the AUDIT_TRAIL database parameter,
which is called traditional auditing. Unified Auditing is not certified with E-Business Suite. Bug 25540183 is logged for this Enhancement Request.
To disable the new Unified Auditing functionality:
1. Take the Apps and DB tier offline
2. Source RDBMS environment
3. cd $RDBMS_ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk uniaud_off ioracle
4. Verify the output of the following query is FALSE
SQL> SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unified Auditing';
5. Take the DB and Apps tier online
Reference: APP-FND-01564 AND ORA-1455 Errors In Afpodbinit When A EBS Form Is Called Or Responsibility Selected (Doc ID 1963969.1)