After configuring OBIA 11.1.1.x ,I noticed "Custom Functional Area for Custom content" checkbox option is grayed out/disabled during the load plan creation in BIACM .
Issue: There was a broken link between "Custom Functional Area for Custom content" Functional Area (X_CUSTOM_FA) and "Custom Fact Group for Custom Facts" Fact group (X_CUSTOM_FG).
We can check this relation in XX_BIACOMP schema using below query.
Resolution: Insert a record to create this relation between X_CUSTOM_FA and X_CUSTOM_FG.
Note : Take the backup before inserting data
Insert new record.
Now check box will be enabled for creating loadplans.
Issue: There was a broken link between "Custom Functional Area for Custom content" Functional Area (X_CUSTOM_FA) and "Custom Fact Group for Custom Facts" Fact group (X_CUSTOM_FG).
We can check this relation in XX_BIACOMP schema using below query.
SELECT * FROM C_FUNCAREA_FACTGROUP_REL WHERE
FACTGROUP_KEY='X_CUSTOM_FG';
Resolution: Insert a record to create this relation between X_CUSTOM_FA and X_CUSTOM_FG.
Note : Take the backup before inserting data
CREATE TABLE C_FUNCAREA_FACTGROUP_REL_BKP AS SELECT
* FROM C_FUNCAREA_FACTGROUP_REL;
Insert new record.
INSERT INTO C_FUNCAREA_FACTGROUP_REL VALUES (NULL,'X_CUSTOM_FA','X_CUSTOM_FG','SEED_DATA_FROM_BACKEND_MANUAL',
SYSDATE,'SEED_DATA_FROM_BACKEND_MANUAL', SYSDATE,'-1');
COMMIT;
Now check box will be enabled for creating loadplans.
No comments:
Post a Comment