ORA-00600: internal error code, arguments: [kxfqupp_bad_cvl]

When running the ETL job, you may encounter the following error

Failed : CREATE BITMAP INDEX
W_SLS_CC_LN_F_F34
ON
W_SALES_CYCLE_LINE_F
(
PROFIT_CENTER_WID ASC
)
NOLOGGING PARALLEL TABLESPACE OLAP_REP_INDEX With error message : java.sql.SQLException: ORA-00600: internal error code, arguments: [kxfqupp_bad_cvl], [8863], [6], [0], [], [], [], []

After 10 attempts.

This error will occur when creating index with parallel option on huge tables. If the table size is small to medium, this error does not error while creating the index with parallel option.

There are two ways to resolve this issue. Either create the index serially, which might take lot of time or fix the Oracle DB. There is a bug in the Oracle DB (to be more specific 10.2.0.3) and a patch is available for this. Apply the patch 4695511 to fix this issue.