GST: Error "before insert or update on JE.JAI_BOE_DETAILS" During Patch Application Of Patch 27026651:R12.JAI.C

(Doc ID 2340113.1)

Last updated on JANUARY 03, 2018

Applies to:

Oracle Financials for India - Version 12.2.6 to 12.2.7 [Release 12.2]
Oracle Financials for India - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.


On trying to apply patch 27026651:R12.JAI.C , it is failing with an error .

Error Message
From the patch log and its relevant adworker log , below are the error messages

a. From Adworker log file :
    FAILED: file JAI_BOE_DETAILS_X1.sql on worker 1 for product ja username JA.

b. From Patch log file :
    sqlplus -s APPS/***** @/testapp/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/testapp/TEST/fs1/EBSapps/appl/ja/12.0.0/patch/115/sql/JAI_BOE_DETAILS_X1.sql &un_je'

    PL/SQL procedure successfully completed.

    before insert or update on JE.JAI_BOE_DETAILS
    ERROR at line 2:
    ORA-00942: table or view does not exist

Patch should be allowed for application successfully.


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