Wednesday, June 22, 2016

Formula column for getting instance name in mail subject

function CF_INSTANCEFormula return Char is
L_INSTANCE VARCHAR2(20);
begin
select INSTANCE_NAME INTO L_INSTANCE
from V$INSTANCE;
  RETURN L_INSTANCE;
EXCEPTION when others then
RETURN NULL;
end;

In bursting control file  Subject should be "subject  - ${CF_INSTANCE}"

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...