The GME API gme_api_pub.update_material_line Nulls Out the Contribute To Yield and Contribute to Step Quantity Fields/Columns

(Doc ID 2392905.1)

Last updated on APRIL 30, 2018

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, API Issues

ACTUAL BEHAVIOR
---------------
Applying <patch 27430619>, which brings in the fix for <bug 26986447> causes a new issue. When calling the gme_api_pub.update_material_line API without passing in a value for 'contribute to yield' or 'contribute to step quantity', those columns get nulled out.

There should be code like the following, as there is for most other data like this:

IF p_material_detail_rec.contribute_yield_ind IS NOT NULL THEN

so it will not go into any other code unless user is actually passing in a value. In this code, this check is not there.


EXPECTED BEHAVIOR
-----------------------
Expect the values already in those columns to be left alone if the user does not pass in a new value.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Call the API without passing in new values for those columns

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, data is being corrupted.

Changes

 

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