Search Results header_flag

Overview

PA_PROJECT_OPTIONS_SS_V is an APPS-owned database view in the Oracle Projects (PA) module, defined in ETRM with a VALID status for Oracle EBS 12.1.1 and 12.2.2. It presents the set of project-level and task-level configuration options that a given user is licensed to access and privileged to view for a specific project. The view is a "self-service" (SS) structure: the "_SS_" suffix reflects that it drives the self-service Projects interface, exposing options such as option codes, their display names, parent/child relationships, and the web entry points that invoke them.

Functionally, the view answers the question: "which project options should be displayed to this user, for this project, and in what order?" Rather than returning every option defined in PA_OPTIONS, it filters aggressively on function licensing and on user privilege checks, returning only rows the current user is actually entitled to see. This makes it the primary data source for option-driven navigation and menu rendering in the Projects self-service pages, and a useful reference for reporting and integration queries that need to understand project setup configuration.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects:

• FND_FORM_FUNCTIONS (SYNONYM) — provides the WEB_HTML_CALL entry point for each option, joined via OPTION_FUNCTION_NAME.
• PA_LOOKUPS (VIEW) — supplies the display meaning of the option through lookup type PA_OPTIONS_SS.
• PA_OPTIONS (SYNONYM) — the master definition of each option, including SORT_ORDER, OPTION_CODE, PARENT_OPTION_CODE, PROJECT_LEVEL_FLAG, TASK_LEVEL_CODE, USAGE_CODE, ACCESS_MODULE, and TOP_OPTION_CODE.
• PA_PROJECTS_ALL (SYNONYM) — the project being queried; the view relates the project to its template project via CREATED_FROM_PROJECT_ID.
• PA_PROJECT_OPTIONS (SYNONYM) — records the options actually enabled on the project, used to compute DISPLAYED_FLAG.
• PA_PRODUCT_INSTALL_UTILS (PACKAGE) — CHECK_FUNCTION_LICENSED determines whether the option's function is licensed.
• PA_PROJECT_UTILS (PACKAGE) — CHECK_OPTION_CHILD_EXISTS indicates whether the option has sub-options.
• PA_PROJ_TEMPLATE_SETUP_UTILS (PACKAGE) — HEADER_OPTION identifies header-level options.
• PA_SECURITY_PVT (PACKAGE) — CHECK_USER_PRIVILEGE enforces per-row user security on the option function.

Key Columns

• PROJECT_ID — the project for which options are evaluated.
• OPTION_CODE / MEANING — the internal code and the user-facing display name of the option.
• OPTION_FUNCTION_NAME — the function name bound to the option; it is the join key to FND_FORM_FUNCTIONS and the identifier passed into privilege and licensing checks. This is the column users most commonly search for.
• PARENT_OPTION_CODE / TOP_OPTION_CODE — define the option hierarchy.
• SORT_ORDER — display sequencing of the option.
• PROJECT_LEVEL_FLAG / TASK_LEVEL_CODE — indicate whether the option applies at project or task level.
• DISPLAYED_FLAG — 'Y' when the option is currently enabled on the project, otherwise 'N'.
• HEADER_FLAG — derived from PA_PROJ_TEMPLATE_SETUP_UTILS.HEADER_OPTION; identifies header options.
• WEB_HTML_CALL — the web entry point associated with the option.
• ALLOW_OVERRIDE_ENABLED_FLAG / USAGE_CODE / ACCESS_MODULE / INTERNAL_PRODUCT_CODE — control override capability, usage context, module ownership, and product grouping.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include diagnosing why an option does not appear for a user, mapping option codes to their backing function, and extracting the enabled option set for a project.

List options and their functions for a project:

SELECT option_code, meaning, option_function_name, displayed_flag
FROM   pa_project_options_ss_v
WHERE  project_id = :p_project_id
ORDER  BY sort_order;

Find the option associated with a specific function:

SELECT project_id, option_code, meaning, displayed_flag
FROM   pa_project_options_ss_v
WHERE  option_function_name = 'PA_PROJECT_OPTION_XYZ';

Identify currently enabled options only:

SELECT option_code, meaning, web_html_call
FROM   pa_project_options_ss_v
WHERE  project_id = :p_project_id
AND    displayed_flag = 'Y';

Because the view is security- and licensing-aware, results vary by user session; queries run as a privileged or unprivileged user may return different row sets. For system-wide extraction, querying PA_OPTIONS and PA_PROJECT_OPTIONS directly avoids the per-user privilege filtering applied here.