Creating a work order through API EAM_PROCESS_WO_PUB.PROCESS_WO does not return any error message (Doc ID 390316.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Enterprise Asset Management - Version 11.5.10 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Apr-2013***


Symptoms

EAM_PROCESS_WO_PUB.PROCESS_WO API has problems with the following scenarios:

1) In Oracle Enterprise Asset Management, inserting a work order which already exists, through Work Order API EAM_PROCESS_WO_PUB.PROCESS_WO), would return status 'S', but no wip entity id generated. Actually, return status should be E with appropriate error messages.

Expected behaviour: Actually, return status should be E with appropriate error messages. Functionally is correct that the work order is not getting created but the output should have been a status of 'E' and an appropriate error message.

2) Insert Api for a work order being called with status as 'cancelled or complete' Actual Result: Return Status : S But no wip entity id generated Expected behaviour: Return status should be E with appropriate error messages

3) Insert api for a work order being called with scheduled start date the completion date
Actual Result: Return Status : S But no wip entity id generated.
Expected Result: Return status should be E with appropriate error messages

4) Insert Api for a work order being called with both (asset number &asset group) and (rebuild serial number &rebuild item id) passed.
Actual Result: Return Status : S But no wip entity id generated
Expected Result: Return status should be E with appropriate error messages

5) Creating a work order having requested/due date outside activity association dates, through Work Order API (EAM_PROCESS_WO_PUB.PROCESS_WO) would not return any error message.
Expected Result: Return status should be E with appropriate error messages Actual Result: Return status is E . No error message though.

The issue can be reproduced at will with the following steps:
1. Run the pl/sql script or try creating a work order using the values

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