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 JULY 20, 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

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.