Page 17

Populate LOV in BPM workspace pages (HumanTask generated pages)
We want to show the case status value instead of statusID in Case HumanTask object

• In Jdeveloper create a Model project the BPM Application.

• Connect to the database where the domain values are available and accept all default settings Click Finish.
• Create a Viewobejct and it to the AppModule

• Accept all default settings Click Next then Finish
• Add the ViewObject to the AppModule

• Drag the value of the DataControl to the page and create select one choice

Select the following in the popup screen
• In the Base Data Source the payload of the object, in this case is CaseObject
• Chose Dynamic List
• In the List Data Source select the created LOV datasource
• For the datavalue select status and the List Attribute the ID from LOV
• Chose for Display Attribute the Description
• Then OK

In the SelectOneChoise element set auto submit= true

You Done, now you can delete the status value which has been auto generated from the HT page.

You should have a directory structure similar to this:
C:\app\Administrator\product\11.1.0\db_1\apex (this is the unzipped kit)
C:\app\Administrator\product\11.1.0\db_1(this is created by the Oracle 11g installation)
C:\app\Administrator\product\11.1.0\db_1\oradata (this is created by the Oracle 11g installation)

Step 1
Open DOS CMD window and change default to the directory of the unzipped Apex kit.
e.g.
CMD> cd C:\app\Administrator\product\11.1.0\db_1\apex

Step 2 – Upgrade
CMD> sqlplus sys/password as sysdba
SQL> @apexins SYSAUX SYSAUX TEMP /i/

Step 3 – Set images directory
CMD> sqlplus sysm/password as sysdba
SQL> @apxldimg.sql c:\oraclexe

Step 4 – Set Admin password
SQL> @apxxepwd.sql password

Step 5 – Enable remote http connections
SQL> exec dbms_xdb.setListenerLocalAccess (l_access => FALSE);

Posts

Populate LOV in BPM generated Human Task (ADF) pages

Upgrade Oracle Application Express (ApEx) from 3.x to 4.x