Results for “rg_pa”

4 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.RG_CURRENCIES_V is a reporting and integration view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema. It exposes a filtered subset of records from the underlying RG_REPORT_PARAMETERS table, specifically those rows whose DATA_TYPE is equal to the literal value 'C' — indicating currency-type report parameters. The object is part of the Oracle Application Object Library (FND) and Programme Management/Projects reporting infrastructure associated with the RG (Report Generator) family of objects, and its name is frequently encountered by users searching on the string "rg_pa," which appears both in the view alias prefix and in the base table alias (RG_PA).

Underlying Base Objects

The view is defined over a single documented base object: RG_REPORT_PARAMETERS, referenced in the ETRM metadata as a SYNONYM. In the view text, this table is aliased as RG_PA. Although the ETRM metadata lists a synonym, RG_REPORT_PARAMETERS is conventionally accessed through public or APPS-private synonyms in EBS, allowing the view definition to resolve across editions and editions-specific schema mappings in 12.1.1 and 12.2.2. The view performs no joins; it is a straight column projection with a single WHERE clause restricting results to currency parameters, making it a lightweight, deterministic read-only object suitable for concurrent-program parameter resolution.

Key Columns

The view projects the full column set of the currency parameter rows, prefixed to disambiguate the aliases. Notable columns include:

  • ROW_ID — the ROWID of the base row, retained for updatable-view and row-identification scenarios.
  • PARAMETER_SET_ID — identifies the report parameter set to which the currency row belongs.
  • PARAMETER_NUM — the ordinal position of the parameter within its set.
  • CURRENCY_TYPE, ENTERED_CURRENCY, LEDGER_CURRENCY — the currency-specific attributes that distinguish this view from generic parameter exposure.
  • DATA_TYPE — always the constant 'C' in this view, distinguishing currency parameters from other parameter types in the base table.
  • CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS DFF (descriptive flexfield) attribute columns, available for client extensions.
  • Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN, supporting standard EBS auditing and _WHO column conventions.

Common Use Cases and Queries

This view is typically employed when a report or concurrent program must enumerate the currency parameters associated with a given parameter set without scanning the full RG_REPORT_PARAMETERS table. Because the DATA_TYPE filter is applied internally, callers receive only currency-relevant rows. A representative query is:

SELECT parameter_set_id,
       parameter_num,
       currency_type,
       entered_currency,
       ledger_currency
  FROM apps.rg_currencies_v
 WHERE parameter_set_id = :p_set_id
 ORDER BY parameter_num;

Typical scenarios include resolving the entered and ledger currencies for a report's currency parameter, joining to RG_REPORT_PARAMETERS on PARAMETER_SET_ID to enrich output, and auditing which parameter sets define currency-type parameters. The view's simplicity makes it safe to use in custom concurrent programs, PL/SQL packages, and Reports/BI Publisher data models that must respect EBS currency parameter semantics in either 12.1.1 or 12.2.2.