Showing posts with label FNDLOAD. Show all posts
Showing posts with label FNDLOAD. Show all posts

Thursday, November 2, 2017

MOVE CONCURRENT PROG DEF FROM ONCE INSTANCE TO ANOTHER INSTANCE

Valueset
=========

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXRS_CUST_PRICING_TYPE_NEW_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XXRS_CUST_PRICING_TYPE_NEW"


Concurrent Program Definition
======================================

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRS_WIP_PROD_TIME.ldt PROGRAM APPLICATION_SHORT_NAME="XXRS" CONCURRENT_PROGRAM_NAME="XXRS_WIP_PROD_TIME"


XXRSOE_CUST_PRICING

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRSOE_CUST_PRICING.ldt PROGRAM APPLICATION_SHORT_NAME="ONT" CONCURRENT_PROGRAM_NAME="XXRSOE_CUST_PRICING"


Data Definition and Template Registration
======================================

FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct XXRS_WIP_PROD_TIME_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXRS' DATA_SOURCE_CODE='XXRS_WIP_PROD_TIME' TMPL_APP_SHORT_NAME='XXRS' TEMPLATE_CODE='XXRS_WIP_PROD_TIME'



DATA_TEMPLATE (Data Source .xml file)
=====================================

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XXRS_WIP_PROD_TIME -APPS_SHORT_NAME XXRS -LANGUAGE en -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $XXRS_WIP_PROD_TIME_D


RTF TEMPLATE (Report Layout .rtf file)
======================================

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))' -LOB_TYPE TEMPLATE -LOB_CODE XXRS_WIP_PROD_TIME -APPS_SHORT_NAME XXRS -LANGUAGE en -TERRITORY 00 -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $XXRS_WIP_PROD_TIME_DT



Bursting File
=============
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))" -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME XXRS  -LOB_CODE  XXRS_ASN_ERROR_RPT -LANGUAGE en  -XDO_FILE_TYPE XML-BURSTING-FILE -FILE_NAME XXRS_ASN_ERROR_RPT_BURST.xml -CUSTOM_MODE FORCE


===================
upload commands
===================

Valueset
=========
$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XXRS_CUST_PRICING_TYPE_NEW_VS.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


Concurrent Program
===================

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRS_WIP_PROD_TIME.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE




Data Definition and Template Registration
======================================

FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXRS_WIP_PROD_TIME_DD.ldt


DATA_TEMPLATE (Data Source .xml file)
=====================================

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=UAT)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XXRS_WIP_PROD_TIME -XDO_FILE_TYPE XML -FILE_NAME $DATA_FILE_PATH/$DATA_FILE_NAME.xml -APPS_SHORT_NAME XXRS -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME


RTF TEMPLATE (Report Layout .rtf file)
======================================

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=DEV)))' -LOB_TYPE TEMPLATE -LOB_CODE XXRS_ASN_ERROR_RPT -XDO_FILE_TYPE RTF -FILE_NAME $XXRS_TOP/XXRS_ASN_ERROR_RPT_en_US.rtf -APPS_SHORT_NAME XXRS -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME



Bursting File
=============

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION  "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=290098-vm4.testdb.rsne.com)(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=DEV)))"  -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME XXRS  -LOB_CODE  XXRS_ASN_ERROR_RPT -LANGUAGE en  -XDO_FILE_TYPE XML-BURSTING-FILE -FILE_NAME XXRS_ASN_ERROR_RPT.xml -CUSTOM_MODE FORCE


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