Results for “okl_open_int_all”

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

Overview

OKL_OPEN_INT_ALL is an open interface table in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. Its documented purpose is to serve as the staging and transmission vehicle for reporting lease and contract data to credit bureaus and for transferring accounts to external collection or recovery agencies. Records inserted into this table represent the outbound payload consumed by concurrent programs, external integrations, or clearing routines that push delinquency, default, and contract status information beyond the enterprise boundary.

In EBS 12.1.1 and 12.2.2 the object resides in the OKL schema and is classified as VALID. The heuristically mined Data Vault classification is standalone, indicating that the table neither acts as a pure hub, link, nor satellite within a modelled vault structure but instead functions as a transient interface entity. When modelling it for analytical purposes, treating it as a staging satellite keyed on a natural contract identifier is a reasonable suggestion, since its rows carry descriptive contract and party attributes rather than serving as a shared business key repository. Its multi-org nature is confirmed by the presence of ORG_ID and the standard concurrent program request columns.

Key Information Stored

The table spans 82 documented columns. The surrogate primary key is ID, enforced through OKL_OPEN_INT_ALL_PK. A separate unique index, OKL_OPEN_INT_ALL_U1, exists on KHR_ID, making that column the principal business-key candidate and the foreign-key link back to OKL_PRTFL_CNTRCTS_B.

• ID – surrogate primary key generated per interface row.
• KHR_ID – business key referencing the source contract in OKL_PRTFL_CNTRCTS_B; uniquely indexed.
• CONTRACT_NUMBER, CONTRACT_TYPE, CONTRACT_STATUS – identifying and lifecycle attributes of the underlying lease or loan contract.
• PARTY_ID, PARTY_NAME, PARTY_TYPE – the customer or counterparty being reported.
• DATE_OF_BIRTH, PLACE_OF_BIRTH, PERSON_IDENTIFIER, PERSON_IDEN_TYPE, COUNTRY – personal identification data required for credit bureau submissions.
• ADDRESS1 through POSTAL_PLUS4_CODE – the structured mailing address block used by bureaus and agencies.
• ORIGINAL_AMOUNT, REMAINING_AMOUNT, PAST_DUE_AMOUNT, MONTHLY_PAYMENT_AMOUNT – monetary exposure figures.
• START_DATE, CLOSE_DATE, TERM_DURATION, LAST_PAYMENT_DATE, DELINQUENCY_OCCURANCE_DATE – contractual and delinquency timing.
• CREDIT_INDICATOR, NOTIFICATION_DATE, CREDIT_BUREAU_REPORT_DATE – reporting status and bureau transmission flags.
• EXTERNAL_AGENCY_TRANSFER_DATE, EXTERNAL_AGENCY_RECALL_DATE, REFERRAL_NUMBER – agency transfer and recall tracking.
• CONTACT_ID, CONTACT_NAME, CONTACT_PHONE, CONTACT_EMAIL – collection contact details.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, ORG_ID – concurrent program and operating unit context.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE15 – DFF extensibility columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER – standard audit and optimistic locking columns.

Common Use Cases and Queries

Typical usage centres on extracting pending outbound records, reconciling them against source contracts, and confirming that bureau or agency transmissions have been completed.

• Retrieve unreported delinquencies: SELECT contract_number, party_name, past_due_amount, delinquency_occurance_date FROM okl_open_int_all WHERE credit_bureau_report_date IS NULL AND credit_indicator = 'Y'.
• Join back to the source contract for validation: SELECT o.contract_number, c.* FROM okl_open_int_all o, okl_prtfl_cntrcts_b c WHERE o.khr_id = c.khr_id.
• Reconcile agency transfers by filtering on EXTERNAL_AGENCY_TRANSFER_DATE and REFERRAL_NUMBER for a given operating unit via ORG_ID.
• Audit batch runs using REQUEST_ID and PROGRAM_UPDATE_DATE to confirm which concurrent request populated the interface.
• Identify recalled accounts by selecting rows where EXTERNAL_AGENCY_RECALL_DATE is populated.

Related Objects

• OKL_PRTFL_CNTRCTS_B – the source contract table referenced by the KHR_ID foreign key; the primary join for any lineage query.
• OKL_PRTFL_CNTRCTS_TL – translation table commonly joined to retrieve contract descriptions.
• OKL_OPEN_INT_ALL_PK and OKL_OPEN_INT_ALL_U1 – the primary key constraint and unique business-key index on ID and KHR_ID respectively.
• OKL_CONTRACTS – the core operational contract entity frequently joined via contract or KHR identifiers.
• OKL_K_HEADERS – header information often linked through KHR_ID for contract header semantics.
• Concurrent programs under the OKL application that populate this interface, identifiable through PROGRAM_ID and PROGRAM_APPLICATION_ID.