This content has been marked as final. Show 2 replies
Hi Chetan ,1 person found this helpful
You could write a query to get the person id like below
SELECT 'person_id:'||xxx_AME_PKG.GETApprover1(:transactionId) FROM DUAL
where your logic of your approver selection could be in a custom package and in a function which returns teh person id.
Try this hopefully it should work.
By the way did you get the answer as how you can use change first approver as I am trying to use the change first approver button and it does not change the first approver for me after i click apply .
Yes, we need to return back the person id in the format 'PER: '||person_id from the dynamic sql. The issue is now resolved. Apparently although Oracle AME supports personnels from PER, FND, TCA, iProcurement recognizes persons only from PER. So a custom action type was created to achive this.