Search Results receipt_creation_status




Overview
Explore in AI Chat

Overview

The view APPS.OKL_BPD_TRX_RCPT_HEADER_V is a consolidated receivables receipt header view within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL/ETRM) module. It presents receipt-level information combining Accounts Receivable (AR) cash receipts with contract and billing consolidation data derived from the OKL schema. Its principal role is to serve as a reporting and integration layer for the Billing and Payment Distribution (BPD) functional area, exposing receipts associated with lease contracts in a form suitable for transaction reconciliation and status reporting.

The view is particularly relevant to users searching for receipt_creation_status. It exposes this attribute through the derived column TRANSACTION_STATUS, which is resolved by a call to ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('RECEIPT_CREATION_STATUS', ARCASH.STATUS). This maps the raw AR receipt status code to its human-readable lookup meaning, allowing consumers to interpret receipt lifecycle states directly from the view output.

Underlying Base Objects

The view is owned by APPS and is defined over a mix of AR base objects and OKL consolidation objects. Documented referenced objects include:

The definition is a UNION of two queries: the first joins consolidation data through OKL_CNSLD_AR_STRMS_B, and the second draws on additional AR and OKL billing structures, ensuring receipts from multiple billing paths are represented. Referenced objects also include OKL_BPD_AR_INV_LINES_V and OKL_BILLING_UTIL_PVT, supporting the billing-to-receipt bridge.

Key Columns

Common Use Cases and Queries

This view is typically consumed to report receipt status per lease contract, reconcile applied amounts against invoices, and audit receipt creation across operating units.

To retrieve receipts by decoded creation status:

  • SELECT RECEIPT_NUMBER, CONTRACT_NUMBER, RECEIVABLE_INVOICE_NUMBER, AMOUNT_APPLIED, TRANSACTION_STATUS FROM APPS.OKL_BPD_TRX_RCPT_HEADER_V WHERE RECEIPT_CREATION_STATUS_STATUS = 'APPLIED'; — filter on the decoded status value.
  • SELECT CONTRACT_NUMBER, SUM(AMOUNT_APPLIED) FROM APPS.OKL_BPD_TRX_RCPT_HEADER_V GROUP BY CONTRACT_NUMBER; — aggregate applied receipts per contract.
  • SELECT RECEIPT_NUMBER, RECEIPT_DATE, STATUS, TRANSACTION_STATUS FROM APPS.OKL_BPD_TRX_RCPT_HEADER_V WHERE ORG_ID = :p_org_id; — operating-unit-scoped status listing.

Because the status decoding depends on the RECEIPT_CREATION_STATUS lookup, queries returning TRANSACTION_STATUS are the most direct means of surfacing the receipt_creation_status value in OKL reporting.