Search Results ar_br_trx_batch_rpt

Overview

The AR_BR_TRX_BATCH_RPT table is a report-specific data structure within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by the Receivables (AR) module. Its primary role is to serve as a staging or reporting table for the Automatic Transaction Batch report. This indicates it is not a core transactional table but is populated during report generation to temporarily hold formatted or aggregated data for display and analysis. The "BR" in its name strongly suggests a functional link to Brazil-specific localizations, implying the report handles transaction batches compliant with Brazilian regulatory or business requirements, such as those related to electronic invoicing or payment processing.

Key Information Stored

While the provided metadata does not list specific columns, the documented foreign key relationships reveal critical data points stored in this table. The table holds identifiers that link to key customer and site information, specifically for the drawee (the party obligated to pay). The column DRAWEE_CONTACT_ID stores a foreign key to HZ_CUST_ACCOUNT_ROLES, identifying the specific contact person for the drawee customer. The column DRAWEE_SITE_USE_ID stores a foreign key to HZ_CUST_SITE_USES_ALL, identifying the specific business purpose (e.g., Bill-To, Ship-To) and location of the drawee. Other columns likely include batch identifiers, transaction summaries, totals, statuses, and dates pertinent to the batch report's output.

Common Use Cases and Queries

The primary use case is generating the Automatic Transaction Batch report for Brazilian operations. This report would provide a consolidated view of transaction batches, likely for validation, reconciliation, or submission purposes. A system process populates this table when the report is requested. Common queries would involve joining to customer tables to enrich the drawee information. A typical reporting pattern might be:

Extracting a complete batch report by a specific batch ID or date range.
Validating drawee details before batch submission by joining to the HZ (Trading Community Architecture) tables.
Analyzing batch totals and statuses directly from this aggregated data store.

Sample SQL would focus on selecting from this table and joining to HZ_CUST_ACCOUNT_ROLES and HZ_CUST_SITE_USES_ALL to resolve contact and site use details.

Related Objects

The table has defined foreign key relationships with two core Trading Community Architecture (TCA) tables, which are essential for resolving customer information.

HZ_CUST_ACCOUNT_ROLES: Joined via the AR_BR_TRX_BATCH_RPT.DRAWEE_CONTACT_ID column. This relationship retrieves detailed contact role information for the drawee.
HZ_CUST_SITE_USES_ALL: Joined via the AR_BR_TRX_BATCH_RPT.DRAWEE_SITE_USE_ID column. This relationship retrieves the specific site use (e.g., billing address) details for the drawee customer account.

As a report table, it is likely populated by a concurrent program or PL/SQL package specific to the Brazilian Automatic Transaction Batch reporting functionality.

Table: AR_BR_TRX_BATCH_RPT 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_BR_TRX_BATCH_RPT, object_name:AR_BR_TRX_BATCH_RPT, status:VALID, product: AR - Receivables , description: Report table for the Automatic Transaction Batch report , implementation_dba_data: AR.AR_BR_TRX_BATCH_RPT ,
Table: AR_BR_TRX_BATCH_RPT 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_BR_TRX_BATCH_RPT, object_name:AR_BR_TRX_BATCH_RPT, status:VALID, product: AR - Receivables , description: Report table for the Automatic Transaction Batch report , implementation_dba_data: AR.AR_BR_TRX_BATCH_RPT ,
Table: HZ_CUST_ACCOUNT_ROLES 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_ACCOUNT_ROLES, object_name:HZ_CUST_ACCOUNT_ROLES, status:VALID, product: AR - Receivables , description: Roles that parties perform in customer accounts , implementation_dba_data: AR.HZ_CUST_ACCOUNT_ROLES ,
Table: HZ_CUST_ACCOUNT_ROLES 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_ACCOUNT_ROLES, object_name:HZ_CUST_ACCOUNT_ROLES, status:VALID, product: AR - Receivables , description: Roles that parties perform in customer accounts , implementation_dba_data: AR.HZ_CUST_ACCOUNT_ROLES ,
Table: HZ_CUST_SITE_USES_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_SITE_USES_ALL, object_name:HZ_CUST_SITE_USES_ALL, status:VALID, product: AR - Receivables , description: Stores business purposes assigned to customer account sites. , implementation_dba_data: AR.HZ_CUST_SITE_USES_ALL ,
Table: HZ_CUST_SITE_USES_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_SITE_USES_ALL, object_name:HZ_CUST_SITE_USES_ALL, status:VALID, product: AR - Receivables , description: Stores business purposes assigned to customer account sites. , implementation_dba_data: AR.HZ_CUST_SITE_USES_ALL ,