Search Results okl_cons_bill




Overview
Explore in AI Chat

Overview

OKL_CONS_BILL is a concurrent program owned by the Oracle Lease and Finance Management (OKL) module. Its user-facing name is Receivables Bills Consolidation, and it is catalogued in Enterprise Territory and Resource Management (ETRM) documentation under product OKL. The program is designed to consolidate bill lines arising within Lease and Finance Management contracts into a combined receivables billing structure, allowing multiple underlying lease or finance charges to be grouped and forwarded for invoicing. This consolidation step is relevant when a lease contract generates several discrete billing lines that must be presented to the customer as a single bill or a reduced set of bills.

A critical documented attribute is that the program is marked Enabled: No in the supplied ETRM metadata for release 12.2.2. Consequently, although the executable and metadata exist in the environment, the concurrent program is not active by default. Administrators must deliberately enable it through the Concurrent Programs setup form before it becomes submittable from the Standard Request Submission (SRS) window.

Execution Details

The documented execution attributes are as follows:

  • Execution Method: PL/SQL Stored Procedure
  • Argument Method: Standard
  • Executable: OKL_CONS_BILL
  • Execution Filename: OKL_CONS_BILL_PUB.CREATE_CONS_BILL
  • Subroutine Name: (not specified in the metadata)

The execution filename identifies the PL/SQL package and procedure invoked at runtime: OKL_CONS_BILL_PUB.CREATE_CONS_BILL. This places the program in the public API layer of OKL, consistent with Oracle's convention of exposing concurrent logic through a _PUB package whose procedure accepts a standard parameter list. Because the execution method is PL/SQL Stored Procedure rather than a hosted SQL*Plus or Java concurrent program, the program runs inside the database session and does not depend on an external execution file on the application tier.

How to Run

Because the Argument Method is Standard, the program is submitted through the standard SRS interface. Users navigate to Requests > Run, select the request name Receivables Bills Consolidation, and supply the displayed parameters before submitting. The exact parameter list is not enumerated in the ETRM excerpt; the standard argument method indicates that parameters are defined against the executable and validated by the concurrent manager before the procedure is called, with the values passed positionally or by token to CREATE_CONS_BILL.

Prerequisite to submission is that the program be enabled by an administrator with the appropriate OKL or system administrator responsibility. Given the documented Enabled flag of No, a fresh 12.1.1 or 12.2.2 installation will not present this request name in the list of available concurrent programs until that configuration step is performed. Typical parameters for a consolidation program of this class would include the operating unit, the lease or contract identifier or range, a bill date or date range, and possibly a customer or bill-to account, but these should be confirmed against the live parameter definition in the Concurrent Programs form rather than assumed.

Related Objects

The program operates within the OKL billing and receivables integration flow. Objects commonly associated with this area include:

  • The OKL public API package OKL_CONS_BILL_PUB, which contains the invoked CREATE_CONS_BILL procedure.
  • Lease and Finance Management contract tables storing bill lines, billing schedules, and contract headers that feed the consolidation.
  • Oracle Receivables interface and billing tables, since consolidated bills are ultimately generated for receivables processing.
  • Sibling OKL billing concurrent programs and reports that manage bill generation, bill presentment, and receivables transfer.

Implementers should review the package specification for OKL_CONS_BILL_PUB to confirm parameter semantics, error handling, and the interface tables affected by each run.