Thursday, June 21, 2018

How to declare and use a variable in BI Publisher report

Decalring the Varible :<?xdoxslt:set_variable($_XDOCTX, 'var', 0)?>

Do the calculation :<?xdoxslt:set_variable($_XDOCTX,'var', xdoxslt:get_variable($_XDOCTX,'var‘)+ XML columnname)?>

Display the Variable : <?xdoxslt:get_variable($_XDOCTX, 'var')?>

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_...