Skip to content
Advertisements

Concurrent program migration

If your developer asked you to migrate concurrent program from dev or UAT to production, As a system administrator you need to do follow steps

 

Example :

Concurrent Program :

Concurrent program name : XX Report for Statement

Shortcut : xx_rep_stat

Application : XX Custom Application

 

XML Publisher :

Data definition code : xx_rep_stat

Template (rtf) :  XX Report for Statement.rtf

 

rdf file on the custom top

Report File (rdf): xx_rep_stat.rdf

Step 1: 
On development

System Administrator — > Concurrent  –> Program –> define

Query — > “XX Report for Statement”

Download the ldt file on application tier :

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct  xx_rep_stat.ldt PROGRAM CONCURRENT_PROGRAM_NAME=’XX_REP_STAT’  APPLICATION_SHORT_NAME=’XXREP’

How to find out application short name :

SELECT fa.application_id “Application ID”,
fat.application_name “Application Name”,
fa.application_short_name “Application Short Name”,
fa.basepath “Basepath”
FROM fnd_application fa,
fnd_application_tl fat
WHERE fa.application_id = fat.application_id
AND fat.language = USERENV(‘LANG’) and fat.application_name =’XX Custom Application’
— AND fat.application_name = ‘Payables’ — <change it>
ORDER BY fat.application_name;

The output — > “XXREP”

Once downloaded ldt file, you please copy to production application server which is concurrent program running server. If its linux, you please use SCP to transfer the file or winscp

Step 2:

On development,

Download the Template

XML Publisher Administrator — >

Query code –> ” xx_rep_stat”

Download the rtf and save it on your desktop

Step 3:

On Production,

Upload the ldt file on production server which you’re copied ldt file.

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct xx_rep_stat.ldt

Once uploaded, you please check on your application whether its uploaded or not

 

System Administrator — > Concurrent  –> Program –> define

Query — > “XX Report for Statement”

 

Step 4: 

Transfer the “xx_rep_stat.rdf” file from development custom top report to production custom top report location

Step 5: 

On production application,

Create data definition and template as same as development

–> create data definition

Once Done Data definition,

–> create Template

Here you please upload that Template file which you’re downloaded from development.

Example :

Create Data Definition :

 

Create Template

 

Step 6:

Please check with your developer any Objects you need to migrate to production which is related to this report.

If yes, please migrate those objects also from development to production

 

Step 7: 

Add your report file to related request group

 

Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: