My Oracle Support Banner

Shipsku.adjust_type Is Being Updated With SL Regardless There Is Discrepancy Or Not (Doc ID 2678005.1)

Last updated on JUNE 08, 2020

Applies to:

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


Shipsku.adjust_type is being updated with SL regardless there is discrepancy or not

For the warehouse to store transfer, shipsku.adjust_type is being populated with SL even though there is not receipt discrepancy. This is only occur for the system_option.TSF_Force_Close_IND='SL' and system_option.TSF_Over_Receipt_ind='SL'. This problem is only for "SL" adjust type. For others, it will only populate the shipment line if there are shipment/receipt discrepancy.

Steps to Recreate:
1. Create warehouse to store transfer in RMS with multiples item in the transfer
2. Create shipment
3. Receive the shipment in SIM (perfect receive, over/short receipt)
4. once RIB message processed, query to shipsku table where distro_no is equal to your transfer order number. You will see the perfect receipt line will have adjust_type=SL.
5. Repeat the above step to create addition warehouse to store transfer, you can make a perfect receipt in SIM. After the RIB processed, shipsku table will populate adjust_type=SL even though it is perfect receipt.


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.