Search Results ar_interest_headers_u1

Overview

AR.AR_INTEREST_HEADERS_ALL is the Receivables late charges interest document header table. It stores the header-level definition of a late charge (interest) run: the customer, currency, calculation rules, penalties, thresholds, and processing state used to generate interest debit memos, interest invoices, or adjustments. Each row represents one interest document header within a batch, and child lines are held in AR_INTEREST_LINES_ALL.

In Oracle EBS 12.1.1 and 12.2.2 the table resides in the AR schema, is stored in the APPS_TS_TX_DATA tablespace, and is registered in FND Design Data as AR.AR_INTEREST_HEADERS_ALL with status VALID. It carries 55 documented columns in the 12.2.2 physical schema and its unique indexes are AR_INTEREST_HEADERS_U1 (INTEREST_HEADER_ID) and AR_INTEREST_HEADERS_U2 (INTEREST_BATCH_ID, INTEREST_HEADER_ID). Based on the foreign-key structure, the object is heuristic Data Vault classified as hub-leaning; from a modeling perspective it can be treated as a hub (or a link hub) whose natural business keys are the unique index combinations, with the remaining descriptive attributes behaving as satellite content.

Key Information Stored

The surrogate primary key is INTEREST_HEADER_ID, enforced by AR_INTEREST_HEADERS_U1. The business-key candidate is the composite (INTEREST_BATCH_ID, INTEREST_HEADER_ID), enforced by AR_INTEREST_HEADERS_U2, which ties the header to its parent batch.

• INTEREST_HEADER_ID — Primary key of the header.
• INTEREST_BATCH_ID — Foreign key to RA_INTEREST_BATCHES_ALL.INTEREST_BATCH_ID; groups headers into a processing batch.
• CUSTOMER_ID / CUSTOMER_SITE_USE_ID — The customer and site being charged.
• HEADER_TYPE — Document type of the late charge: ADJ, DM, or INV.
• CURRENCY_CODE — Currency of the interest document.
• LATE_CHARGE_CALCULATION_TRX, CREDIT_ITEMS_FLAG, DISPUTED_TRANSACTIONS_FLAG — Eligibility/selection flags controlling which transactions and credit or disputed items are included.
• PAYMENT_GRACE_DAYS, INTEREST_PERIOD_DAYS, INTEREST_CALCULATION_PERIOD — Timing controls for grace and interest periods.
• LATE_CHARGE_TERM_ID, CUST_TRX_TYPE_ID — Terms and transaction type used to create the resulting document.
• INTEREST_RATE, INTEREST_FIXED_AMOUNT, INTEREST_TYPE, INTEREST_SCHEDULE_ID — Interest computation parameters.
• PENALTY_RATE, PENALTY_FIXED_AMOUNT, PENALTY_TYPE, PENALTY_SCHEDULE_ID — Penalty computation parameters.
• MIN_FC_INVOICE_AMOUNT, MIN_INTEREST_CHARGE, MAX_INTEREST_CHARGE — Thresholds that gate whether interest is applied.
• ORG_ID — Multi-org operating unit identifier.
• PROCESS_STATUS, PROCESS_MESSAGE, REQUEST_ID — Processing state and concurrent request context.
• LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER — Standard audit/WHO and optimistic-locking columns.

Common Use Cases and Queries

Typical reporting extracts late charge runs by customer, currency, or batch, and reconciles generated documents back to header definitions.

• Headers by batch: SELECT interest_header_id, customer_id, header_type, currency_code FROM ar_interest_headers_all WHERE interest_batch_id = :batch_id;
• Headers by customer: join CUSTOMER_ID to HZ_CUST_ACCOUNTS_ALL to trace interest documents per customer.
• Processing status monitoring: filter on PROCESS_STATUS and REQUEST_ID to audit a concurrent interest run.
• Document reconciliation: join INTEREST_HEADER_ID to RA_CUSTOMER_TRX_ALL.INTEREST_HEADER_ID to match header definitions to the receivable documents actually created.
• Calculation-rule reporting: report INTEREST_RATE, PENALTY_RATE, and MIN/MAX thresholds to document the rules applied in each run.

Related Objects

The table participates in an extensive parent/child network:

• RA_INTEREST_BATCHES_ALL — parent batch via INTEREST_BATCH_ID.
• AR_INTEREST_LINES_ALL — child lines referencing INTEREST_HEADER_ID.
• RA_CUSTOMER_TRX_ALL — receivable transactions created from a header via INTEREST_HEADER_ID.
• HZ_CUST_ACCOUNTS_ALL / HZ_CUST_SITE_USES_ALL — customer and site via CUSTOMER_ID and CUSTOMER_SITE_USE_ID.
• AR_COLLECTORS, FV_LEGAL_ENTITIES, CE_INTEREST_SCHEDULES, HZ_CUST_PROFILE_AMTS — collector, legal entity, interest schedule, and profile amount references.
• RA_CUST_TRX_TYPES_ALL — transaction type via CUST_TRX_TYPE_ID.
• AR_TRX_HEADER_GT, AR_TRX_HEADER_TMP_GT, AR_LATE_CHARGE_DOC_GT — interface/working tables referencing INTEREST_HEADER_ID during late charge processing.