Search Results ar_receivables_trx_all




The JL_BR_AR_REC_MET_ACCTS_EXT_ALL table is a critical custom extension table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2, specifically designed to support Brazil localization requirements for Accounts Receivable (AR) and Receivables Management. This table stores metadata and accounting-related extensions necessary for compliance with Brazilian fiscal and regulatory standards, particularly for payment methods, tax calculations, and financial reporting.

Purpose and Functional Context

This table extends the functionality of Oracle Receivables by capturing Brazil-specific accounting attributes linked to payment methods and transaction types. It integrates with core EBS modules like AR_PAYMENT_SCHEDULES_ALL, RA_CUSTOMER_TRX_ALL, and GL_CODE_COMBINATIONS to ensure accurate financial postings per Brazilian GAAP. Key use cases include:
  • Mapping payment methods to specific GL accounts for tax liabilities.
  • Storing fiscal classification codes (e.g., COA segments) mandated by Brazilian authorities.
  • Tracking deferred tax accounting rules for installment payments.

Key Columns and Structure

The table typically includes these critical columns:
Column NameData TypeDescription
REC_MET_ACCT_EXT_IDNUMBERPrimary key, sequence-generated.
PAYMENT_METHOD_CODEVARCHAR2Links to AR_RECEIPT_METHODS.
ORG_IDNUMBEROperating Unit identifier (multi-org enabled).
TAX_ACCOUNT_CCIDNUMBERGL combination for tax postings.
FISCAL_CLASSIFICATIONVARCHAR2Brazilian SPED/FISCAL code.
DEFERRED_TAX_FLAGVARCHAR2(1)Y/N indicator for deferred tax treatment.

Integration Points

  1. Tax Engine: Interfaces with Brazil localization tax engines (e.g., JlBrTax) to determine correct tax accounts based on payment method.
  2. GL Posting: During AR invoice validation (RA_CUSTOMER_TRX_ALL), this table provides subsidiary ledger accounts for Brazil-specific entries.
  3. SPED Reporting: Supplies fiscal classification data for EFD Contribuições and ECD reports.

Technical Considerations

  • Multi-Org: Partitioned by ORG_ID to support multiple legal entities.
  • Indexing: Typically indexed on PAYMENT_METHOD_CODE and ORG_ID for performance.
  • Extensions: Often extended via JL_BR_AR_REC_MET_ACCTS_EXT (client-specific customizations).

Implementation Notes

For EBS 12.2.2, this table is part of the "Latin America Localization" patchset (R12.JL.B). Administrators must:
  • Seed data using Brazil-specific Rapid Implementation templates.
  • Validate GL account mappings during payment method setup.
  • Monitor for custom triggers or APIs (e.g., JL_BR_AR_ACCT_EXT_PKG) that may modify table behavior.
This table exemplifies Oracle's approach to localization, where core EBS functionality is extended without modifying standard tables, ensuring upgrade compatibility while meeting regional compliance needs.