What is the recommended way to add PO Description column to CAA? — Oracle Analytics

Oracle Fusion ERP Analytics

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

What is the recommended way to add PO Description column to CAA?

Question
10
Views
0
Comments

A frequent analysis that is done by our users is a journal and account analysis for the payables module. As payables is a journal source, it is easy to merge journal and payables information, but my analysis can go one step further to purchase order details. There are a few purchase order details available in the CAA subject area, but not many. I am specifically looking to bring in PO description which doesn't currently exist in CAA. What is the recommended way to do this?

When GL Account Analysis was active, we had a custom data set that joined this kind of data. With the enhancement that is CAA, I hope this is not needed as it would be another customization at risk to be replaced. I cannot add CAA and AP Expense subject areas to the same report for example, as this does not bring in correct PO data. Please let me know what you recommend.