Unable To Save a Record when reference to a block field exists in a DFF error APP-FND-01022 (Doc ID 331656.1)

Last updated on AUGUST 16, 2016

Applies to:

Oracle Learning Management - Version 11.5.10.0 to 12.2.1 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 27-JAN-2013***

Symptoms


o Customer receives the following error message when saving a record which reference a blockfield in the Add'l Delegate Booking Info descriptive flexfield window.


APP-FND-01022: The flexfield on this field contains a flexfield bind variable with a :BLOCKFIELD reference.

o The sequence of events :

- Application: System administration

- menu application>flexfield> Descriptive flexfield

- Title: Add'l Delegate Booking Info.

- create a segment that use a value set in with the following properties:

Table Name
hr_all_organization_units hou, hr_locations hl

Value
concat(address_line_1, address_line_2)

Where/Order By
where hou.organization_id = :BOOKING.TDB_INFORMATION1
and hou.location_id = hl.location_id

- save and compile

then:

- Application: System administration

- menu : Enrollment

- Enroll someone and go on the DFF

- save

APP-FND-01022: The flexfield on this field contains a flexfield bind variable with a :BLOCKFIELD reference.

o Where it happened :
When customer tries to enroll a student and enter value for the DFF

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms