Quality Results Sent Via Eam_process_wo_pub.Process_wo Have Invalid Status 1 (Doc ID 1357284.1)

Last updated on JUNE 01, 2016

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

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.


EXPECTED BEHAVIOR

If they pass validation, then the status should not be 1. It seems to be hard coded into the procedures.

STEPS

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.

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