Search Results okl_credit_requests




Overview
Explore in AI Chat

Overview

The OKL_CREDIT_REQUESTS table resides in the OKL schema and is a core transactional object within the Oracle E-Business Suite Lease and Finance Management (OKL) module. It stores transaction-level credit request information, capturing the workflow by which credit exposure associated with a leasing or financing transaction is requested, evaluated, and approved. In release 12.1.1 and 12.2.2, this table serves as the persistence layer behind the credit adjudication process that precedes contract booking, ensuring that a quote or transaction has an approved credit line before it proceeds.

The ETRM metadata classifies this object heuristically as standalone under the Data Vault modeling framework. This suggests that the table functions primarily as a self-contained record of credit request events, rather than as a strict hub or link with dense foreign-key dependencies. Modelers may nonetheless treat it as a satellite-like entity whose natural business identity is the credit request number, with the surrogate key providing physical row identity.

Key Information Stored

The table contains 35 documented columns. The most significant include:

Common Use Cases and Queries

Typical use cases include credit exposure reporting, approval cycle-time analysis, and integration with quoting. A representative query joins credit requests to their source quotes:

  • Credit status by quote: SELECT q.quote_number, c.credit_req_number, c.status, c.credit_amount FROM okl.okl_credit_requests c JOIN as_quotes_all q ON c.quote_id = q.quote_id;
  • Pending approvals: SELECT credit_req_number, requested_by, requested_date FROM okl.okl_credit_requests WHERE status = 'PENDING' ORDER BY requested_date;
  • Approval cycle time: SELECT credit_req_number, (approved_date - requested_date) days FROM okl.okl_credit_requests WHERE approved_date IS NOT NULL;
  • Multi-org filtering: add WHERE org_id = :p_org_id to respect operating unit security.

Related Objects

  • AS_QUOTES_ALL — referenced via QUOTE_ID; the principal parent quote record.
  • OKL_CREDIT_REQUESTS primary key constraint OKL_CRQ_PK — enforces uniqueness on ID.
  • Related OKL credit and contract tables that consume approved credit requests prior to booking.
  • Oracle Quoting views over AS_QUOTES_ALL used to present credit status to sales users.
  • Standard WHO audit and descriptive flexfield infrastructure supporting the ATTRIBUTE columns.