Search Results xfr_proj_number

Overview

PA_XLA_XFR_PROJ_REF_V is an Oracle E-Business Suite 12.1.1 / 12.2.2 view owned by the APPS schema within the Projects (PA) product family. It functions as a denormalized project reference view used by the Subledger Accounting (XLA) transfer and accounting derivation infrastructure. The "XFR" prefix in the view name indicates that the object supplies transfer-time reference data: when project-related transactions are transferred to Subledger Accounting and accounted, the accounting engine requires specific project attributes that are not held on the transaction tables themselves. This view assembles those attributes in a single, pre-joined result set.

The view is status VALID and is classified as a reporting and integration object rather than a base transaction table. Its most notable characteristic is that it exposes both the carrying-out organization's descriptive flexfield context values and the operating unit's descriptive flexfield context values, drawing specifically on ORG_INFORMATION3 and ORG_INFORMATION5 from HR_ORGANIZATION_INFORMATION. This design allows subledger accounting rules to reference organization-level flexfield segments — company and cost center concepts — directly from project data without additional lookups.

Underlying Base Objects

The ETRM metadata documents three referenced base objects, all accessed through APPS synonyms:

• PA_PROJECTS_ALL — the project header table, supplying project id, name, number (SEGMENT1), project type, carrying-out organization, location, public sector flag, operating unit (ORG_ID), and the project descriptive flexfield columns (ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE10).
• PA_PROJECT_TYPES_ALL — the project type definition table, supplying the project type class code, burden cost flag and burden amount display method, together with its own descriptive flexfield columns. It joins to PA_PROJECTS_ALL on PROJECT_TYPE and ORG_ID.
• HR_ORGANIZATION_INFORMATION — joined twice with outer join syntax (+) on ORGANIZATION_ID, restricted to the ORG_INFORMATION_CONTEXT of 'COMPANY COST CENTER'. The first alias (I1) matches the project's CARRYING_OUT_ORGANIZATION_ID; the second alias (I2) matches the project's ORG_ID, thereby resolving organization flexfield values for both the delivering organization and the operating unit.

Both organization joins are outer joins, so projects whose organizations lack a COMPANY COST CENTER flexfield context are still returned, with those organization columns null.

Key Columns

The view exposes thirty-seven columns, all prefixed XFR_PROJ_ to distinguish them from base-table column names. Principal columns include:

• XFR_PROJ_ID, XFR_PROJ_NAME, XFR_PROJ_NUMBER — project identifier, name, and segment1 number.
• XFR_PROJ_TYPE, XFR_PROJ_TYPE_CLASS_CODE — project type and its classification, used to drive accounting rule selection.
• XFR_PROJ_ORGANIZATION_ID, XFR_PROJ_LOCATION_ID — carrying-out organization and location.
• XFR_PROJ_ORG_COMPANY, XFR_PROJ_ORG_COST_CENTER — ORG_INFORMATION3 and ORG_INFORMATION5 for the carrying-out organization, typically representing company and cost center segments.
• XFR_PROJ_OPERATING_UNIT_ID, XFR_PROJ_OU_COMPANY, XFR_PROJ_OU_COST_CENTER — the operating unit identifier plus its ORG_INFORMATION3 and ORG_INFORMATION5 values.
• XFR_PROJ_BURDEN_COST_FLAG, XFR_PROJ_BURDEN_DISPLAY_METHOD — burdening behavior inherited from the project type.
• XFR_PROJ_PUBLIC_SECTOR_FLAG — public sector processing indicator.
• XFR_PROJ_ATTRIBUTE1–10 and XFR_PROJ_TYPE_ATTRIBUTE1–10 — project and project type descriptive flexfield segments, each accompanied by its ATTRIBUTE_CATEGORY column.

Common Use Cases and Queries

The view is principally consumed by Subledger Accounting transfer programs and by reporting queries that require project attributes joined to organization flexfield values. Typical use cases include building accounting rule conditions based on cost center or company, reconciling project accounting entries to organization hierarchies, and extracting project metadata for external reporting.

A representative query retrieves core project attributes with their organization flexfield values:

• SELECT xfr_proj_number, xfr_proj_name, xfr_proj_type, xfr_proj_org_company, xfr_proj_org_cost_center, xfr_proj_ou_company, xfr_proj_ou_cost_center FROM apps.pa_xla_xfr_proj_ref_v WHERE xfr_proj_operating_unit_id = :org_id;

A second common pattern filters on project type class to locate projects governed by a particular accounting treatment:

• SELECT xfr_proj_id, xfr_proj_number, xfr_proj_type_class_code, xfr_proj_burden_cost_flag FROM apps.pa_xla_xfr_proj_ref_v WHERE xfr_proj_type_class_code = 'CONTRACT' AND xfr_proj_public_sector_flag = 'Y';

Because the underlying joins to HR_ORGANIZATION_INFORMATION are outer joins, queries should anticipate null values in the organization company and cost center columns for organizations without a COMPANY COST CENTER flexfield context.