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 MARCH 09, 2017

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.