My Oracle Support Banner

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.

Symptoms

ACTUAL BEHAVIOR
-----------------------
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'
    Connected.

    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



EXPECTED BEHAVIOR
-----------------------
Patch should be allowed for application successfully.

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
Cause
Solution


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