My Oracle Support Banner

Cartons With Adjust Type 'RE' Appearing In Stock Order Reconciliation Screen (Doc ID 2790285.1)

Last updated on SEPTEMBER 07, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.


Cartons with Adjust type RE appearing in stock order reconciliation screen.Cartons adjusted with RE (for wrong store receipts) have no open inventory issues since tran_data posting (TC30, TC32) are reversed and rewritten for wrong store receipts. The adjust type is populated properly, but these shipments show as open on stock order reconciliation screen.
No transactions are posted in backend when any Adjustment type is selected from RMS UI, however it gives incorrect status for the shipment which needs to be corrected.
Also qty_expected is not updated even though extra TC32 entry is present in TRAN_DATA table.

Steps to Recreate:

  1. Create transfer.
  2. Ship the same.
  3. Receive at wrong store. Make sure no open inventory available to receive further.
  4. Check the data. Try to open this shipment in stock order reconciliation screen. Still it is shown in the screen.




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.