Results for “rg_srs_dss_dop_v”

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

Overview

RG_SRS_DSS_DOP_V is a view in the APPS schema of Oracle E-Business Suite, classified under the RG (Application Report Generator) product. The ETRM documentation lists its status as VALID and records a terse description of "10SC ONLY," indicating that this object is scoped to a specific 10SC environment or release line rather than being a general-purpose reporting construct across all EBS deployments. The name suggests an internal helper view used by the SRS/DSS report generation subsystem within Application Report Generator, exposing a narrow lookup mapping rather than business transaction data.

The view does not persist data itself. It is a union query that assembles a small, fixed set of code-to-description rows, blending numeric row multipliers from the General Ledger with literal lookup meanings. Its role is therefore to supply a constrained value list — day numbers and their display strings — to whichever report definition or concurrent program consumes it. The user search term "roig seen wws 11" does not correspond to a documented object name; it appears to be a garbled or OCR-distorted reference, most plausibly an attempt to reference this RG view. No other ETRM object matches that string.

Underlying Base Objects

The ETRM metadata records two referenced base objects: GL_LOOKUPS (documented as a VIEW) and GL_ROW_MULTIPLIERS (documented as a SYNONYM). GL_ROW_MULTIPLIERS is the standard General Ledger table that stores row and column multiplier definitions used by FSG and report generator layouts; the synonym resolves to the underlying APPS-owned table. GL_LOOKUPS is the standard lookup view in the General Ledger schema, providing language-sensitive MEANING values for LOOKUP_TYPE and LOOKUP_CODE pairs.

The view text joins these sources through three UNION branches. The first selects MULTIPLIER values up to 35 from GL_ROW_MULTIPLIERS. The second and third select lookup meanings for the LITERAL lookup type, specifically the codes LAST and N/A. Because GL_LOOKUPS is a view, the actual base table is FND_LOOKUP_VALUES or its GL-specific counterpart, but the ETRM documents the dependency at the GL_LOOKUPS level.

Key Columns

• DAY_NUM — A numeric column. For the multiplier branch it carries the MULTIPLIER value itself (1 through 35). For the LAST literal it is the constant -1; for N/A it is the constant 100. These sentinel values allow consumers to distinguish real day multipliers from the "LAST" and "not applicable" special selections.
• DAY_CHAR — A character column of up to 30 characters. For the multiplier branch it is the multiplier converted to text via TO_CHAR and truncated to 30 characters. For the lookup branches it is the translated MEANING from GL_LOOKUPS, so the display label respects the session language.

The pairing of a numeric key with a language-aware display string is the defining characteristic of the view. The -1 and 100 sentinels are conventional in report generator value sets to represent "last period" and "no value" respectively.

Common Use Cases and Queries

The view is typically referenced by report generator value sets or LOV definitions that need a bounded list of day offsets together with LAST and N/A options. Because it filters MULTIPLIER <= 35, callers cannot accidentally offer an unbounded range. A representative query is:

• SELECT DAY_NUM, DAY_CHAR FROM APPS.RG_SRS_DSS_DOP_V ORDER BY DAY_NUM;
• SELECT DAY_CHAR FROM APPS.RG_SRS_DSS_DOP_V WHERE DAY_NUM = -1; — retrieves the translated label for the LAST option.
• SELECT COUNT(*) FROM APPS.RG_SRS_DSS_DOP_V WHERE DAY_NUM BETWEEN 1 AND 35; — verifies the multiplier population is complete.

Given the "10SC ONLY" designation, use of this view outside its intended 10SC context should be treated as unsupported. Implementers encountering the distorted search term "roig seen wws 11" should confirm whether the intended object is in fact RG_SRS_DSS_DOP_V before proceeding.