Search Results warehouse

The EDW_CONS_SET_OF_BOOKS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical component within the Enterprise Data Warehouse (EDW) framework, primarily used for financial consolidation and reporting purposes. This table stores consolidated set of books (SOB) information, which is essential for organizations operating multiple legal entities or business units with distinct accounting requirements. The table serves as a bridge between transactional data in Oracle General Ledger (GL) and analytical reporting in the EDW layer, enabling unified financial reporting across disparate entities.

Key Attributes and Structure

The EDW_CONS_SET_OF_BOOKS table typically contains metadata and hierarchical relationships between sets of books, including:

CONS_SET_OF_BOOKS_ID: A unique identifier for the consolidated set of books.
SET_OF_BOOKS_ID: References the underlying sets of books (from GL_SETS_OF_BOOKS) being consolidated.
CONSOLIDATION_LEVEL: Defines the hierarchy level (e.g., corporate, regional, or entity-level).
CURRENCY_CODE: The reporting currency for the consolidated data.
PERIOD_SET_NAME: Links to the accounting calendar used for consolidation.
STATUS: Indicates whether the consolidation is active, inactive, or pending.

Functional Role in Oracle EBS

In Oracle EBS 12.1.1/12.2.2, this table supports:

Multi-Org Consolidation: Enables aggregation of financial data across multiple operating units or legal entities, each with their own set of books.
Currency Translation: Facilitates foreign currency conversions for global reporting by storing target currency details.
Intercompany Elimination: Provides metadata to identify and eliminate intercompany transactions during consolidation.
Reporting Alignment: Ensures consistent period close processes across entities by referencing shared calendars.

Integration with Other Modules

The table integrates with:

General Ledger (GL): Sources transactional data from GL_SETS_OF_BOOKS and GL_PERIODS.
Financial Consolidation Hub (FCH): Provides consolidation rules and mappings for EDW processes.
Oracle Business Intelligence (OBIEE): Serves as a dimension table for financial dashboards.

Technical Considerations

Partitioning: In large deployments, the table may be partitioned by CONS_SET_OF_BOOKS_ID for performance.
Indexes: Common indexes include those on SET_OF_BOOKS_ID and CURRENCY_CODE for join optimization.
ETL Processes: Populated via Oracle Data Integrator (ODI) or custom PL/SQL during period close.

Customization Scenarios

Organizations often extend this table to include:

Custom attributes like regulatory reporting flags
Additional hierarchy levels for complex organizational structures
Integration keys for third-party consolidation tools

Best Practices

Maintain referential integrity with GL_SETS_OF_BOOKS through regular audits.
Implement change tracking to log modifications to consolidation hierarchies.
Archive historical consolidation mappings to support audit requirements.

In summary, the EDW_CONS_SET_OF_BOOKS table is a foundational element for financial consolidation in Oracle EBS EDW implementations, enabling standardized reporting across heterogeneous accounting structures while maintaining flexibility for organizational-specific requirements.

Lookup Type: BIS_IMPLEMENTATION_TYPE 12.1.1
product: BIS - Applications BIS , meaning: BIS Implementation Type , description: BIS Implementation Type ,
Lookup Type: BIS_IMPLEMENTATION_TYPE 12.2.2
product: BIS - Applications BIS , meaning: BIS Implementation Type , description: BIS Implementation Type ,
Concurrent Program: EDW_ANALYZE_UTIL 12.2.2
execution_filename: EDW_ANALYZE_UTIL.ANALYZE_WH_TABLES , product: BIS - Applications BIS , user_name: EDW Analyze Warehouse Tables , description: EDW Analyze Warehouse Tables , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: EDW_ANALYZE_UTIL 12.1.1
execution_filename: EDW_ANALYZE_UTIL.ANALYZE_WH_TABLES , product: BIS - Applications BIS , user_name: EDW Analyze Warehouse Tables , description: EDW Analyze Warehouse Tables , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Lookup Type: EDW_OBJECTS_TO_LOAD 12.1.1
product: BIS - Applications BIS , meaning: Dimensions and Facts to load on source warehouse , description: Dimensions and Facts to load on source warehouse ,
Lookup Type: EDW_OBJECTS_TO_LOAD 12.2.2
product: BIS - Applications BIS , meaning: Dimensions and Facts to load on source warehouse , description: Dimensions and Facts to load on source warehouse ,
Concurrent Program: EDW_SIZE_REPORT 12.1.1
execution_filename: EDW_SIZE_WRAPPER.show_results , product: BIS - Applications BIS , user_name: EDW_SIZE_REPORT , description: EDW Sizing Report , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: EDW_SIZE_REPORT 12.2.2
execution_filename: EDW_SIZE_WRAPPER.show_results , product: BIS - Applications BIS , user_name: EDW_SIZE_REPORT , description: EDW Sizing Report , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: BIS_PMF_GET_EDW_DIMENSIONS 12.2.2
execution_filename: BIS_PMF_MIGRATE_DIMENSIONS_PVT.MIGRATE_EDW_DIMENSIONS , product: BIS - Applications BIS , user_name: BISVMDLS , description: Get Dimensions and Levels from EDW , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: BIS_PMF_GET_EDW_DIMENSIONS 12.1.1
execution_filename: BIS_PMF_MIGRATE_DIMENSIONS_PVT.MIGRATE_EDW_DIMENSIONS , product: BIS - Applications BIS , user_name: BISVMDLS , description: Get Dimensions and Levels from EDW , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Table: EDW_CONS_SET_OF_BOOKS 12.1.1
owner:BIS, object_type:TABLE, fnd_design_data:BIS.EDW_CONS_SET_OF_BOOKS FII.EDW_CONS_SET_OF_BOOKS, object_name:EDW_CONS_SET_OF_BOOKS, status:VALID, product: BIS - Applications BIS , description: Warehouse consolidation definitions setup table , implementation_dba_data: BIS.EDW_CONS_SET_OF_BOOKS ,
Table: EDW_EQUI_SET_OF_BOOKS 12.1.1
owner:BIS, object_type:TABLE, fnd_design_data:BIS.EDW_EQUI_SET_OF_BOOKS FII.EDW_EQUI_SET_OF_BOOKS, object_name:EDW_EQUI_SET_OF_BOOKS, status:VALID, product: BIS - Applications BIS , description: Warehouse equivalent set of books setup table , implementation_dba_data: BIS.EDW_EQUI_SET_OF_BOOKS ,
Table: EDW_SET_OF_BOOKS 12.1.1
owner:BIS, object_type:TABLE, fnd_design_data:BIS.EDW_SET_OF_BOOKS FII.EDW_SET_OF_BOOKS, object_name:EDW_SET_OF_BOOKS, status:VALID, product: BIS - Applications BIS , description: Warehouse set of books setup table , implementation_dba_data: BIS.EDW_SET_OF_BOOKS ,
Table: EDW_EQUI_SET_OF_BOOKS 12.2.2
product: BIS - Applications BIS , description: Warehouse equivalent set of books setup table , implementation_dba_data: Not implemented in this database ,
Table: EDW_CONS_SET_OF_BOOKS 12.2.2
product: BIS - Applications BIS , description: Warehouse consolidation definitions setup table , implementation_dba_data: Not implemented in this database ,
Table: EDW_LOCAL_CONS_SET_OF_BOOKS 12.1.1
owner:BIS, object_type:TABLE, fnd_design_data:BIS.EDW_LOCAL_CONS_SET_OF_BOOKS, object_name:EDW_LOCAL_CONS_SET_OF_BOOKS, status:VALID, product: BIS - Applications BIS , description: EDW_LOCAL_CONS_SET_OF_BOOKS is the setup table for warehouse consolidation mappings , implementation_dba_data: BIS.EDW_LOCAL_CONS_SET_OF_BOOKS ,
Table: EDW_SET_OF_BOOKS 12.2.2
product: BIS - Applications BIS , description: Warehouse set of books setup table , implementation_dba_data: Not implemented in this database ,
Table: EDW_LOCAL_CONS_SET_OF_BOOKS 12.2.2
product: BIS - Applications BIS , description: EDW_LOCAL_CONS_SET_OF_BOOKS is the setup table for warehouse consolidation mappings , implementation_dba_data: Not implemented in this database ,
Lookup Type: BIS_SOURCE_SYSTEM 12.1.1
product: BIS - Applications BIS , meaning: Source System for PMF , description: Source System for PMF ,
Lookup Type: BIS_SOURCE_SYSTEM 12.2.2
product: BIS - Applications BIS , meaning: Source System for PMF , description: Source System for PMF ,
Concurrent Program: EDW_SIZE_WRAPPER 12.2.2
execution_filename: EDW_SIZE_WRAPPER.function_call , product: BIS - Applications BIS , user_name: EDW_SIZE_WRAPPER , description: Estimate EDW Size , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: EDW_SIZE_WRAPPER 12.1.1
execution_filename: EDW_SIZE_WRAPPER.function_call , product: BIS - Applications BIS , user_name: EDW_SIZE_WRAPPER , description: Estimate EDW Size , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: EDW_CLEAN_DIM_DATA 12.2.2
execution_filename: EDW_CLEAN_OBJECT.clean_up_object , product: BIS - Applications BIS , user_name: Clean Object Data , description: Cleans object and all associated objects in warehouse , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: EDW_CLEAN_FACT_DATA 12.1.1
execution_filename: EDW_CLEAN_OBJECT.clean_up_object , product: BIS - Applications BIS , user_name: Clean Object Data , description: Cleans object and all associated objects in warehouse , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: EDW_CLEAN_FACT_DATA 12.2.2
execution_filename: EDW_CLEAN_OBJECT.clean_up_object , product: BIS - Applications BIS , user_name: Clean Object Data , description: Cleans object and all associated objects in warehouse , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: EDW_CLEAN_DIM_DATA 12.1.1
execution_filename: EDW_CLEAN_OBJECT.clean_up_object , product: BIS - Applications BIS , user_name: Clean Object Data , description: Cleans object and all associated objects in warehouse , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,