My Oracle Support Banner

Stream Generator Package has High Execution Rate when Importing Contracts (Doc ID 2774216.1)

Last updated on MAY 06, 2021

Applies to:

Oracle Lease and Finance Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version,

ACTUAL BEHAVIOR
---------------
Find that while working on conversion & expecting about 60,000 contracts to flow into OLFM, we observed high execution rate with the stream generation package. The following cursor is being used in a loop and causing the performance issue.

CURSOR is_prospective_rbk_csr(p_khr_id NUMBER)
  IS
  SELECT amort_inc_adj_rev_dt_yn rbk_prospectively
  FROM okl_sys_acct_opts_all sysop
  ,okc_k_headers_b chr
  WHERE sysop.org_id = chr.authoring_org_id;
 
This cursor is being used in loop.

EXPECTED BEHAVIOR
-----------------------
Expect better performance with the Lease Import open interface process.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using the lease import open interface, import multiple contracts.

2. Try pricing about 1000 contracts in same batch, it is taking forever to load those due to cursor having high execution rates.



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.