Search Results bis_source

Overview

BIS_PMF_GET_DIMLEVELS_PUB is a public PL/SQL API in the Oracle E-Business Suite Applications (APPS) schema that supports the Business Intelligence System (BIS) and Enterprise Data Warehouse (EDW) dimensional reporting infrastructure. Its primary business function is to return the SQL SELECT string used to resolve DimensionLevelValues, the identifiers that map analytical dimension members to their level values across the BIS and EDW data models. The package determines the appropriate source of that SELECT string by inspecting the profile option BIS_SOURCE, allowing the application to switch between the EDW and BIS retrieval mechanisms without code changes. Although the source header carries a "noship" designation, indicating it is not shipped as an end-user-facing artifact, the package is referenced by seven other packages, confirming its role as a shared internal service within the dimensional metadata layer. The current source revision is 120.2, dated 27-JUN-2005, with the checkfile directive requiring a minimum version of 115.13 at installation time.

Key Procedures and Functions

Two public procedures are documented for this package:

• GET_DIMLEVEL_SELECT_STRING — Returns the SELECT string that retrieves dimension level values. Because the package resolves the origin of this string based on the BIS_SOURCE profile option, the procedure abstracts the differences between the EDW and BIS source schemas from its callers.
• GET_SORTED_SELECT_STRING — Returns a SELECT string variant that applies ordering to the dimension level values, supporting consumers that require deterministic sort sequences when presenting or processing dimensional data.

The package also declares several public PL/SQL record and table types used to carry dimensional metadata: dimlvl_rec_type and its associated dimlvl_tbl_type collection, which hold the dimension short name, dimension level short name, dimension level value identifier, and the RI attribute code; and dim_rel_info_rec, which describes parent-child relationships between dimension levels, including the parent dimension and level names, the parent dimension level value identifier, the relation column and relation type, and the parent RI attribute code. The RI attribute code field was added in bug fix 4456833 (27-JUN-2005), and the child and parent dimension level record and table types were introduced in enhancement 2819971 (09-MAY-2003).

Tables Accessed

The ETRM metadata does not enumerate specific base tables accessed through APPS synonyms. Consistent with its stated purpose, the package reads the BIS_SOURCE profile option setting to determine whether the SELECT string is sourced from EDW or BIS repository structures, and the returned strings themselves are directed against the dimensional metadata tables that underlie those repositories. No write operations against business tables are documented; the package operates as a read-oriented retrieval API.

Usage Notes

BIS_PMF_GET_DIMLEVELS_PUB is intended for internal consumption by other BI and dimensional analysis packages rather than direct invocation from Oracle Forms or concurrent programs. The documented reverse reference count of seven dependent packages indicates that it is called during dimensional metadata resolution, including the assembly of parent-child dimension level hierarchies through the dim_rel_info_rec type. Custom code extending the BIS/EDW dimensional model may call the two public procedures to obtain canonical SELECT strings; doing so ensures the caller honors the BIS_SOURCE profile option and therefore remains consistent with the repository selected by the system administrator. Because the package returns SQL text rather than query results, callers are responsible for executing the returned statement and for validating that the referenced dimension level value identifiers conform to the declared 32000-character limit. Any customization should be validated against both the 12.1.1 and 12.2.2 releases, as AD and TXK patching can affect APPS synonym resolution.