My Oracle Support Banner

Error AHL_UMP_INVALID_STTS_CHNG When Using API AHL_PRD_WORKORDER_PUB To Change Work Order Status (Doc ID 779638.1)

Last updated on MARCH 22, 2019

Applies to:

Oracle Complex Maintenance, Repair, & Overhaul - Version 11.5.10.2 and later
Information in this document applies to any platform.

AHLPWOSB.pls
AHL_PRD_WORKORDER_PUB
process_workorder

Symptoms

When attempting to change the status of the work orders by using the API AHL_PRD_WORKORDER_PUB.process_workorder, the following error occurs:


ERROR
"Cannot change status from 3 to 4"
[e.g. "Cannot change status from &FROM_STATUS to &TO_STATUS"]


EXPECTED BEHAVIOUR
Expecting the changing of work order status from Released (Status 3) to Complete (Status 4) to be successful.
From the Application screen of the work orders, changing a work order from Released (3) to Complete
(4) status completes without any errors.


STEPS
Use the API call 'AHL_PRD_WORKORDER_PUB.process_workorder' to change a work order's status from Released (Status 3) to Complete (Status 4)

Cause

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
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.