Getting a Warning when compiling DFF.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    Warning when compiling DFF.

API Programming Error (CS_ServiceRequest_PUB.Create_ServiceRequest): An error occurred when validating the descriptive flexfield. Additional information: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

Log files:

API Programming Error (CS_ServiceRequest_PUB.Create_ServiceRequest): An error occurred when
validating the descriptive flexfield. Additional information: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

Also, in Descriptive Flexfield Segments setup can see this error:

BLOCK FIELD references are only supported in Oracle Forms.
The Segment "Vehicle Registration No" of context VRTJC uses value set "XXFZ_VEH_TEJ_CAN" which has BLOCK reference INCIDENT.TRACKING in it's where clause or Additional Columns.

Solution:

In OA (11.5.10) based pages, you cannot reference :BLOCK.FIELD as you used to do in Oracle forms. However users can achieve this reference fields functionality in OA based pages in R12. This feature is not available in R11.5.10. Please check the following links for reference field implementation in R12 and R11i.

R12
----
http://www-apps.us.oracle.com:1100/fwk/fwksite/1206devguide/feat/feat_flexfields.htm#dffreffield

R11.5.10
----------
http://www-apps.us.oracle.com:1100/fwk/jdev11510/doc/devguide/feat/feat_flexfields.htm#reffields

For 11.5.10 alone : Note: Reference fields for descriptive flexfields are supported by Forms-based Oracle Applications, but not by OA Framework. A developer mode error occurs in JDeveloper if you
try to implement this feature in OA Framework. Refer to the "Reference Fields" section of Chapter 3 ("Planning and Defining Descriptive Flexfields") in the Oracle Applications Flexfields Guide Release 11i for additional information about reference fields.

Remember, even though OA Framework implements the context flexfield, it is up to each functional product to implement or not the feature.

References:

check Note 377160.1 that gives you an explanation about this error message and also how BLOCK.FIELD variables should be used in EBusiness suite.

Get Oracle Certifications for all Exams
Free Online Exams.com