Search Results submit_accruals




Overview

OKL_GENERATE_ACCRUALS_PUB is the public API package body for accrual generation within the Oracle Lease and Finance Management (OLFM/OKL) module of Oracle E-Business Suite, Release 12.1.1 and 12.2.2. It resides in the APPS schema with VALID status and is classified as a PUB (public) API, meaning it is the externally callable interface exposed to forms, concurrent programs, and custom integrations. The package orchestrates the accrual lifecycle for lease and finance contracts: it validates accrual rules, calculates contract receivables, submits accrual runs, processes catch-up accruals, and performs reversal and acceleration operations against lease contracts.

The body delegates substantive processing logic to its private companion package OKL_GENERATE_ACCRUALS_PVT, while relying on OKL_API, OKC_API, FND_API, and FND_MSG_PUB for the standard EBS API framework behaviors — message handling, error stacking, and consistent return-status conventions. Accrual generation determines the revenue or interest amounts earned on lease contracts over an accounting period and produces the corresponding accounting entries for subledger processing.

Key Procedures and Functions

  • SUBMIT_ACCRUALS — Primary entry point that drives an accrual run for the requested contract population, coordinating validation, calculation, and downstream accounting generation.
  • CALCULATE_CNTRCT_REC — Computes the contract receivable amounts that form the basis of the accrual calculation for a given lease contract.
  • VALIDATE_ACCRUAL_RULE — Verifies that the accrual rule associated with the contract is eligible and correctly configured before accrual processing proceeds.
  • CATCHUP_ACCRUALS — Processes accruals that were not generated in prior periods, bringing the contract current for missed or delayed accrual cycles.
  • REVERSE_ACCRUALS — Reverses accruals previously generated for a specific period or contract, restoring the accounting to its pre-accrual state.
  • REVERSE_ALL_ACCRUALS — Performs a bulk reversal across all applicable accrual records, typically used for contract-level or full-population corrections.
  • ACCELERATE_ACCRUALS — Brings forward future accrual amounts, commonly invoked upon contract termination or early payoff so that remaining income is recognized immediately.

Tables Accessed

Through APPS synonyms, the package body touches the following documented tables:

  • OKC_K_HEADERS_B — The core contract header base table shared across the Oracle Contracts (OKC) schema, read to resolve contract identity and status.
  • OKL_K_HEADERS — The OKL-specific contract header table holding lease attributes, accrual rule references, and contract dates used by the calculation and validation routines.
  • OKL_TRX_CONTRACTS — The transaction-to-contract association table, used to determine which transactions and contracts participate in the accrual run.

Related dependencies include the packages OKL_TRX_CONTRACTS_PUB, used for transaction-contract relationships. No database objects reference OKL_GENERATE_ACCRUALS_PUB, though six other packages invoke it.

Usage Notes

The package is typically invoked from the OLFM accrual generation concurrent program, from lease contract forms where accrual or termination actions are initiated, and from custom PL/SQL integrations that require programmatic accrual processing. Because the package conforms to the standard FND_API return-status and message-stack pattern, callers should inspect the returned status and extract messages via FND_MSG_PUB rather than relying on exceptions. Reversal and acceleration operations should be sequenced carefully relative to catch-up processing to avoid double recognition of revenue. All procedures execute against the APPS schema, and calling users require the appropriate OLFM responsibility and data security grants.