On Premise customers, see steps below. On Demand/SaaS customers, please contact Broadcom support for assistance
Step 1: Check for constraints:
select * from USER_CONSTRAINTS
where CONSTRAINT_NAME like '%NBI_R_FACTS_PK%'
and status = 'ENABLED'
Step 2: If constraints are found, disable the constraint using the below query:
alter table "Schema name"."NBI_R_FACTS" disable constraint "NBI_R_FACTS_PK";
Step 3: Drop and recreate the below index
drop index NBI_R_FACTS_U1
CREATE UNIQUE INDEX NBI_R_FACTS_U1 ON NBI_R_FACTS ("FACT_DATE", "RESOURCE_ID")