E1: 41: R41505 Not Tracing Last IM (Material Issue) Only

(Doc ID 2386095.1)

Last updated on APRIL 13, 2018

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

R41505|XJDE0001 (Batch Lot Tracing) is tracing only the last inventory issue (IM). On the other hand, P41203|ZJDE0002 (Lot Track & Trace Inquiry) to Trace the Lot Usage yield different outcome.

cf., R41505|XJDE0002 (Lot Tracking) and P41203|ZJDE0001 has similar behavior, which is fixed. Refer to <Document 2357994.1> - E1: 41: Lot Track and Trace Print (R41505) Does Not Track All Lot Usage When Partial Completion is Performed.

The simplified steps are described here to show the visual representation.

1. (P3002) Add BOM (Bill of Material) parent item which is made up of chicken and rice (purchased items)
2. (P4310) Enter purchase order for components child01 and child02 with quantity 6
3. (P4312) Receipt PO for child01 * 6, and child02 * 6 to the lot 'REC01'
4. Enter Work Order with parent item * 6
5. Attach part list
6. (P31113) Issue received component with quantity 3 from the receipt lot 'REC01'
7. (P31114) Complete WO (Work Order) based on material issued parent item * 3 to the lot 'COMP01'
8. Issue child01 * 2, and child02 * 2 on REC01
9. Complete parent item * 2 on COMP01
10. Issue the balance child01 * 1, and rice * 1
11. Complete parent item * 1
12. (Optional) Trace 'parent item' using P41203|ZJDE0002 which explode all IM (Material Issue) 3, 2, and 1
13. Run R41505|XJDE0001 and verify that in tracing parent item (or, COMP01) which represents only the last IM (REC01 * 1 for IM in step 12)

As - Is representation

Level       Lot Number                      Trans Qty                    Ty

-------------------------------------------------------------------------
1             COMP01                               6.0000                   IC

. 2           REC01                                  1.0000-                 IM

..3           REC01                                  6.0000                  OV

   : The second row in above example, does not trace inventory issue. It issued only 1 but completed with the quantity 6.                              

To - Be representation

Level       Lot Number                      Trans Qty                    Ty

-------------------------------------------------------------------------
1             COMP01                               6.0000                   IC

. 2           REC01                                  6.0000-                 IM

..3           REC01                                  6.0000                  OV

 

 

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms