AD Utilities

AD Administration	adadmin Oracle Application Manager	Performs maintenance tasks on the Oracle Applications file system and database.
AutoPatch	adpatch	Applies patches to the Oracle Applications and Oracle database (also you can add new languages and products as a patch).
AD Controller	adctrl	Which this utility you can restart, see the status of parallel workers in AutoPatch, AD Administration and AutoUpgrade.
AutoUpgrade	adaimgr	Upgrades your database code and objects from an old version to the last 11i version. This is a time consuming step.
AD Relink	adrelink	Used to re-link apps executables with product libraries. This must be done if some library definition is changed or an executable is corrupted.
AD Merge Patch	admrgpch	Used to merge multiple patches into a single one. This is useful when we have to apply many patches to reduce the patching time.
AD Splicer	adsplice	Used to register the off-cycle products (a new oracle released product which is not delivered with the initial package).
File Character Set Converter	adncnv	Used to convert a file from one character set to another.
AD Configuration	$AD_TOP/sql/adutconf.sql	Shows information about the installed configuration of the APPS.
AD Job Timing Report	$AD_TOP/admin/sql/adtimrpt.sql	Shows timing statistics about the parallel workers.
AD File Identification	adident	Shows the header file of one Oracle Application file. In the header we can see the version and the timestamp of the file.
License Manager	Oracle Application Manager	Licenses products, country-specific functionalities or languages.
Patch Wizard	Oracle Application Manager	Determines which patches was applied and which need to be applied.
Applied Patches	Oracle Application Manager	Keeps a history of the patches which have been applied.

FNDLOAD

To download

On source: FNDLOAD apps/xxxxxx O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct GL_SUPERUSER.ldt MENU MENU_NAME="GL_SUPERUSER"


To upload

On Target: FNDLOAD apps/xxxxxx O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct GL_SUPERUSER.ldt MENU MENU_NAME="GL_SUPERUSER"

SQL Queries for Parameter description

SQL> show parameter background_dump

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest                 string      /u0x/oracle/PROD/db/tech_st/11
                                                 .2.0/admin/XXXX/diag/
                                                 rdbms/XXX/XXX/trace


SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      /u06/oracle/proddata/cntrl01.d
                                                 bf, /u06/oracle/proddata/cntrl
                                                 02.dbf, /u06/oracle/proddata/c
                                                 ntrl03.dbf
control_management_pack_access       string      DIAGNOSTIC+TUNING

SQL> show parameter log

will display all the parameters info about logs

SQL> show parameter

will display all the parameters info