Search Results iby_document_lines_h




Overview
Explore in AI Chat

Overview

The IBY_DOCUMENT_LINES_H table is a core historical data repository within the Oracle E-Business Suite Payments (IBY) module. It functions as an audit and reporting table, capturing denormalized snapshots of invoice or document line items at specific, critical points in time. Its primary role is to preserve a historical record of line-level details as they existed when a payment for the associated document was submitted to a payment system or at other key processing milestones. This ensures that a complete, unalterable financial record is maintained for audit trails and reconciliation, independent of any subsequent changes to the original transactional data in source systems like Payables or Receivables.

Key Information Stored

The table stores a denormalized set of attributes for each captured line item. The primary identifier is the DOCUMENT_LINE_HISTORY_ID. Each record is linked to its parent document via the DOCUMENT_PAYABLE_ID, which references the current document in IBY_DOCS_PAYABLE_ALL, and the DOCUMENT_PAYABLE_HISTORY_ID, which references the corresponding historical snapshot of the document header in IBY_DOCUMENTS_PAYABLE_H. Typical columns in this table would include captured line-level details such as line amount, quantity, accounting code combinations (e.g., DIST_CODE_CONCATENATED), item description, tax information, and the line type. The inclusion of denormalized data allows for historical reporting without complex joins back to the original, potentially changed, source transaction lines.

Common Use Cases and Queries

This table is essential for audit inquiries, payment reconciliation reports, and troubleshooting payment processing issues. A common use case is generating a detailed report of what was paid for a specific invoice, exactly as the payment engine saw it. For example, to retrieve the historical line details for a specific payment instruction, one might query:

  • SELECT * FROM iby_document_lines_h dlh WHERE EXISTS (SELECT 1 FROM iby_docs_payable_all idpa WHERE idpa.document_payable_id = dlh.document_payable_id AND idpa.payment_id = :p_payment_id);

Another critical scenario is comparing historical line amounts against the original source transaction lines to identify discrepancies or changes made after payment submission, which is vital for financial controls and audit compliance.

Related Objects

IBY_DOCUMENT_LINES_H is centrally linked to two key parent tables in the Payments schema, as defined by its foreign keys.

  • IBY_DOCS_PAYABLE_ALL: This table holds the current version of payable documents. The foreign key on DOCUMENT_PAYABLE_ID links the historical line to its active document parent.
  • IBY_DOCUMENTS_PAYABLE_H: This is the historical header table. The foreign key on DOCUMENT_PAYABLE_HISTORY_ID links the line snapshot to the corresponding header snapshot, ensuring a complete historical record is maintained together.

Together, these tables form the backbone for the Payments module's historical audit and reporting capabilities.