E1: 42i: OIM/VMI Report Consumption Via Product Activity Date R47121 Does Not Process FIFO Same as Interactive Report Consumption P42i03
(Doc ID 3012270.1)
Last updated on MARCH 25, 2024
Applies to:
JD Edwards EnterpriseOne Outbound Inventory Management - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
OIM / VMI Interactive Report Consumption P42i03 allows the selection of item/location and processes FIFO correctly. It does not need to be in item/location/lot inquiry mode to process FIFO and the system processes consumption of lots with no issue. The Product Activity Data R47121 requires entry of item/location and lot information which is manual FIFO for Report Consumption. Since the P42i03 allows a quantity consumed by item/ location even with item records where there are lots and FIFO is correct, the R47121 should allow this functionality and not have the lot number field be mandatory.
Also, if the lot is not populated, the R47121 will end in Errors:
Invalid OIM Agreement
Invalid Consumed Qty
Consumption Report Failed
The generation of the errors enforces the necessity of adding the lot number so the item/location/lot records are found for sales orders ready for Report Consumption.
Steps to Duplicate:
1. Create OIM or VMI sales order P42101 for an item with location and lots that expire at different times.
2. Ship Confirm P4205 / Set OIM processing options to Not Auto-Acknowledge.
3. Manual Acknowledgement P42i02 | xjde0001 version.
4. Populate EDI Header & Detail tables F47121/F47122 for EDI Inbound 852 R47121 with the Item and Location| where the Processing Options call Report Consumption P42i03.
5. Execute the R47121.
Receive Errors
Invalid OIM Agreement
Invalid Consumed Qty
Consumption Report Failed
No record is created in the F42i03 Report Consumption table.
6. If you run the same test above, but input the lot numbers, the program processes successfully. The problem is the users had to choose the exact lots in order to process FIFO and ensure the R47121 did not error.
Run test via Interactive Report Consumption P42i03
1. Create OIM sales order P42101 with item/ location/ and different lot expiry dates.
2. Ship Confirm P4205
3. Manual Acknowledgement P42i02 | xjde0001
4. Report Consumption P42i03 using Inquiry Mode Item/ Location only.
This creates a record in the Report Consumption (F42i03) table with inventory relieved for lots using FIFO. The program reports consumption of lots using FIFO in Inquiry mode Item/Location with no issue. It is not necessary to be in Item/Location/Lot mode to chose lots.
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 |