If BLOCK.FIELD Form References are used in the DFF value sets, Oracle will give a warning similar to the error message below:
The descriptive flexfield "PO Headers" of application "Purchasing" uses features which are only supported in Oracle Forms. This flexfield may not function in other environments such as OA Framework or PL/SQL APIs.
The number of warning messages: 2.
--------------------------------------------------------------
The segment "Blanket Context Test" of context "BLANKET" uses value set "Standard Document Type" which has BLOCK.FIELD reference "PO_HEADERS.TYPE_LOOKUP_CODE" in its Where clause or Additional Columns.
BLOCK.FIELD references are only supported in Oracle Forms.
--------------------------------------------------------------
The segment "Standard" of context "STANDARD" uses value set "Vendor Sites" which has BLOCK.FIELD reference "PO_HEADERS.VENDOR_NAME" in its Where clause or Additional Columns.
BLOCK.FIELD references are only supported in Oracle Forms.
Any form references must be specified and added to the Form References form in the DFF setup. Otherwise the Descriptive Flexfield will cause exceptions within Application Interface Wizard and will not function correctly.
An example has been provided below on how to set up Form References:
• Each Form Reference MUST have the ‘Form References’ field populated WITHOUT the colon ':'
• The associated Wizard Attribute column must then be selected.
• The Reference Type can either look at a column value in the section, or a static value, more information on reference types is below.
• The value populated depends on the type.
• Column ID will use the upload ID if selected, or else will use the sheet value.
• You may delete form references using the ‘Delete’ button.
Reference Types - Column
The value selected must be a sheet column. This will derive the value from a column within the current template. The column ID checkbox determines whether the sheet value or the Upload ID is used for the substitution (LOV Only).
Reference Types - Value
A Reference Type of Value replaces the Form Reference with a static value.
Refer to section:
