ECC V5 Concurrent Request 'Projects Costing and Accounting ECC Data Load' errors with 'ORA-00904: 'PA_COST_TASKDFF_VIEW_HAS_FAILED_CHECK_LOG_FILE'": invalid identifier' for Data Set 'pa-ds-cost-eicdl'. (Doc ID 2763318.1)

Last updated on NOVEMBER 17, 2022

Applies to:

Symptoms

ECC V5 load for 'Projects Costing and Accounting ECC Data Load' errors with the following in the data set pa-ds-cost-eicdl:

startTime: Mon Feb 22 16:13:17 GMT 2021
             endTime: Mon Feb 22 16:13:17 GMT 2021
             status: FAILURE
             sql time: 0:0:0
             total elapsed time: 0:0:0
             statusMessage: There is an error while trying to ingest data for
this load rule PA_ECC_COST_PROJ_PKG.LOAD_FULL_EICDL_DATA with dataset
pa-ds-cost-eicdl for job 19,036 ORA-00904:
"'PA_COST_TASKDFF_VIEW_HAS_FAILED_CHECK_LOG_FILE'": invalid identifier

The meta data log file shows:

            auditLoadDetailId:19022
             operation:EXECUTE
             sqlQuery:select  distinct 'PA_COST_TASKDFF_' ||
UPPER(REGEXP_REPLACE(col.END_USER_COLUMN_NAME, '[^a-zA-Z0-9]', '_'))
TARGET_INSTANCE_ATTRIBUTE , 'PA_COST_TASKDFF_VIEW_HAS_FAILED_CHECK_LOG_FILE'
TRIGGER_INSTANCE_ATTRIBUTE,  '*'   TRIGGER_ATTR_VALUE ,'Y'  ENABLED_FLAG
from FND_DESCR_FLEX_COL_USAGE_VL col, FND_DESCR_FLEX_CONTEXTS_VL con where
con.GLOBAL_FLAG = 'N' and  col.ENABLED_FLAG ='Y' and con.ENABLED_FLAG ='Y'
and col.application_id=275 and con.application_id=col.application_id  and
col.descriptive_flexfield_name='PA_TASKS_DESC_FLEX' and
col.descriptive_flex_context_code = con.descriptive_flex_context_code;
             startTime: Mon Feb 22 15:18:52 GMT 2021
             endTime: Mon Feb 22 15:18:54 GMT 2021
             status: FAILURE
             sql time: 0:0:0
             total elapsed time: 0:0:2
             statusMessage: There is an error while trying to ingest data for
this load rule PA_ECC_COST_PROJ_PKG.GET_DESC_METADATA_LOAD_INFO with dataset
pa-ds-cost-eicdl for job 19,015 Dataset attributes doesn't have one of the
attribute keys targetAttribute: PA_COST_TASKDFF_PLOT_IDand trigger attribute:
PA_COST_TASKDFF_VIEW_HAS_FAILED_CHECK_LOG_FILE

Changes

Cause

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