Results for “gcs_elim_rules_b”
37 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
GCS_ELIM_RULES_B is the base table that stores consolidation and elimination rule definitions within the Oracle E-Business Suite Financial Consolidation Hub (GCS) module. It holds the master header-level definition for each elimination rule, including the rule type, the transaction types to which it applies, the account treatment mapping (from/to treatments), and the enabled status. This table is the driving entity behind the consolidation engine, where each rule defines how intercompany balances and transactions are eliminated during a consolidation run.
In Oracle EBS 12.1.1 and 12.2.2 this object belongs to the GCS schema and is documented as obsolete in later releases. The ETRM metadata classifies it heuristically as hub-leaning in a Data Vault model, since it carries a single natural key resolved through a unique index and is referenced by several dependent tables. This classification is a modeling suggestion only and does not reflect an explicit Data Vault design in the EBS schema.
Key Information Stored
The table is keyed by the surrogate primary key RULE_ID, defined on the constraint GCS_ELIM_RULES_B_PK and reinforced by the unique index GCS_ELIM_RULES_B_U1. Together these establish RULE_ID as the business-key candidate for the rule.
- RULE_ID — Surrogate primary key identifying each consolidation rule.
- RULE_TYPE_CODE — Classifies the rule (for example, elimination or consolidation logic).
- TRANSACTION_TYPE_CODE — Restricts the rule to a given transaction category.
- FROM_TREATMENT_ID — References the source account treatment used as the rule input.
- TO_TREATMENT_ID — References the target account treatment produced by the rule.
- SEEDED_RULE_FLAG — Indicates whether the rule was delivered by Oracle as seed data or user-defined.
- ENABLED_FLAG — Controls whether the rule is active during a consolidation run.
- OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF/BC4J framework.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Who columns capturing audit and user context.
Common Use Cases and Queries
Typical queries begin from the rule header and join into translation and step detail. A common pattern lists enabled rules by type:
SELECT RULE_ID, RULE_TYPE_CODE, TRANSACTION_TYPE_CODE,
FROM_TREATMENT_ID, TO_TREATMENT_ID, SEEDED_RULE_FLAG
FROM GCS_ELIM_RULES_B
WHERE ENABLED_FLAG = 'Y';
GCS_ELIM_RULES_TL resolves RULE_ID to the user-facing rule name and description for each language, while GCS_ELIM_RULE_STEPS_B and GCS_ELIM_RULE_RELS decompose the rule into execution steps and relationships. Reporting on which rules produced which journals requires joining to GCS_ENTRY_HEADERS on RULE_ID.
Related Objects
- GCS_ELIM_RULES_TL — multilingual name/description, joined on RULE_ID.
- GCS_ELIM_RULE_RELS — rule-to-relationship assignments, joined on RULE_ID.
- GCS_ELIM_RULE_STEPS_B — ordered rule execution steps, joined on RULE_ID.
- GCS_ENTRY_HEADERS — consolidation entry headers generated by the rule, joined on RULE_ID.
- FROM_TREATMENT_ID / TO_TREATMENT_ID — treatment references used to resolve source and target accounts.
-
GCS consolidation rules
-
TABLE: GCS.GCS_ELIM_RULES_B 12.1.1
-
Table: GCS_ELIM_RULES_B 12.2.2
GCS consolidation rules
Not implemented in this database·Explore GCS module →
-
Table: GCS_ELIM_RULES_TL 12.2.2
Translation table for GCS_ELIM_RULES_B
Not implemented in this database·Explore GCS module →
-
View: GCS_ELIM_RULES_VL 12.1.1
Elimination rules information
APPS.GCS_ELIM_RULES_VL·↳ GCS_ELIM_RULES_B·↳ GCS_ELIM_RULES_TL·Explore GCS module →
-
Translation table for GCS_ELIM_RULES_B
-
VIEW: APPS.GCS_ELIM_RULES_VL 12.1.1
-
View: GCS_ELIM_RULES_VL 12.2.2
Elimination rules information
Not implemented in this database·Explore GCS module →
-
Table: GCS_ELIM_RULE_STEPS_B 12.2.2
GCS elimination rule steps
Not implemented in this database·Explore GCS module →
-
GCS consolidation treatment and consolidation rules relationship information
-
Table: GCS_ELIM_RULE_RELS 12.2.2
GCS consolidation treatment and consolidation rules relationship information
Not implemented in this database·Explore GCS module →
-
12.1.1 FND Design Data 12.1.1
-
Table: GCS_ENTRY_HEADERS 12.2.2
GCS consolidation entry headers
Not implemented in this database·Explore GCS module →
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
GCS elimination rule steps
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - GCS Tables and Views 12.1.1
XML generated for XML Publisher reporting
-
GCS consolidation entry headers
-
VIEW: APPS.GCS_ELIM_RULES_VL 12.1.1
-
Foreign Keys 12.2.2
-
Foreign Keys 12.1.1
-
eTRM - GCS Tables and Views 12.1.1
XML generated for XML Publisher reporting
-
12.1.1 DBA Data 12.1.1