Troubleshooting Commonly Known India Goods & Services Tax (GST) 12.2.x Upgrade Issues
(Doc ID 2818913.1)
Last updated on JUNE 12, 2023
Applies to:
Oracle Financials for India - Version 12.2 and laterInformation in this document applies to any platform.
Purpose
This document is intended to provide troubleshooting assistance to resolve common, known issues encountered with Oracle Financials for India objects while upgrading from 12.1.X to 12.2.X
Troubleshooting Steps
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
| Purpose |
| Troubleshooting Steps |
| Issue 1: ORA-20001: Could Not Apply Invalid Cross-edition Trigger JAI Objects While Applying 12.2.9 |
| Issue 2: jai_tds_gdf_tax_ui_upg.sql script running long during 12.2.0 upgrade |
| Issue 3: 12.2.0 Upgrade is failing on JAIRCVDFF.SQL |
| Issue 4: Post upgrade, form JAINRCLM.fmb is not compiling or the package jai_rgm_recovery.plb is invalid. |
| Issue 5: R12.2.9 failing with PLS-00049: bad bind variable error |
| Issue 6: While installing Release 12.2.0 upgrade driver, the following scripts failed: jai_6780154.sql and jairgmsetupmig.sql |
| Issue 7: 12.2.0 upgrade driver failed, worker log shows ORA-01017 invalid username/password; logon denied |
| Issue 8: Post upgrade, many JAI invalid objects are generated. |
| Issue 9: While upgrading from 12.1.3 to 12.2.10, u_merged.drv patch worker failed jain09.odf |
| Issue 10: 12.2.9 upgrade patch failed on below JAI objects |
| Issue 11: Upgrading EBS from 11.5.10.2 to R12.2, worker failed for FAILED: file jaidtchgmig_ola.sql |
| Issue 12: Post upgrade, JAI_SETTLEMENT_PKG became Invalid |
| Issue 13: Post Upgrade to 12.2.9 Data for Few Columns Are Missing in 3 GST Tables(JAI_AP_TDS_THHOLD_TRXS,JAI_AP_TDS_THHOLD_TRXS,JAI_REPORTING_CODES) |
| Issue 14: Upgrade patch is failing on ODF files owing to duplicate keys error on JAI_AP_WTHLD_INV_TAXES |
| Issue 15: JAI_DATA_FIX_PKG Package is violating DB Adzddbcc analysis during upgrade |
| Issue 16: When upgrading to 12.2.10, error is encountered on jai121pl.ldt: ORA-06502: PL/SQL: numeric or value error: character string buffer too small |
| References |