AME: Error: Ensure The Query Selects Exactly 1 Column (Doc ID 1901092.1)

Last updated on JULY 12, 2016

Applies to:

Oracle Approvals Management - Version 12.1 HRMS RUP4 and later
Information in this document applies to any platform.

Symptoms

On : 12.1 HRMS RUP4 version, AME Setup issues

When attempting to create a dynamic approver group, the following error occurs when pushing the [Validate] button and the approver group cannot be saved

Ensure the query selects exactly 1 column


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

1. (resp.): Approvals Management Business Analyst > Setup > Approver Groups
2. Push [Create] button
3. Make sure property 'Usage Type' = "Dynamic"
4. Enter the following query:

select 'person_id:' || A.person_id from TABLE(xxzitg_ame_approvals_pkg.get_approver_list(:transactionId,'APPROVER')) A ORDER BY ID

  
5. Push [Apply] button
The error occurs and the approver group cannot be saved


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms