Search Results srt_code

Overview

OKL_SIF_RETS is a table in the OKL schema (Oracle Lease and Finance Management) that stores the header-level details of data returned by the external pricing engine during the lease and loan origination process. In Oracle EBS 12.1.1 and 12.2.2, the Sales Interface Facility (SIF) integrates Oracle Lease Management with an external pricing engine to calculate yields, implicit interest rates, and stream-level pricing attributes. When the external engine completes its computation, the results are written back into OKL_SIF_RETS, which acts as the parent header record for all subsequent detail data returned in the same response.

The table is best understood as the return-side counterpart to the outbound SIF request structures. Each row corresponds to one pricing result keyed by transaction number, yield name, and index number, and additional child tables hang off it to hold level breakdowns, errors, streams, and stream transaction data. From a Data Vault modeling perspective, the metadata's FK structure suggests a hub-leaning classification: OKL_SIF_RETS is the referenced parent for four dependent tables (OKL_SIF_RET_LEVELS, OKL_SIF_RET_ERRORS, OKL_SIF_RET_STRMS, and OKL_STREAM_TRX_DATA), with its unique business key defined by TRANSACTION_NUMBER, YIELD_NAME, and INDEX_NUMBER. This pattern is characteristic of a hub that anchors business keys while satellites and links attach descriptive and transactional context.

Key Information Stored

The table contains 36 documented columns. The surrogate primary key is ID, enforced by unique index OKL_SIR_U1 and also referenced as SIR_PK in the ETRM documentation. A second unique index, OKL_SIR_U2, defines the business-key candidate: TRANSACTION_NUMBER, YIELD_NAME, and INDEX_NUMBER together identify a unique pricing result for a given transaction, yield method, and index.

The most significant data columns include:

• TRANSACTION_NUMBER — identifies the lease or loan transaction whose pricing was submitted to the external engine.
• SRT_CODE — code identifying the return type or result category.
• YIELD_NAME — the yield method or category returned by the pricing engine.
• INDEX_NUMBER — sequence index distinguishing multiple results within the same yield or transaction.
• EFFECTIVE_PRE_TAX_YIELD / EFFECTIVE_AFTER_TAX_YIELD — effective yield percentages before and after tax.
• NOMINAL_PRE_TAX_YIELD / NOMINAL_AFTER_TAX_YIELD — nominal yield percentages before and after tax.
• IMPLICIT_INTEREST_RATE — the implied rate derived by the pricing engine.
• DATE_PROCESSED — the date the external engine response was processed.
• STREAM_INTERFACE_ATTRIBUTE01 … 15 — fifteen extensible attributes carrying engine-specific values required to map returns back into lease stream structures.
• Standard EBS audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical uses include reconciling external pricing results against internally computed yields, diagnosing failed SIF response processing, and reporting on yield calculations per transaction for finance and audit purposes.

• Retrieve all pricing results for a transaction:

  SELECT id, transaction_number, yield_name, index_number, effective_pre_tax_yield, effective_after_tax_yield, implicit_interest_rate FROM okl.okl_sif_rets WHERE transaction_number = :trx_num;

• Identify recent return headers processed:

  SELECT transaction_number, yield_name, date_processed FROM okl.okl_sif_rets WHERE date_processed >= :start_date;

• Detect errors associated with a return header by joining to OKL_SIF_RET_ERRORS on SIR_ID.
• Report on stream interface attributes for debugging engine-specific field mapping.

Related Objects

The following dependent tables reference OKL_SIF_RETS via the SIR_ID foreign key column (matching ID in OKL_SIF_RETS):

• OKL_SIF_RET_LEVELS — level-wise pricing breakdowns returned by the engine (OKL_SIF_RET_LEVELS.SIR_ID → OKL_SIF_RETS.ID).
• OKL_SIF_RET_ERRORS — error records generated during response processing (OKL_SIF_RET_ERRORS.SIR_ID → OKL_SIF_RETS.ID).
• OKL_SIF_RET_STRMS — stream-level returns produced by the pricing engine (OKL_SIF_RET_STRMS.SIR_ID → OKL_SIF_RETS.ID).
• OKL_STREAM_TRX_DATA — stream transaction data linked to the return header (OKL_STREAM_TRX_DATA.SIR_ID → OKL_SIF_RETS.ID).

These relationships confirm OKL_SIF_RETS as the anchoring header for SIF return processing; queries should join on SIR_ID = ID, and the SIF concurrent programs and lease origination APIs that populate these tables are the principal consumers of this data.