Create poplist in OAF

The requirement is to create a drop down for Status. These status are based on a table which has all the possible status and status ids.

Here is the design of the status table:

CREATE TABLE XX_ORDER_STATUS

( STATUS_ID NUMBER PRIMARY KEY

, STATUS_DESCRIPTION VARCHAR2(100)

, MEANING VARCHAR2(200)

, CREATION_DATE DATE

, CREATED_BY NUMBER

, LAST_UPDATE_DATE DATE

, LAST_UPDATED_BY NUMBER

, LAST_UPDATE_LOGIN NUMBER

);

The table has say following data:

(1, ‘OPEN’, ‘Open’, TRUNC(SYSDATE), -1, TRUNC(SYSDATE), -1, -1)

(2, ‘WIP’, ‘Work in Progress’, TRUNC(SYSDATE), -1, TRUNC(SYSDATE), -1, -1)

(3, ‘CLOSED’, ‘Closed’, TRUNC(SYSDATE), -1, TRUNC(SYSDATE), -1, -1)

To setup the Drop Down LOV, we need a Read Only VO based on the XX_ORDER_STATUS table.

Following are the steps to create the VO:

As a convention, we will place all such Read Only VOs in the package oracle.apps.fnd.orderbooking.picklist.server

In the next step, provide the Query which fetches the Status_id and Meaning for that status id based on the XX_ORDER_STATUS.

Test the Query to check if it is Valid.

Finish the wizard…

Double click on the AM, to add the VO to the AM. Take the Note of the VO Instance: OrderStatusLOVVO1

Go to the page and select the status item on the page. In the properties tab, select the following properties:

Item Style: messageChoice

Picklist View Instance: OrderStatusLOVVO1

Picklist Display Attribute: Meaning

Picklist Value Attribute