My Oracle Support Banner

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.


On : 12.1.3 version, API Issues

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.

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

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

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




To view full details, 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 a vibrant support community of peers and Oracle experts.