Unable To Apply Activate EIM_ACCOUNT After Running EIM Mapping Wizard For S_ORG_EXT

Last updated on AUGUST 08, 2017

Applies to:

Symptoms

On : 15.0 [IP2015] version, EIM

Unable to Apply activate EIM_ACCOUNT after running EIM Mapping wizard for S_ORG_EXT with more that 1000 mappings

The following steps have been performed:
1. Ran EIM Mapping wizard on S_ORG_EXT for EIM_ACCOUNT.
2. At the time of apply/ activate EIM_ACCOUNT it is giving below error.

A. UTLDbDdlDbMerge
B. pOperCallback UTLDbDdlOperMultiColAdd
C. SQL Error Adding multiple column in one batch ... 608
D. S1000 (1792): [tp][ODBC Oracle driver][Oracle]ORA-01792: maximum number of columns in a table or view is 1000

Bellow is the select statement for EIM_ACCOUNT:

select * from siebel.S_TABLE where NAME = 'EIM_ACCOUNT'
Output= 1-1-NIQY

select count (*) from siebel.S_COLUMN where TBL_ID = '1-1-NIQY' and repository_id = '1-1-1'
Output= 1124


ERROR
-----------------------
S1000 (1792): [tp][ODBC Oracle driver][Oracle]ORA-01792: maximum number of columns in a table or view is 1000




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add more that 1000 mapped columns to an EIM table
2. Apply DDL

Changes

 The customer has added more that 1000 active mappings to EIM_ACCOUNT.

Cause