Not Able To Compile Some GST Related Objects As Part Of GST Patches Rollout To Production Instance.

(Doc ID 2285448.1)

Last updated on JULY 11, 2017

Applies to:

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

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

	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