ECEPOO and ECEPOCO Errors - PL/SQL cIn_string ORA-20001 (Doc ID 393035.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle EDI Gateway - Version 11.5 to 12.2.5 [Release 11.5 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 31-Dec-2012***

Symptoms

Running the 850 Purchase Order Outbound (ECEPOO) or 860 Purchase Order Changes Outbound (ECEPOCO) transaction in e-Commerce Gateway produces errors.  Here are the errors reported for the 850 Outbound transaction in Release 11.5.10:

Program Error: PL/SQL position not found for cIn_string.
Program level POOB-TZ-1001: Please check the log file, correct the problem, and
try again.
SQL error message ORA-20001: .
Program level POO-10-1040: Please check the log file, correct the problem, and
try again.
SQL error message ORA-20001: .

 

Here are similar errors reported for the 850 Outbound transaction in Release 12.1:

Enter ECE_FLATFILE_PVT.Find_pos->29-SEP-2010 12:19:13
Search text : ==>SHIP_TO_CUSTOMER_NAME
nColumn_count : ==>115
Program Error: PL/SQL position not found for cIn_string.
Program level POOB-10-1428: Please check the log file, correct the problem, and try again.
SQL error message ORA-20001: .
Program level POO-10-1040: Please check the log file, correct the problem, and try again.
SQL error message ORA-20001: .

 

 

Changes

Upgrade to a higher applications release

   - OR -

Application of an ATG_PF rollup patch, or any EDI mini-pack, that contains updated to the EDI files in the $EC_TOP/patch/115/sql directory.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms