My Oracle Support Banner

Issues When Attempting To Access Approvals Administrator Responsibility (Doc ID 390500.1)

Last updated on NOVEMBER 06, 2023

Applies to:

Oracle Approvals Management - Version to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


When attempting to sign on using the AME responsibility Approvals Management Administrator, the following error occurs.

## Detail 0 ##
java.sql.SQLException: ORA-01722: invalid number

at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.ttc7.TTIoer.processError(
at oracle.jdbc.ttc7.Oall7.receive(

The issue can be reproduced at will with the following steps:

1. Login as Administrator.
2. Select the User Management responsibility.
3. Select the Users page.
4. Search for the user to grant AME roles.
5. In the results table, click Update. In the Update User page, the user details are viewed along with a list of roles available to the user.
6. Click Assign Roles.
7. Select the roles from the resulting list and click Apply

1. Login as Administrator.
2. Select the Functional Administrator responsibility.
3. Select the Grants tab.
4. Click Create Grant.
5. Select Specific User as grantee type.
6. Select the user as grantee key.
7. Select AME Transaction Types as object:
8. All rows: This grants access to all AME Transaction Types to the User
9. Instance: This grants access to a specific AME Transaction Type specified by the following parameters: FND_APPLICATION_ID => Application ID of the application to which the transaction type belongs TRANSACTION_TYPE_ID => Unique identifier of the AME Transaction type within application
10. Instance set: This grants access to one or more AME Transaction Types specified by the following parameters:

• Use the predefined instance set AME Transaction Type Instance Set.
• In the next page, select FND_APPLICATION_ID as Parameter1 and a wild card search string for TRANSACTION_TYPE_ID as Parameter2.

11. In the next page there will be three options for instance type: select AME Calling Applications as the permission set.
12. Review and Finish.
13. Set the AME: Installed profile option to Yes for Advanced Benefits and Human Resources applications
14. Login as user and click on the Approvals Management Administrator




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.