My Oracle Support Banner

XOrder API Is Not Populating IMPORT_COUNTRY_ID Correctly (Doc ID 2565232.1)

Last updated on AUGUST 26, 2019

Applies to:

Oracle Retail Merchandising System - Version 15.0.1 and later
Information in this document applies to any platform.


XOrder API is not populating IMPORT_COUNTRY_ID correctly. The IMPORT_COUNTRY_ID should be related to the warehouse related country.

When the purchase order (PO) is created using XOrder, for Order Header and Order Detail call in the same request, the IMPORT_COUNTRY_ID is populated correctly.
If Order Header and Order Detail call are not in the same request the IMPORT_COUNTRY_ID, the IMPORT_COUNTRY_ID is populated incorrectly (the IMPORT_COUNTRY_ID for all POs are always picked by the system options default Country).

Steps to reproduce:

  2. Create new order header.
  3. Add the order details  to the previous order header.
  4. Approve the order.
  5. Notice that IMPORT_COUNTRY_ID for the process order from ORDHEAD table took the value from the system options default country ( SYSTEM_CONFIG_OPTIONS.BASE_COUNTRY_ID ).




To view full details, 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 a vibrant support community of peers and Oracle experts.