My Oracle Support Banner

After Run Inv_Replenish_Detail_Pub.Line_Details_Pub API, There Is No Data on Mtl_Material_Transactions_Temp, Even Though There Is Sufficient On-Hand Quantity. (Doc ID 2547738.1)

Last updated on JULY 24, 2021

Applies to:

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

Symptoms

Actual Behavior
After run INV_REPLENISH_DETAIL_PUB.LINE_DETAILS_PUB API, there is no data on MTL_MATERIAL_TRANSACTIONS_TEMP,
Even though there is sufficient on-hand quantity.
Lot Divisible value is un-checked(No) on Master Item.
There are 2 rows on-hand quantity has different ORIG_DATE_RECEIVED value.

INVENTORY_ITEM_ID ORGANIZATION_ID DATE_RECEIVED           TRANSACTION_QUANTITY SUBINVENTORY_CODE LOT_NUMBER ORIG_DATE_RECEIVED
123 111 2018-12-21 00:00:00 500 RIP A 2018-12-21 00:00:00
123 111 2018-12-25 00:00:00 5000 RIP A 2018-12-25 00:00:00

Expected Behavior
If there is sufficient on-hand quantity, MTL_MATERIAL_TRANSACTIONS_TEMP data should be generated after INV_REPLENISH_DETAIL_PUB.LINE_DETAILS_PUB API.

Steps to Reproduce

  1. To check on-hand quantity.
    (N)INV > On-hand, Availability > On-hand Quantity
  2. To create Move Order
  3. To run INV_REPLENISH_DETAIL_PUB.LINE_DETAILS_PUB API
  4. To check MTL_MATERIAL_TRANSACTIONS_TEMP data

Cause

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
Symptoms
Cause
Solution
References


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