HRMS Approvals Management (AME) Reporting Utility Support Tool

HRMS Approvals Management (AME) Reporting Utility Support Tool [ID 287255.1]

--------------------------------------------------------------------------------

Modified 27-MAY-2010 Type SCRIPT Status PUBLISHED

Oracle Approvals Management (AME)

AME Set-up Utility Report


Checked for relevance on 01-May-2009

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(to_char(

nvl(fnd_profile.value('AME_INSTALLATION_LEVEL')

,'Pre-AME.B'))

,'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/@dbname @file_name AME-InternalID
Example : sqlplus apps/apps@hrprodenv @get_ame_setup -200


Attachments



--------------------------------------------------------------------------------
getPost11510AMESetup.sql (69.43 KB)
getPre11510AMESetup.sql (30.81 KB)


Related



--------------------------------------------------------------------------------
Products
--------------------------------------------------------------------------------

Oracle E-Business Suite > Human Capital Management > Human Resources > Oracle Approvals Management
Keywords
--------------------------------------------------------------------------------
UTILITY; AME




Back to top

Rate this document

Article Rating
Rate this document
Excellent
Good
Poor

Did this document help you?
Yes
No
Just browsing

How easy was it to find this document?
Very easy
Somewhat easy
Not easy
Comments
Provide some feedback

Cancel