Search Results pa_project_options_ss_v




Overview
Explore in AI Chat

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:

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.