Applying AD Patch 9239090 End in Error ORA-04098: trigger 'APPS.GL_AUTOREVERSE_OPTIONS_AI' is invalid and failed re-validation
(Doc ID 2573802.1)
Last updated on AUGUST 06, 2020
Applies to:
Oracle General Ledger - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, Patch Application Issues
When attempting to upgrade EBS 12.1.2 to 12.1.3, While applying AD Patch 9239090 as part of APPS patch,
the following error occurs.
ERROR
Error loading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = Prior billed earned, ORA-04098: trigger 'APPS.GL_AUTOREVERSE_OPTIONS_AI' is invalid and failed re-validation
ORA-06512: at "APPS.GL_AUTOREVERSE_OPTIONS_PKG", line 237
ORA-06512: at "APPS.GL_JE_CATEGORIES_PKG", line 278
ORA-06512: at "APPS.GL_JE_CATEGORIES_PKG", line 397
ORA-06512: at "APPS.GL_JE_CATEGORIES_PKG", line 622
ORA-01403: no data found
Table : GL_AUTOREVERSE_OPTIONS
Table owner : GL
Synonym : GL_AUTOREVERSE_OPTIONS
Synonym owner :APPS
Trigger : GL_AUTOREVERSE_OPTIONS_AI
Trigger APPS.GL_AUTOREVERSE_OPTIONS_AI
Error(1,238): PLS-00049: bad bind variable 'OLD.SET_OF_BOOKS_ID'
Error(1,432): PLS-00049: bad bind variable 'NEW.SET_OF_BOOKS_ID'
create or replace TRIGGER GL_AUTOREVERSE_OPTIONS_AI
AFTER INSERT ON GL_AUTOREVERSE_OPTIONS
FOR EACH ROW
BEGIN
IF fnd_audit_pkg.audit_on THEN
GL_AUTOREVERSE_OPTIONS_AIP(:old.JE_CATEGORY_NAME,:old.CRITERIA_SET_ID,:old.AU
STEPS
The issue can be reproduced at will with the following steps:
1. Apply Patch 9239090
Cause
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
Symptoms |
Cause |
Solution |
References |