Search Results ar_llca_adj_trx_lines_gt




Overview
Explore in AI Chat

Overview

AR_LLCA_ADJ_TRX_LINES_GT is a table owned by the AR (Receivables) schema in Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. The suffix _GT designates it as a global temporary table within the Receivables architecture, meaning its rows are session-scoped and typically populated, consumed, and purged within the lifecycle of a single concurrent program or online transaction. In Oracle EBS, such global temporary tables act as transient staging structures rather than permanent stores of record.

Functionally, the object supports the adjustment of transaction lines associated with low-level lease/customer adjustments (LLCA) in Receivables. Its narrow four-column projection—transaction header, transaction line, receivables activity, and line amount—indicates it is used to stage line-level adjustment candidates prior to validation and posting against the base transaction tables. From a Data Vault modeling perspective, the heuristic classification is standalone, and the mined FK line from RECEIVABLES_TRX_ID toward AR_RECEIVABLES_TRX_ALL suggests the nearest warehouse analogue is a lightweight transaction link rather than a hub or satellite; however, as a staging global temporary table, the object carries no true business-key identity beyond its four attributes.

Key Information Stored

The documented physical schema for 12.2.2 exposes four columns, with a single unique index, AR_LLCA_ADJ_TRX_LINES_U1, defined on CUSTOMER_TRX_LINE_ID. This index identifies the line ID as the closest documented surrogate/business-key candidate, while CUSTOMER_TRX_ID supplies the parent header context.

  • CUSTOMER_TRX_ID — Reference to the transaction header (RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID) that owns the line being adjusted.
  • CUSTOMER_TRX_LINE_ID — The transaction line identifier; documented as the unique-key candidate via AR_LLCA_ADJ_TRX_LINES_U1.
  • RECEIVABLES_TRX_ID — The Receivables activity applied by the adjustment; the sole documented FK, referencing AR_RECEIVABLES_TRX_ALL.
  • LINE_AMOUNT — The monetary amount to be applied against the line within the staging context.

Because the object is a global temporary table, no permanent row retention should be assumed; persist any results into a durable table or interface before session termination.

Common Use Cases and Queries

Typical usage falls into staging, validation, and reconciliation patterns executed by Receivables adjustment or AutoInvoice-adjacent programs. Representative queries:

  • Staging overview — SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID, RECEIVABLES_TRX_ID, LINE_AMOUNT FROM AR_LLCA_ADJ_TRX_LINES_GT; executed within the owning session to inspect pending adjustments.
  • Activity lookup — join to AR_RECEIVABLES_TRX_ALL on RECEIVABLES_TRX_ID to retrieve the receivables activity name and type for each staged line.
  • Header/line reconciliation — join to RA_CUSTOMER_TRX_ALL and RA_CUSTOMER_TRX_LINES_ALL on CUSTOMER_TRX_ID and CUSTOMER_TRX_LINE_ID to compare staged amounts against current line balances.
  • Aggregation for posting checks — SELECT CUSTOMER_TRX_ID, SUM(LINE_AMOUNT) FROM AR_LLCA_ADJ_TRX_LINES_GT GROUP BY CUSTOMER_TRX_ID; to verify the net adjustment before commit.
  • Duplicate detection — use AR_LLCA_ADJ_TRX_LINES_U1 on CUSTOMER_TRX_LINE_ID to confirm that each line appears only once in the staging set.

Related Objects

  • AR_RECEIVABLES_TRX_ALL — Referenced by the documented FK RECEIVABLES_TRX_ID; supplies the receivables activity definition for each staged adjustment.
  • RA_CUSTOMER_TRX_ALL — Transaction header source for CUSTOMER_TRX_ID; required for header-level context and reconciliation.
  • RA_CUSTOMER_TRX_LINES_ALL — Transaction line source for CUSTOMER_TRX_LINE_ID; the base line being adjusted.
  • AR_ADJUSTMENTS_ALL — The persistent adjustment table where approved staging rows ultimately influence posted adjustments.
  • PL/SQL adjustment APIs (e.g., AR_ADJUST_PUB) and Receivables concurrent programs that populate and consume this _GT structure during processing.