Search Results wait_for_end_subreq




Overview
Explore in AI Chat

Overview

AR_CREATE_ACCTING_SRS is an Oracle Receivables (AR) PL/SQL package body owned by the APPS schema, classified as an OTHER API. Its purpose is to drive the mass creation of accounting entries for Receivables transactions through the concurrent manager rather than through interactive forms. The package orchestrates the submission of standard Receivables accounting and revenue recognition concurrent programs across multiple operating units, tracks their completion, and reports status through the concurrent program log and output files.

The package body carries the header ARSACCTB.pls 120.10.12000000.2 dated 2007/08/22, which places it within the code line shared by Oracle E-Business Suite 12.1.1 and 12.2.2. It is a server-side scheduling and exception-handling wrapper around FND_REQUEST.SUBMIT_REQUEST, designed to relieve users of manually launching the Create Accounting program for every ledger and period.

Key Procedures and Functions

The documented ETRM surface exposes a single entry point, SUBMISSION. This procedure is the public driver of the package. It is responsible for reading the set of organizations or ledgers to be processed, submitting the underlying accounting concurrent requests, and monitoring their progress. The remainder of the package body consists of private helpers that support this work, including:

  • log, out, outandlog — formatting utilities that write messages to the concurrent program log file, the report output file, or both simultaneously.
  • logerror — collects messages from the FND message stack and appends the PL/SQL SQLERRM text, returning a consolidated error string for logging.
  • revrec_per_org — submits the Revenue Recognition program ARTERRPM for a specified organization, accepting a report mode, worker count, polling interval, maximum wait, and organization identifier, and returning the submitted request ID. This procedure also calls FND_REQUEST.SET_ORG_ID to establish the correct operating unit context before submission.

The user search term wait_for_end_subreq corresponds to the sub-request waiting logic that such accounting submission wrappers employ: after each child request is submitted, the package must poll FND_CONCURRENT_REQUESTS (or its public views) until the child completes, times out, or fails, so that subsequent processing and error reporting remain deterministic. The p_interval and p_max_wait parameters of revrec_per_org are the visible controls for that polling behavior.

Tables Accessed

  • AR_SUBMISSION_CTRL_GT — a global temporary table used to stage the organization identifiers and control parameters that drive the submission loop.
  • AR_SYSTEM_PARAMETERS_ALL — supplies Receivables system option values per operating unit, such as accounting and revenue recognition settings, needed when deciding how and whether to submit each request.
  • GL_LEDGERS and GL_PERIOD_STATUSES — used to resolve the ledgers and open accounting periods for which accounting must be created.
  • MO_GLOB_ORG_ACCESS_TMP — the standard organization access temporary table that constrains processing to the organization hierarchy accessible to the requesting user.
  • FND_LANGUAGES — referenced for language and installation context information.

Usage Notes

AR_CREATE_ACCTING_SRS is normally invoked from a Receivables concurrent program rather than from a form. Administrators schedule the parent request, which then drives child accounting submissions for each organization in scope. The package is not referenced by other documented packages, indicating it functions as a top-level driver rather than a shared utility.

In 12.1.1 and 12.2.2 the accounting engine is subledger accounting (XLA); the package sets an internal flag (g_xla_run) to indicate the XLA path and tracks an execution status using FND_API.G_RET_STS_SUCCESS. When diagnosing a run, review the concurrent program log, since all messages are written through FND_FILE and errors are aggregated via logerror. Jobs that appear to hang are usually waiting on child sub-requests, a condition governed by the interval and maximum wait settings described above.