Hi could you please share any ex. of the Purchase requisition approval page and provide some additional screenshots to understand the exact requirement?

The only way to restrict it is through applying data security at the code level.

Have you checked the role_code column for the approver present under po_action_history?

Hi @User_1U7TA Kindly try to check it under FND tables.

@Amitabha You can use the below logic present under the where clause to fetch the latest ESS job id. Let me know if found helpful. please modify it as per your need. SELECT a.payment_service_request_id, SUM(a.payment_amount) amt FROM hr_organization_units hou, iby_payments_all a, iby_pay_service_requests ipsr WHERE 1 = 1…