Search Results ar_lockboxes




Overview
Explore in AI Chat

Overview

AR_SUBMIT_LOCKBOX is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports automated bank lockbox processing within Oracle Receivables. Its purpose is to submit the lockbox import concurrent program through the Standard Request Submission (SRS) framework, allowing lockbox transmission data to be read from bank files and applied to customer receipts. In release 12.1.1 and 12.2.2, this package is classified as an OTHER API in ETRM, indicating that it is intended primarily for internal, programmatic use by Oracle's own application logic rather than as a publicly supported extension interface.

Key Procedures and Functions

The ETRM metadata documents a single entry point for this package:

  • SUBMIT_LOCKBOX_VIA_SRS — Submits the lockbox processing request through the Oracle SRS concurrent manager. It orchestrates the submission of the lockbox import program by referencing a lockbox definition and its associated transmission and transmission format records, then invoking the concurrent request using standard submission conventions. No parameter list is documented in the ETRM metadata; consumers should treat the signature as internal and subject to change.

Tables Accessed

AR_SUBMIT_LOCKBOX reads from a set of Receivables configuration and transactional tables, resolved via APPS synonyms:

  • AR_LOCKBOXES — Defines lockbox configurations, including the bank and receipt-matching rules used during import.
  • AR_TRANSMISSIONS — Stores transmission records representing incoming bank lockbox files requiring submission.
  • AR_TRANSMISSION_FORMATS — Provides the format definition associated with each transmission, controlling how records are parsed.
  • AR_SYSTEM_PARAMETERS — Supplies Receivables system-level settings influencing lockbox submission behavior.
  • AR_TRANS_FIELD_FORMATS and AR_TRANS_RECORD_FORMATS — Define field-level and record-level parsing rules for lockbox transmission data.
  • FND_NEW_MESSAGES — Used to retrieve or present user-facing messages during submission and validation.

This package does not reference AR_TRANSMISSION_FORMATS in isolation; it depends on the interrelated set of transmission configuration tables to validate and hand off the request correctly.

Usage Notes

AR_SUBMIT_LOCKBOX is typically invoked when a user or process needs to submit a lockbox transmission for import without directly navigating the SRS form. In a standard EBS deployment, this occurs through the Receivables Lockbox responsibility or through batch automation that identifies unsubmitted transmissions. The package depends on AR_LOCKBOXES, AR_TRANSMISSIONS, and AR_TRANSMISSION_FORMATS, and is referenced by itself in the dependency graph (APPS.AR_SUBMIT_LOCKBOX references and is referenced by APPS.AR_SUBMIT_LOCKBOX), which reflects recursive submission or helper logic within the package body.

Because ETRM reports zero external package references and classifies this as an OTHER API, customizations should not rely on AR_SUBMIT_LOCKBOX as a stable interface. Developers performing diagnostics around "ar_transmissions" should instead inspect the AR_TRANSMISSIONS table and the Lockbox concurrent programs directly. Direct calls are possible through custom concurrent programs or PL/SQL scripts, but Oracle does not document or guarantee the SUBMIT_LOCKBOX_VIA_SRS signature across releases; any use should be validated in a test instance before promotion to production.