Search Results ar_invoice




Overview
Explore in AI Chat

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:

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.