Search Results ra_interface_lines_all

Overview

The RA_INTERFACE_LINES_ALL table is a critical staging table within the Oracle E-Business Suite Receivables (AR) module, specifically for versions 12.1.1 and 12.2.2. It serves as the primary data repository for invoice line-level information that is imported into the system via the AutoInvoice program. AutoInvoice is the standard mechanism for converting transactional data from external feeder systems, such as Order Management or legacy applications, into valid Receivables invoices, debit memos, credit memos, and on-account credits. The table's role is to hold raw, unvalidated line data until the AutoInvoice process validates it against Receivables' business rules and successfully transfers it to the base transaction tables, such as RA_CUSTOMER_TRX_LINES_ALL.

Key Information Stored

The table stores a comprehensive set of attributes required to create a fully defined invoice line. While the specific column list is extensive, the documented foreign key relationships highlight several critical data points. Key columns include INTERFACE_LINE_ID (the primary key), SET_OF_BOOKS_ID for the accounting context, and APPLICATION_ID to identify the source feeder system. It holds customer and site identifiers for billing and shipping (e.g., ORIG_SYSTEM_BILL_CUSTOMER_ID, ORIG_SYSTEM_SHIP_ADDRESS_ID) as well as for the paying party (PAYING_CUSTOMER_ID, PAYING_SITE_USE_ID). The table also links to contract management (CONTRACT_ID, CONTRACT_LINE_ID) and payment processing (PAYMENT_TRXN_EXTENSION_ID). Each record typically includes line amounts, quantity, item information, tax references, and descriptive flexfield data necessary for complete transaction creation.

Common Use Cases and Queries

The primary use case is troubleshooting and monitoring the AutoInvoice import process. Developers and functional consultants frequently query this table to diagnose rows that have failed validation, identified by a populated INTERFACE_LINE_CONTEXT and INTERFACE_LINE_ATTRIBUTE1-15 columns with error messages, and a STATUS of 'R' (Rejected). A common diagnostic query is: SELECT interface_line_id, line_number, error_message FROM ra_interface_lines_all WHERE request_id = :req_id AND status = 'R'; where :req_id is the concurrent request ID of the AutoInvoice run. Another routine operation is purging successfully processed ('I' for Imported) records using the standard AR_INTERFACE_LINES_PKG procedures to maintain performance. For reporting, the table can be joined to interface headers (RA_INTERFACE_LINES_ALL.INTERFACE_HEADER_ID = RA_INTERFACE_HEADERS_ALL.INTERFACE_HEADER_ID) to analyze the volume and nature of data staged for import.

Related Objects

As documented in the ETRM metadata, RA_INTERFACE_LINES_ALL has numerous key relationships with other EBS objects. Its primary key, INTERFACE_LINE_ID, is referenced by the ZX_LINES_DET_FACTORS and ZX_LINES tables in the Tax (eZX) module. The table itself foreign keys to several foundational tables, establishing critical validations for imported data. These include:

• HZ_CUST_ACCOUNTS (for ORIG_SYSTEM_SOLD_CUSTOMER_ID, PAYING_CUSTOMER_ID, ORIG_SYSTEM_BILL_CUSTOMER_ID, ORIG_SYSTEM_SHIP_CUSTOMER_ID)
• HZ_CUST_ACCT_SITES_ALL (for ORIG_SYSTEM_BILL_ADDRESS_ID, ORIG_SYSTEM_SHIP_ADDRESS_ID)
• HZ_CUST_SITE_USES_ALL (for PAYING_SITE_USE_ID)
• HZ_CUST_ACCOUNT_ROLES (for ORIG_SYSTEM_BILL_CONTACT_ID, ORIG_SYSTEM_SHIP_CONTACT_ID)
• GL_SETS_OF_BOOKS_11I (for SET_OF_BOOKS_ID)
• FND_APPLICATION (for APPLICATION_ID)
• OKC_K_HEADERS_B & OKC_K_LINES_B (for CONTRACT_ID and CONTRACT_LINE_ID)
• IBY_FNDCPT_TX_EXTENSIONS (for PAYMENT_TRXN_EXTENSION_ID)

These relationships ensure that data staged in the interface table aligns with established customers, accounting setups, contracts, and payment methods before being imported.