My Oracle Support Banner

OMSPRC_BJ_100_01 bath performance issue due to mock statement (Doc ID 2695436.1)

Last updated on APRIL 19, 2021

Applies to:

Oracle Financial Services Lending and Leasing - Version 14.8.0.0.0 to 14.8.0.0.0 [Release 14]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------

We had started OMSPRC_BJ_100_01 (SET-ODD2) for approx 37000 accounts . There have been 8 hrs passed already and system has just processed 11519 accounts. Mock Statements will be generated for most of the accounts in system clustered across 2-3 days, which means there would be big load on system that day

Please see attached AWR.

EXPECTED BEHAVIOR
-----------------------
System should process the batch job according to benchmark

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Run the SET-ODD2 --> OMSPRC_BJ_100_01

2. Verify the process is getting completed as per benchmark
 
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, causing end of the day delays

Changes

 

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
Changes
Cause
Solution


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