My Oracle Support Banner

Unable To Tie Onhand With Receipts (Doc ID 1085042.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Inventory Management - Version 11.5.10 and later
Information in this document applies to any platform.

Goal

Question :

We are trying find out which receipts are tied to on-hand transactions. When we first receive a PO, there is a column MTL_ONHAND_QUANTITIES_DETAIL.CREATE_TRANSACTION_ID that we could tie to the material transaction record to figure out the receipt. But after performing a subinventory transfer, that ID is being changed. We would like to know if this is a bug in Oracle when the original created transaction ID is updated instead of update transaction ID.

Support Test Case:

Created new item: ATS-VF 100
Assigned item to M1 Seattle Manufacturing
Misc Receipt, 4 lines for 10 items each
After Misc Receipt, complete subinventory transfer for quantity 12.

Support test results after 4 misc misc receipt transactions of 10 items each.
Data is from mtl_onhand_quantities_detail table.

PRIMARY_TRANSACTION_QUANTITY SUBINVENTORY_CODE CREATE_TRANSACTION_ID UPDATE_TRANSACTION_ID
10 FGI 15894244 15894244
10 FGI 15894245 15894245
10 FGI 15894246 15894246
10 FGI 15894247 15894247


Support test results after subinventory transfer of 12 items to subinventory 'JBP Subinv'.
Data is from mtl_onhand_quantities_detail table.

PRIMARY_TRANSACTION_QUANTITY SUBINVENTORY_CODE CREATE_TRANSACTION_ID UPDATE_TRANSACTION_ID
8 FGI 15894245 15894251
10 FGI 15894246 15894246
10 FGI 15894247 15894247
12 JBP Subinv 15894252 15894252



Results:
-----------
This test case confirmed the data shown in mtl_onhand_quantities_detail table.

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.