Search Results ar_interest_headers_pk

Overview

AR_INTEREST_HEADERS_ALL is the Oracle Receivables (AR) transaction table that stores Late Charge headers. A "late charge" in Receivables is the finance charge or interest a business levies on overdue customer invoices, debit memos, and chargebacks. Each row in this table defines a single late charge run: the customer or customer site being charged, the calculation method, the interest and penalty parameters, the currency, and the processing status. Its primary key is AR_INTEREST_HEADERS_PK, defined on INTEREST_HEADER_ID.

The table sits in the AR schema as a central transactional object. In addition to the primary key, a unique index AR_INTEREST_HEADERS_U1 (INTEREST_HEADER_ID) and AR_INTEREST_HEADERS_U2 (INTEREST_BATCH_ID, INTEREST_HEADER_ID) provide business-key candidates. The second index confirms that each late charge header is sequenced within its interest batch. From a Data Vault modeling perspective, this table is hub-leaning: INTEREST_HEADER_ID acts as a durable business key, while many descriptive and calculation attributes arriving from multiple foreign-key relationships behave like satellite and link content. The heuristic classification should be treated as a suggestion rather than a prescriptive model.

Key Information Stored

The 55 documented columns group into identification, calculation, and audit families. The most important are:

• INTEREST_HEADER_ID — surrogate primary key; the surrogate identifier for a late charge header.
• INTEREST_BATCH_ID — foreign key to AR_INTEREST_BATCHES_ALL; groups headers into a single late charge run.
• CUSTOMER_ID and CUSTOMER_SITE_USE_ID — the party and site use being charged.
• CURRENCY_CODE, EXCHANGE_RATE, EXCHANGE_RATE_TYPE — currency and conversion context for multi-currency late charges.
• INTEREST_RATE, INTEREST_FIXED_AMOUNT, INTEREST_TYPE — the primary interest computation parameters.
• PENALTY_RATE, PENALTY_FIXED_AMOUNT, PENALTY_TYPE — penalty computation parameters.
• CHARGE_BEGIN_DATE, FINANCE_CHARGE_DATE, LAST_ACCRUE_CHARGE_DATE — date anchors for accrual and posting.
• PAYMENT_GRACE_DAYS, INTEREST_PERIOD_DAYS, INTEREST_CALCULATION_PERIOD — timing rules that govern the charge.
• MIN_INTEREST_CHARGE, MAX_INTEREST_CHARGE — bounds applied to the calculated charge.
• PROCESS_STATUS and PROCESS_MESSAGE — workflow state and error text from the late charge program.
• LEGAL_ENTITY_ID, ORG_ID — legal entity and operating unit context.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, OBJECT_VERSION_NUMBER — standard audit and concurrency columns.

Business-key candidates are documented as the unique indexes on INTEREST_HEADER_ID and on (INTEREST_BATCH_ID, INTEREST_HEADER_ID), which should be preferred over surrogate values when de-duplicating source data.

Common Use Cases and Queries

Receivables reporting on late charge activity frequently begins with this table. A typical query joins headers to batches and lines to summarize charges by customer and period:

• Identifying overdue late charges by status: SELECT interest_header_id, customer_id, currency_code, process_status FROM ar_interest_headers_all WHERE process_status = 'ERROR';
• Aggregating charged invoices for a batch: join AR_INTEREST_LINES_ALL on INTEREST_HEADER_ID to total charges per header.
• Reconciling to transactions: join RA_CUSTOMER_TRX_ALL on INTEREST_HEADER_ID to find invoices that generated or received a late charge.
• Multi-currency analysis: group by CURRENCY_CODE and EXCHANGE_RATE_TYPE to review foreign currency late charge exposure.
• Auditing accrual timing: filter on CHARGE_BEGIN_DATE, FINANCE_CHARGE_DATE, and LAST_ACCRUE_CHARGE_DATE.

Related Objects

The following objects are most significant, based on the documented foreign-key relationships:

• AR_INTEREST_BATCHES_ALL — parent batch referenced by INTEREST_BATCH_ID.
• RA_CUSTOMER_TRX_ALL — referenced by INTEREST_HEADER_ID and also referencing this table; links late charges to transactions.
• AR_INTEREST_LINES_ALL — detail lines referencing INTEREST_HEADER_ID.
• HZ_CUST_PROFILE_AMTS — customer profile amounts via CUST_ACCT_PROFILE_AMT_ID.
• CE_INTEREST_SCHEDULES — interest schedule via INTEREST_SCHEDULE_ID.
• RA_CUST_TRX_TYPES_ALL — transaction type via CUST_TRX_TYPE_ID.
• AR_COLLECTORS and FV_LEGAL_ENTITIES — collector and legal entity context.
• AR_LATE_CHARGE_DOC_GT, AR_TRX_HEADER_GT, and AR_TRX_HEADER_TMP_GT — global temporary staging tables referencing INTEREST_HEADER_ID.