R12: IBY: Error While Trying To Apply Patches In 12.1.3: CREATE GLOBAL TEMPORARY TABLE "APPS"."IBY_AR_DOC_HEADER_GT" ORA-00955: name is already used by an existing object (Doc ID 3035666.1)

Last updated on JULY 22, 2024

Applies to:

Symptoms

Error while trying to apply patches in 12.1.3.

Example: 33622595:R12.AR.B and 33622595:R12.AR.C PERFORMANCE ISSUES WHEN SAVING TRANSACTION IN TRANSACTIONS WORKBENCH

Error Messages:

From Adpatch logs:

FAILED: file iby_ar_doc_header_gt.xdf on worker 1 for product iby username APPS.
ATTENTION: All workers either have failed or are waiting.

From Adwork logs:

CREATE GLOBAL TEMPORARY TABLE "APPS"."IBY_AR_DOC_HEADER_GT"
( "CALLING_APP_DOC_REF_NUMBER" VARCHAR2(30),
"DOCUMENT_DATE" DATE,
"CREATION_DATE" DATE,
"DOCUMENT_TYPE" CHAR(7),
"DOCUMENT_DESCRIPTION" VARCHAR2(240),
"DOCUMENT_AMOUNT" NUMBER,
"DOCUMENT_CURRENCY_CODE" VARCHAR2(15),
"SETTLEMENT_AMOUNT" NUMBER,
"DISCOUNT_AMOUNT" NUMBER,
"FREIGHT_AMOUNT" NUMBER,
"DOCUMENT_DISCOUNT_EARNED" NUMBER,
"LOCAL_TAX_AMOUNT" NUMBER,
"NATIONAL_TAX_AMOUNT" NUMBER,
"VAT_TAX_AMOUNT" NUMBER,
"ADDRESS1" VARCHAR2(240),
"ADDRESS2" VARCHAR2(240),
"ADDRESS3" VARCHAR2(240),
"CITY" VARCHAR2(60),
"COUNTY" VARCHAR2(60),
"STATE" VARCHAR2(60),
"COUNTRY" VARCHAR2(60),
"POSTAL_CODE" VARCHAR2(60),
"TO_ADDRESS1" VARCHAR2(240),
"TO_ADDRESS2" VARCHAR2(240),
"TO_ADDRESS3" VARCHAR2(240),
"TO_CITY" VARCHAR2(60),
"TO_COUNTY" VARCHAR2(60),
"TO_STATE" VARCHAR2(60),
"TO_COUNTRY" VARCHAR2(60),
"TO_POSTAL_CODE" VARCHAR2(60),
"ORDER_TANGIBLE_ID" VARCHAR2(80),
"TRANSACTIONID" NUMBER,
"INITIATOR_EXTENSION_ID" NUMBER(15,0),
"DOC_UNIQUE_REF" NUMBER(15,0),
"BR_DRAWEE_ISSUED_FLAG" VARCHAR2(1),
"BR_SIGNED_FLAG" VARCHAR2(1),
"REGISTRATION_NUMBER" VARCHAR2(30),
"LEGAL_ENTITY_NAME" VARCHAR2(240),
"PARTY_NAME" VARCHAR2(360),
"ACCOUNT_NUMBER" VARCHAR2(30),
"TAX_REGISTRATION_NUMBER" VARCHAR2(2000),
"LE_REGISTRATION_NUMBER" VARCHAR2(30)
) ON COMMIT PRESERVE ROWS

java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

Steps To Reproduce

The issue can be reproduced at will with the following step:
1. Apply patch using AdPatch tool.

Cause

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