MOVE CONCURRENT PROGRAM DEFINITION FROM ONE INSTACNE TO ANOTHER INSTANCE

MOVE CONCURRENT PROGRAM DEFINITION FROM ONE INSTACNE TO ANOTHER INSTANCE

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

àConnect to PUTTY

àLOGIN WITH THE CREADENTIALS

àRUN THE COMMAND   "ps -ef|grep inh" FOR PATHS

àset the environment by the above paths(/us1001/DEV/apps/apps_st/appl)

àrun the evinronment command (". APPSDEV_phl3dsjpmtdb01.env")

àThen run the command “sqlplus” for connectiong to DB with username & password

àCREATE ONE DIRECTORY IN THE SPECIFIC PATH(Optional) for all files in ONE FOLDER EASY TO DOWN LOAD AND MOVE THE FILES

àFIRST RUN THE BELOW COMMAND FOR CONCURRENT PROGRAM DEFINITION

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

EXPLANATION

apps/apps—DB username and password

JMORDERINTERFACE_FND.ldt—FOR CREATING A FILE

JM-- APPLICATION_SHORT_NAME

JMORDERINTERFACE_FND--CONCURRENT_PROGRAM_NAME

àThen we need to run the below command for DATA DEFINITION & TEMPLATE CODE DEFINITION

FNDLOAD apps/apps O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct JMORDERINTERFACE_FND_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='JM' DATA_SOURCE_CODE='JMORDERINTERFACE_FND' TMPL_APP_SHORT_NAME='JM' TEMPLATE_CODE='JMORDERINTERFACE_FND'

EXPLANATION

apps/apps—DB username and password

JMORDERINTERFACE_FND_DD.ldt—FOR CREATING A FILE IN THE SPECIFIC FOLDER.

JM-- APPLICATION_SHORT_NAME

JMORDERINTERFACE_FND-- DATA_SOURCE_CODE(data definition code)

JMORDERINTERFACE_FND—Template code

àNext, We need to run the below command for getting the RTF TEMPLATE FILE FROM THE APPLICATION and creating that file in specific folder.

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=phl3dsjpmtdb01.jacmel.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=DEV)))' -LOB_TYPE TEMPLATE -LOB_CODE JMORDERINTERFACE_FND -APPS_SHORT_NAME JM -LANGUAGE en -TERRITORY US -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $JMORDERINTERFACE_FND_DT

EXPLANATION

JDBC_CONNECTION—need to give the TNS NAMES

JMORDERINTERFACE_FND—LOB_CODE(LOB code from XML Publisher Responsibility)

JM-Application short name

En—laguage in template

US—territory

àThen we need to run the below command for getting BURSTING CONTROL FILE FROM APPLICATION to specific folder.

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=phl3dsjpmtdb01.jacmel.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=DEV)))" -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME JM  -LOB_CODE  JMORDERINTERFACE_FND -LANGUAGE en  -XDO_FILE_TYPE XML-BURSTING-FILE -FILE_NAME burst_JMORDERINTERFACE_FND.xml -CUSTOM_MODE FORCE

àall files got created in specific folder which you create first

àthen download the folder using SSH OR WINSCP to local machine

àNow connect to WINSCP with the destination Instance which you want to move the concurrent def

àmove the downloaded folder file to the new instance then follow the steps..

àConnect to PUTTY

àLOGIN WITH THE CREADENTIALS

àRUN THE COMMAND   "ps -ef|grep inh" FOR PATHS

àset the environment by the above paths(/us1001/DEV/apps/apps_st/appl)

àrun the evinronment command (". APPSDEV_phl3dsjpmtdb01.env")

àThen run the command “sqlplus” for connectiong to DB with username &

 password

àCREATE ONE DIRECTORY IN THE SPECIFIC PATH(Optional) for all files in ONE FOLDER EASY TO DOWN LOAD AND MOVE THE FILES

àThen we need to upload the downloaded files and concurrent prog Definition.

àRun the below command for uploading the CONCURRENT PROGRAM DEFINITION

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

àRun the below command for UPLOADING THE DATA DEFINITION & TEMPLATE DEFINITION

FNDLOAD apps/j27d1wnf O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct JMORDERINTERFACE_FND_DD.ldt

àRun the below command for UPLOADING THE RTF TEMPLATE FILE

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD j27d1wnf -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=phl3dsjpmtdb01.jacmel.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST)))" -LOB_TYPE TEMPLATE -LOB_CODE JMORDERINTERFACE_FND -XDO_FILE_TYPE RTF -FILE_NAME $JMINTRFACEORDER TEMPLATE_SOURCE_JM_JMORDERINTERFACE_FND_en_US.rtf -APPS_SHORT_NAME JM -NLS_LANG en -TERRITORY US -LOG_FILE $JMORDERINTERFACE_FND_LOG

àRun the below command for UPLOADING THE BURSTING CONTROL FILE

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD j27d1wnf -JDBC_CONNECTION  "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=phl3dsjpmtdb01.jacmel.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST)))"  -LOB_TYPE BURSTING_FILE -APPS_SHORT_NAME JM  -LOB_CODE  JMORDERINTERFACE_FND -LANGUAGE en  -XDO_FILE_TYPE XML-BURSTING-FILE -FILE_NAME BURSTING_FILE_JM_JMORDERINTERFACE_FND.xml -CUSTOM_MODE FORCE

àDONE FOR THE PROCESS  NEEDS TO CHECK WHEATHER ALL THE CONCURRENT PROGRAM DEFINITIONS , RTF FILES, BURSTING CONTROL FILES.