My Oracle Support Banner

PO Induction Process Is Creating Orders With SYSTEM_OPTIONS.BASE_COUNTRY_ID Instead Of Using Physical Warehouse Location (Doc ID 2373431.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


When an order is created using Purchase Order(PO) Induction process, Import Country is defaulted from t from the default country setup in SYSTEM_OPTIONS.

RMSSUB_XORDER package performs a validation using the virtual location identifier against the ADDR table, which does not contain any entries associated with a virtual warehouse.

If this occurs, Import Country code will be defaulted to the one setup in SYSTEM_OPTIONS instead of using Physical Warehouse country code.

Steps to reproduce:

  1. Create a PO using induction process.
  2. Assure that SYSTEM_OPTION.BASE_COUNTRY_ID is different from Physical Warehouse Country from address table.
  3. Notice that ORDHEAD, IMPORT_COUNTRY_ID will be defaulted with BASE_COUNTRY_ID instead of Warehouse country.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.