Wednesday, August 12, 2015

FNDLOAD Usage in R12


FORM Definition download in R12
========================================================================
Download
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <xxaoa_file_name.ldt> FUNCTION FUNCTION_NAME="xx_function_name"


FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <xxaoa_file_name.ldt> FND_FORM_CUSTOM_RULES form_name=<form name>
OR
FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct xxaoa_file_name.ldt FUNCTION FUNCTION_NAME=<function_name>
OR
FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct xxaoa_file_name.ldt FORM FORM_NAME=<form_name>
OR
FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <xxaoa_file_name.ldt> FND_FORM_CUSTOM_RULES function_name=<function name>

Upload (with force mode)
$FND_TOP/bin/FNDLOAD <userid>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <xxaoa_file_name.ldt> - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Upload (normal mode)
$FND_TOP/bin/FNDLOAD <userid>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <xxaoa_file_name.ldt>


FORM Compilation in R12.2/R12
========================================================================
frmcmp.sh module=<form.fmb> userid=<userid>/<password> module_type=form batch=yes compile_all=yes

OR

frmcmp_batch module=<form.fmb> userid=<userid>/<password> module_type=form batch=yes compile_all=yes

Menu Definition Download in R12
========================================================================
Download
FNDLOAD <userid>/<password>@TEST 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <xxaoa_file_name.ldt> MENU MENU_NAME="INV_NAVIGATE"

Upload
FNDLOAD <userid>/<password>@UAT 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <xxaoa_file_name.ldt>


REQUEST GROUPS
========================================================================
Download
FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct <xxaoa_file_name.ldt> REQUEST_GROUP REQUEST_GROUP_NAME='HMC SHRMS Benefit Admin Reps'

Upload
FNDLOAD <userid>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct <xxaoa_file_name.ldt>


BI PUBLISHER
========================================================================
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=hostname.domain)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=hostname) (INSTANCE_NAME=SID)))' -LOB_TYPE TEMPLATE -LOB_CODE <xx_code> -APPS_SHORT_NAME PER -LANGUAGE en -TERRITORY 00 -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE log.txt


CONCURRENT PROGRAM
========================================================================
Download
FNDLOAD <userid>/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct <xx_conc.ldt> PROGRAM APPLICATION_SHORT_NAME='PER' CONCURRENT_PROGRAM_NAME='<xx_conc>'

Upload
FNDLOAD <userid>/<password> O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct <xx_conc.ldt>


LOOKUP
========================================================================
Download
FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct <xx_lookup.ldt> FND_LOOKUP_TYPE APPLICATION_SHORT_NAME='AU' LOOKUP_TYPE='XX_LOOKUP'

Upload
FNDLOAD <userid>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct <xx_lookup.ldt>

========================================================================

3 comments:

  1. Replies
    1. Thanks Bhagath, For any of your more requirements you can post me .I will try to catch up more details in this blog.

      Delete
    2. Yes, it will be useful if you can post few shell script commands, putty commands for basic operations like searching an object, moving to a different path, etc.

      Delete

Oracle Database Administrator