My Oracle Support Banner

Enterprise Command Center (ECC) Project Costing and Billing Data Load - No Data Retrieved and Error ORA-01467: Sort Key Too Long (Doc ID 3010544.1)

Last updated on APRIL 30, 2024

Applies to:

Oracle Project Costing - Version 12.2 and later
Oracle Enterprise Command Center Framework - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

ECC Project Costing and Billing Data Load request was run but no data appears in the dashboard.

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

  1. Login with Projects Super User Responsibility.
  2. Navigate to Requests > Submit.
  3. Run PAECCCADLCP: Projects Costing and Billing ECC Data Load.
  4. Request ECCRUNDL: ECC Run Data Load is triggered.
  5. Navigate to Projects Command Center menu.
  6. Click on Costing Dashboard icon.
  7. No data is retrieved.

ERROR is seen in log file of request ECCRUNDL: ECC Run Data Load

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 67,750 ORA-01467: sort key too long

 

Changes

 Upgraded to 19C Database.

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.