Results for “gl_id_ded_adj_clearing”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OZF_CLAIM_TYPES_ALL_B is the foundational base table within the Oracle Trade Management (OZF) module that stores the definition of Claim Types. Claim Types represent the configurable categories of deductions, promotional accruals, and trade claims that an organization processes — for example, promotional billbacks, distributor chargebacks, unsaleables, or promotional accruals. Each row defines a distinct claim category and carries the financial, workflow, and accounting parameters that govern how claims of that type are created, validated, settled, and posted to the General Ledger.

The "_B" suffix denotes the base (non-translated) table of a translated entity; descriptive, language-dependent attributes are held in the companion table OZF_CLAIM_TYPES_ALL_TL. The "_ALL" suffix indicates that rows are partitioned by operating unit through the ORG_ID column, enabling multi-org (MOL) access control. In the supplied metadata the table is classified, heuristically, as a hub in Data Vault terms: CLAIM_TYPE_ID is a durable, unique business entity key referenced by many downstream tables, which is consistent with hub semantics. This classification is a modeling suggestion rather than a documented Oracle designation.

Key Information Stored

The table contains 51 documented columns. The surrogate primary key is CLAIM_TYPE_ID, enforced by the constraint OZF_CLAIM_TYPES_ALL_B_PK. The unique index OZF_CLAIM_TYPES_ALL_B_U1 on (CLAIM_TYPE_ID, ORG_ID, ZD_EDITION_NAME) reflects the multi-org and multi-edition business key, confirming that the same logical claim type can exist per operating unit.

The most significant columns include:

• CLAIM_TYPE_ID — surrogate primary key and the foreign key target used by all dependent claim tables.
• ORG_ID — operating unit that owns the claim type, driving multi-org security.
• CLAIM_CLASS — classifies the claim type (for example, deduction, accrual, or promotional), controlling downstream processing behaviour.
• SET_OF_BOOKS_ID — the ledger context in which claims of this type are accounted.
• POST_TO_GL_FLAG and TRANSACTION_TYPE — determine whether and how claims post to the General Ledger.
• START_DATE and END_DATE — effective-dating window for the claim type.
• GL_ID_DED_ADJ, GL_ID_DED_ADJ_CLEARING, GL_ID_DED_CLEARING, GL_ID_ACCR_PROMO_LIAB, and GL_BALANCING_FLEX_VALUE — the accounting flexfield identifiers for deduction adjustments, clearing, and promotional liability postings.
• ADJUSTMENT_TYPE, CREATION_SIGN, and CREATED_FROM — control how claims originate and are adjusted.
• ORDER_TYPE_ID — links the claim type to an order type in SO_ORDER_TYPES_115_ALL.
• SECURITY_GROUP_ID — references FND_SECURITY_GROUPS for row-level access.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF-based Trade Management UI.

Common Use Cases and Queries

Claim Types are typically queried when configuring deduction and accrual processing, when reconciling claims to GL postings, or when populating claim entry LOVs. A representative query listing active claim types for an operating unit follows:

• SELECT ct.claim_type_id, ct.claim_class, ct.post_to_gl_flag, tl.claim_type_name FROM ozf_claim_types_all_b ct, ozf_claim_types_all_tl tl WHERE ct.claim_type_id = tl.claim_type_id AND tl.language = USERENV('LANG') AND ct.org_id = :org_id AND SYSDATE BETWEEN ct.start_date AND NVL(ct.end_date, SYSDATE + 1);
• Reporting on claim volumes by type: join OZF_CLAIMS_ALL to OZF_CLAIM_TYPES_ALL_B on CLAIM_TYPE_ID and aggregate by CLAIM_CLASS.
• Configuration auditing: inspect GL_ID_* and GL_BALANCING_FLEX_VALUE assignments per claim type to validate accounting setups.
• Autopay configuration review: join to OZF_SYS_PARAMETERS_ALL via CLAIM_TYPE_ID or AUTOPAY_CLAIM_TYPE_ID.

Related Objects

The following objects have the most significant documented relationships with OZF_CLAIM_TYPES_ALL_B:

• OZF_CLAIMS_ALL — references this table via CLAIM_TYPE_ID; every claim row is typed by a claim type.
• OZF_CLAIM_DEF_RULES_ALL — references CLAIM_TYPE_ID; stores defaulting rules applied at claim creation.
• OZF_CLAIM_TYPES_ALL_TL — translated (language-dependent) attributes; join on CLAIM_TYPE_ID.
• OZF_SYS_PARAMETERS_ALL — references CLAIM_TYPE_ID and AUTOPAY_CLAIM_TYPE_ID for system parameter and autopay configuration.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for row-level security.
• SO_ORDER_TYPES_115_ALL — referenced via ORDER_TYPE_ID, linking claim types to order types.

Together these relationships establish OZF_CLAIM_TYPES_ALL_B as the central reference hub for claim classification across the Trade Management deduction lifecycle.