Search Results okl_cure_reports_all




Overview
Explore in AI Chat

Overview

The OKL_CURE_REPORTS_ALL table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the OKL (Leasing and Finance Management) product module. It functions as the primary repository for storing header-level information related to cure repurchase requests. In the context of leasing and asset finance, a cure repurchase request is a critical transaction where a lessor or financier may repurchase an asset from a vendor, often as part of a contractual remedy or settlement process. This table serves as the master record for such requests, capturing essential administrative and supplier details that govern the transaction lifecycle.

Key Information Stored

The table's primary key is CURE_REPORT_ID, which uniquely identifies each cure repurchase request. As indicated by its foreign key relationships, the table heavily integrates with the Oracle Payables (AP) supplier model to manage vendor information. Key columns include VENDOR_ID, which links to the AP_SUPPLIERS table to identify the supplier from whom the asset is being repurchased. The VENDOR_SITE_ID links to AP_SUPPLIER_SITES_ALL, specifying the precise business location of the vendor. Furthermore, VENDOR_CONTACT_ID links to AP_SUPPLIER_CONTACTS, storing contact details for the transaction. While the provided metadata does not list all columns, typical header information in such a table would also encompass request dates, statuses, financial amounts, currency, and references to related lease contracts or assets.

Common Use Cases and Queries

This table is central to operational and reporting processes within the Lease Management module. Common use cases include generating cure repurchase request reports, tracking the status of outstanding requests, and feeding data into financial reconciliation processes. For reporting, a typical SQL query might join this table with its related AP supplier tables to create a comprehensive vendor view. A sample reporting pattern is:

  • SELECT cr.cure_report_id, cr.request_date, cr.status, aps.vendor_name, apsa.vendor_site_code FROM okl_cure_reports_all cr, ap_suppliers aps, ap_supplier_sites_all apsa WHERE cr.vendor_id = aps.vendor_id AND cr.vendor_site_id = apsa.vendor_site_id;

Data from this table is also crucial for integration points, such as creating payable invoices in AP for the repurchase amount or updating the asset's financial status in the Fixed Assets module.

Related Objects

The OKL_CURE_REPORTS_ALL table has defined relationships with several key EBS objects, primarily within the Oracle Payables module. As per the metadata, its foreign keys directly reference:

  • AP_SUPPLIERS: For master supplier information via VENDOR_ID.
  • AP_SUPPLIER_SITES_ALL: For supplier site details via VENDOR_SITE_ID.
  • AP_SUPPLIER_CONTACTS: For contact person details via VENDOR_CONTACT_ID.

It is highly probable that this header table has child tables (not listed in the excerpt) storing line-level details for the repurchase, such as specific assets or amounts. The table is also integral to the OKL Cure Repurchase business flow and is likely accessed by dedicated Oracle APIs and forms within the OKL application for data creation, validation, and processing.