Search Results ar_cash_appln_work_queue




Overview
Explore in AI Chat

Overview

APPS.AR_CAO_ASSIGN_PKG is a Receivables (AR) utility package that supports the Cash Application Operations (CAO) processing framework in Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business purpose is to distribute unapplied and on-account cash application work items across a pool of parallel worker processes so that receipt processing can be completed concurrently rather than serially. The package combines request-spawning logic, worker-queue access validation, and query construction helpers into a single body used by the Cash Application Worker Queue infrastructure.

The package belongs to the AR module and is classified as an OTHER API rather than a public open interface. It is not referenced by any other documented package, indicating that it is invoked directly by concurrent programs and the Cash Application Worker Queue page rather than being embedded in a larger dependency chain.

Key Procedures and Functions

  • ASSIGN_WORK_ITEMS — The primary driver routine of the package. It performs the core assignment of cash application work items to processing workers. The source excerpt shows the internal helper spawn_child_requests submitting concurrent requests against the AR application, using the short name ARCAOAB with the description "Assign Cash Application Work Items". Notably, this helper accepts p_receipt_date_from and p_receipt_date_to as VARCHAR2 parameters, which are passed through unchanged to each child request. This confirms that the receipt date range searched by users is a first-class selection criterion of the assignment process.
  • CHECK_ACCESS — A validation function that determines whether a given user may access the Cash Application Worker Queue page. It accepts a user identifier and a validity flag (Y/N) and returns a numeric verdict. When the flag is Y, it verifies that the user currently holds the AR_CASH_APPLN_WORK_QUEUE function, taking into account function grants and responsibility-level exclusions; when N, it checks only whether the user is associated with that function. The function resolves access by traversing the compiled menu, form function, responsibility, and direct user-responsibility tables.

An internal diagnostic helper, write_debug_and_log, writes messages to the concurrent manager log via FND_FILE and to the standard AR debug channel when a concurrent request ID exists.

Tables Accessed

  • AR_CASH_RECEIPTS_ALL — The principal receipt table against which cash application work items are identified, including the receipt date range used for selection.
  • AR_CASH_RECPT_RULE_PARAM_GT — A global temporary table holding cash receipt rule parameters used during assignment evaluation.
  • FUN_RULE_BULK_RESULT_GT — A global temporary table storing bulk rule evaluation results consumed by the assignment logic.
  • FND_RESPONSIBILITY, FND_RESP_FUNCTIONS, FND_COMPILED_MENU_FUNCTIONS, FND_FORM_FUNCTIONS — Oracle Application Object Library tables joined by CHECK_ACCESS to resolve menu, function, and responsibility grants for the worker queue page.
  • HZ_LOCATIONS — The Trading Community location table, consulted for address-related attributes of receipts or customers in the work item selection.
  • DBMS_SQL and PLITBLM — Dynamic SQL and PL/SQL table utilities used to build and execute flexible selection statements.

Usage Notes

This package is invoked in three typical ways. First, the "Assign Cash Application Work Items" concurrent program (short name ARCAOAB) executes ASSIGN_WORK_ITEMS and, through spawn_child_requests, submits parallel child requests equal to the worker count minus one. Second, the Cash Application Worker Queue page calls CHECK_ACCESS to gate user entry to the queue. Third, custom or extension code may call the package when implementing alternative worker distribution schemes.

Because the receipt date range is passed as a VARCHAR2, callers must supply correctly formatted date strings consistent with the session date format used in EBS 12.1.1 and 12.2.2. The parameter is propagated verbatim to every spawned child request, so an incorrectly formatted p_receipt_date_from value will affect all workers simultaneously. The package is shipped under the APPS schema and is not designed for direct modification.