Search Results jl_br_ar_borderos_all




Overview
Explore in AI Chat

Overview

The table JL_BR_AR_BORDEROS_ALL is a core data object within the Oracle E-Business Suite Latin America Localizations module, specifically designed for the Brazilian market. It serves as the master repository for storing header-level information for bank transfer batches, known as "Borderôs." A Borderô is a critical financial instrument in Brazil, representing a batch of receivables (such as invoices or promissory notes) that a company submits to a bank for collection or discounting. This table is central to the automation and management of these bulk financial transactions within the localized Brazilian AR (Accounts Receivable) processes in releases 12.1.1 and 12.2.2. As an "ALL" table, it is multi-organization enabled, meaning it stores data for all operating units accessible to a user, with a corresponding "ORG_ID" column to partition the data.

Key Information Stored

While the provided metadata does not list individual columns, the primary and foreign key relationships define the essential data points stored. The primary key, BORDERO_ID, uniquely identifies each batch. The table stores critical foreign key references that define the batch's context: the SELECT_ACCOUNT_ID links to the selection criteria (JL_BR_AR_SELECT_ACCOUNTS_ALL), the BANK_ACCOUNT_ID and BANK_ACCT_USE_ID identify the specific bank account involved (via AP_BANK_ACCOUNTS_ALL and CE_BANK_ACCT_USES_ALL), and the SELECTION_CONTROL_ID ties to the control parameters for the transaction creation (JL_BR_AR_SELECT_CONTROLS_ALL). Typical data would also include batch creation date, status, total amount, currency, and relevant bank submission details.

Common Use Cases and Queries

This table is primarily used for tracking and reporting on the lifecycle of bank transfer batches. Common operational reports include listing all Borderôs created within a date range for a specific operating unit, checking the status of a particular batch, or reconciling batches sent to the bank. A typical query would join to related tables to provide a comprehensive view. For example, to list active batches with their associated bank account:

  • SELECT b.bordero_id, b.creation_date, aba.bank_account_name, b.status
  • FROM jl_br_ar_borderos_all b,
  • ap_bank_accounts_all aba
  • WHERE b.bank_account_id = aba.bank_account_id
  • AND b.org_id = :p_org_id
  • AND b.status = 'SUBMITTED';

Technical consultants also query this table when debugging batch creation issues or integrating with external banking systems.

Related Objects

JL_BR_AR_BORDEROS_ALL is a central hub with defined relationships to several key localization tables, as documented in the foreign key metadata:

  • Parent/Reference Tables: It references JL_BR_AR_SELECT_ACCOUNTS_ALL (via SELECT_ACCOUNT_ID), AP_BANK_ACCOUNTS_ALL (via BANK_ACCOUNT_ID), JL_BR_AR_SELECT_CONTROLS_ALL (via SELECTION_CONTROL_ID), and CE_BANK_ACCT_USES_ALL (via BANK_ACCT_USE_ID).
  • Child/Dependent Tables: It is referenced as a parent by:

These relationships form the complete data model for managing Brazilian Borderô transactions from creation through to bank remittance and settlement.