850 POI Errors: Unable to derive a unique ship to address for the EDI Location Code

(Doc ID 341328.1)

Last updated on DECEMBER 01, 2017

Applies to:

Oracle Order Management - Version 11.5.10.0 to 12.2 [Release 11.5.10 to 12.2]
Oracle e-Commerce Gateway - Version 12.2 and later
Information in this document applies to any platform.
*** Checked for relevance on 01-Decl-2017 ***
ECEPOI


Symptoms

When attempting to run e-Commerce Gateway (EDI) 850 Purchase Order Inbound (POI) process, the following error occurs:

ERROR

Multiple table entries were found for ship to address for the Location Code ORL with the ORG_ID 999.


-- or --


Unable to derive a unique ship to address for the EDI Location Code XXXXXXXXX with the ORG_ID 99.

The ECEPOI log file is showing the following error messages :

...
Input to Address Derivation
l_transaction_type==>POI
l_tp_translator_code==>177667227
l_org_id==>89
l_tp_location_code==>RM0173055
Unable to derive a unique ship to address for the EDI Location Code RM0173055 with the ORG_ID 89.
...
Input to Address Derivation
l_transaction_type==>POI
l_org_id==>89
l_tp_translator_code==>177667227
l_tp_location_code==>PM0037374
Unable to derive a unique ship to address for the EDI Location Code PM0037374 with the ORG_ID 89.
...

Changes

 

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