Ability to create a OTBI report for purchasing document communication

Uma Devi Sajja-Oracle

Organization Name

The Cleveland Clinic Foundation

Description

We want to build a report for the details sent through "communicate purchasing document" task, through OTBI. This information that is needed in the report are -- PO number, the Email id to which the mail was sent, weather the mail was received by the Supplier, weather the communication was successful and other basic info. If this details can be retrieved through OTBI reports, it would be helpful to easily access the purchase document details.

Navigation:

1. Schedule process > Running ESS job > "Communicate Purchasing Documents"

2. Open a PO >  Action > Communicate

Use Case and Business Need

Client needs a report, to view the details they are sending through "communicate purchasing document" task. They also want to know the status of the communication.

More details

This data is available in fusion_orasdpm which is under SOA and BPM Infrastructure. Now, this cannot be accessed through BI Publisher, we cannot use this to build a report. We need a table with this data, which is accessible through OTBI.

Original Idea Number: 0ad7c53f54