My Oracle Support Banner

OBIA Missing Relationship In C_FUNCAREA_FACTGROUP_REL For Custom Application (Doc ID 2221989.1)

Last updated on MARCH 29, 2018

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Missing Relationship in C_FUNCAREA_FACTGROUP_REL for Custom Application

When enabling the offerings in the BIACM for Oracle Custom Analytics, there are no Associated Dimensions and Fact Groups for the Custom Analytics Offering.

Also, there is no seeded record in the database in C_FUNCAREA_FACTGROUP_REL for the X_CUSTOM_FA FUNCAREA_KEY and X_CUSTOM_FG FACTGROUP_KEY.


In the BIACM added a new (+), but that appears to be creating a NEW fact group and/or dimension group.

However, user only want to create the relationship between the Custom Offering and existing Custom Factgroup (as seen in C_FACT_GROUP:

select * from C_FACT_GROUP where factgroup_key = 'X_CUSTOM_FG' => Custom Fact Group for Custom Facts).


User needs this to pull in the X_CUSTOM load plan with the load plan generator for a custom dimension user built.

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
References


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