BIACM Queries

When Creating a Document on Domain values that have been mapped to target values etc in BIACM we can use the BIACOMP schema to derive various pieces of information.

Below are some querys that can be used to get information on mappings etc.

Query to get Offerings enabled
select offering_code,offering_name
from c_bia_offering
where installed_flag = 1;


Query to get offering, implementation project, task list

SELECT ATLT.TASK_LIST_NAME,
  ATT.Task_name,
  AIPT.IMPL_PROJECT_NAME,
  AIEI.*
FROM ASM_IP_EXECUTION_ITEMS AIEI,
  ASM_TASK_LISTS_TL ATLT,
  ASM_TASK_LIST_ITEMS ATLI ,
  ASK_TASKS_TL ATT ,
  ASM_IMPL_PROJECTS_TL AIPT
WHERE ATLT.TASK_LIST_ID   =AIEI.TASK_LIST_ID
AND ATLI.TASK_LIST_ITEM_ID=AIEI.TASK_LIST_ITEM_ID
AND ATT.TASK_ID           =ATLI.ITEM_TASK_ID
AND AIPT.IMPL_PROJECT_ID  =AIEI.IMPL_PROJECT_ID
AND ATLT.language ='US'
AND ATT.Language  ='US'
AND AIPT.Language ='US'
  --AND TASK_LIST_NAME= 'Oracle Financial Analytics' --Give the required Module name here
AND AIPT.IMPL_PROJECT_NAME
LIKE 'Financials _ P and S Implementation Project' ; -- Give your implementation project name here

--Query to get standard domain Mappings list in biacm which are loaded with BIAPPS installation

SELECT src.domain_code source_domain_code,
  trg.domain_code target_domain_code,
  srct.domain_name source_domain_name,
  trgt.domain_name target_domain_name
FROM c_domain_map cdm ,
  c_domain_tl srct,
  c_domain_tl trgt,
  c_domain src,
  c_domain trg
WHERE cdm.TRG_DOMAIN_KEY=trgt.DOMAIN_KEY
AND cdm.SRC_DOMAIN_KEY  =srct.DOMAIN_KEY
AND trg.DOMAIN_KEY      =trgt.DOMAIN_KEY
AND src.DOMAIN_KEY      =srct.DOMAIN_KEY
AND trgt.LANGUAGE_CODE  ='US'
AND srct.language_code  ='US'
AND src.domain_code     ='COUNTRY';