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.

Symptoms

On : 12.1.3 version, Purchase Order

ACTUAL BEHAVIOR
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

STEPS TO REPRODUCE
Navigation:
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.


BUSINESS IMPACT
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.

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