While Applying Patch 30399999 / Patch 31856789 Error 'Table EGO_BULKLOAD_INTF Is Missing The Column C_INTF_ATTR9#1' / 'ORA-01792: maximum number of columns in a table or view is 1000' (Doc ID 2761449.1)

Last updated on JULY 05, 2023

Applies to:

Symptoms

12.2.10+ EBS Patch: application fails on egot047.odf with below error for table EGO_BULKLOAD_INTF

_________________________________________________________________
The table EGO_BULKLOAD_INTF is missing the column C_INTF_ATTR9#1.

Add the column with the statement:

Start time for statement below is: MON DD YYYY HH:MM:SS

ALTER TABLE EGO.EGO_BULKLOAD_INTF ADD ( C_INTF_ATTR9#1 VARCHAR2(4000) )

AD Worker error:
The following ORACLE error:

ORA-01792: maximum number of columns in a table or view is 1000
_________________________________________________________________

CAUSE:
Following steps can cause issue,

1. Apply patch (Ex: 12.2.10 patch 30399999) having file egot047.odf version higher than 120.4.12020000.4.
2. Abort patch without completing patching cycle.
3. Perform full cleanup
4. Perform fs clone
5. Re apply patch again (Ex: 12.2.10 patch 30399999) having file egot047.odf version higher than 120.4.12020000.4.
6. Error “ORA-01792: maximum number of columns in a table or view is 1000” will get displayed in worker logs.
7. Skip and continue patch
8. See another error, ORA-20001: Could not apply invalid crossedition trigger "APPS"."EGO_BULKLOAD_INTF_F1": PLS-00049: bad bind variable

Cause

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