Cost Invoice Job - ERROR: Too Many Work Order Material Records (Doc ID 1511592.1)

Last updated on JULY 27, 2022

Applies to:

Symptoms

Line item is not removed from the WO Material List when the item is transferred to a new Purchase Order. The Cost Invoice Job then fails with the following error:


ERROR
-----------------------
ERROR: Too many Work Order Material records


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

1. PO has line item that references Work Order
2. PO is canceled
3. Line item is transferred to a new PO
4. New PO is issued.
5. Work Order referenced on the line item has 2 entries for the item on the Material List
6. PO is received and Invoiced. Cost Invoice shows too many material items error

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.