Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

PO-Requisition cross-subject area report

edited Sep 26, 2019 5:01AM in Reporting and Analytics for ERP 2 comments

Summary

PO-Requisition cross-subject area report in fusion saas

Content

I am trying to create a simple cross-subject OTBI Analysis to display PO details alongwith the Requisition details and Requisition Preparer. I tried using combination of Procurement - Purchasing Real Time/Procurement - Requisitions Real Time/Procurement - Procure to Pay Real Time subject areas but not able to get the join condition working between PO distribution and Requsition distribution.

For example, if I use below logical query, the PO data is displayed correctly but the data from requistion is resulting in a cross-product. Is there a way to use the subject areas here to display the columns logically?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!