MISSING EXPENSE CODE ERROR WHEN ACTIVING WO WITH A CU THAT HAS DIRECT MATERIAL
(Doc ID 943245.1)
Last updated on OCTOBER 16, 2016
Applies to:Oracle Utilities Work and Asset Management - Version 126.96.36.199.2 and later
Information in this document applies to any platform.
This problem can occur on any platform.
The following error is generated when Activing a Work Order that references a
CU which has a Direct Stock Item :
ERROR: Inserting into SA_REQUISITION_ITEM_ACCOUNTS ORA-01400: cannot insert
The data conditions are:
The Direct Stocked item has only the Debit Expense Code populated on the
The Direct Stocked Item exists in only 1 Storeroom (hence the storeroom is
automatically populated in the Items Worksheet)
When this problem occurs,the Expense Code field is not populated on the
Material Detail record (which results in the error message above). If the
Storeroom on the Items Worksheet is removed and re-entered using the LOV,the
problem does not occur.
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