E1: 31P: Using Purchase Orders - P4310 to Cancel ETO Related Purchase Order Detail Lines Blanks Out the Related PO/SO No, Rel Order Type and Related PO/SO Line No Fields in W.O. Parts List - P3111 (Doc ID 2906370.1)

Last updated on APRIL 03, 2024

Applies to:

Symptoms

When an ETO Project has a work order attached to a shippable task and if the WO Parts List contains two different related purchase orders created for the same component, with different Lot Serial Numbers and cancelling one of these purchase orders, the system blanks out the Related PO/SO No (Alias: RORN), Rel Order Type (Alias: RCTO) and Related PO/SO Line No (Alias: RLLN) fields for both WO parts detail lines, although the View Related Orders form in P31P001 shows correct results for both related purchase orders (one being cancelled and the other one being open).

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

1. P4101 / P41026 - Create 1 project specific parent item (Stk Ty = G, Ln Ty = S) and one project specific component (Stk Ty = H, Ln Ty = SC).
2. P3002 / P3003 - Create BOM / Routing for the parent item.
3. P31P001 - Create an ETO Project with a shippable task using the project specific parent item.
4. P31P001 - Process MFG Task.
5. P31P001 > More Task Actions > Mfg Parts List option - Verify the WO P.L. (P3111).
6. P3111 > Row Exit > Create PO option - Create a related OP order for project specific component defined on the parts detail line. Note the OP # .
7. P31P001 - Save the Project.
8. P31P001 - View Related Orders form shows the related OP order.
9. P31P001 > More Task Actions > Mfg Parts List option - Open the WO P.L. (P3111).
10. P3111 - Manually add a new part detail line for the same component but using a different Lot Serial Number; Save the changes.
11. P31P001 - Hit Save and Continue button.
12. P31P001 > More Task Actions > Mfg Parts List option - Open the WO P.L. (P3111).
13. P3111 > Row Exit > Create PO option - Select the second parts detail line and create a related OP order too. Note the OP #.
14. P31P001 - Select the MFG shippable task. In the View Related Orders form, select one of the related purchased orders and take Edit Order button.
15. P4310 - Edit the purchase order by taking Row Exit > Cancel Line option.
16. P31P001 - The View Related Orders form shows the second OP # being canceled (Last Status = 980, Next Status = 999). The fist OP # is still open (Last Status = 220, Next Status = 230).
17. P31P001 > More Task Actions > Mfg Parts List option - Open the WO P.L. .
18. P3111 - Both WO parts detail lines have the Related PO/SO No (Alias: RORN), Rel Order Type (Alias: RCTO) and Related PO/SO Line No (Alias: RLLN) fields blanked out. The data integrity is not maintained between the ETO Project (F4080, F3111) and project specific supply orders (F4301, F4311).
19. F4080 - Related Order Cross Reference Table shows both OP orders being attached to the WO P.L..

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.