Search Results ar_interest_lines_all




Overview
Explore in AI Chat

Overview

AR_INTEREST_LINES_ALL is a Receivables (AR) transactional table that stores late charge lines generated by Oracle E-Business Suite when finance charges or interest are assessed against overdue customer transactions. Each row represents a single late charge line, capturing the calculated interest amount, the payment schedule item it applies to, the rate and period used in the calculation, and the processing status of the line. In EBS 12.1.1 and 12.2.2, the table is owned by the AR schema and is a core storage object for the late charge workflow, sitting beneath AR_INTEREST_HEADERS_ALL and generating adjustments and customer transaction lines when completed.

Under the heuristic Data Vault classification derived from the foreign key structure, AR_INTEREST_LINES_ALL is hub-leaning. In Data Vault modeling terms, INTEREST_LINE_ID behaves as a business hub key representing the unique late charge line, with INTEREST_HEADER_ID providing a link to the parent late charge batch and RECEIVABLES_TRX_ID linking the line to the receivables transaction type that determines accounting. Analysts modeling this table in a warehouse may therefore treat it as a hub with satellite attributes for the calculated amounts, dates, and processing columns.

Key Information Stored

The surrogate primary key is INTEREST_LINE_ID, enforced by the AR_INTEREST_LINES_PK unique index. A second unique index, AR_INTEREST_LINES_U2, covers INTEREST_HEADER_ID and INTEREST_LINE_ID, establishing the parent-child business key relationship. The most significant columns include:

Common Use Cases and Queries

Typical reporting scenarios include aging analysis of late charges, reconciliation of generated interest against adjustments, and monitoring of lines left in error status. A representative query joining the header, line, and source transaction is:

SELECT h.interest_header_id, l.interest_line_id, l.outstanding_amount, l.interest_rate, l.interest_charged, l.process_status FROM ar.ar_interest_headers_all h, ar.ar_interest_lines_all l WHERE h.interest_header_id = l.interest_header_id AND l.org_id = :org_id AND l.process_status = 'ERROR';

Because late charges post to adjustments, a common reconciliation joins AR_ADJUSTMENTS_ALL on INTEREST_LINE_ID to confirm that each calculated line produced an accounting adjustment, while a further join to RA_CUSTOMER_TRX_LINES_ALL via the INTEREST_LINE_ID foreign key traces the resulting customer transaction line.

Related Objects

  • AR_INTEREST_HEADERS_ALL — parent late charge batch, joined on INTEREST_HEADER_ID.
  • AR_RECEIVABLES_TRX_ALL — transaction type definition, joined on RECEIVABLES_TRX_ID.
  • AR_ADJUSTMENTS_ALL — adjustment records referencing INTEREST_LINE_ID.
  • RA_CUSTOMER_TRX_LINES_ALL — customer transaction lines created from the late charge, referencing INTEREST_LINE_ID.
  • AR_LATE_CHARGE_DOC_GT, AR_TRX_LINES_GT, AR_TRX_LINES_TMP_GT — interface and temporary tables used by the late charge generation and posting programs, referencing INTEREST_LINE_ID.