Payables and Cash Management - EBS (MOSC)

MOSC Banner

Approval Groups Dynamic query issue

edited Dec 12, 2013 1:30PM in Payables and Cash Management - EBS (MOSC) 5 commentsAnswered
 Hi Folks,
Our requirement as follow.


If user submitting expense report for "2000" Supervisor approval (Supervisor hierarchy) , then chain of approval hierarchy level by amount required.

While defining chain of authority approvals, I have defined Approval group along with following SQL condition.


SELECT paf.supervisor_id
FROM per_people_x ppx, per_assignments_f paf
WHERE ppx.person_id = paf.person_id
AND paf.supervisor_id is not null
and level = 2
CONNECT BY PRIOR paf.supervisor_id = ppx.person_id
START WITH paf.person_id = (select employee_id from ap_expense_report_headers_all where report_header_id= :transaction_id)


When I am trying to submit expense report for approval, system is displaying following error message

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