Search Results okl_cure_refunds_all




Overview
Explore in AI Chat

Overview

OKL_CURE_REFUNDS_ALL is a transactional table in the OKL (Lease and Finance Management) schema within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store refunds made to a vendor for cured contracts. The cure refund pool is maintained per contract, and a single refund record groups all cash received by the vendor against one contract ID. This makes the table a central repository for tracking amounts owed back to, or received from, lessees or vendors when a delinquent contract is brought back into good standing (cured).

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is standalone. In practice this suggests the table behaves as a satellite-like detail store hanging off cure refund header and stage parents, rather than acting as an independent hub or a link between two business keys. All refinements to the record are captured through standard WHO columns (CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE), and concurrency is managed via OBJECT_VERSION_NUMBER.

Key Information Stored

The table contains 44 documented columns. The most operationally significant are:

Common Use Cases and Queries

Typical reporting scenarios include reconciling cure refunds to the general ledger, tracking outstanding balances owed to vendors, and auditing refunds by contract or operating unit. A common query joins the header and stage parents:

SELECT r.REFUND_NUMBER, r.CHR_ID, r.TOTAL_REFUND_DUE, r.RECEIVED_AMOUNT, r.BALANCE, r.STATUS FROM OKL_CURE_REFUNDS_ALL r, OKL_CURE_REFUND_HEADERS_B h WHERE r.CURE_REFUND_HEADER_ID = h.CURE_REFUND_HEADER_ID AND r.STATUS = 'OPEN';

Analysts frequently aggregate AMOUNT and RECEIVED_AMOUNT by ORG_ID and REFUND_DATE for period-end reporting, and filter by VENDOR_SITE_ID to produce vendor statements. Because the refund pool is per contract, a contract-level drill-down typically constrains on CHR_ID.

Related Objects

  • OKL_CURE_REFUND_HEADERS_B — parent header table; join on CURE_REFUND_HEADER_ID.
  • OKL_CURE_REFUND_STAGE — stage master; join on CURE_REFUND_STAGE_ID.
  • OKL_CURE_REFUNDS_ALL — the _ALL suffix indicates a multi-org view/table pair in EBS; related _ALL views expose ORG_ID filtering.
  • OKL_CURE_REFUNDS — the operating-unit-filtered synonym or view counterpart.
  • OKL_CURE_CONTRACTS — cure contract master, related through CHR_ID.
  • OKL_TRANSACTIONS — related via TAP_ID/TAI_ID for associated transaction and asset records.