My Oracle Support Banner

Total Receipt Cost Captured In TD Does Not Match With Total Available Receipt In REIM (Doc ID 2983368.1)

Last updated on OCTOBER 30, 2023

Applies to:

Oracle Retail Invoice Matching - Version 16.0.3 and later
Information in this document applies to any platform.


Total receipt cost for a non-pack catchweight item as captured in TRAN_DATA (TC20) does not total receipt cost when viewed in REIM.

The issue can be reproduced at will with the following steps:
1. Create a purchase order for 2 units of a non-pack catchweight item.
2. Fully ship the 2 units of the order.
3. Receive the 2 units with weight received slightly deviating from the nominal weight of the item. Ex. if item's nominal weight is 10lbs, receive with 10.2lbs
4. Capture total cost for the PO in TRAN_DATA upon receipt. Moreover, capture the TOTAL_COST_EXCL_ELC. These 2 costs should be the same if landed costs aren't factored in. In this case no landed costs are applied on the PO.
5. Open REIM -> Summary Match and search the receipt using the PO number generated above.
6. Compare the Available Amount value vs the total cost (exclusive of ELC)


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.