Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Anurag Jain
    AP NON PO Invoice Approval BPM process to know if Reassign...
    Topic posted May 21, 2018 by Anurag JainGreen Ribbon: 100+ Points, last edited January 30, 2019, tagged Payables, Reports 
    660 Views, 3 Comments
    Title:
    AP NON PO Invoice Approval BPM process to know if Reassign has been used
    Summary:
    AP NON PO Invoice Approval BPM process to know if Reassign has been used
    Content:

    As part of auditing requirement, we need to know during a NON PO Invoice Approval BPM process, if any particular invoice has been approved due to being reassigned. If Yes, we ant to know who the original approver was and who the reassigned approver is.

     

    Is there any way we can query this information back. Are there any standard reports which can give me this information.

     

    I have identified that the information may be contained in

     

    AP_INV_APRVL_HIST_ALL: The table contains the approval and rejection history of each invoice that passes through the Invoice Approval Workflow process. The process inserts a record for each approver assigned to review an invoice. This table corresponds to the Invoice Approval History window.

     

    Other alternative is to use "OTBI Report using Oracle provided OTBI Subject Areas"

     

    Payables Invoices – Transactions Real Time, gives us reporting capability to create an OTBI analysis to query for Invoice Approvals. See below screen shot.

     

    Please tell if it is possible to query this information through either of this 2 methods.

     

    Thanks in advance.

     

    Anurag

     

     

    Image:

    Comment

     

    • Alexey Shtrakhov

      Both Methods should be fine although in some particular cases will be hard to follow the approval chain.
      I would try first to use OTBI as it is more starighforward and includes all the information.

      If you would need more exact data then you could probably investigate on WFTASK, WFASSIGNEE tables, but you have to be aware of purging cycle on this data.
      So you could do some periodic check for most recent data and analyze it in more details.

      Otherwise would use OTBI to identify reassigned cases for certain type of business cases (e.g. nonPO)

      Alexey

      • Anurag Jain

        Many Thanks Alexey. Where can I find technical details or any documentation of all the below tables

         

        FIN_FUSION_SOAINFRA.WFTASK
        FIN_FUSION_SOAINFRA.WFASSIGNEE
        FIN_FUSION_SOAINFRA.WFCOMMENTS
        FIN_FUSION_SOAINFRA.WFATTACHMENT
        FIN_FUSION_SOAINFRA.WFTASKASSIGNMENTSTATISTIC
        FIN_FUSION_SOAINFRA.WFTASKHISTORY
        FIN_FUSION_SOAINFRA.WFMESSAGEATTRIBUTE
        FIN_FUSION_SOAINFRA.WFAPPROVALGROUPS
        FIN_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS
        FIN_FUSION_SOAINFRA.WFCOLLECTIONTARGET
        PRC_FUSION_SOAINFRA.WFTASK
        PRC_FUSION_SOAINFRA.WFASSIGNEE
        PRC_FUSION_SOAINFRA.WFCOMMENTS
        PRC_FUSION_SOAINFRA.WFATTACHMENT
        PRC_FUSION_SOAINFRA.WFTASKASSIGNMENTSTATISTIC
        PRC_FUSION_SOAINFRA.WFTASKHISTORY
        PRC_FUSION_SOAINFRA.WFMESSAGEATTRIBUTE
        PRC_FUSION_SOAINFRA.WFAPPROVALGROUPS
        PRC_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS
        PRC_FUSION_SOAINFRA.WFCOLLECTIONTARGET

         

        Regards

        Anurag

    • Alexey Shtrakhov

      I guess you can find some info on these table in Middleware documentation.
      Otherwise you can just start by this:

      SELECT          wft.CREATEDDATE as "TASK_CREATION_DATE",

                      wft.UPDATEDDATE as "TASK_LAST_UPDATE_DATE",

                      wft.STATE as "TASK_STATE",

                      wft.OUTCOME AS "TASK_OUTCOME",

                      wfa.ASSIGNEE as "TASK_ASSIGNEE",

                      wft.creator as "CREATED_BY",

                      wft.IDENTIFICATIONKEY as "INVOICE_ID",

                      i.INVOICE_NUM as "INVOICE_NUM"

             FROM       FIN_FUSION_SOAINFRA.WFTASK wft,

                        FIN_FUSION_SOAINFRA.WFASSIGNEE wfa,

                        FUSION.AP_INVOICES_ALL i

            WHERE       1=1

               AND    wfa.TASKID = wft.TASKID

               AND    wft.ASSIGNEES is not null

               AND    wft.componentname     IN ('FinApInvoiceApprovalErrorFyi', 'FinApInvoiceApproval')

               AND    wft.IDENTIFICATIONKEY = to_char(i.invoice_id)

               AND    i.invoice_num like :P_INVOICE_NUM

               

               --and  wft.state = 'ASSIGNED'

          ORDER BY    1 asc