Search Results ar_receivables_trx_all

Overview

The table JL_BR_AR_REC_MET_ACCTS_EXT_ALL is a core data object within the Oracle E-Business Suite Latin America Localizations module, specifically for Brazil (JL.BR). It functions as an extension table to the standard Receivables receipt method accounts setup, storing localization-specific accounting and processing rules required for Brazilian legal and fiscal compliance. Its primary role is to augment the standard AR_RECEIPT_METHOD_ACCOUNTS_ALL table with additional attributes necessary for managing complex financial instruments, interest calculations, abatements, and factoring operations unique to the Brazilian market in both EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure centers on linking a receipt method and a bank account use (its composite primary key) to specialized accounting flexfields and transaction types. Key columns include BANK_ACCT_USE_ID and RECEIPT_METHOD_ID, which form the primary key. Critical extension columns store Code Combination IDs (CCIDs) for specific accounting charges, such as INTEREST_REVENUE_CCID, BANK_CHARGES_CCID, and FACTORING_DOCS_CCID. Furthermore, it holds references to specific Receivables Transaction types (via *_RECTRX_ID columns) for calculated interest, interest write-off, abatement, and revenue recognition. A significant functional link is established through FACTOR_FORMAT_PGM_ID and COLL_FORMAT_PGM_ID, which foreign key to AP_PAYMENT_PROGRAMS, connecting receipt methods to specific payment formats for factoring and collection processes.

Common Use Cases and Queries

This table is essential for configuring and reporting on Brazilian-compliant cash management and receivables operations. Common use cases include the setup of factoring arrangements, the automatic calculation and posting of interest on overdue invoices, and the handling of bank collection endorsements. A typical diagnostic query would join this extension table to its parent to verify the complete setup for a given receipt method.

• Sample Query: SELECT rm.name receipt_method, ext.* FROM jl_br_ar_rec_met_accts_ext_all ext, ar_receipt_methods rm, ar_receipt_method_accounts_all rma WHERE ext.receipt_method_id = rma.receipt_method_id AND ext.bank_acct_use_id = rma.bank_acct_use_id AND rm.receipt_method_id = rma.receipt_method_id AND rm.name = '<METHOD_NAME>';
• Reporting Use Case: Generating a report that lists all receipt methods with their associated Brazilian-specific interest revenue and write-off accounts, often required for audit or GL reconciliation purposes.

Related Objects

The table maintains extensive foreign key relationships, integrating tightly with standard EBS financial modules. Key documented relationships include:

• AR_RECEIPT_METHOD_ACCOUNTS_ALL: The core parent table, joined via BANK_ACCT_USE_ID and RECEIPT_METHOD_ID.
• CE_BANK_ACCT_USES_ALL: For bank account details, joined via BANK_ACCT_USE_ID.
• GL_CODE_COMBINATIONS: For multiple accounting flexfields (e.g., INTEREST_REVENUE_CCID, BANK_CHARGES_CCID).
• AR_RECEIVABLES_TRX_ALL: For various transaction type definitions (e.g., CALCULATED_INTEREST_RECTRX_ID, ABATEMENT_WRITEOFF_RECTRX_ID).
• AP_PAYMENT_PROGRAMS: A critical link for payment formatting, joined via FACTOR_FORMAT_PGM_ID and COLL_FORMAT_PGM_ID, directly relevant to the user's search context.
• AR_BATCH_SOURCES_ALL: Joined via BATCH_SOURCE_ID for transaction batch control.