Search Results arp_program_generate_br




Overview
Explore in AI Chat

Overview

The APPS.ARP_PROGRAM_GENERATE_BR package is an Oracle E-Business Suite AutoInvoice-related PL/SQL package whose owner is the APPS schema and whose status is VALID across both 12.1.1 and 12.2.2. The "_BR" suffix and the inclusion of Brazil-specific objects such as CE_BANK_BRANCHES_V and AR_BR_TRX_BATCH_RPT indicate this is the Brazilian localization variant used to generate billing and receipt (BR) program files from Oracle Receivables transactional data. Its business purpose is to assemble the payment, receipt, and transaction information held in Receivables and Trading Community Architecture (TCA) tables into the structure required by the Brazilian banking and fiscal reporting programs, then hand that data off to the downstream program generator.

In the documented ETRM record, the package is classified as API classification OTHER and it is referenced by zero other packages, meaning it functions as a top-level, self-contained program rather than a shared library invoked by other PL/SQL units. It is, however, referenced by a package of the same name in the APPS schema, consistent with a package specification and package body pair.

Key Procedures and Functions

Three procedures/functions are documented for this package:

  • AUTO_CREATE_BR_PROGRAM — The primary driver program that performs the automatic creation of the Brazilian billing/receipt program records. It reads the eligible Receivables batches, transactions, and receipt data and generates the corresponding program output.
  • AUTO_CREATE_BR_API — The programmatic entry point for the same auto-creation logic, exposed so the generation can be invoked from custom code or another calling layer rather than only from the concurrent manager. It follows the FND_API convention, as evidenced by the dependency on FND_API.
  • REVISION — A standard revision-tracking function that returns the package version identifier, used for patch-level and support diagnostics.

No parameter lists are documented in the ETRM metadata, and none should be assumed; callers should inspect the package specification in the target instance before direct invocation.

Tables Accessed

Via APPS synonyms, the package reads and writes Receivables, TCA, and setup tables. The core transactional tables are RA_CUSTOMER_TRX, RA_BATCHES, RA_BATCH_SOURCES, RA_CUST_TRX_TYPES, AR_PAYMENT_SCHEDULES, and AR_TRANSACTION_HISTORY. Customer and site information is drawn from HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, and HZ_CUST_SITE_USES. Receipt configuration and classification come from AR_RECEIPT_METHODS and AR_RECEIPT_CLASSES. Selection and system defaults are held in AR_SELECTION_CRITERIA, AR_SYSTEM_PARAMETERS, and AR_LOOKUPS. The Brazil-specific output is written to AR_BR_TRX_BATCH_RPT, and CE_BANK_BRANCHES_V supplies bank branch data. FND_NEW_MESSAGES supports message/error handling, consistent with the FND_API dependency.

Usage Notes

In practice, this package is invoked through a concurrent program (AutoInvoice or a Brazilian localization program) registered against AUTO_CREATE_BR_PROGRAM, typically submitted from the Receivables responsibility menu. It may also be called programmatically through AUTO_CREATE_BR_API by custom localization extensions. Because it touches core AR and TCA tables, testing should be performed in a non-production instance, and because the ETRM record shows no inbound package dependencies, changes to this package have limited blast radius but still affect the Brazilian statutory reporting output.