My Oracle Support Banner

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

Last updated on MARCH 12, 2021

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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