Indra

• Jul 14th, 2006

 

The necessary step we have to follow to implement Flexfield in forms:

1. Create a table through which we are going to create the flex field.

2.Registered the table.

3.Registered the column of the table.

4.Insert few data into the table.

5.fire a commit statement after inserting the data.

6.Nevigate to Oracle System Administrator Responsibility->Corresponding flexfield Register.

7.Nevigate to Oracle System Administrator Responsibility->Corresponding flexfield Segment.

8.Create a non-database field in your form where you are going to implement the flexfield.

9.Define the corresponding flexfield in the WHEN-NEW-FORM-INSTANCE trigger of your form.

10.Activate the event like WHEN-NEW-ITEM-INSTANCE and WHEN-VALIDATE-ITEM in the created non-database field item by using FND_FLEX.EVENT procedure.

11. Run your form and text it.