Search Results iby_documents_payable_h




Overview
Explore in AI Chat

Overview

The IBY_DOCUMENTS_PAYABLE_H table is a core data repository within the Oracle Payments (IBY) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a historical audit table, capturing a complete record of all payment-related documents processed by the system. Its primary role is to maintain a non-modifiable, time-stamped history of the status and attributes of documents payable, such as invoices or expense reports, as they move through the payment lifecycle. This ensures full auditability and traceability for financial transactions, from initial selection for payment through final settlement and reconciliation.

Key Information Stored

The table's structure is defined by its relationships to other key IBY entities, as indicated by its foreign keys. The primary identifier is the DOCUMENT_PAYABLE_HISTORY_ID. Critical columns link each historical record to its associated payment process components. These include PAYMENT_ID (linking to IBY_PAYMENTS_ALL), PAYMENT_HISTORY_ID (linking to IBY_PAYMENTS_H), and PAYMENT_SERVICE_REQUEST_ID (linking to IBY_PAY_SERVICE_REQUESTS), which together anchor the document's history to a specific payment instruction and run. Other significant columns store the PAYMENT_METHOD_CODE, the PAYMENT_PROFILE_ID governing the payment rules, and the COUNTRY code for jurisdictional context. The CALLING_APP_ID and PAY_PROC_TRXN_TYPE_CODE define the originating application (e.g., Payables) and the transaction type, respectively.

Common Use Cases and Queries

This table is essential for audit reporting, payment traceability, and troubleshooting payment processing issues. A common use case is tracing the complete history of a specific invoice through all payment runs. Another is generating reports on documents paid via a specific method (e.g., Electronic Funds Transfer) within a date range. A sample query to retrieve the payment history for a document from a known payment request would be:

  • SELECT dph.* FROM iby_documents_payable_h dph WHERE dph.payment_service_request_id = <REQUEST_ID> ORDER BY dph.creation_date;

For reconciliation, one might join this table to IBY_PAYMENTS_ALL to list all documents included in a specific, finalized payment instruction.

Related Objects

As per the provided metadata, IBY_DOCUMENTS_PAYABLE_H has integral relationships with several key tables in the Payments schema. It is a central hub connected to payment master data (IBY_PAYMENTS_ALL), payment history (IBY_PAYMENTS_H), and the controlling payment request (IBY_PAY_SERVICE_REQUESTS). It references configuration tables for payment methods (IBY_PAYMENT_METHODS_B), payment profiles (IBY_ACCT_PMT_PROFILES_B), and transaction types (IBY_TRXN_TYPES_B). The link to FND_TERRITORIES provides territory information. This network of relationships underscores the table's role in tying document-level audit trails to the broader payment execution framework.