DBA in the Trenches

So you want to create a Concurrent Program that will run some code on the environment your application is installed on? OK but you also want to use the environment variables that are setup. Seems reasonable. Well I ran into a problem when trying to build a string and then run it. The Story I have a table that I store various commands related to an object. For this example say I want to use FNDLOAD to upload or download a concurrent program I would use something like this: FNDLOAD apps/$APPLPWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct ./MY_CONC.ldt PROGRAM APPLICATION_SHORT_NAME=XXX CONCURRENT_PROGRAM_NAME=MY_CONC So far makes sense but if I want to automate this and seeing as FNDLOAD is pretty standard with its layout i placed the data into the table and made some fields that I change using replace. Not that important but when running the program using a HOST concurrent I was running into trouble. All the fields can be setup using replace except for the apps password...

After finally getting hold of bursting for BI Publisher I started to play around and with the help of Gareth Roberts I got it up and running sending PDF templates. I would suggest reading his article if you want a quick rundown of how it all work's. One item I would highlight is that when using dataTigger's inside Data Definition's the heading of the XML is case sensitive:  <dataTemplate name="XXXMLEXAMPLE" description="XSL-XML Example" Version="1.0" defaultPackage ="XXOM_AAABBBCCC_INTERFACE_PKG"> Pay special attention when defining the defaultPackage as I was left scratching my head with the defaultPackage was not being picked up. Also the dataTrigger placement is also in the fine print. beforeReport should be placed before the dataStructure and the afterReport trigger should be placed afterwards. Somehow this managed to catch my eye while reading the documentation.   Data Definition Create the data definition ...