Search Results p_format_option

Overview

APPS.AR_BR_FORMAT_WRAPPER_PKG is a wrapper package in the Oracle E-Business Suite Receivables (AR) module that orchestrates the submission of format programs for Bill of Remittance (BR) processing. Its primary business function is to identify the correct payment format program associated with customer transaction types and then submit those programs as concurrent requests to generate the appropriate output layouts — such as bank transfer files, lockbox formats, or remittance advice formats. The package acts as a dispatch layer rather than a formatting engine itself: it resolves which format program to run based on the context of the BR transaction data, and delegates actual formatting work to the identified concurrent program.

The package is registered under the APPS schema with an API classification of OTHER, indicating it is not a public, supported open API but an internal utility invoked by Oracle's own concurrent program or form logic. The header check-in date (2006) confirms its lineage in the Receivables codebase that remains relevant through EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package body exposes a single documented procedure:

• SUBMIT_FORMATS — The core entry point. It accepts a format type, a BR identifier, an optional amount range, and a set of books identifier, then evaluates the supplied format option to determine the correct processing path. Internally it uses declared cursors to resolve the format program in three distinct scenarios: BR batches, remittance batches, and individual BRs. Based on the parameter value (for example, "BR BATCH"), the procedure iterates over the matching format programs and submits each as a concurrent request. It also retrieves the operating unit (org_id) from the current concurrent request so that downstream programs execute in the correct organization context.

The user search term p_format_option corresponds to the format-selection parameter of this procedure. The internal variable v_format is assigned from the incoming format argument and drives the conditional branching that selects between the BR batch, remittance, and individual BR cursors. No additional public functions or procedures are documented beyond SUBMIT_FORMATS.

Tables Accessed

• AP_PAYMENT_PROGRAMS — Supplies the program name for each format program, joined to transaction types through FORMAT_PROGRAM_ID.
• RA_CUST_TRX_TYPES_ALL — Provides the linkage between transaction types and their assigned format program, defining which program should run for a given BR.
• RA_CUSTOMER_TRX — Identifies the transactions belonging to the target BR batch or individual BR, filtering the applicable programs.
• AR_PAYMENT_SCHEDULES — Used in the remittance path, where RESERVED_TYPE and RESERVED_VALUE identify remittance batches.
• FND_CONCURRENT_REQUESTS — Read to derive the current request's org_id, ensuring the submitted format program runs under the correct operating unit.

Usage Notes

SUBMIT_FORMATS is typically invoked from Oracle's BR processing flows — either through a Receivables form action or an existing concurrent program that processes Bills of Remittance. It is not intended for direct customer invocation, given its OTHER classification. Because the procedure calls FND_REQUEST.SET_ORG_ID and submits child requests, it must execute within an active concurrent request context where CONC_REQUEST_ID is populated. Customizations should treat it as an internal dependency and avoid direct calls, instead invoking the standard BR submission interface that Oracle supports.