March 19, 2015

FND Script and Shell Scripting

Download

Concurrent:
FNDLOAD apps/q1w2e3r4 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXHREMPPAYH.ldt PROGRAM APPLICATION_SHORT_NAME="XXHR" CONCURRENT_PROGRAM_NAME="XXHREMPPAYH"  

Valueset:
FNDLOAD apps/q1w2e3r4 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXHR_CCCODE.ldt VALUE_SET FLEX_VALUE_SET_NAME="XXHR_CCCODE"

Data Def:

FNDLOAD apps/q1w2e3r4 O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct XXHREMPPAYHDD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXHR' DATA_SOURCE_CODE='XXHREMPPAYH' TMPL_APP_SHORT_NAME='XXHR' TEMPLATE_CODE='XXHREMPPAYH'


Upload:
Value Set:
$FND_TOP/bin/FNDLOAD $APPSID O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct  XXHR_BU_LOV.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Conc Prog:
$FND_TOP/bin/FNDLOAD $APPSID O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct  XXHREMPPROM.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

 RTF:
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME $APPS_LOGIN -DB_PASSWORD $APPS_PWD -JDBC_CONNECTION $APPSJDBC -LOB_TYPE TEMPLATE -APPS_SHORT_NAME XXHR -CUSTOM_MODE FORCE -XDO_FILE_TYPE RTF -LANGUAGE en -LOB_CODE XXHREMPPROM -FILE_NAME EMP_PROM_REP.rtf

DD:
 $FND_TOP/bin/FNDLOAD $APPSID O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXHREMPPOSPAYDD.ldt

Script Process:

Make a temp folder in instance you have registered the reports and create the ldt of Concurrent program,valuset and assosiated RTF if any using the fndload downlod command from unix machine login
Script the *.install File with command to copy the sql,view,ldt,rtf,rdf,valusets etc related to the report.
together create the tar file using command tar -cvf TARFILENAME.tar FOLDER_NAME(CONTAINS files specified in script)
Now Move the tar to the desired instance and extract the tar file using the command tar -xvf TARFILENAME.tar 
go the the extracted folder and run the *.install file using command ./Filename.install


COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...