My Oracle Support Banner

JAI_CST_ACCRUAL_LOAD PACKAGE Became Invalid After RUP11 JUN 18 CONSOLIDATION Patch (Doc ID 2418087.1)

Last updated on APRIL 29, 2020

Applies to:

Oracle Financials for India - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

After RUP 11 JUN 18 CONSOLIDATION Patch, the JAI_CST_ACCRUAL_LOAD PACKAGE has become invalid. During compilation of the package, following error is coming:


ERROR
-----------------------
NAME TYPE TEXT
JAI_CST_ACCRUAL_LOAD PACKAGE BODY PL/SQL: SQL Statement ignored
JAI_CST_ACCRUAL_LOAD PACKAGE BODY PL/SQL: ORA-00904: "GTT"."INVENTORY_TRANSACTION_ID": invalid identifier
JAI_CST_ACCRUAL_LOAD PACKAGE BODY PL/SQL: ORA-00904: "INVENTORY_TRANSACTION_ID": invalid identifier


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply JUN 18 CONSOLIDATION Patch 28124448:R12.JAI.B/ 28124448:R12.JAI.C
2. Check list of invalid objects.

Changes

 

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
Changes
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.