Results for “ozf_reason_codes_all_b”

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

Overview

OZF_REASON_CODES_ALL_B is a Trade Management (OZF) base table that stores the reason codes used to classify and justify claims, adjustments, and invoicing decisions throughout the Oracle E-Business Suite Trade Management module. Reason codes recorded here are consumed by claim processing, automatic payment routines, deduction and adjustment workflows, and partner-facing claim entry. The table is owned by the OZF schema and is marked VALID in the ETRM repository for both 12.1.1 and 12.2.2.

In Data Vault terms the table is best modeled as a hub: it carries a single, stable surrogate identifier (REASON_CODE_ID) and acts as the integration point for several dependent and reference relationships. The physical definition documents 34 columns, with a primary key constraint named OZF_REASON_CODES_ALL_B_PK defined on REASON_CODE_ID.

Key Information Stored

The most significant columns are:

• REASON_CODE_ID — surrogate primary key; the value referenced by all dependent tables.
• REASON_CODE — the user-visible code presented in claim and adjustment screens.
• REASON_TYPE_ID — discriminator identifying which reason category a row belongs to; participates in the unique key and in foreign relationships to JTF_TASK_TEMP_GROUPS_B and OZF_REASONS.
• REASON_TYPE — descriptive or denormalized companion to the type identifier.
• ORG_ID — operating unit that owns the reason code; combined with REASON_CODE_ID it forms the unique index OZF_REASON_CODES_ALL_B_U1.
• START_DATE_ACTIVE and END_DATE_ACTIVE — effective-dating window controlling availability of the code.
• ORDER_TYPE_ID — foreign key to SO_ORDER_TYPES_115_ALL, linking a reason code to an order type.
• ADJUSTMENT_REASON_CODE and INVOICING_REASON_CODE — flags or codes that scope the row to adjustment and invoicing scenarios.
• PARTNER_ACCESS_FLAG — controls whether the reason code is exposed to partners.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS for row-level access control.
• OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard audit and optimistic-locking columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard DFF extensibility block.

The surrogate key is REASON_CODE_ID; the documented business-key candidate is the unique index OZF_REASON_CODES_ALL_B_U1 on (REASON_CODE_ID, ORG_ID), confirming that reason codes are defined per operating unit. Translated text resides in the companion table OZF_REASON_CODES_ALL_TL.

Common Use Cases and Queries

Typical usage includes validating a reason code entered on a claim, listing active reason codes for an operating unit, and resolving the description text for a claim line. A basic active-code lookup:

• SELECT b.reason_code_id, b.reason_code, t.description FROM ozf_reason_codes_all_b b, ozf_reason_codes_all_tl t WHERE b.reason_code_id = t.reason_code_id AND b.org_id = :p_org_id AND TRUNC(SYSDATE) BETWEEN b.start_date_active AND NVL(b.end_date_active, TRUNC(SYSDATE))

A claim-level join returns the reason recorded against each claim:

• SELECT c.claim_id, b.reason_code FROM ozf_claims_all c, ozf_reason_codes_all_b b WHERE c.reason_code_id = b.reason_code_id

Reporting queries can group claims by reason type, filter by PARTNER_ACCESS_FLAG when producing partner-facing extracts, or resolve the system parameters governing autopay using OZF_SYS_PARAMETERS_ALL.AUTOPAY_REASON_CODE_ID. Extensibility reporting can pivot the ATTRIBUTE1–15 columns as needed.

Related Objects

The following objects are the most significant dependents and references:

• OZF_CLAIMS_ALL — references REASON_CODE_ID; the primary transactional consumer of reason codes.
• OZF_REASONS — relates through REASON_CODE_ID and REASON_TYPE_ID, providing additional reason categorization.
• OZF_REASON_CODES_ALL_TL — translated descriptions keyed on REASON_CODE_ID.
• OZF_SYS_PARAMETERS_ALL — references the table twice, via REASON_CODE_ID and AUTOPAY_REASON_CODE_ID, controlling default and automatic payment behavior.
• JTF_TASK_TEMP_GROUPS_B — referenced via REASON_TYPE_ID for task grouping.
• SO_ORDER_TYPES_115_ALL — referenced via ORDER_TYPE_ID.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for access control.