Search Results ar_activity_details




Overview
Explore in AI Chat

Overview

AR_ACTIVITY_DETAILS is a Receivables (AR) module table that stores line-level detail for receivable activities. In Oracle EBS 12.1.1 and 12.2.2, it is owned by the AR schema and is documented with 48 columns. The table captures the individual components that make up an activity applied against a transaction line — for example, cash receipt applications with the amount, tax, freight, charges, and discount portions recorded separately. Its primary key is AR_ACTIVITY_DETAILS_PK, defined on the LINE_ID column, and a unique index AR_ACTIVITY_DETAILS_U1 (LINE_ID) confirms LINE_ID as the business-key candidate. Based on the FK structure mined into the metadata, the object is classified heuristically as standalone; as a modeling suggestion, this positions it as neither a pure hub nor link, but rather a transactional/satellite-style detail table dependent on other AR entities through logical rather than enforced foreign keys.

Key Information Stored

The surrogate primary key is LINE_ID, which uniquely identifies each activity detail row. The most significant business columns include:

Common Use Cases and Queries

AR_ACTIVITY_DETAILS is primarily queried for reconciliation and reporting of cash receipt applications. A common pattern joins receipt details to transaction lines to explain how a receipt was applied across tax, freight, and charges:

SELECT a.line_id, a.cash_receipt_id, a.customer_trx_line_id,
       a.amount, a.tax, a.freight, a.charges,
       a.line_discount, a.line_balance, a.current_activity_flag
FROM   ar.ar_activity_details a
WHERE  a.cash_receipt_id = :receipt_id;

Reporting use cases include unapplied or on-account receipt analysis, discount and adjustment reporting, balance trending by transaction line, and audit queries filtered on CURRENT_ACTIVITY_FLAG to isolate the effective activity row. The SOURCE_ID and SOURCE_TABLE columns support lineage tracing back to originating activity records.

Related Objects

The metadata documents AR_ACTIVITY_DETAILS as standalone (no enforced foreign keys in the mined structure), but it logically references key AR objects through its identifier columns:

These relationships make the table a central reference for tracing how receipt amounts, discounts, and component charges are distributed at the transaction-line level within Receivables.