Search Results setting_id

Overview

The APPS.PJI_DEFAULT_PERIOD_SETTINGS_V view is a database object within the Oracle E-Business Suite environment, owned by the APPS schema and residing in the PJI (Project Intelligence) product family. Per the documented ETRM metadata, PJI is classified as obsolete, and the view itself is described as an "internal summarization view." Its purpose is to consolidate the default period and billing-cycle configuration maintained for each project reporting group defined in Project Intelligence, exposing a single, query-friendly result set rather than requiring consumers to join the system settings, lookup, and billing cycle data manually.

The view presents one row per report group, translating the internal SETTING_ID and per-group default columns stored in PJI_SYSTEM_SETTINGS into a uniform structure with a report group name, a period type, an as-of date, and a resolved billing cycle name. This makes it useful wherever the reporting layer, concurrent programs, or custom extensions need to resolve the effective default period settings applied to PJI reports without hard-coding the underlying column names, which differ for each report group.

Underlying Base Objects

The documented references confirm that the view is defined over four APPS objects: FND_GLOBAL (package), PA_BILLING_CYCLES (synonym), PJI_LOOKUPS (view), and PJI_SYSTEM_SETTINGS (synonym). All are referenced from the APPS schema, and the synonyms resolve to the underlying PA and PJI base objects.

The view body is a UNION ALL of several near-identical SELECT statements. Each branch joins a row from PJI_LOOKUPS (filtered on LOOKUP_TYPE = 'PJI_REPORT_GROUP' and a specific LOOKUP_CODE) to the single row in PJI_SYSTEM_SETTINGS and, via an outer join (B.BILLING_CYCLE_ID (+)), to PA_BILLING_CYCLES. The outer join ensures that a report group whose default billing cycle is not set still returns a row, with a null billing cycle name. The PJI_LOOKUPS branches correspond to report groups such as PROJECT_BOOKINGS_AND_BACKLOG, RESOURCE_UTILIZATION, RESOURCE_AVAILABILITY, PROJECT_ACTIVITY, PROJECT_PROFITABILITY, and PROJECT_COST, each mapped to its own set of default columns on PJI_SYSTEM_SETTINGS.

Key Columns

• MEANING — The descriptive name of the PJI report group, sourced from PJI_LOOKUPS for each LOOKUP_CODE.
• SETTING_ID — The identifier of the corresponding row in PJI_SYSTEM_SETTINGS, tying the summarized row back to the parent settings record.
• Period type column — Exposed under group-specific names such as DFLT_PRJBAB_PERIOD_TYPE, DFLT_RESUTL_PERIOD_TYPE, DFLT_RESAVL_PERIOD_TYPE, DFLT_PRJACT_PERIOD_TYPE, DFLT_PRJPRF_PERIOD_TYPE, and DFLT_PRJCST_PERIOD_TYPE, indicating the default period basis for that report group.
• As-of date column — Group-specific columns such as DFLT_PRJBAB_AS_OF_DATE and DFLT_RESUTL_AS_OF_DATE holding the default effective/as-of date.
• Cycle ID column — Group-specific identifiers such as DFLT_PRJBAB_CYCLE_ID, DFLT_RESUTL_CYCLE_ID, and DFLT_RESAVL_CYCLE_ID referencing PA_BILLING_CYCLES.BILLING_CYCLE_ID.
• BILLING_CYCLE_NAME — The resolved cycle name from PA_BILLING_CYCLES, or null when no default cycle is configured.

Common Use Cases and Queries

The view is typically used to inspect or validate the default period configuration governing PJI report generation. A straightforward query lists all report groups and their defaults:

• SELECT meaning, setting_id, billing_cycle_name FROM apps.pji_default_period_settings_v ORDER BY meaning;
• SELECT meaning, setting_id FROM apps.pji_default_period_settings_v WHERE billing_cycle_name IS NULL; — identifies report groups lacking a default billing cycle.
• Because the period type columns are group-specific, filtering by a particular group requires referencing the appropriate column name (for example DFLT_RESUTL_PERIOD_TYPE for resource utilization).

Given the obsolete status of PJI, the view should be treated as a legacy reporting aid rather than a foundation for new development, but it remains valid in both 12.1.1 and 12.2.2 and continues to provide a convenient consolidated read of the default period settings.