My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.