Tuesday, February 21, 2017

Custom Functional Area for Custom content option is disabled

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.

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