Fiscal Year / Fiscal Period filters not applying correctly in AP Expense subject area workbook

Question

Hi,

Relatively new to FDI and trying to create a simple table visualisation from the Financials - AP Expense subject area but the Fiscal Year and Fiscal Period fields are not working when added as workbook filters.

When I select the fiscal year 2026 (or any other) within the filter instead of filtering the data it is leaving the Fiscal Period, GL segment fields, tax classification field, and expense account combination fields blank and returning data in the other columns e.g. invoice number, invoiced date, supplier name, supplier number, invoice identifier, and invoice line DFF fields dating back to the start of our Fusion implementation.

I'm urgently trying to create this report for a budget holder - can anyone suggest a fix or help identify the issue?

The issue is the same whether I use the fields from the Time or the Invoice Details>Distribution Accounting Date folder.

Elaine

Gianni Ceresa · Answer

Hi @Elaine Hendry ,

If your workbook is hitting some "limits" on the data you are retrieving, you should get a message saying that is the case. My guess would be more in how the FDI model is built, it could expose some attributes that only works in a given context, when other things are selected and filtered.

I just don't have a FDI available to look into those columns and subject area.

Hopefully another FDI user will be able to provide you with a more direct, and correct, answer soon.

Don't try to check hardware or OS or anything else, you are using FDI, you don't have access to those things…

Syamantak Saha · Answer

@Elaine Hendry

https://docs.oracle.com/cd/E14571_01/core.1111/e10064/logs.htm

Also can check for the operating system log files (such as Solaris etc.) that is your data server from which you are requesting data. As it is a data loss error, log files from application layer as well as physical layer may contain the full list of errors.

Elaine Hendry · Answer

@Syamantak Saha  that could be the problem as the nature of the analysis requires substantial AP invoice line data.

I'm not sure how to check the resources being allocated for the queries. I am system admin but it's not something our implementer covered. Can you assist with where I can find the information in the console?