Search Results derivation_detail_id




Overview
Explore in AI Chat

Overview

The GCS_LEX_MAP_DRV_DETAILS table is a core data structure within the Financial Consolidation Hub (GCS) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as a detailed repository for the configuration of transformation rule set derivations. In the context of financial consolidation, transformation rules are critical for mapping and converting source ledger data into a format suitable for the consolidation ledger. This table stores the granular, line-level instructions that define how specific data points are derived or calculated during this transformation process, acting as a child to higher-level derivation definitions.

Key Information Stored

The table's primary purpose is to link derivation rules to the specific columns they affect and the source data they reference. Its structure is defined by key foreign key relationships. The central identifier is the DERIVATION_DETAIL_ID, which is the table's primary key. Each record is tied to a parent derivation rule via the DERIVATION_ID, which references the GCS_LEX_MAP_DERIVATIONS table. The operational logic of a detail record is defined by two critical column references: the DETAIL_COLUMN_ID indicates the target column in the consolidation entity that will receive the derived value, while the LOOKUP_COLUMN_ID points to the source column in the mapping structure that provides the data or value for the derivation. This design enables a flexible rule engine where multiple detail lines can compose a single derivation rule.

Common Use Cases and Queries

This table is primarily accessed for implementation configuration, troubleshooting, and impact analysis of financial data transformation rules. A common operational query involves listing all derivation details for a specific rule set to validate configuration. For example: SELECT * FROM GCS.GCS_LEX_MAP_DRV_DETAILS dd WHERE dd.DERIVATION_ID = (SELECT DERIVATION_ID FROM GCS_LEX_MAP_DERIVATIONS WHERE RULESET_NAME='<Rule_Set_Name>');. Support and development personnel may query this table to diagnose data mapping issues by joining to the column reference tables to see the specific source-to-target mappings. Reporting on the complexity and design of transformation logic often starts with aggregating data from this detail table.

Related Objects

The GCS_LEX_MAP_DRV_DETAILS table exists within a tightly integrated schema for managing transformation mappings. Its documented relationships are as follows:

  • GCS_LEX_MAP_DERIVATIONS: This is the parent table. The foreign key GCS_LEX_MAP_DRV_DETAILS.DERIVATION_ID references it, linking detail lines to their parent derivation rule.
  • GCS_LEX_MAP_COLUMNS (Two Relationships): This table is referenced twice. The DETAIL_COLUMN_ID foreign key links to a column record defining the target of the derivation. The LOOKUP_COLUMN_ID foreign key links to a (potentially different) column record defining the source for the derivation.
These relationships underscore the table's role as a junction that connects derivation rules, target columns, and source data points within the consolidation mapping framework.