E1: 13: Purchase Order Entry - P4310 Blanks out the Fields Related PO/SO/WO Number (RORN) and Related PO/SO/WO Order Type (RCTO) in the Work Order Parts List - P13730 When F3111 and F3411 Tables Have the Same UKID Value (Doc ID 2863551.1)

Last updated on MARCH 01, 2024

Applies to:

Symptoms

The related purchase order generated in the Work Order Parts List - P13730 screen does not update the fields Related PO/SO/WO Number (Alias: RORN) and Related PO/SO/WO Order Type (Alias: RCTO) on the Work Order Parts List File - F3111. Only the field Related PO/SO Line Number (Alias: RLLN) is populated with the line number.
However, the OP order is created correctly, and the details of the purchase order can be found in the Purchase Order Entry - P4310 (and F4301, F4311) screen.
The issue only occurs when the Unique Key ID of the maintenance order parts detail line matches an existing UKID value already set in the MPS/MRP/DRP Message File - F3411.

The issue can be reproduced at will with the following steps:

1. P00022 - Change the UKID for table F3111 to match one of the existing UKID values existing in the F3411 table (e.g. 10000004)
2. P13700 > P13714 > P13730 - Add the same stock and non-stock components for operation sequence # 2 on the work order parts list
3. Databrowser - F3111; Note the new UKIDs of the two work order parts detail lines: 10000004 and 10000005; both UKID values exist in the F3411 table
4. P13714 > P13730 - Create a purchase order for the stock purchased component (Stk Ty = P, Ln Ty = S) on Op Seq # 2 by taking "Create Purchase Order" button; the fields Related PO/SO/WO Number (Alias: RORN) and Related PO/SO/WO Order Type (Alias: RCTO) are blank and the field Related PO/SO Line Number (Alias: RLLN) is populated with the corresponding line number; Save the changes
5. P4310 - Even if the F3111 / P13730 Related PO/SO/WO Number and Related PO/SO/WO Order Type fields are not updated, the purchase order is created correctly
6. Databrowser - F3111 - RORN and RCTO fields are not updated by P4310; only RLLN field has the Line Number set
7. P13714 > P13730 - Create a purchase order for the non-stock component on the second operation sequence; the fields Related PO/SO/WO Number (Alias: RORN) and Related PO/SO/WO Order Type (Alias: RCTO) are blank and the field Related PO/SO Line Number (Alias: RLLN) is populated with the corresponding line number; Save the changes
8. P4310 - Even if Related PO/SO/WO Number and Related PO/SO/WO Order Type fields are not updated in the F3111 / P13730, the purchase order is created correctly
9. Databrowser - F3111 - RORN and RCTO fields are not updated by P4310; only RLLN field has the Line Number populated by P4310

Changes

Cause

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