BILL_TO_LOCATION_CODE And SHIP_TO_LOCATION_CODE Fields Not Showing Up In The Assign Code Conversion

(Doc ID 1575081.1)

Last updated on APRIL 07, 2016

Applies to:

Oracle EDI Gateway - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Purchase Order

Key Columns not showing up in the Assign code Conversion categories for POO and POCO in R12

BILL_TO_LOCATION_CODE and SHIP_TO_LOCATION_CODE Fields Not showing up in the Assign code Conversion categories for POO and POCO in R12. In the 11i instance, these fields mapped to BILL_TO_LOCATION and SHIP_TO_LOCATION categories and populating the EDI Location codes in the outbound document. These fields are used as identifiers on translator side.

This occurs every time because of missing mappings

e-commerce gateway > setup > code conversion > Assign code conversion categories

Next Query for PO/POCO and dont find the BILL_TO_LOCATION_CODE and SHIP_TO_LOCATION_CODE Columns
1. Enable a Supplier for POO and POCO.
2. Create a PO for the supplier. Approve it.
3. Run the POO process.
4. Make a change to PO and reapprove the PO.
5. Run the POCO process.

Due to this issue, Right now the POs are going out with missing/invalid/wrong Bill_to Location codes and ship to edi location codes. and the vendors are rejecting because they don't know where to ship the Items. More over EDI Vendors wont accept Paper POs.


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