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.