My Oracle Support Banner

Mock Billing - Performance Issue (Doc ID 2855919.1)

Last updated on MARCH 16, 2022

Applies to:

Oracle Financial Services Lending and Leasing Cloud Service - Version 14.10.0.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
when mock billing got generated the nightly batch processing took 12 hours to complete.

Below are the total numbers of records generated for the below tables.  ODD2 with (MOCK_STM_GEN_LAST_MTH_ONLY_IND = Y).

~138 million records created in MOCK_STATEMENT_DETAILS.
~ 7 million records created in MOCK_STATEMENTS.
 

EXPECTED BEHAVIOR
-----------------------
Mock billing job job should not take more than 5 hours.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute the mock billing batch job where we have more than 7 million records to process
2. Check for the batch job execution timing

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.