Search Results jl_br_ar_select_accounts_all




Overview
Explore in AI Chat

Overview

The JL_BR_AR_SELECT_ACCOUNTS_ALL table is a core data object within the Oracle E-Business Suite Latin America Localizations module (JL), specifically designed for the Brazilian market. It functions as a configuration table that defines bank account distribution criteria for generating Bank Transfer batches. This table is essential for automating the selection of appropriate bank accounts when creating payment batches for customer receipts, a process often mandated by Brazilian fiscal and banking regulations. Its role is to link high-level batch source controls with specific, operational bank accounts and their uses, ensuring compliant and accurate financial transactions.

Key Information Stored

The table stores the rules that map selection controls to specific financial instruments. While the full column list is not provided in the excerpt, the foreign key relationships reveal its critical data points. The primary key, SELECT_ACCOUNT_ID, uniquely identifies each distribution rule. The table's central function is established through its foreign keys: it stores a SELECTION_CONTROL_ID linking to JL_BR_AR_SELECT_CONTROLS_ALL, a BATCH_SOURCE_ID linking to AR_BATCH_SOURCES_ALL, and identifiers for both the bank account (BANK_ACCOUNT_ID to AP_BANK_ACCOUNTS_ALL) and its specific use (BANK_ACCT_USE_ID to CE_BANK_ACCT_USES_ALL). This structure allows a single control rule to determine the exact bank account to be used for a transaction batch based on its source.

Common Use Cases and Queries

The primary use case is the automated generation of bank transfer documents (borderós) during the receipt application process. A typical query would retrieve the target bank account for a given batch source and selection control to populate a payment batch. For troubleshooting or audit reporting, one might join this table to see all configured account distribution rules.

  • Sample Query to Find Configured Bank Accounts for a Batch Source:
    SELECT jlsa.select_account_id,
    arbs.name batch_source,
    aba.bank_account_name,
    cbau.bank_account_id
    FROM jl_br_ar_select_accounts_all jlsa,
    ar_batch_sources_all arbs,
    ap_bank_accounts_all aba,
    ce_bank_acct_uses_all cbau
    WHERE jlsa.batch_source_id = arbs.batch_source_id
    AND jlsa.bank_account_id = aba.bank_account_id
    AND jlsa.bank_acct_use_id = cbau.bank_acct_use_id
    AND arbs.name = 'Your Batch Source';

Related Objects

This table sits at the intersection of several key EBS modules, as evidenced by its foreign key constraints.

  • Primary Parent: JL_BR_AR_SELECT_CONTROLS_ALL via SELECTION_CONTROL_ID.
  • Receivables Integration: AR_BATCH_SOURCES_ALL via BATCH_SOURCE_ID. This links the localization rule to the standard Receivables transaction source.
  • Cash Management & Payables Integration: AP_BANK_ACCOUNTS_ALL and CE_BANK_ACCT_USES_ALL via BANK_ACCOUNT_ID and BANK_ACCT_USE_ID, respectively. This specifies the exact bank account to be used.
  • Child Tables (Dependents):
    • JL_BR_AR_BORDEROS_ALL uses SELECT_ACCOUNT_ID, indicating the bank transfer documents created inherit this account selection.
    • JL_BR_AR_PAY_SCHED_AUX uses SELECT_ACCOUNT_ID, linking payment schedule auxiliary data to the chosen bank account rule.