"PO PCC ECC Data Load" Program In Failing In ECC (Doc ID 2678902.1)

Last updated on OCTOBER 06, 2024

Applies to:

Symptoms

On : 12.2.6 version, ECC Purchasing

While attempting to run full load for procurement data using PO PCC ECC Data Load, the child program ECC Run Data Load failed with following error:

ERROR
-----------------------
There is an error while trying to ingest data for this load rule po_pcc_orders_util_pvt.get_desc_metadata_load_info with dataset po-pcc-orders for job 13,694

oracle.ecc.exeption.ImportMetadataException: Dataset attributes doesn't have one of the attribute keys
targetAttribute: PO_ORD_H_SUPPLIER_SELECTION and trigger attribute: PO_ORD_H_VIEW_HAS_FAILED_CHECK_LOG_FILE
at oracle.ecc.persistence.repositories.impl.PrecedenceRuleRepositoryImpl.getPrecedenceRulesFromDtoList(PrecedenceRuleRepositoryImpl.java:131
..
 dataset: po-pcc-agreements
  status: FAILURE
  Load Type:METADATA_LOAD

Query:
SELECT DISTINCT
  'PO_ORD_H_'
  || upper(regexp_replace(col.end_user_column_name, '[^a-zA-Z0-9]', '_')) target_instance_attribute,
  'PO_ORD_H_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 = 201
  AND con.application_id = col.application_id
  AND col.descriptive_flexfield_name = 'PO_HEADERS'
  AND col.descriptive_flex_context_code = con.descriptive_flex_context_code;

  status: FAILURE

  status Message: There is an error while trying to ingest data for this load rule po_pcc_agreements_util_pvt.get_desc_metadata_load_info with dataset po-pcc-agreements for job 13,694
  Dataset attributes doesn't have one of the attribute keys targetAttribute: PO_ORD_H_SUPPLIER_SELECTIONand trigger attribute: PO_ORD_H_VIEW_HAS_FAILED_CHECK_LOG_FILE
..

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Run full load for procurement data.

2. Error is logged in the 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.