Error before insert or update on JA.JAI_IRN_DETAILS (Doc ID 2785578.1)

Last updated on NOVEMBER 10, 2023

Applies to:

Symptoms

Problem description
-----------------------
Error observed while applying any patches which are released on top of e invoicing/TCS offering.
Though this error is observed while applying patch 32777132, it is certain that any patch which is released on top of e invoicing/TCS and if customer objects
are not on e invoicing/TCS patches then this issue may occur.


Error message
----------------
sqlplus -s APPS/***** @/EBSTRNapp/12.2/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/EBSTRNapp/12.2/fs2/EBSapps/appl/ja/12.0.0/patch/115/sql/JAI_IRN_DETAILS_X1.sql &un_ja'
Connected.
PL/SQL procedure successfully completed.
  before insert or update on JA.JAI_IRN_DETAILS
  *
 ERROR at line 2: ORA-00942: table or view does not exist

Steps for replication 
-----------------------
This is patching issue observed when trying to applying patches which are released on top of e invoicing/TCS offering.

Expected behavior
---------------------
Patches are expected to be applied successfully without any errors.

Cause

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