Fusion Applications: Disabled Primary Keys In Fusion Database (Doc ID 2057370.1)

Last updated on SEPTEMBER 18, 2015

Applies to:

Oracle Fusion Accounting Hub - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Goal

While trying to troubleshoot the poor performance, it is found that many primary keys are disabled and the indexes for the primary keys are non-existent. Below is a count of disabled constraints by constraint type per owner.

OWNER C STATUS COUNT(STATUS)
------------------------------ - -------- -------------
FUSION C DISABLED 95
FUSION P DISABLED 5789
FUSION R DISABLED 5867
FUSION U DISABLED 648
FUSION_OTBI P DISABLED 51
FUSION_OTBI R DISABLED 23
FUSION_OTBI U DISABLED 20
FUSION_PORTLET R DISABLED 1
FUSION_SETUP P DISABLED 181

Should these constraints be enabled?

 

Solution

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