My Oracle Support Banner

AccountProfile_Balance fails when records are large in number (Doc ID 2392460.1)

Last updated on APRIL 24, 2023

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 6.2.1 to 8.0 [Release 6.0 to 8.0]
Information in this document applies to any platform.

Symptoms

While running BDF AccountProfile_Balance, below error comes:

[main] FATAL - AccountProfile_Balance - Message 10019: Unexpected Exception: com.ofss.bdf.common.RethrownException: ORA-12801: error signaled in parallel query server P003
ORA-00600: internal error code, arguments: [kxfqenq1], [], [], [], [], [], [], [], [], [], [], []

[main] FATAL - AccountProfile_Balance - Message 10200: java.sql.SQLException: ORA-12801: error signaled in parallel query server P003
ORA-00600: internal error code, arguments: [kxfqenq1], [], [], [], [], [], [], [], [], [], [], []

However, when triggered the MERGE query from the logs directly on SQL Developer, it works fine and rows merged successfully.

It is also noticed that this BDF doesn't fail for low volumes



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


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