Data Load Concurrent Program Fails with ORA-00904 Invalid Identifier After Cloning EBS Environment (Doc ID 3070061.1)

Last updated on FEBRUARY 03, 2025

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.9 to 12.2.9 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Some of the data load jobs ( Not all) failed with the error ORA-00904: "T0"."VALUE_SEARCHABLE_FLAG" is an invalid identifier . The errors are observed in the log Req_287486505_xxxx.txt

>>log Req_287486505_xxxx.txt

data load concurrent program failed
null

JOB Details: <-- START --->
Details of auditDataset#: 6170916
dataset: ozf-closed-claim
...

status: FAILURE
total elapsed time: 0:0:16
JOB Details: <-- END --->
Please check the output Log of Concurrent program for error details
Error Details: <-- START --->
03:10:20.697 [pool-5-thread-1] ERROR 6.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is an error while trying to ingest data for this load rule OZF_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset ozf-closed-claim for job 6,170,910
org.eclipse.persistence.exceptions.DatabaseException:
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T0"."VALUE_SEARCHABLE_FLAG": invalid identifier

Error Code: 904
Call: SELECT DISTINCT t1.ATTRIBUTE_ID, t1.ATTR_SOURCE_DATATYPE, t1.ATTRIBUTE_FORMULA, t1.ATTRIBUTE_KEY, t1.COLLAPSED_BY_DEFAULT_FLAG, t1.DESCRIPTIVE_FLEXFIELD_NAME, t1.DIM_ENABLE_REFINEMENTS_FLAG, t1.DIM_SEARCH_HIERARCHICAL_FLAG, t1.HIERARCHICAL_MGD_ATTR_FLAG, t1.MANAGED_ATTRIBUTE_FLAG, t1.REC_SEARCH_HIERARCHICAL_FLAG, t1.SELECT_TYPE_CODE, t1.RANKING_TYPE_CODE, t1.SHOW_IN_GUIDED_DISCOVERY_FLAG, t1.SHOW_RECORD_COUNTS_FLAG, t1.SNIPPET_SIZE, t1.TEXT_SEARCHABLE_FLAG, t1.TRANSLATION_FLAG, t1.ATTRIBUTE_TYPE, t1.UNIT, t1.ATTR_PROFILE_KEY, t1.DATASET_ID, t0.ATTR_PROFILE_KEY, t0.ATTR_DATATYPE, t0.DOC_VALUES_FLAG, t0.REQUIRED_FLAG, t0.SINGLE_ASSIGN_FLAG, t0.STORED_FLAG, t0.UNIQUE_FLAG, t0.VALUE_SEARCHABLE_FLAG, t2.BUCKET_ID, t2.BUCKET_END, t2.BUCKET_KEY, t2.BUCKET_START, t2.SEQUENCE_NUM, t2.BUCKET_ATTRIBUTE_ID, t2.DATASET_ID, t2.ATTRIBUTE_ID, t3.CUSTOM_DISPLAY_NAME, t3.DEFAULT_VALUE, t3.DISPLAY_NAME, t3.SOURCE_LANG, t3."LANGUAGE", t3.ATTRIBUTE_ID FROM ECC_DATASET_ATTRS_B t1 LEFT OUTER JOIN ECC_DATASET_ATTR_PROFS t0 ON (t0.ATTR_PROFILE_KEY = t1.ATTR_PROFILE_KEY) LEFT OUTER JOIN ECC_BUCKETS_B t2 ON (t2.BUCKET_ATTRIBUTE_ID = t1.ATTRIBUTE_ID) LEFT OUTER JOIN ECC_DATASET_ATTRS_TL t3 ON (t3.ATTRIBUTE_ID = t1.ATTRIBUTE_ID) WHERE (t1.DATASET_ID = ?) ORDER BY t1.ATTRIBUTE_ID ASC
bind => [1 parameter bound]

Replication Steps

1. Login to EBS with appropriate responsibility

2. Navigate to View --> Request

3. Submit the concurrent program of load type as "Incremental Load"