Not Able To Compile Some GST Related Objects As Part Of GST Patches Rollout To Production Instance. (Doc ID 2285448.1)

Last updated on MARCH 29, 2022

Applies to:

Symptoms

 Invalids occur after following cutover steps to implement GST patches.  Examples are:

JAI_IM_TAX_MAPPING_V VIEW ORA-00942: table or view does not exist
JAI_OPEN_TAX_DET_PKG PACKAGE BODY PL/SQL: ORA-00942: table or view does not exist
JAI_OPEN_API_PKG PACKAGE BODY PL/SQL: SQL Statement ignored
JAI_OPEN_API_PKG PACKAGE BODY PL/SQL: ORA-00942: table or view does not exist
JAI_EXTRACT_PKG PACKAGE BODY PL/SQL: ORA-00904: "MAT"."SOURCE": invalid identifier
JAI_OPEN_TAX_DET_PKG PACKAGE BODY PL/SQL: SQL Statement ignored
JAI_OPEN_API_PKG PACKAGE BODY PLS-00341: declaration of cursor 'GET_TAX_ID_FROM_MAPPING_CUR' is incomplete or malformed
JAI_EXTRACT_PKG PACKAGE BODY PL/SQL: ORA-00904: "REC"."SOURCE": invalid identifier
JAI_EXTRACT_PKG PACKAGE BODY PLS-00364: loop index variable 'TRAD_RET' use is invalid
JAI_OPEN_API_PKG PACKAGE BODY PLS-00364: loop index variable 'REC_TAX_ID' use is invalid
JAI_EXTRACT_PKG PACKAGE BODY PL/SQL: Statement ignored
JAI_CMN_MATCH_RECEIPTS_V VIEW ORA-00904: "MATCH"."SOURCE": invalid identifier
JAI_OPEN_API_PKG PACKAGE BODY PL/SQL: Item ignored
JAI_OPEN_API_PKG PACKAGE BODY PL/SQL: Statement ignored
JAI_EXTRACT_PKG PACKAGE BODY PL/SQL: SQL Statement ignored

Changes

Applied patches listed in GST Production Cutover Steps - Patch Details (Doc ID 2279444.1) in merged format, and definitely included a patch with a version of jain18.odf that is higher than the one included in 26153906.

Cause

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