About Me.

My self Adinarayana working as Implementation Application DBA with advanced technologies like RAC/PCP,OID/SSO,DMZ,Exadata and Fusion Middleware i.e Demantra,Application Server,SOA,FMW,BPEL and UPK. Created this blog to share the useful information related to DBA and Application DBA Your comments and suggestions are most welcome. Disclaimer: Please note all the views and opinions expressed in this site are my own. It's not recommend to use the fixes/suggestions provided in this site directly in production instance, please test them before implementing.

Sunday, July 21, 2013

Compiling Forms & Reports in R12

Using the OracleAS 10.1.2 Forms and Reports Builders with Oracle Applications Release 12 (Doc ID 444248.1)
How to Convert Forms/ Libraries/ Menus Files From Binaries to Text and Back From the Command Line (Doc ID 200258.1)

R11:

f60gen module=ARXTWMAI.pll userid=APPS/**** output_file=ARXTWMAI.plx module_type=library batch=yes compile_all=special

Gererate forms in R12:

 frmcmp_batch module=/TEST/apps/apps_st/appl/au/12.0.0/forms/US/JGZZVACF.fmb userid=APPS/***** output_file=/sgom/apps/apps_st/appl/jg/12.0.0/forms/US/JGZZVACF.fmx
module_type=form batch=yes compile_all=special

Section 5: Compiling Forms :

frmcmp_batch.sh module=/TEST/testappl/au/12.0/forms/US/ARXTWMAI.fmb userid=APPS/APPS output_file=/TEST/testappl/ar/12.0/forms/US/ARXTWMAI.fmx module_type=form
compile_all=special

frmcmp_batch.sh module=/TEST/testappl/au/12.0/resource/APPCORE.pll userid=APPS/APPS output_file=/TEST/testappl/au/12.0/resource/APPCORE.plx module_type=library

compile_all=special

Compiling Reports on R12:

rwconverter.sh userid=APPS/APPS source=$FND_TOP/reports/US/FNDATREP.rdf stype=rdffile dtype=rdffile overwrite=yes batch=yes compile_all=yes

rwconverter.sh userid=APPS/APPS source=$FND_TOP/reports/US/FNDATREP.rdf dest=/tmp/FNDATREP.rdf stype=rdffile dtype=rdffile overwrite=yes batch=yes compile_all=yes

rwconverter.sh userid=apps/apps source=$AU_TOP/plsql/BISRPRT.pll stype=pllfile dtype=pllfile overwrite=yes batch=yes compile_all=yes

rwconverter.sh userid=apps/apps source=$AU_TOP/plsql/BISRPRT.pll dest=/tmp/BISRPRT.pll stype=pllfile dtype=pllfile overwrite=yes batch=yes compile_all=yes



No comments:

Post a Comment