My Oracle Support Banner

RMS 11: ORDHEAD Is Updated With Incorrect Values In RMS When Updating A Replenishment Order In SIM (Doc ID 1961727.1)

Last updated on FEBRUARY 21, 2019

Applies to:

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


When adding an item to an automatically generated worksheet order in SIM, some updates are done in ORDHEAD table in RMS.

Note that these orders are displayed in SIM via RSL for RMS, so there is no need to exist in SIM database before opening them.

Steps to Reproduce
1. Find a replenishment generated order in Worksheet status in RMS. Check the ORDHEAD table.
2. Go to SIM, search for and open the order.
3. Modify the order (eg. add a new item)
4. Save the order and check the ORDHEAD in RMS.

The following fields were changed:

ORDER_TYPE (which is set to N/B)
ORIG_IND (which is set to 7)
EDI_PO_IND (which is set to "N")
PRE_MARK_IND (which is set to "N")


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.