My Oracle Support Banner

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 MARCH 24, 2021

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.10 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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