Search Results jl_br_ar_select_controls_all




Overview
Explore in AI Chat

Overview

The table JL_BR_AR_SELECT_CONTROLS_ALL is a core data object within the Oracle E-Business Suite Latin America Localizations module, specifically designed for the Brazilian market. It functions as the master definition table for selection criteria used to identify and group customer invoices destined for bank transfer batches, commonly known as "Borderôs." This table is central to automating the process of creating electronic payment files that comply with Brazilian banking regulations, enabling efficient mass payment processing from Accounts Receivable.

Key Information Stored

The table stores configuration parameters that define the rules for invoice selection. Its primary key is SELECTION_CONTROL_ID, which uniquely identifies each set of criteria. A critical foreign key is CUST_TRX_TYPE_ID, which links to RA_CUST_TRX_TYPES_ALL, allowing the control rule to be associated with specific transaction types (e.g., specific invoice categories). While the full column list is not detailed in the provided metadata, typical columns in such a control table would include fields for setting status filters, date ranges (like due date parameters), currency, customer class, and other attributes necessary to dynamically build a batch of payable invoices for bank remittance.

Common Use Cases and Queries

The primary use case is the setup and execution of the Borderô generation process. An administrator defines a selection control, specifying which invoices qualify. This control is then referenced when running the concurrent program to create the bank transfer batch. Common queries involve listing active controls or diagnosing batch inclusion issues.

  • Listing all defined selection controls: SELECT selection_control_id, name, description FROM jl_br_ar_select_controls_all WHERE NVL(org_id, -99) = NVL(FND_PROFILE.VALUE('ORG_ID'), -99);
  • Finding controls for a specific transaction type: SELECT s.* FROM jl_br_ar_select_controls_all s, ra_cust_trx_types_all t WHERE s.cust_trx_type_id = t.cust_trx_type_id AND t.name = 'STANDARD INVOICE';

Related Objects

This table sits at the center of a key functional flow and has defined relationships with several other localization tables.

  • RA_CUST_TRX_TYPES_ALL: Linked via CUST_TRX_TYPE_ID, this ties the selection criteria to standard Oracle Receivables transaction types.
  • JL_BR_AR_BORDEROS_ALL: This is the main transactional table for created bank batches. It holds a foreign key (SELECTION_CONTROL_ID) back to this controls table, recording which rule was used to generate each Borderô.
  • JL_BR_AR_SELECT_ACCOUNTS_ALL: Likely stores specific bank account assignments or further filtering rules at the account level, subordinate to a master selection control.