Search Results bsc_aw_adapter_dim

Overview

BSC_AW_ADAPTER_DIM is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that functions as the dimension adapter layer for the Oracle Business Intelligence (BSC) Analytic Workspace (AW) integration. It mediates between the EBS Balanced Scorecard metadata model and the Oracle OLAP analytic workspace, translating dimension definitions stored in the EBS repository into the physical dimension objects, levels, hierarchies, and relations that the analytic workspace requires. In ETRM terms the package is classified as OTHER, meaning it is an internal implementation package rather than a public, supported API, though it exposes a large surface of callable units.

The package is documented with 75 procedures and functions and is referenced by ten other database objects, confirming its role as a foundational utility in the BSC/OLAP metadata build path. It is not referenced by any database object itself at the package level, indicating it sits near the top of the call stack within this subsystem.

Key Procedures and Functions

The documented units group into several functional clusters:

Dimension construction: CREATE_DIM, CREATE_DIM_OBJECTS, CREATE_DIM_FOR_LEVELS, CREATE_CCDIM, CREATE_LEVEL_NAME_DIM, CREATE_DIM_PROGRAM, and CREATE_DIM_PROGRAM_REC create and register dimension definitions and their associated analytic workspace objects.
Level and hierarchy management: GET_ALL_DIM_LEVELS, GROUP_LEVELS_INTO_SETS, ASSIGN_SET_TO_LEVEL, SET_LEVEL_POSITION, and RESET_DIMENSION_R organize levels into sets, assign them, and control ordering and reset behavior.
Virtual levels: CREATE_VIRTUAL_ZERO_CODE_LEVEL and CREATE_VIRTUAL_REC_LEVEL generate synthetic levels for zero-code and reconciliation requirements.
Deployment and cleanup: IMPLEMENT_DIM_AW materializes the dimension into the analytic workspace, while DROP_DIM, DROP_KPI_OBJECTS_FOR_DIM, and DROP_OLD_DIM_FOR_LEVEL remove obsolete structures.
Relationships and lookup: CREATE_RELATION builds dimension relations; GET_KPI_FOR_DIM resolves KPI associations.

No parameter signatures are asserted here; only documented names and their evident roles are described.

Tables Accessed

The package references DBMS_SQL (dynamic SQL execution), BSC_OLAP_OBJECT and BSC_OLAP_OBJECT_RELATION (EBS repository tables holding analytic workspace object definitions and their relationships), and PLITBLM (the PL/SQL integer table type used for array binding and bulk operations). BSC_OLAP_OBJECT and BSC_OLAP_OBJECT_RELATION are the primary persistent stores the package reads and writes when synchronizing dimension metadata with the AW.

Usage Notes

BSC_AW_ADAPTER_DIM is invoked during Analytic Workspace generation and refresh cycles, typically from concurrent programs and from higher-level BSC packages such as BSC_AW_LOAD_DIM, BSC_AW_MD_API, BSC_AW_MD_WRAPPER, and BSC_AW_UTILITY. It is not intended for direct customer invocation; customizations should prefer supported BSC APIs. Behavior is consistent across EBS 12.1.1 and 12.2.2.

PACKAGE BODY: APPS.BSC_AW_ADAPTER_DIM 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_AW_ADAPTER_DIM, status:VALID,
PACKAGE: APPS.BSC_AW_ADAPTER_DIM 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_AW_ADAPTER_DIM, status:VALID,
PACKAGE: APPS.BSC_AW_BSC_METADATA 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_AW_BSC_METADATA, status:VALID,
PACKAGE: APPS.BSC_AW_MD_WRAPPER 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_AW_MD_WRAPPER, status:VALID,
PACKAGE: APPS.BSC_AW_MD_API 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_AW_MD_API, status:VALID,
PACKAGE: APPS.BSC_AW_UTILITY 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_AW_UTILITY, status:VALID,
SYNONYM: APPS.BSC_OLAP_OBJECT 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_OLAP_OBJECT, status:VALID,
PACKAGE: APPS.BSC_METADATA 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_METADATA, status:VALID,
PACKAGE BODY: APPS.BSC_AW_LOAD_DIM 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_AW_LOAD_DIM, status:VALID,
PACKAGE: APPS.BSC_AW_LOAD_DIM 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_AW_LOAD_DIM, status:VALID,
SYNONYM: APPS.BSC_OLAP_OBJECT_RELATION 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_OLAP_OBJECT_RELATION, status:VALID,
PACKAGE BODY: APPS.BSC_AW_MD_WRAPPER 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_AW_MD_WRAPPER, status:VALID,
PACKAGE BODY: APPS.BSC_AW_ADAPTER 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_AW_ADAPTER, status:VALID,
PACKAGE BODY: APPS.BSC_AW_BSC_METADATA 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_AW_BSC_METADATA, status:VALID,
PACKAGE BODY: APPS.BSC_METADATA 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_METADATA, status:VALID,
PACKAGE BODY: APPS.BSC_AW_MD_API 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_AW_MD_API, status:VALID,
PACKAGE: APPS.BSC_AW_DBMS_AW 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_AW_DBMS_AW, status:VALID,
PACKAGE BODY: APPS.BSC_AW_ADAPTER_KPI 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_AW_ADAPTER_KPI, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE: APPS.BSC_AW_ADAPTER_KPI 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_AW_ADAPTER_KPI, status:VALID,
PACKAGE BODY: APPS.BSC_AW_READ 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_AW_READ, status:VALID,
PACKAGE: APPS.BSC_AW_CALENDAR 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_AW_CALENDAR, status:VALID,
PACKAGE BODY: APPS.BSC_AW_UTILITY 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_AW_UTILITY, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE: APPS.BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_AW_MD_WRAPPER dependencies on BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_METADATA dependencies on BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_AW_LOAD_DIM dependencies on BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_AW_MD_API dependencies on BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_METADATA dependencies on BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_AW_ADAPTER dependencies on BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_AW_MD_API dependencies on BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_AW_UTILITY dependencies on BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_AW_READ dependencies on BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_AW_ADAPTER_DIM dependencies on BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_AW_BSC_METADATA dependencies on BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_AW_MD_WRAPPER dependencies on BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_AW_CALENDAR dependencies on BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_AW_ADAPTER_KPI dependencies on BSC_AW_ADAPTER_DIM 12.1.1
APPS.BSC_AW_BSC_METADATA dependencies on BSC_AW_ADAPTER_DIM 12.1.1
SYNONYM: PUBLIC.DBMS_SQL 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBMS_SQL, status:VALID,
PACKAGE BODY: APPS.BSC_AW_ADAPTER_DIM 12.1.1
SYNONYM: PUBLIC.PLITBLM 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:PLITBLM, status:VALID,
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,