Quality Results Sent Via Eam_process_wo_pub.Process_wo Have Invalid Status 1
(Doc ID 1357284.1)
Last updated on JULY 28, 2020
Applies to:Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.
When sending quality results with the work order completion EAM_PROCESS_WO_PUB.process_wo, the STATUS field of the QA_RESULTS record is set to 1 which is INVALID. There doesn't appear to be a way to change this.
qa_results_api.insert_row sets the STATUS to p_enabled_flag which comes from EAM_WO_QUA_UTILITY_PVT.insert_row which hard-codes that value to 1. So anyone calling EAM_PROCESS_WO_PUB.PROCESS_WO will not be able to send quality results via that PL/SQL API call without them being set to a QA_RESULTS.STATUS of 1 which, according to eTRM, is invalid.
If they pass validation, then the status should not be 1. It seems to be hard coded into the procedures.
The issue can be reproduced at will with the following steps:
1. Complete a work order using the script attached or a similar script.
2. This example is using the VISION demo data as a reference, specifically a fork lift in the EM1 organization.
3. Once the results are added, they aren't accessible from the QA Results Java interface in EBS and they can't be changed as far as I can tell.
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