AuditTrail Update Tables-completed With Error During Upgrade
(Doc ID 2046237.1)
Last updated on JUNE 26, 2022
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...
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! |
In this Document
Goal |
Solution |
References |