Purpose of Utility Script
This reporting utility script will allow a snapshot to be taken of the AME set-up for a specified transaction type (ie Setup Report for the transaction Type).
It will report on the following
- AME Setup Data for a Transaction Type
- Invalid Approvers in the setup
- Invalid AME Objects
- AME Patch Level
- AME Key Files Versions
The output of this utility script is an HTML document.
Steps to generate the Setup Report
There are 2 steps involved in generating the setup report. The first step we need to identify the AME’s internal application id for the transaction type in question. The second step is the actually running the script which generates the setup report.
Step 1 : Identify the AME Internal ID for the Transaction Type.
AME assigns a internal ID (also known as AME application ID) for each transaction type. The utility script generates the setup report based on this ID. The following details on how to identify the correct application ID for your Transaction Type.
Run the following SQL from SQLPLUS under ‘apps’ account.
Select decode(
to_char(nvl(fnd_profile.value('AME_INSTALLATION_LEVEL')
,'Pre-AME.B'))
,'Pre-AME.B','Pre-AME.B'
,'1','Pre-AME.B'
,'1.1','Pre-AME.B'
,'2','Post-AME.B'
,'Post-AME.B')
From Dual;
If the value returned 'Pre-AME.B' then do the following
1. Login to AME Application using ‘AME Application Administrator’ responsibility.
2. Select ‘Admin’ tab
3. Choose "Application Administration" and continue.
4. Choose "Maintain Transaction Types" and continue.
5. Click on your transaction type.
6. AME-Internal ID of the choosen transaction type will be displayed on "Edit Transaction Type" page.
If the value returned by step is 'Post-AME.B' then do the following
1. Login to AME Application using "Approvals Management Administrator" responsibility.
2. Search for your transaction type
3. Click on the transaction type
4. AME-Internal ID of the choosen transaction type will be displayed.
Note: Please note that the AME Internal ID (Application ID) is usually a negative integer.
Make a note of the AME Internal ID
Step 2 : Running the script
Run the following SQL from SQLPLUS under ‘apps’ account.
Select decode(
nvl(fnd_profile.value('AME_INSTALLATION_LEVEL')
,'Pre-11.5.10')
,'Pre-11.5.10','Pre-11.5.10'
,'Post-11.5.10')
From Dual;
If the value returned by step is ‘Pre-11.5.10', then run the script 1
If the value returned by step is ‘Post-11.5.10', then run the script 2
The utility script should be run in an SQLPLUS session using ‘apps’ account. The AME-internalID identified in Step 1 should be applied as a parameter to the script as specified below.
Usage : sqlplus apps/<pwd>@dbname @file_name AME-InternalID
Example : sqlplus apps/apps@hrprodenv @get_ame_setup -200
