My Oracle Support Banner

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 DECEMBER 03, 2019

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.