16.2.2 Computing an Application Item at Login

Use an Application Computation with After Authentication execution point to set an application item's value after the user logs in.

The one shown below computes the value of G_APP_USER_EMPNO using the SQL statement below that returns a single value.

select empno
  from eba_demo_emp
 where ename = :APP_USER

You can also use a PL/SQL expression, function body returning a result, or other methods.

Tip:

You can also assign the application item value in an Application Process with an After Authentication processing point.

The figure shows the Application Computation edit page in App Builder where the value of the G_APP_USER_EMPNO item is computed after user authentication using a one-column SELECT statement that returns one row.

Figure 16-7 Computing an Application Item's Value After Login

Description of "Figure 16-7 Computing an Application Item's Value After Login"