Procurement - EBS (MOSC)

MOSC Banner

Using custom logic to return approvers in AME

edited Apr 17, 2015 5:55AM in Procurement - EBS (MOSC) 2 commentsAnswered

We are using an 'Approver group' that uses a  dynamic query for Purchase requisitions. The query reads our custom table and returns list of multiple approvers. The custom table contains list of approvers based on amount ranges and account code ranges. e.g. upto 10K approver 1, 10k to 20k approver 2, etc. If amount is between 10 k and 20 k, we want it to go to first approver 1 and then approver 2.

Our current query returns both approvers. The problem is we are unable to sequence them based on amount ranges. The sql in AME only allows to select one column (person_id) and sort by that. But we want to sort by Amount Ranges.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center