MISSING EXPENSE CODE ERROR WHEN ACTIVING WO WITH A CU THAT HAS DIRECT MATERIAL
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.
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