Search Results auto_create_remit_program

Overview

ARP_PROGRAM_BR_REMIT is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the creation and assignment of remittance programs in Accounts Receivable. The name and dependency profile indicate that its primary purpose is to automate the association of a remittance banking program with a customer bill-to site use, thereby enabling automatic remittance processing for receipts received through external payment channels. In the context of Oracle EBS 12.1.1 and 12.2.2, remittance is managed through the Payments (IBY) infrastructure, where external payers are configured against payment instruments and transaction operations. ARP_PROGRAM_BR_REMIT bridges that payment infrastructure with the Receivables customer model, resolving the site use and counterparty identifiers required to link an automatic remittance program to a specific customer site. The object is documented with a VALID status and an API classification of OTHER, meaning it is an internal utility rather than a formally published public API, and the documented surface includes two procedures: AUTO_CREATE_REMIT_PROGRAM and GET_SITE_USE_ID.

Key Procedures and Functions

The package exposes two documented procedures or functions:

• AUTO_CREATE_REMIT_PROGRAM — Drives the creation or assignment of a remittance program for the applicable customer and payment context. It builds on the resolved site use and payer information to configure the automatic remittance linkage. This routine is the functional entry point of the package and is the reason the object is referenced by the Bills Creation and Bills Maintenance public packages.
• GET_SITE_USE_ID — Resolves the customer site use identifier for the party, account, or profile combination passed into the calling routine. The site use identifier is the key that ties a remittance program to a specific bill-to or remit-to location on a customer record, and it is consumed directly by AUTO_CREATE_REMIT_PROGRAM. Both routines are executed with the privileges of the APPS schema and rely on the STANDARD package supplied by SYS for their base PL/SQL runtime behavior.

Tables Accessed

The documented table references reflect the package's role in reconciling receivables transactions with the payment and remittance infrastructure:

• HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_ORGANIZATION_PROFILES — provide the trading party, customer account, and organization profile context used to derive the correct site use.
• IBY_EXTERNAL_PAYERS_ALL, IBY_PMT_INSTR_USES_ALL, IBY_FNDCPT_TX_OPERATIONS, IBY_TRXN_SUMMARIES_ALL — the Payments foundation tables that define external payers, payment instrument usage, funds capture transaction operations, and transaction summaries.
• CE_BANK_ACCOUNTS and AP_PAYMENT_PROGRAMS — supply the bank account and payment program definition against which the remittance program is configured.
• AR_BATCHES, AR_PAYMENT_SCHEDULES, AR_TRANSACTION_HISTORY, AR_SYSTEM_PARAMETERS, RA_CUSTOMER_TRX, RA_CUST_TRX_TYPES — the Receivables transactional and setup tables that determine which transactions and transaction types are eligible for the automatic remittance program.

Usage Notes

ARP_PROGRAM_BR_REMIT is not an end-user-facing API. It is invoked indirectly by the Bills Creation and Bills Maintenance public packages (AR_BILLS_CREATION_PUB and AR_BILLS_MAINTAIN_PUB), which reference it during the bill creation and maintenance flows. Administrators typically encounter its effects when configuring automatic remittance for customers whose receipts are processed through external payers or funds capture operations. Because the package is classified as OTHER and is undocumented in the standard public API listings, custom development should not call its routines directly; integrations should instead use the referencing public packages. When troubleshooting remittance program assignment, verify the customer site use resolution path and the IBY external payer configuration, as these are the inputs on which the package depends.