Search Results iex_writeoff_objects_u1

Overview

The IEX.IEX_WRITEOFF_OBJECTS table is a transactional table within the Oracle E-Business Suite Collections (IEX) schema. It stores the individual writeoff objects associated with a writeoff transaction, capturing the specific level at which a writeoff is applied. According to the object documentation, writeoffs in the Oracle Contracts (OKL) context can occur at three distinct levels: at the contract level (where a contract with a delinquent case may be written off), at the consolidated invoice level (where all consolidated invoices within a contract can be written off), and at the lowest level (where an individual invoice line within a consolidation can be written off). This table therefore acts as the granular detail behind the parent IEX_WRITEOFFS header, recording which contracts, consolidated invoices, consolidated invoice lines, or receivables payment schedules are affected by a given writeoff.

From a Data Vault modeling perspective, the mined foreign key structure suggests classifying this object as a Link table. It resolves the many-to-many relationship between a writeoff header and the underlying receivable or contract entities being written off, with the surrogate key WRITEOFF_OBJECT_ID serving as the link identifier.

Key Information Stored

The table contains 41 documented columns. The most significant columns include:

• WRITEOFF_OBJECT_ID — The surrogate primary key (unique index IEX_WRITEOFF_OBJECTS_U1), uniquely identifying each writeoff object row.
• WRITEOFF_ID — Foreign key to IEX_WRITEOFFS, linking the detail row to its parent writeoff header.
• CONTRACT_ID — Foreign key to IEX_CASE_OBJECTS.OBJECT_ID, corresponding to CONTRACT_ID from OKC_K_HEADERS_B; identifies the contract being written off.
• CONS_INVOICE_ID — Foreign key to OKL_CNSLD_AR_HDRS_B; identifies the consolidated invoice written off.
• CONS_INVOICE_LINE_ID — Foreign key to OKL_CNSLD_AR_LINES_B; identifies the specific consolidated invoice line written off.
• TRANSACTION_ID — Foreign key to AR_PAYMENT_SCHEDULES; the payment schedule against which the writeoff is performed.
• ADJUSTMENT_AMOUNT — The amount to be adjusted in the writeoff.
• ADJUSTMENT_REASON_CODE — The reason code associated with the adjustment.
• RECEVIABLES_ADJUSTMENT_ID — Foreign key to AR_ADJUSTMENTS_ALL; populated with the adjustment ID once the adjustment is successfully created.
• WRITEOFF_TYPE_ID and WRITEOFF_TYPE — Classify the nature of the writeoff.
• WRITEOFF_STATUS — Indicates processing status of the writeoff object.
• CUSTOMER_TRX_ID and CUSTOMER_TRX_LINE_ID — Link to the AutoInvoice transaction header and line being written off.
• OBJECT_VERSION_NUMBER — Column used for optimistic locking during updates.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS for multi-tenant data segregation.
• The standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) tracking concurrent program processing.

Common Use Cases and Queries

This table supports reconciliation of writeoffs from the Collections module to the underlying Receivables adjustments. A common reporting query joins the writeoff detail to its parent header and to the generated AR adjustment:

• Reconciling writeoff amounts against AR_ADJUSTMENTS_ALL using RECEVIABLES_ADJUSTMENT_ID.
• Identifying all writeoff objects for a specific contract or consolidated invoice to audit outstanding delinquent balances.
• Reporting on writeoff activity by status and type to monitor collection performance.
• Tracing a writeoff to a specific AR_PAYMENT_SCHEDULES transaction via TRANSACTION_ID.

Typical join pattern: IEX_WRITEOFF_OBJECTS.WRITEOFF_ID = IEX_WRITEOFFS.WRITEOFF_ID combined with IEX_WRITEOFF_OBJECTS.RECEVIABLES_ADJUSTMENT_ID = AR_ADJUSTMENTS_ALL.ADJUSTMENT_ID to verify that each requested writeoff produced a corresponding receivable adjustment.

Related Objects

• IEX.IEX_WRITEOFFS — Parent writeoff header; joined on WRITEOFF_ID.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for security grouping.
• OKC.OKC_K_HEADERS_B — Contract header source for CONTRACT_ID.
• OKL.OKL_CNSLD_AR_HDRS_B — Consolidated AR invoice header referenced by CONS_INVOICE_ID.
• OKL.OKL_CNSLD_AR_LINES_B — Consolidated AR invoice lines referenced by CONS_INVOICE_LINE_ID.
• AR.AR_PAYMENT_SCHEDULES — Payment schedule referenced by TRANSACTION_ID.
• AR.AR_ADJUSTMENTS_ALL — Created adjustment referenced by RECEVIABLES_ADJUSTMENT_ID.