nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to join GL Account Analysis and AP Payments Subject Area

Molly P

We have a workbook using GL Account Analysis and AP Expense subject areas. We use this to analyze our GL and AP SL data together. We want to be able to pull in payment/paid date of the invoice. When we try to add AP Payment subject area (because it seems to be the only one with payment date), we either get a query error or the payment date column is blank even though the invoice has been paid. Most fields we have tried to pull in from the AP Payment subject area are blank even though we expect a value. Is there a way to get the payment date into a report like this?

Find more posts tagged with

Oracle Fusion Analytics

ERP Analytics Content

Fusion ERP Analytics

Accepted answers

All comments

Sumanth V -Oracle

@Molly P -

Could you please let us know which product you are using—FAW, FDI, or OTBI? This will help us better understand your requirements and provide more accurate guidance.

Molly P

@Sumanth V -Oracle I'm making the report in FAW.

Jamie Anderson-Oracle

@Molly P : To answer your question:

Yes, there is a way to create a single analysis in Fusion Data Intelligence (formerly known as FAW) using data from multiple Subject Areas. However, you'll need someone with an administrator role to work with you to make this happen.

Theoretically, something to keep in mind is that in order for data to be included in the same analysis (like adding a Payment/Paid date column to the GL detail), it must come from the same Subject Area. This sounds contradictory to my sentence above, so I'll explain:

To address this, Fusion Data Intelligence has a feature called Configurable Account Analysis. This is an administrative step that essentially combines measures/attributes from multiple subject areas that may be referenced together often into what is essentially a new custom subject area. As I understand it (this is where I'll lean on my more technical colleagues for potential correction) - if every single measure & attribute offered out-of-the-box in FDI were all included in the same subject area, you'd likely encounter significant latency issues in generating your analysis since each measure and attribute is trying to relate itself to each other measure and attribute (If you try to do this in OTBI in the Fusion ERP Application - you'll experience this).

One final thing for you to check just to be sure you don't go through all that and still get blanks:

When you pull in metrics from the AP Payment Subject Area into a table by itself, data does populate, correct? It's just when you are pulling in the data from multiple Subject Areas that you encounter the blanks. If this is not the case, you have a separate issue at hand that needs to be addressed first.

Jamie Anderson-Oracle

Also, check out this playlist that @Navnit Mishra posted for walkthrough steps for Configurable Account Analysis:

https://community.oracle.com/products/oracleanalytics/discussion/21967/fdi-configurable-account-analysis-caa-playlist

Molly P

Hi @Jamie Anderson-Oracle

Thanks for your reply. I cannot view the playlist through your shared link. I get an error saying "something went wrong" Can you please provide an updated link?

For your earlier comment, are you saying that this kind of data blend is only available if we enable and configure CAA? We are hesitant to do this because we have so many workbooks and trained all users on using the GL Account Analysis subject area. Or is a way to do this using the GL Account Analysis subject area with one of the AP Invoice subject areas while still being able to pull in Payment Date from the AP Payments subject area?

On your last comment, yes we see correct data when we use only the AP Payments subject area.

Thanks, Molly

Jamie Anderson-Oracle

@Molly P :

Oops, thank you for letting us know!
@Navnit Mishra - please see Molly's comment above in regards to this video playlist.
Is there a link that we can share externally and update in your original post?:

I cannot view the playlist through your shared link. I get an error saying "something went wrong" Can you please provide an updated link?

Molly - In the meantime, you can watch a snippet of this video; it's not as detailed as the one I've tried to link above, but can give more context.

Regarding the data blend using CAA: Yes, using CAA is the route for this.
You can still have users pull in the GL Account Analysis subject area every time, but ask them to pull in the newly-created-via-CCA Subject Area (named whatever would make the most sense to the end users) when they need to do this type of analysis. I know this will involve some change management from the end-user perspective which is not always the easiest, so I understand your hesitation. I suggest adding an Idea Lab post for what you have in mind.

Navnit Mishra

@Molly P Pl check this link. It is working for me

https://videohub.oracle.com/playlist/dedicated/1_2yl7la32/

Molly P

@Jamie Anderson-Oracle thank you for the clarification. The link to the snippet video does work so I will review.

@Navnit Mishra this link still does not work for me. Do I not have access/need an account or something?

Thanks,

Molly

Krishna Prasad Kotti-Oracle

GL Account Analysis is planned for deprecation by 25.R3, so please migrate to Configurable Account Analysis which has attributes for AP.

https://docs.oracle.com/en/cloud/saas/analytics/24r4/faiae/advanced-configurations.html#GUID-985BA8AF-9E36-4E4B-9C84-BFE6100262CF

Molly P

Hello,
We migrated to the configurable account analysis subject area. When I pull payment status into an invoice journal analysis (all columns from CAA), the payment status shows "~No Value~". How can I get payment status to show correctly?