My Oracle Support Banner

Performance Issue: When Running C1-FTRAN For Loading Account Feed It Is Taking Time (Doc ID 2826438.1)

Last updated on DECEMBER 15, 2021

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 3.0.0.0.0 and later
Information in this document applies to any platform.

Goal

On : 3.0.0.0.0 version, BT - Batch

Facing a performance issue while running C1-FTRAN for loading Account feed file. From the AWR report, it was observed that one query is being executed at least a million times when trying to load 10000 records. There is a Post processing algorithm in the Account Business Object C1-LINKACCIC which is taking a long time to create new accounts.

How can the performance be improved?
 

Solution

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
Goal
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.