Set mandatory parameters in request

When you submit a request and information retrieved is not you expected it or blank, usually is because you not use success parameter because there are not mandatory.

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

Kill Session using pl/sql Developer

Many times users process become hung and block other sessions user. For this reason .Using PL/SQL Developer program we can kill this process using Tools->Sessions Monitor as you see below:

In the next window appear all users sessions(including username) and modules. With right click mouse you can choose kill selected session option.

Warning: Kill sessions process have to do it carefully.