Search Results pa_proj_all_basic_un_sec_v




Overview
Explore in AI Chat

Overview

PA_PROJ_ALL_BASIC_UN_SEC_V is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) module. It is documented as "a view of the projects to which you can do search (for subledgers LOV)." In practice, this view serves as a filtered, security-aware list of projects that can be presented to users in a List of Values (LOV) when they are entering project-related data in subledger transactions — for example, when associating a project with an expenditure, invoice, or other subledger accounting entry. Unlike secured project views that enforce full project-level access control through PA security profiles, this view is labeled "UN_SEC" (unsecured) and is intended to return the broad set of projects available for search, subject to the business-group and operating-unit conditions defined in its query rather than to a specific user's project security hierarchy.

The view is defined with STATUS: VALID and is available in both Oracle EBS 12.1.1 and 12.2.2. It exists to simplify subledger development and configuration by exposing a single, pre-joined result set of projects together with their project types, set of books, and operating unit, so that forms and concurrent programs do not need to reimplement the joining and filtering logic.

Underlying Base Objects

The view is constructed over a join of several base objects. The documented referenced objects are:

Key Columns

Among the columns exposed, the following are most significant for reporting and integration:

Common Use Cases and Queries

The view is most commonly referenced by subledger forms and custom concurrent programs to populate a project LOV or to validate a user-entered project. A typical query filters to non-template, transaction-eligible projects within a given operating unit:

  • Populating a project LOV: SELECT project_id, project_number, project_name FROM pa_proj_all_basic_un_sec_v WHERE org_id = :org_id AND charges_allowed_flag = 'Y' ORDER BY project_number_sort_order;
  • Validating a project for a subledger entry: SELECT project_id FROM pa_proj_all_basic_un_sec_v WHERE project_number = :project_number AND org_id = :org_id;
  • Reporting on active projects by operating unit: SELECT operating_unit, project_number, project_name, project_status_code, start_date FROM pa_proj_all_basic_un_sec_v WHERE project_status_code = 'APPROVED';

Because the view explicitly excludes template projects and award projects (via the PT.PROJECT_TYPE <> 'AWARD_PROJECT' predicate), consumers should rely on it when the intent is to offer receivable/chargeable projects rather than the full project catalog. Where strict project-level security is required, secured project views should be used instead.