JAI_GSTR2A_PKG is INVALID even after RUP11

(Doc ID 2359243.1)

Last updated on FEBRUARY 19, 2018

Applies to:

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

Symptoms

On : 12.1.3 version

JAI_GSTR2A_PKG is invalid even after RUP11. While trying to compile manually, receiving the following error:


ERROR
-----------------------

SQL> ALTER PACKAGE JAI_GSTR2A_PKG COMPILE BODY;

Warning: Package Body altered with compilation errors.

18:24:31 SQL> show errors;
Errors for PACKAGE BODY JAI_GSTR2A_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2236/16 PL/SQL: SQL Statement ignored
2245/31 PLS-00382: expression is of wrong type
2245/31 PLS-00436: implementation restriction: cannot reference fields
of BULK In-BIND table of records

2247/31 PLS-00382: expression is of wrong type
2247/31 PLS-00436: implementation restriction: cannot reference fields
of BULK In-BIND table of records

2249/31 PLS-00382: expression is of wrong type
2249/31 PLS-00436: implementation restriction: cannot reference fields

LINE/COL ERROR
-------- -----------------------------------------------------------------
of BULK In-BIND table of records

2251/31 PL/SQL: ORA-22806: not an object or REF
2251/31 PLS-00382: expression is of wrong type
2251/31 PLS-00436: implementation restriction: cannot reference fields
of BULK In-BIND table of records

2261/19 PL/SQL: SQL Statement ignored
2268/40 PL/SQL: ORA-22806: not an object or REF
2268/40 PLS-00382: expression is of wrong type
2268/40 PLS-00436: implementation restriction: cannot reference fields

LINE/COL ERROR
-------- -----------------------------------------------------------------
of BULK In-BIND table of records

2557/31 PLS-00382: expression is of wrong type
2557/31 PLS-00436: implementation restriction: cannot reference fields
of BULK In-BIND table of records

2559/31 PLS-00382: expression is of wrong type
2559/31 PLS-00436: implementation restriction: cannot reference fields
of BULK In-BIND table of records

2561/31 PLS-00382: expression is of wrong type

LINE/COL ERROR
-------- -----------------------------------------------------------------
2561/31 PLS-00436: implementation restriction: cannot reference fields
of BULK In-BIND table of records

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply RUP11 patch - 27212160:R12.JAI.B
2. Notice that JAI_GSTR2A_PKG is invalid.
3. Try to compile the package manually but compilation ends in error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, JAI_GSTR2A_PKG remains invalid.

Cause

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 hundreds of Community platforms