After Patching Updating of Planned Quantity Using GNE_API_PUB.UPDATE_MATERIAL_LINE API Fails With FLEX-USER DEFINED ERROR
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.
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.
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.)
The issue can be reproduced at will with the following steps:
1. Run API wrapper to update planned quantity
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms