[apdba@oracledb1 ~]$ cd $GL_TOP
[apdba@oracledb1 12.0.0]$ ls
admin forms html
lib mds mesg
patch sql
bin help java
log media out
reports
[apdba@oracledb1 12.0.0]$ cd reports/
[apdba@oracledb1 reports]$ ls
US
[apdba@oracledb1 reports]$ cd US/
[apdba@oracledb1 US]$ ls
GLCRDR.rdf GLRTB2.rdf GLXCLVAL.rdf GLXRBUDA.rdf
GLXRLRUR.rdf
GLGDOCDE.rdf GLRTBD.rdf GLXCOCRR.rdf GLXRCAUT.rdf
GLXRLSEG.rdf
GLGENCRE.rdf GLRTR1.rdf GLXDALST.rdf GLXRCTRS.rdf
GLXRLSUS.rdf
GLGVFNAV.rdf GLWACCTR.rdf GLXDDA.rdf
GLXRDRTS.rdf GLXRLTCL.rdf
GLGVOPEN.rdf GLXACDAL.rdf GLXDFLST.rdf
GLXRLACH.rdf GLXRLVAT.rdf
GLRFCLD.rdf GLXAVADT.rdf GLXDFUSR.rdf
GLXRLBOL.rdf GLXRSUOM.rdf
GLRFGNJ.rdf GLXAVTRB.rdf GLXETB.rdf
GLXRLCOA.rdf GLXUSA.rdf
GLRGCBGT.rdf GLXBCRBC.rdf GLXJETAX.rdf
GLXRLFBL.rdf GLXXTB.rdf
GLRGNJ.rdf GLXBCSD.rdf GLXLSLST.rdf
GLXRLHST.rdf GLYRLBGE.rdf
GLRGNL.rdf GLXBOR.rdf GLXRBCR.rdf GLXRLMAB.rdf
GLYRLGLG.rdf
GLRJED.rdf GLXBTB.rdf GLXRBDHR.rdf GLXRLRFL.rdf
GLYRLJGE.rdf
GLRSGNJ.rdf GLXCAR.rdf GLXRBJRN.rdf GLXRLRUD.rdf
GLYRLJRE.rdf
Take backup of two .rdf files and we will regenerate them using adadmin
Take backup of two .rdf files and we will regenerate them using adadmin
[apdba@oracledb1 US]$ mv GLCRDR.rdf GLCRDR.rdf.bkp
[apdba@oracledb1 US]$ mv GLYRLJRE.rdf GLYRLJRE.rdf.bkp
[apdba@oracledb1 US]$
[apdba@oracledb1 US]$
[apdba@oracledb1 US]$ adadmin
Copyright
(c) 2002 Oracle Corporation
Redwood
Shores, California, USA
Oracle
Applications AD Administration
Version 12.0.0
NOTE: You may not use this utility for custom development
unless you have written
permission from Oracle Corporation.
Your default directory is '/u01/apdba/apps/apps_st/appl'.
Is this the correct APPL_TOP [Yes] ?
AD Administration records your AD Administration session in a text file
you specify. Enter your AD
Administration log file name or press [Return]
to accept the default file name shown in brackets.
Filename [adadmin.log] :
************* Start of AD Administration session *************
AD Administration version: 12.0.0
AD Administration started at: Mon Apr 08 2013 09:00:20
APPL_TOP is set to /u01/apdba/apps/apps_st/appl
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?
Please enter the batchsize [1000] :
Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.
The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.
Sample Applications System names are: "prod",
"test", "demo" and
"Development_2".
Applications System Name [PROD] : PROD *
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.
Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.
Example 2: If you don't have forms files installed in this area, you
cannot
generate them or run them from this APPL_TOP.
Example 3: If you don't have concurrent program files installed in this
area,
you cannot relink concurrent programs or generate reports from this
APPL_TOP.
Do you currently have files used for installing or upgrading the
database
installed in this APPL_TOP [YES] ? YES *
Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *
Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *
Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *
Please enter the name Oracle Applications will use to identify this
APPL_TOP.
The APPL_TOP name you select must be unique within an Oracle
Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.
Sample APPL_TOP Names are: "prod_all",
"demo3_forms2", and "forms1".
APPL_TOP Name [oracledb1] : oracledb1 *
You are about to use or modify Oracle Applications product tables
in your ORACLE database 'PROD'
using ORACLE executables in '/u01/apdba/apps/tech_st/10.1.2'.
Is this the correct database [Yes] ?
AD Administration needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
Enter the password for your 'SYSTEM' ORACLE schema:
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] :
AD Administration is verifying your username/password.
The status of various features in this run of AD Administration is:
Saving product information.
AD code level : [B.1]
AD Administration
Main Menu
--------------------------------------------------
1. Generate Applications Files menu
2. Maintain Applications Files menu
3. Compile/Reload Applications Database
Entities menu
4. Maintain Applications Database Entities
menu
5. Change Maintenance Mode
6. Exit AD Administration
Enter your choice [6] : 1
Generate Applications
Files
----------------------------------------
1. Generate message files
2. Generate form files
3. Generate report files
4. Generate product JAR files
5. Return to Main Menu
Enter your choice [5] : 3
AD utilities can support a maximum of 999 workers. Your
current database configuration supports a maximum of 73 workers.
Oracle recommends that you use between 4 and 8 workers.
Enter the number of workers [4] :
Your current character set is "UTF8".
Do you want to generate Oracle Reports objects
using this character set [Yes] ?
Do you want to regenerate Oracle Reports PL/SQL library files [Yes] ?
Do you want to regenerate Oracle Reports executable files [Yes] ?
Enter list of products ('all' for all products) [all] : GL
Generate specific reports objects for each selected product [No] ?
The current set of installed languages is: US
Please select languages for generating Oracle Reports files.
You may select all of the above languages, or just a subset.
Enter list of languages ('all' for all of the above) [all] :
You selected the following languages: US
Is this the correct set of languages [Yes] ?
Reading product report information...
Selecting Oracle Reports PL/SQL library files to generate...
Selecting library files for General Ledger...
Selecting product reports to generate...
Selecting reports for General Ledger...
Generating Oracle Reports objects...
Creating the AD_UTIL_PARAMS table...
Table AD_UTIL_PARAMS already exists, so dropping the table and
recreating it.
Creating FND_INSTALL_PROCESSES table...
Writing dependencies of jobs to run to appldep.txt file...
There are now 60 jobs remaining (current phase=admin+1):
0 running, 60 ready to run
and 0 waiting.
Reading completed jobs from restart file (if any).
There are now 60 jobs remaining (current phase=admin+1):
0 running, 60 ready to run
and 0 waiting.
Determining which java executables are supported by adJavaWorker...
Starting worker processes.
Worker process 1 started.
Worker process 2 started.
************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Mon Apr 08 2013 09:02:04
APPL_TOP is set to /u01/apdba/apps/apps_st/appl
Worker process 3 started.
************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Mon Apr 08 2013 09:02:04
APPL_TOP is set to /u01/apdba/apps/apps_st/appl
************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Mon Apr 08 2013 09:02:04
APPL_TOP is set to /u01/apdba/apps/apps_st/appl
Worker process 4 started.
Checking if all jobs have their actual and symbolic arguments in
sync....
Done.
Writing jobs to run to restart file.
Reading jobs from FND_INSTALL_PROCESSES table ...
************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Mon Apr 08 2013 09:02:04
APPL_TOP is set to /u01/apdba/apps/apps_st/appl
Done reading jobs from FND_INSTALL_PROCESSES table ...
Telling workers to read 'todo' restart file.
Done.
Starting phase 1001 (admin+1): Generate Report Files
There are now 60 jobs remaining (current phase=admin+1):
0 running, 60 ready to run
and 0 waiting.
There are now 0 jobs remaining (current phase=Done):
0 running, 0 ready to run and
0 waiting.
Telling workers to quit...
All workers have quit.
Dropping FND_INSTALL_PROCESSES table...
FND_INSTALL_PROCESSES table dropped.
Dropping AD_DEFERRED_JOBS table...
AD_DEFERRED_JOBS table dropped.
Copying files to destination ...
Done copying files to destination.
Review the messages above, then press [Return] to continue.
Backing up restart files, if any......Done.
Now go and check in $GL_TOP
Now go and check in $GL_TOP
[apdba@oracledb1 ~]$ cd $GL_TOP
[apdba@oracledb1 12.0.0]$ ls
admin forms html lib mds mesg patch sql
bin help java log media out reports
[apdba@oracledb1 12.0.0]$ cd reports/
[apdba@oracledb1 reports]$ ls
US
[apdba@oracledb1 reports]$ cd US/
[apdba@oracledb1 US]$ ls GLCRDR.rdf GLYRLJRE.rdf
GLYRLJRE.rdf GLYRLJRE.rdf
Note:--Regenerating of report files is completely dependant on licensing
GLYRLJRE.rdf GLYRLJRE.rdf
Note:--Regenerating of report files is completely dependant on licensing
No comments:
Post a Comment