Search Results pji_system_settings




Overview
Explore in AI Chat

Overview

PJI_SYSTEM_SETTINGS is a configuration table in the PJI (Project Intelligence) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores the installation-level parameters that govern how Oracle Projects Intelligence reports, dashboards, and analytical engines interpret Projects data. Rather than holding transactional project records, the table centralizes defaults such as period types, as-of dates, currency treatment, budget and forecast conversion rules, and feature enablement flags. Typically a single row, or a very small number of rows, defines the active configuration for the installation, making the table a mandatory reference point for nearly every Project Intelligence query that resolves reporting periods or currency conversions.

From a dimensional modeling perspective, the metadata's heuristic Data Vault classification is standalone. In Data Vault terms this suggests the table behaves as an independent hub-like structure rather than a link or satellite dependent on a parent business key. Its grain is defined by the surrogate SETTING_ID, and it does not act as an associative entity between other hubs.

Key Information Stored

The documented physical schema contains 75 columns. The most operationally significant include:

The unique index PJI_SYSTEM_SETTINGS_U1 spans SETTING_ID and ZD_EDITION_NAME. The inclusion of ZD_EDITION_NAME indicates support for Oracle's edition-based redefinition (EBR) model, meaning the same SETTING_ID can exist once per edition, and any business-key lookup must account for the active edition rather than relying on SETTING_ID alone.

Common Use Cases and Queries

The primary use case is configuration discovery: determining which period type, currency flag, or budget type code an installation is using before running any Project Intelligence report. A typical pattern retrieves the single active configuration row:

Related Objects

The documented foreign keys tie this configuration to Oracle HRMS organization structures:

Beyond these, Project Intelligence reporting extracts and the PA (Oracle Projects) budget, forecast, cost, and revenue tables depend on the conversion rules and type codes defined here. Oracle Projects period definitions in PA_PERIODS and GL period tables in GL_PERIODS are referenced conceptually by the PA_PERIOD_FLAG and GL_PERIOD_FLAG settings, while PA budgeting and forecasting tables consume the COST/REVENUE_BUDGET_TYPE_CODE and FORECAST_TYPE_CODE values. The ZD_EDITION_NAME column also links the table to Oracle's editioning infrastructure, which must be respected in any join or lookup against this configuration.