Monday, April 16, 2012

Retrieve information from a DFF(Descriptive Flexfield)

Many times is neccesary add, modify or delete a DFF, but to find it can be, sometimes, imposible.
For do it, see instructions below:

Scenario: Find a DFF.

1. Go to screen when you need to add a new DFF.
(Help | Register History)





















2.Retrieve the table name.

3. Now navigating to Application Developer responsability.(Flexfield | Descriptive | Register)
Query on table name and store Title and Application Content. If the name is ended with _V it means View, so the table could be: OE_ORDER_HEADERS_ALL or OE_ORDER_HEADERS_T. For finding purpose is better use wildcards: OE_ORDER_HEADERS%






4.Navigating (Flexfield | Descriptive | Segment). Quey on  Title and Application Content. Pressing Segment button we will get segment information regardless DFF.



Tip: For modifying you have to unfrezee DFF and freeze DFF when you finish

No comments:

Post a Comment