Invoice Proxy Approver Details Not Stored (Doc ID 2045841.1)

Last updated on MARCH 17, 2016

Applies to:

Oracle Workflow - Version 12.2.2 to 12.2.2 [Release 12.2]
Information in this document applies to any platform.

Goal

Scenario:

User "A" setups user "B" as proxy approver on invoices.
2. User "B" submits invoice for approval that is submitted to user "X" as first level approver.
3. User "X" approves the invoice and requisition is forwarded to user "B" for final approval.
4. As user "A" has granted proxy role to user "B", notification is accessed by user "B" and user "B" approves invoice using proxy roles.


Invoice approval history table AP_INV_APRVL_HIST_ALL doesnt store any details of user "B".
The goal is to  to generate a report of all invoices approved by delegated users but base tables doesnt store the data.

Description :

When a user has a proxy access to some other user in EBS and it acts as a proxy and perform some action on the notifications (like reassgin, approveetc) , the value of Proxy user is not stored anywhere , instead the name of Granter (the User whose worklist has been accessed) is getting stored in the proxy_role column of WF_COMMENTS table.

 

 

Solution

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