Results for “okl_taa_request_details_b”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_TAA_REQUEST_DETAILS_B is a transactional table in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It stores the detailed attributes of Transfer and Assumption (TAA) requests, the business process through which an existing lease contract is transferred from one lessee to another, with the incoming party assuming the rights and obligations of the original agreement. Each row represents a request-level record that captures the financial, billing, insurance, and policy information associated with a specific transfer and assumption transaction.

Consistent with the ETRM relationship metadata, the heuristic Data Vault classification for this object is satellite-leaning. It is modeled as a descriptive table that hangs off a central parent entity (referenced through TCN_ID) rather than acting as a pure hub or a pure link. This classification should be treated as a modeling suggestion derived from the foreign-key topology, not as a physical constraint imposed by the schema.

Key Information Stored

The table contains 48 documented columns. Its surrogate primary key is ID, enforced through the OKL_TAA_PK constraint. Key business and descriptive columns include:

• TCN_ID — Foreign key linking the request to its parent Transfer and Assumption header record; the primary join path to the TAA transaction.
• NEW_CONTRACT_NUMBER — Identifier for the contract resulting from the transfer and assumption.
• CUST_ACCT_ID and BILL_TO_SITE_ID — The customer account and billing site of record for the assumed lease.
• BANK_ACCT_ID, PAYMENT_MTHD_ID, and INVOICE_FORMAT_ID — Payment and invoicing configuration; INVOICE_FORMAT_ID references PA_INVOICE_FORMATS.
• MLA_ID and CREDIT_LINE_ID — Links to the master lease agreement and credit line governing the transaction.
• INSURANCE_YN, LEASE_POLICY_YN, IPY_TYPE, POLICY_NUMBER, COVERED_AMT, DEDUCTIBLE_AMT — Insurance policy details captured during assumption.
• EFFECTIVE_FROM_DATE, EFFECTIVE_TO_DATE, PROOF_REQUIRED_DATE, PROOF_PROVIDED_DATE — Effective and proof-of-insurance dates.
• INT_ID, ISU_ID, AGENCY_SITE_ID, AGENT_SITE_ID — Interest, issuer, agency, and agent references.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — Flexfield-enabled descriptive attributes for extensibility.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns.

Common Use Cases and Queries

Typical uses include reporting on active TAA requests, validating insurance coverage against lease policies, and reconciling new contract numbers. A representative join pattern is:

• SELECT d.ID, d.NEW_CONTRACT_NUMBER, d.EFFECTIVE_FROM_DATE FROM OKL.OKL_TAA_REQUEST_DETAILS_B d WHERE d.TCN_ID = :p_tcn_id;
• SELECT d.*, f.FORMAT_NAME FROM OKL.OKL_TAA_REQUEST_DETAILS_B d, PA.PA_INVOICE_FORMATS f WHERE d.INVOICE_FORMAT_ID = f.INVOICE_FORMAT_ID;

Related Objects

• OKL_TAA_REQUEST_DETAILS_B.TCN_ID — parent TAA request/header record (join key).
• PA_INVOICE_FORMATS — via INVOICE_FORMAT_ID.
• OKL_TAA_REQUEST_DETAILS_TL — translation table for multi-language text.
• OKL_TAA_PK — primary key constraint on ID.
• OKL Lease Contract API — transfer/assumption processing logic.