Session date is not populating

The problem manifests in various ways in the custom or regular
Human Resource Management System (HRMS) responsibility.

Repeatedly, list of values (LOV) are missing for parameters in concurrent
processes or process are not running because the session date is not being populated.
The problem occurs if the value set is table validated and the session_id is
part of the 'where' clause. Any value set that references session_id or any
process that has session date as a non displayed (but required) parameter will
not work.

Solution Description
--------------------

To resolve this issue, follow the steps listed below:

1. Sign into Oracle Applications as System Administrator GUI Responsibilty.

2. Bring up the Menu in question (either custom menu or regular HRMS menu)
and add the following function from the LOV:

Navigator: Disable Multiform.

Note: this is an AOL function that should be included on all menus
(custom or standard) to allow session_id to be populated.

3. Save your changes before exiting the form.

4. The concurrent processes you were having problems with should now work
correctly.

Explain Plan - Error

Error:
ORA-02404: specified plan table not found

Explain Plan
The Explain Plan command generates information that details the execution plan that will be used on a particular query. It uses a precreated table (PLAN_TABLE) in the current shema to store information about the execution plan chosen by the optimizer.

Creating the Plan Table

The plan table is created using the script utlxplan.sql. This script is typically found under the Oracle Home in the rdbms/admin directory.
On Unix its location will be:

$ORACLE_HOME/rdbms/admin

On WindowsNT/2000:

%ORACLE_HOME%\rdbms\admin

This script creates the output table, called PLAN_TABLE, for holding the output of the Explain plan Command. Note that the exact structure of the plan table can change with different release as new features are introduced.

Age

select employee_number,
date_of_birth,
trunc(months_between(trunc(sysdate),date_of_birth)/12) age
from per_people_x per