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:
Oracle Financials for India - Version 12.1.3 and laterInformation 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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |