My Oracle Support Banner

Item Reclassification Does Not Validate Against Approved Orders (Doc ID 1587317.1)

Last updated on FEBRUARY 26, 2019

Applies to:

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


When performing Item Reclassifications through Retail Integration Bus (RIB), the validations that the item, child item or grandchild item do not exist on an ‘A’pproved order is not performed as it is when the reclassification is entered in the on-line RMS screens.

All validations that are performed in the on-line screens have to be performed in the RIB Item Reclassification processing as well, or the reclassification batch (reclsdly.pc) will be allowed to incorrectly reclassify items.

Steps to Reproduce:

  3. Create and ‘A’pprove a purchase order to a Level 2 item.
  4. Try to reclassify the level 1 item on-line and notice the error message: “The specified item(s) or its child(s)/grandchild(s) to be reclassified is on approved orders(s).”
  5. Notice that no records are created in RECLASS_HEAD / RECLASS_ITEM.
  6. Now attempt to reclassify via the RIB Item Reclassification capabilities (i.e., RMSSUB_XITEMRCLS). Notice that records are created in RECLASS_HEAD / RECLASS_ITEM.
  7. Run the reclsdly.pc batch process.
  8. Run the prepost recldly post process.
  9. Notice that the item and its child/grandchildren have been reclassified.
  10. Notice that the purchase order has had its DEPT set to NULL.



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.