Monday 16 December 2013

Compiling forms,libraries,reports in Oracle Apps 11i /R12

You all are may be well aware that we use f60gen for compiling forms and libraries in Oracle Applications Version 11i,But this is deprecated in R12 and we need to use frmcmp(Form Compiler) To compile forms,menus,PL/SQL libraries.

Compiling library files 
------------------------
11.5.9 and 11.5.10

$ f60gen module=/test/applmgr/11510/au/11.5.0/resource/OEXOELIN.pll userid=apps/passwd
output_file=/test/applmgr/11510/au/11.5.0/resource/OEXOELIN.plx module_type=library
batch=no compile_all=special

R12

$ frmcmp_batch module=/test/applmgr/11510/au/11.5.0/resource/OEXOELIN.pll userid=apps/passwd
output_file=/test/applmgr/11510/au/11.5.0/resource/OEXOELIN.plx module_type=library
batch=no compile_all=special


Compiling forms
-----------------
11.5.9 and 11.5.10

[applmgr@oracle vis11appl]$export FORMS60_PATH=$FORMS60_PATH:$AU_TOP/fomrs/US
[applmgr@oracle vis11appl]$ echo $FORMS60_PATH
/apps/appl/vis11appl/au/11.5.0/resource:/apps/appl/vis11appl/au/11.5.0/resource/stub:
/apps/appl/vis11appl/au/11.5.0/forms/US
[applmgr@oracle vis11appl]$

f60gen module=$AU_TOP/forms/US/APXSUMBA.fmb userid=apps/appspasswd
output_file=$PROD_TOP/forms/US/APXSUMBA.fmx module_type=form 
batch=no compile_all=special

R12
=====
$ frmcmp_batch module=<path to the fmb file> userid=apps/<apps pwd> 
output_file=<path to the fmx file> compile_all=special batch=yes

eg.

frmcmp_batch module=FNDFBMAS.fmb userid=apps/<apps password> module_type=form batch=yes compile_all=yes


Compiling reports
==================
Syntax 

adrepgen userid=APPS/APPS
source=/<full path of schema top>/reports/<report name>.rdf
dest=/<full path of schema top>/reports/<report name>.rdf stype=rdffile
dtype=rdffile logfile=<report name>.log overwrite=yes batch=yes dunit=character

Example :

adrepgen userid=apps/appspasswd source=/test/applmgr/11510/ap/11.5.0/reports/US/APXPBBLD.rdf dest=/test/applmgr/11510/admin/TEST/out/tmp001.rdf stype=rdffile dtype=rdffile logfile=/test/applmgr/11510/admin/TEST/out/adrep001.txt overwrite=yes batch=yes compile_all=yes


****what is the diff between batch=yes and no *******

If batch=yes -> it won't display the output,If  batch=no -> it will display output 

Use the same syntax to generate the report. In 11i


adrepgen userid=apps\<psswd> source = $PRODUCT_TOP\srw\filename.rdf dest=$PRODUCT_TOP\srw\filename.rdf stype=rdffile dtype=rdffile logfile=x.log overwrite=yes batch=yes dunit=character 

Parameters Explanation :
---------------------------

adrepgen :The ad utility to generate the report.
userid=apps\<psswd>   :Apps username and password
source = $PRODUCT_TOP\srw\filename.rdf  :The source file name and location
dest=$PRODUCT_TOP\srw\filename.rdf :The destination file name and location
stype=rdffile :The source file type
dtype=rdffile :The destination file type
logfile=x.log :The log file name
overwrite=yes :Whether to overwrite the existing destination file or not
batch=yes     :Suppress terminal input/output 
dunit=character :The type of the report (character/bitmap)

NOTE :R12, compiling reports is not required, just place the rdf file in the product directory (under reports/<LANG> directory). For custom reports, just make sure you can compile the report successfully using reports builder (at the client side), and copy the same file to the server.

1 comment:

  1. Oracle Apps Dba: Compiling Forms,Libraries,Reports In Oracle Apps 11I /R12 >>>>> Download Now

    >>>>> Download Full

    Oracle Apps Dba: Compiling Forms,Libraries,Reports In Oracle Apps 11I /R12 >>>>> Download LINK

    >>>>> Download Now

    Oracle Apps Dba: Compiling Forms,Libraries,Reports In Oracle Apps 11I /R12 >>>>> Download Full

    >>>>> Download LINK

    ReplyDelete