MISSING EXPENSE CODE ERROR WHEN ACTIVING WO WITH A CU THAT HAS DIRECT MATERIAL
(Doc ID 943245.1)
Last updated on FEBRUARY 28, 2019
Applies to:Oracle Utilities Work and Asset Management - Version 22.214.171.124.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
NULL into (SA_REQUISITION_ITEM_ACCOUNTS.EXPENSE_CODE)
The data conditions are:
The Direct Stocked item has only the Debit Expense Code populated on the Storeroom record
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