Search Results ra_cust_trx_types_all

Overview

The RA_CUST_TRX_TYPES_ALL table is a core setup and reference table within Oracle E-Business Suite Receivables (AR) in versions 12.1.1 and 12.2.2. It serves as the master repository for all transaction types used across the order-to-cash cycle. As indicated by its description, it defines the characteristics and accounting rules for invoices, commitments, and credit memos. This table is multi-org enabled (signified by the "_ALL" suffix), meaning it stores data specific to each operating unit, which is crucial for deployments with multiple legal entities or business units. Transaction types defined here are fundamental to ensuring proper transaction processing, revenue recognition, and financial reporting.

Key Information Stored

The table's primary key is CUST_TRX_TYPE_ID, which uniquely identifies each transaction type record. Based on the provided foreign key metadata, critical columns include TYPE, NAME, and DESCRIPTION for identification. Crucially, the table stores accounting and control parameters that govern transaction behavior. Key columns include DEFAULT_TERM (linking to RA_TERMS_B), GL_ID_REV, GL_ID_FREIGHT, and GL_ID_REC (linking to GL_CODE_COMBINATIONS for revenue, freight, and receivable accounts), and SET_OF_BOOKS_ID. The metadata also reveals columns for defining relationships between transaction types, such as CREDIT_MEMO_TYPE_ID, SUBSEQUENT_TRX_TYPE_ID, and BR_CUST_TRX_TYPE_ID, which manage links for credit memos, follow-on transactions, and bills receivable, respectively.

Common Use Cases and Queries

This table is central to transaction entry, validation, and reporting. A common use case is validating the setup of a transaction type or listing all types available for an operating unit. For reporting, it is frequently joined to transaction headers (RA_CUSTOMER_TRX_ALL) to provide descriptive type information. The user's search for "jai_cmn_om_ar_ar3_forms" directly correlates to a foreign key relationship from that custom table to RA_CUST_TRX_TYPES_ALL.TRX_TYPE_ID, indicating a localization or extension linking forms to standard AR transaction types.

Sample Query: To retrieve active transaction types with their default accounting segments for a specific operating unit (ORG_ID).

• SELECT rctt.name, rctt.description, gcc_rev.segment1 revenue_account
• FROM ra_cust_trx_types_all rctt,
• gl_code_combinations gcc_rev
• WHERE rctt.gl_id_rev = gcc_rev.code_combination_id
• AND rctt.org_id = 123
• AND rctt.status = 'A';

Related Objects

As evidenced by the extensive foreign key list, RA_CUST_TRX_TYPES_ALL is a foundational object referenced by numerous core and extended tables. Primary transactional dependencies include AR_PAYMENT_SCHEDULES_ALL and AR_CUSTOMER_TRX_ALL (implied). It is referenced by setup tables like AR_SYSTEM_PARAMETERS_ALL (for late charge types) and AR_RECEIPT_METHODS. The metadata also shows integrations with other modules, such as FV_FINANCE_CHARGE_CONTROLS_ALL (Financials for Venezuela) and the custom object from the user's search, JAI_CMN_OM_AR_AR3_FORMS. This wide-ranging integration underscores its critical role in defining and controlling the financial and legal attributes of all Receivables transactions.