Search Results purchase
The OKL_EXT_FUND_RQNS_ALL_B table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Oracle Lease and Finance Management (OKL) module. This table serves as the base table for storing external funding request information, which is essential for managing lease and loan transactions where third-party funding is involved. Below is a detailed technical and functional analysis of this table, its purpose, key attributes, and its integration within the Oracle EBS ecosystem.
Overview and Purpose
The OKL_EXT_FUND_RQNS_ALL_B table is part of Oracle's Lease and Finance Management module, specifically designed to track and manage funding requests sent to external entities such as banks, financial institutions, or investors. It stores transactional data related to funding requests, approvals, and disbursements, ensuring seamless integration between Oracle EBS and external funding systems. This table supports multi-organization access (as indicated by the "_ALL_" suffix) and is primarily used in scenarios where lease contracts require third-party financing.Key Columns and Structure
The table contains several critical columns that define the funding request lifecycle:- EXT_FUND_RQN_ID: Primary key identifier for each funding request.
- FUNDING_SOURCE_ID: References the external funding source (e.g., bank or investor).
- CONTRACT_ID: Links to the lease or loan contract in the OKL_K_HEADERS_B table.
- RQN_AMOUNT: The monetary value requested for funding.
- RQN_STATUS: Tracks the status of the request (e.g., PENDING, APPROVED, REJECTED, FUNDED).
- RQN_DATE: Timestamp of the request creation.
- APPROVAL_DATE: Date when the request was approved by the funding source.
- FUNDED_DATE: Date when funds were disbursed.
- ORG_ID: Organizational identifier for multi-org functionality.
Functional Role in Oracle EBS
The OKL_EXT_FUND_RQNS_ALL_B table plays a pivotal role in automating and streamlining external funding processes:- Funding Request Initiation: When a lease contract requires external funding, a record is created in this table, capturing request details.
- Status Tracking: The RQN_STATUS column enables real-time monitoring of funding progress, ensuring transparency.
- Integration with Financial Systems: The table interfaces with Oracle General Ledger (GL) and Accounts Payable (AP) modules to post funding-related accounting entries.
- Reporting and Analytics: Data from this table feeds into Oracle Business Intelligence (OBIEE) or custom reports for portfolio analysis.
Integration with Other Modules
This table interacts with several Oracle EBS components:- OKL_K_HEADERS_B: For contract details.
- OKL_FUNDING_SOURCES_B: For funding source metadata.
- GL_INTERFACE: To pass journal entries for funded amounts.
- AP_INVOICES_ALL: If funding involves invoice payments.
Technical Considerations
- Indexing: Primary and foreign key indexes ensure performance for joins with related tables.
- Partitioning: In high-volume environments, partitioning by ORG_ID or RQN_DATE may be implemented.
- API Dependencies: The table is typically accessed via Oracle's PL/SQL APIs (e.g., OKL_EXT_FUND_PUB) rather than direct DML.
Conclusion
The OKL_EXT_FUND_RQNS_ALL_B table is a foundational component of Oracle Lease and Finance Management, enabling efficient external funding operations. Its design supports complex lease financing workflows while maintaining integration with core financial modules. Understanding this table's structure and relationships is crucial for implementing, customizing, or troubleshooting funding processes in Oracle EBS 12.1.1 or 12.2.2 environments.-
Lookup Type: OKL_QUOTE_TYPE
12.1.1
product: OKL - Leasing and Finance Management , meaning: QUOTE TYPE , description: OKL Quote Type ,
-
Lookup Type: OKL_ASSET_TRACK_STRATEGIES
12.1.1
product: OKL - Leasing and Finance Management , meaning: ASSET_TRACK_STRATEGIES , description: Okl Asset Tracking Strategies ,
-
Lookup Type: OKL_POOL_TRANSACTION_REASON
12.1.1
product: OKL - Leasing and Finance Management , meaning: Pool Transaction Reason , description: OKL Pool Transaction Reason ,
-
Lookup Type: OKL_GUARANTEE_TYPE
12.1.1
product: OKL - Leasing and Finance Management , meaning: OKL GUARANTEE TYPE , description: Residual Guarantee Type ,
-
Lookup Type: OKL_EOT_OPTION
12.1.1
product: OKL - Leasing and Finance Management , meaning: OKL EOT OPTION , description: End of Term Options ,
-
Lookup Type: OKL_TC_LINKS
12.1.1
product: OKL - Leasing and Finance Management , meaning: OKL Terms and Conditions Links , description: OKL Terms and Conditions Links ,
-
Lookup Type: OKL_QUOTE_LINE_TYPE
12.1.1
product: OKL - Leasing and Finance Management , meaning: QUOTE LINE TYPE , description: OKL Quote Line Types ,
-
Table: OKL_EXT_FUND_RQNS_ALL_B
12.1.1
owner:OKL, object_type:TABLE, fnd_design_data:OKL.OKL_EXT_FUND_RQNS_ALL_B, object_name:OKL_EXT_FUND_RQNS_ALL_B, status:VALID, product: OKL - Leasing and Finance Management , description: External transaction header when purchase requisition required , implementation_dba_data: OKL.OKL_EXT_FUND_RQNS_ALL_B ,
-
Table: OKL_EXT_FUND_RQNS_B
12.1.1
product: OKL - Leasing and Finance Management , description: External transaction header when purchase requisition required , implementation_dba_data: Not implemented in this database ,
-
Lookup Type: OKL_PROCESSES
12.1.1
product: OKL - Leasing and Finance Management , meaning: OKL_PROCESSES , description: Processes used primarily to identify fulfillment requests ,
-
View: OKL_EXT_FUND_RQNS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:OKL.OKL_EXT_FUND_RQNS_V, object_name:OKL_EXT_FUND_RQNS_V, status:VALID, product: OKL - Leasing and Finance Management , description: External transaction header when purchase requisition required , implementation_dba_data: APPS.OKL_EXT_FUND_RQNS_V ,
-
Lookup Type: OKL_FIN_PRIMARY_PURPOSES
12.1.1
product: OKL - Leasing and Finance Management , meaning: OKL FINANCIAL PRODUCT PRIMARY PURPOSES , description: Financial Product Primary Purposes for Stream Generation Templates ,
-
Lookup Type: OKL_STREAM_TYPE_PURPOSE
12.1.1
product: OKL - Leasing and Finance Management , meaning: Stream Type Purpose , description: Stream Type Purpose ,