Add Payment approval history like Payment approval/rejection,approver name etc in OTBI similar to Jo — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Add Payment approval history like Payment approval/rejection,approver name etc in OTBI similar to Jo

41
Views
3
Comments

Description

Add Payment approval history like Payment approval/rejection date,approver name etc in OTBI similar to Journal approval history

Use Case and Business Need

Hi

We need payment batch approval history for 1 year to submit to external auditors.

In OTBI for payment history subject area or payment disbursement subject area there is no fields for payment approval history like approval date,approved/rejected by etc

The approval history is available in OTBI in other subject areas like Invoices,Journals etc in Financial and Requisition etc in Procurement

This is needed for compliance purposes.

 

Thanks

Palash

 

 

Original Idea Number: 03f4006331

Tagged:
2
2 votes

Submitted · Last Updated

Comments

  • Becky Alvarez
    Becky Alvarez Rank 3 - Community Apprentice

    Moved from Financials Idea Lab.

  • Varun Dhondea
    Varun Dhondea Rank 2 - Community Beginner

    Hi,

    This is a very important feature for audit purposes specially since electronic payments are very common.

    Thanks

  • Sreekanth Reddy Pothula
    Sreekanth Reddy Pothula Rank 1 - Community Starter

    Use the below Query - 

    SELECT payment.call_app_pay_service_req_code        Payment_Batch_Name, 
           To_char(payment.creation_date, 'MM-DD-YYYY') Payment_Batch_Creation_Date, 
           payment.created_by, 
           bpm_task.approvers, 
           payment.payment_service_request_status 
    FROM   fusion.fnd_bpm_task_assignee bpm_assignee, 
           fusion.fnd_bpm_task_b bpm_task, 
           fusion.fnd_bpm_task_history_b bpm_hist, 
           fusion.iby_pay_service_requests payment 
    WHERE  bpm_task.task_id = bpm_hist.task_id 
           AND bpm_hist.task_id = bpm_assignee.task_id 
           AND bpm_hist.version = bpm_assignee.version 
           AND bpm_hist.outcome_code = 'APPROVE' 
           AND bpm_hist.status_code = 'COMPLETED' 
           AND payment.payment_service_request_status = 'COMPLETED' 
           AND bpm_task.identification_key = 
               To_char(payment.payment_service_request_id) 
           AND payment.call_app_pay_service_req_code LIKE '%ACH%' -- PAYMENT REQUEST NAME
    ORDER  BY payment.creation_date DESC