Search Results g_last_updated_by

Overview

OPI_DBI_PTP_BASELINE_PKG is a PL/SQL package body owned by the APPS schema that supports the Oracle E-Business Suite "Plan to Produce" (PTP) baseline collection and extraction framework used by Oracle Daily Business Intelligence / Operational Intelligence reporting. Its role is to extract, load, and refresh the baseline datasets — cost, conversion rate, plan, and organization information — that feed the PTP subject area and its materialized views. The package is registered under ETRM with owner APPS and an API classification of OTHER, meaning it is an internal, non-public API intended for use by the DBI collection infrastructure rather than by external application code.

The package exposes a set of package-level global variables that are shared across its procedures, including g_sysdate, g_created_by, g_last_update_login, g_last_updated_by, g_global_start_date, g_global_currency_code, g_secondary_currency_code, g_opi_schema, g_degree, g_global_rate_type, and g_secondary_rate_type. The user's search term g_last_updated_by refers to the line 11 declaration that carries the FND_USER identifier used to stamp audit columns (LAST_UPDATED_BY) on rows written by the package's load and update steps. It is populated during initialization from the concurrent program or session context and reused consistently throughout a single collection run so that all records touched by that run share a uniform audit identity.

Key Procedures and Functions

Only two procedures are documented in the ETRM metadata for this package:

• EXTRACT_BASELINE — The primary driver that extracts source data for the baseline being processed. It reads plan, organization, cost, and conversion-rate information and populates the PTP staging and fact tables. Its internal helpers include Get_Discrete_Cost_an, which extracts cost and conversion rate for discrete manufacturing organizations associated with the baseline under processing.
• REFRESH — Invoked after extraction to refresh the materialized views that expose the collected baseline data, typically via DBMS_MVIEW. This ensures the DBI reporting layer reflects the newly collected baseline.

The package also declares a comprehensive exception framework, including Oracle predefined exceptions and PTP-specific errors such as intialization_exception, collection_parameter_exception, load_exception, archive_cleanup_exception, update_log_exception, cost_conversion_rate_exception, mv_refresh_exception, and isc_collection_exception, each mapped to a dedicated error number in the -20900 range.

Tables Accessed

• OPI_DBI_BASELINE_DEFINITIONS, OPI_DBI_BASELINE_PLANS, OPI_DBI_BASELINE_SCHEDULES — definitions of the baseline, its plans, and scheduling metadata.
• OPI_DBI_PTP_PLAN_F, OPI_DBI_PTP_COST, OPI_DBI_PTP_CONV, OPI_DBI_PTP_LOG — PTP fact, cost, conversion-rate, and log tables written during extraction.
• OPI_DBI_RUN_LOG_CURR — current run log currency context.
• ISC_DBI_PLANS, ISC_DBI_PLAN_ORGANIZATIONS — source plan and plan-to-organization associations.
• MTL_PARAMETERS, HR_ORGANIZATION_INFORMATION — organization classification used to isolate discrete manufacturing organizations.
• FII_TIME_DAY — calendar/time dimension used for date-based extraction.
• DBMS_MVIEW, DBMS_SQL — dynamic SQL and materialized view refresh.

Usage Notes

OPI_DBI_PTP_BASELINE_PKG is invoked by the DBI/Operational Intelligence collection programs, which are scheduled as concurrent programs and driven by baseline definitions. It is not referenced by any other documented package (referenced by 0). Because it is an internal ETRM-classified OTHER API, custom code should not call it directly; instead, administrators should run the associated baseline collection concurrent programs and let this package execute within the supported collection lifecycle.