PO CLM ECC Data Load Concurrent Program Error with ORA-00904: "EXT"."UEI_EFT": Invalid Identifier (Doc ID 2961583.1)

Last updated on JULY 20, 2023

Applies to:

Symptoms

PO CLM ECC Data Load Concurrent Program failed with below error captured in concurrent log file

sqlQuery: SELECT gt.char1 ECC_SPEC_ID , EXT.ADDRS_DTLS , EXT.CAGE_CODE ,
EXT.CCR_EXP_REASON_DISP AS CCR_EXP_REASON , EXT.CCR_REG_IDICTR ,
EXT.CCR_REG_STATUS , EXT.DOING_BSNS_AS , EXT.DUNS_4_NUM , EXT.DUNS_NUM ,
EXT.EFT_EXC_RESN_DISP AS EFT_EXC_RESN , EXT.EFT_INDCTR , EXT.EMAIL ,
EXT.HIDD_ADDRS_XML , EXT.HIDD_CNTCT_XML , EXT.HIDD_ORG_ID ,
EXT.HIDD_REMIT_XML , EXT.HIDD_VENDOR_ID , EXT.ORIG_SPLR_NAME , EXT.PHONE_NUM
, EXT.PHY_ADDRS , EXT.REMIT_TO_ADDRS_DISP AS REMIT_TO_ADDRS ,
EXT.SOCIO_EC_INFO , EXT.SUPLR_SIZE_DISP AS SUPLR_SIZE , EXT.SUPPLR_CONTACT ,
EXT.TIN_NUM , EXT.UEI , EXT.UEI_EFT FROM po_session_gt gt ,
ECC_PO_HDR_SUPPLIER_DTLS_AGV EXT WHERE gt.key = 56032557 AND
ext.po_header_id = gt.index_num2 AND ext.draft_id = gt.num2
startTime: Thu Jun 15 11:08:56 EDT 2023
endTime: Thu Jun 15 11:08:56 EDT 2023
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 PO_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset
po-clm-award for job 17,444,438 ORA-00904: "EXT"."UEI_EFT": invalid
identifier
oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)

Steps

1. Login to EBS with CLM responsibility
2. Navigation -> Requests
3. Submit 'PO CLM ECC Data Load' concurrent program to run with below parameters
    - Load Type = INCREMENTAL_LOAD
4. 'PO CLM ECC Data Load' Concurrent program completed with above error captured in concurrent log file

Cause

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