After Patching Updating of Planned Quantity Using GNE_API_PUB.UPDATE_MATERIAL_LINE API Fails With FLEX-USER DEFINED ERROR (Doc ID 2020073.1)

Last updated on MARCH 08, 2017

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

After patching, when updating plan_qty via API gme_api_pub.update_material_line API.
the following error occurs.


ERROR
-----------------------
FLEX-USER DEFINED ERROR (MSG=The flexfield on this field contains a flexfield bind variable with a :BLOCK.FIELD reference. This prohibits operation in the mode that optimizes performance over a wide-area network.

To continue using this form, have the system administrator either remove all :BLOCK.FIELD references, or turn off wide area operation by setting the profile option - Flexfields: Validate on Server to N. The reference may be in a WHERE_CLAUSE token passed into the flexfield definition in the form, a WHERE clause in a table-validated value set, or a default value for one of the segments of this flexfield.)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run API wrapper to update planned quantity



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