Search Results ra_customer_trx_all




Overview
Explore in AI Chat

Overview

JAI_AR_TRX_CM_T is a transaction-detail table owned by the JA (Asia/Pacific Localizations) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the statutory form (ST form) linkage details that associate an Accounts Receivable credit memo with the invoice (or debit memo) it corrects, refunds, or reverses. In practice, the table functions as a bridge within the localization layer that maps invoice transactions and invoice lines to their corresponding credit memo transactions and lines, while also anchoring each mapping to a statutory form header record. It is populated and consumed primarily by the JA localization credit memo and statutory reporting functionality rather than by core Receivables processing.

From a Data Vault modeling perspective, the mined foreign-key structure suggests this object is best treated as a link table. It carries no descriptive business attributes of its own beyond amounts, numbers, and flags; instead it records relationships between RA_CUSTOMER_TRX_ALL (twice), RA_CUSTOMER_TRX_LINES_ALL (twice), and JAI_CMN_STFORM_HDRS_ALL. The presence of multiple foreign keys pointing at the same parent table is characteristic of a link entity resolving a many-to-many or transactional association.

Key Information Stored

The table contains 16 documented columns. The most significant are:

  • OE_ST_ID — Foreign key to JAI_CMN_STFORM_HDRS_ALL; identifies the statutory form header under which the credit memo mapping is reported.
  • INV_TRX_ID — Foreign key to RA_CUSTOMER_TRX_ALL; the original invoice or debit memo transaction being credited.
  • CM_TRX_ID — Foreign key to RA_CUSTOMER_TRX_ALL; the credit memo transaction applied against the invoice.
  • INV_TRX_LINE_ID — Foreign key to RA_CUSTOMER_TRX_LINES_ALL; the specific invoice line referenced.
  • CM_TRX_LINE_ID — Foreign key to RA_CUSTOMER_TRX_LINES_ALL; the corresponding credit memo line.
  • INV_TRX_NUM and CM_TRX_NUM — Denormalized transaction numbers for the invoice and credit memo, supporting reporting without joins.
  • INV_TARGET_AMT and CM_TARGET_AMT — Target/credit amounts used for statutory form computation and reconciliation.
  • INV_UPDATE_FLAG — Indicator controlling whether the referenced invoice record has been updated through this mapping.
  • OBJECT_VERSION_NUMBER — Optimistic locking column for concurrent DML.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

No standalone surrogate primary key is documented in the metadata; the identifying key is the composite of INV_TRX_ID, CM_TRX_ID, INV_TRX_LINE_ID, CM_TRX_LINE_ID, and OE_ST_ID.

Common Use Cases and Queries

Typical usage centers on statutory reporting and credit memo reconciliation. A common pattern joins the table to RA_CUSTOMER_TRX_ALL twice to retrieve both sides of the credit relationship:

  • Reconciling credit memos against invoices for tax and statutory form submission.
  • Reporting credit memo activity by statutory form (OE_ST_ID) for a period.
  • Auditing which invoice lines were credited and whether the INV_UPDATE_FLAG was set.
  • Validating completeness of localization credit memo mappings before period close.

A representative query joins INV_TRX_ID and CM_TRX_ID to RA_CUSTOMER_TRX_ALL to resolve transaction numbers, and joins OE_ST_ID to JAI_CMN_STFORM_HDRS_ALL to obtain the form context. Because the transaction numbers are also denormalized, simple extracts can avoid the joins where only numbers and amounts are required.

Related Objects

  • RA_CUSTOMER_TRX_ALL — joined on JAI_AR_TRX_CM_T.INV_TRX_ID and JAI_AR_TRX_CM_T.CM_TRX_ID; the primary AR transaction header table.
  • RA_CUSTOMER_TRX_LINES_ALL — joined on JAI_AR_TRX_CM_T.INV_TRX_LINE_ID and JAI_AR_TRX_CM_T.CM_TRX_LINE_ID; AR transaction line detail.
  • JAI_CMN_STFORM_HDRS_ALL — joined on JAI_AR_TRX_CM_T.OE_ST_ID; statutory form headers.
  • JAI_AR_TRX_CM_LINES_T and associated JA localization credit memo objects — sibling tables in the same functional area.
  • AR credit memo APIs — which ultimately create the RA_CUSTOMER_TRX_ALL records this table references.