My Oracle Support Banner

Fixed Asset Removal Records Not Getting Action Set in SA_WORK_ORDER_FIXED_ASSET table (Doc ID 2304476.1)

Last updated on DECEMBER 13, 2017

Applies to:

Oracle Utilities Work and Asset Management - Version and later
Information in this document applies to any platform.


On : version, Maintenance


In the current versions of WAM, when inserting a CU Worksheet with the Function REMOVE, the record gets inserted into the table SA_WORK_ORDER_FIXED_ASSET, but the column ACTION is NULL.  The Action should be “RETIRE” not NULL.

Action should be “RETIRE” not NULL.

The issue can be reproduced at will with the following steps:

1. Go to the WO task detail

2. CU Worksheet

3. Inserted a new record

4. Add a CU, add Est Qty, Function - Removal, Difficulty - Normal, Usage, Accounting Treatment - Capital, and saved

5. Go to table SA_WORK_ORDER_FIXED_ASSET - the fixed asset record ACTION is Null - it should be RETIRE

The issue has the following business impact:
Due to this issue, With no Action these assets would not have been processed by the system and would not have been interfaced.




To view full details, 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 a vibrant support community of peers and Oracle experts.