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

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version 1.8.1.1 and later
Information in this document applies to any platform.

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

 

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