Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Add Payment approval history like Payment approval/rejection,approver name etc in OTBI similar to Jo

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
Comments
-
Moved from Financials Idea Lab.
0 -
Hi,
This is a very important feature for audit purposes specially since electronic payments are very common.
Thanks
0 -
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 DESC0