My Oracle Support Banner

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  in merged format, and definitely included a patch with a version of jain18.odf that is higher than the one included in 26153906.

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!

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