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 1.7.15.3.2 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

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
(SYNERGEN.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.

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