BILL_TO_LOCATION_CODE And SHIP_TO_LOCATION_CODE Fields Not Showing Up In The Assign Code Conversion
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
STEPS TO REPRODUCE
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
Million Knowledge Articles and hundreds of Community platforms