AuditTrail Update Tables-completed With Error During Upgrade (Doc ID 2046237.1)

Last updated on AUGUST 23, 2015

Applies to:

Oracle Application Object Library - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Goal

After upgrade of E-Business Suite from 11.5.10.2 to 12.2.4, Audit Trail Update Tables program is failing with the below error. How to resolve this issue?

INSERT INTO GMD_RECIPE_VALIDITY_RULE_A (AUDIT_TIMESTAMP,AUDIT_USER_NAME,AUDIT_TRANSACTION_TYPE,AUDIT_TRUE_NULLS, AUDIT_SESSION_ID,AUDIT_SEQUENCE_ID,AUDIT_COMMIT_ID,RECIPE_VALIDITY_RULE_ID,END_DATE,ITEM_ID,MAX_QTY,MIN_QTY,ORGN_CODE,RECIPE_USE,START_DATE,STD_QTY) SELECT SYSDATE,USER,'L',decode(RECIPE_VALIDITY_RULE_ID,NULL,'Y','N')|| decode(END_DATE,NULL,'Y','N')|| decode(ITEM_ID,NULL,'Y','N')|| decode(MAX_QTY,NULL,'Y','N')|| decode(MIN_QTY,NULL,'Y','N')|| decode(ORGN_CODE,NULL,'Y','N')|| decode(RECIPE_USE,NULL,'Y','N')|| decode(START_DATE,NULL,'Y','N')|| decode(STD_QTY,NULL,'Y','N'),USERENV('SESSIONID'),0,0,RECIPE_VALIDITY_RULE_ID,END_DATE,ITEM_ID,MAX_QTY,MIN_QTY,ORGN_CODE,RECIPE_USE,START_DATE,STD_QTY FROM GMD_RECIPE_VALIDITY_RULES
Fatal error in fdacts, quitting...
Fatal error in fdacts, quitting...
Fatal error in fdaut, quitting...

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms