My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.