R12:Format Payment Instructions Error ECE_TP_LOCATION_CODE Invalid Identifier (Doc ID 1560652.1)

Last updated on AUGUST 11, 2022

Applies to:

Symptoms

On : 12.1.3 version, Pmt PayReports PBatch & Prepay

When attempting to run Format Payment Instructions with Text Output
the following error occurs.

ERROR
-----------------------
Format{formatCode:=IBY_PAY_ECE,formatType:=OUTBOUND_PAYMENT_INSTRUCTION,templateCode:=IBYDE_ECE,defaultOutputType:=null,locale:=en_00,extract:=Extract{extractCode:=IBY_FD_PAYMENT_INSTRUCTION,extractVersion:=1}}
saveExtract: true
extract_type: FD_PAYMENT_PMTINSTR
param: N
elecChannel: ECE
Fetching extract
After fetching extract, doc is null!
After extract call args, before create extract.
No extract has been previously created. Create extract.
java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 353
ORA-06512: at line 1

Error message in the fnd log:

 Enter ECE_ERROR_HANDLING_PVT.Print_Parse_Error->30-MAY-2013 06:37:58
         ECE_PARSING_ERROR (ERROR_POSITION=51)
         BAL_ATTRIBUTE20, TO_CHAR(BILL_TO_INT_LOCATION_ID), ECE_TP_LOCATION_CODE, BILL_TO
         _INT_LOCATION_NAME,
         ECE_ERROR_CODE (ERROR_CODE=-904)
         SQL error message ORA-00904: "ECE_TP_LOCATION_CODE": invalid identifier.
       Exit ECE_ERROR_HANDLING_PVT.PRINT_PARSE_ERROR->30-MAY-2013 06:37:58
       Time Taken 0 seconds
       Program level EC_OUTBOUND.LOAD_OBJECTS: Please check the log file, correct the problem, and try again.
       Error occurred while Parsing view for Level : 1 .
EXCEPTION :: END ::30-MAY-13 06.37.58.662101000 AM +00:00
Exit ECE_AP_PAYMENT: Timestamp:30-MAY-13 06.37.58.662699000 AM +00:00
Exit ECE_AP_PAYMENT: Timestamp:30-MAY-13 06.37.58.662699000 AM +00:00
After calling ECE_AP_PAYMENT.Extract_PYO_Outbound() API, return status: U
After calling ECE_AP_PAYMENT.Extract_PYO_Outbound() API, return status: U
An exception has occured when creating extract..
An exception has occured when creating extract..
IBY_EXTRACTGEN_PVT.Create_Extract: An exception has occured when creating extract..

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Payables
2. Payments Manager
3. Submit PPR

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot pay to suppliers.

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.