Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

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

Received Response
31
Views
6
Comments
Elaine Hendry
Elaine Hendry Rank 2 - Community Beginner
in Oracle Fusion Data Intelligence

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

Tagged:

Answers

  • Syamantak Saha
    Syamantak Saha Rank 5 - Community Champion

    Seems to be an access issue with certain rows of tables. Ask your DBA if there is any Row Level Label Security enforced for your account. If you are accessing data from the Cloud, there is a high chance that this maybe enabled.

  • Elaine Hendry
    Elaine Hendry Rank 2 - Community Beginner

    Thanks for replying @Syamantak Saha ,

    I'm one of our Fusion and FDI admins with full access therefore don't think this could be the issue?

  • Syamantak Saha
    Syamantak Saha Rank 5 - Community Champion

    Hi @Elaine Hendry

    If you are pulling a lot of data out of the database then it could be a resource issue. Ask you system admin to check whether adequate resources are being allocated for your queries. I have seen this happen when hardware resources and/or network latency are limiting.

  • Elaine Hendry
    Elaine Hendry Rank 2 - Community Beginner

    @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?

  • Syamantak Saha
    Syamantak Saha Rank 5 - Community Champion

    @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.

  • Gianni Ceresa
    Gianni Ceresa Mod

    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…