Fct_socialno Module Needs Hours For Startup And Then Fails

(Doc ID 578610.1)

Last updated on SEPTEMBER 15, 2008

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.0.0.0
This problem can occur on any platform.

Symptoms

There is a related to poor pipeline performance during startup when module FCT_SocialNo is configured

STEPS

========

Configure around six million entries in our IFW_SOCIALNUMBERS table and configure the pipeline registry to use this module.

The startup takes hours (~7-8 hours)

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms