Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to Link Purchase Order Invoices back to Project Costs? — Cloud Customer Connect
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

How to Link Purchase Order Invoices back to Project Costs?

Received Response
47
Views
1
Comments
edited Sep 6, 2018 11:42AM in Reporting and Analytics for ERP 1 comment

Content

Hi All 

We're working on a Project Statement report that brings back a comprehensive breakdown of the project costs and revenue. For the costs, we were able to bring back Payables invoices pretty easily as they are joined via the original header/distribution/line IDs. However, we are finding it extremely difficult to bring back invoices relating to Purchase Receipts (Oracle Fusion Cost Management). I uncovered the Parent Distribution ID from Projects (pjc_exp_items_all.parent_dist_id) which does seem to link to POs but we are getting varied results (I have tried linking to the po_distribution_id from ap_invoice_distributions_all through a left outer join peia.parent_dist_id = aida.po_distribution_id (+).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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