R12: AP/ECC: Error Ora-00972 Occurs When Ecc Run Data Load is Run on Enterprise Command Center V5 (Doc ID 2746894.1)

Last updated on JANUARY 26, 2021

Applies to:

Symptoms

On : 12.2.8 version, ECC Payables V5

When we run Payables Command Center Data Load, we get the following "ORA-00972: identifier is too long" error in ECC Run Data Load(ECCRUNDL).

ERROR MESSAGE:
---------------------------------
 Details of auditDataset#: 4621
     dataset: ap-trx
     startTime: Wed Nov 04 13:55:19 JST 2020
     endTime: Wed Nov 04 13:55:48 JST 2020
     status: FAILURE
     statusMessage:
There is an error while trying to ingest data for this load rule
AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset ap-trx for job 4,617
ORA-00972: identifier is too long
oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)

Looking at the sqlQuery being executed, one of the alias of column exceeds 30 bytes.
If the DFF name of AP Invoice is 28 or more bytes, it looks like an error on ECC loading.

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.