Metalink id :
=========
BI Apps 11.1.1.8.1 ETL fails with the 'ORA-01792: maximum number of columns in a table or view is 1000' Error Message (Doc ID 1956038.1)
Solution
++++++++
add this parameter *._fix_control='17376322:OFF'
Shutdown Application services and database .
--------------------------------------------------
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
grep -i fix /u01/oracle/bidev/db/12.1.0/dbs/initbidev.ora
*._fix_control='17376322:OFF'
SQL> create spfile from pfile='/u01/oracle/bidev/db/12.1.0/dbs/initbidev.ora';
File created.
SQL> startup
ORACLE instance started.
Total System Global Area 3506438144 bytes
Fixed Size 2930368 bytes
Variable Size 922749248 bytes
Database Buffers 2566914048 bytes
Redo Buffers 13844480 bytes
Database mounted.
Database opened.
SQL> show parameter fix
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_fix_control string 17376322:OFF
common_user_prefix string C##
fixed_date string
os_authent_prefix string ops$
SQL>
=========
BI Apps 11.1.1.8.1 ETL fails with the 'ORA-01792: maximum number of columns in a table or view is 1000' Error Message (Doc ID 1956038.1)
Solution
++++++++
add this parameter *._fix_control='17376322:OFF'
Shutdown Application services and database .
--------------------------------------------------
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
grep -i fix /u01/oracle/bidev/db/12.1.0/dbs/initbidev.ora
*._fix_control='17376322:OFF'
SQL> create spfile from pfile='/u01/oracle/bidev/db/12.1.0/dbs/initbidev.ora';
File created.
SQL> startup
ORACLE instance started.
Total System Global Area 3506438144 bytes
Fixed Size 2930368 bytes
Variable Size 922749248 bytes
Database Buffers 2566914048 bytes
Redo Buffers 13844480 bytes
Database mounted.
Database opened.
SQL> show parameter fix
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_fix_control string 17376322:OFF
common_user_prefix string C##
fixed_date string
os_authent_prefix string ops$
SQL>