Tuesday, November 21, 2017

How to Get the Image dynamically in Oracle Rtf Reports

àdevelop the RTF TEMPLATE REPORT layout.
àcopy a dummy image in that RTF layout at the top position wherever you want the image.
àThen right click on the dummy image EDIT ALT TEXT(Ms office 2016) for the image
àIn the ALT TEXT give the following code for getting the image dynamically.
$OA_MEDIA—is the server path where you want to place the original image location
IMG_TEST.jpg—is the image name whatever you want to display in output.

FOR GETTING THE $OA_MEDIA PATH
àconnect to the PUTTY
àlogin with the credentials
à Run the command for set the environment   “ps -ef|grep inh”
Then you see list of paths in server …cd <path>  eg: /us1001/TEST/apps/tech_st
àin that path you will get the environment path “APPSTEST.env”
àthen run the command  “. APPSTEST.env” for setup environment.
àthen run pwd for getting present working directory
àthen run the command “cd $OA_MEDIA” and then run “pwd”
àthen you will get the $OA_MEDIA directory “/us1001/TEST/apps/apps_st/comn/java/classes/oracle/apps/media”

àconnect WINSCP and goto the above path for placing a image
ànext step in place the image in the above path
àthen run the concurrent program you will the image in the output pdf file.

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