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

Add Fiscal Date field to Financials - Balance Sheet

Juan Hurtado

When creating a dataset link from Financials - GL Balance Sheet to the Configurable Account Analysis we get incorrect data when observing ending balances without revaluation amounts. The goal is to remove Accounted Journal Net Amounts tagged with a revaluation journal source from international ledger balances.

The other idea to consider is add GL Journal Details (Journal Source) to the Financials - GL Balance Sheet subject area. This will help other businesses observe amounts without revaluation and etc.

Thanks,

Juan

Find more posts tagged with

Delivered

Financials

Oracle Fusion Analytics

FDI Back End

Data Modelling and Datasets

FDI

Status: Delivered

Comments

Mallikarjuna Kuppauru-Oracle

Hi @Juan Hurtado

Thanks for submitting an Idea's Lab Request, Internal team will review the same.

Regards,

Arjun

Krishna Prasad Kotti-Oracle

Can we look at drilling from GL Balances to GL Journal and then to Configurable account analysis ?

We can use action links to drill from a Balance amount to the underlying Journal and from Journals to Configurable account analysis.

Mallikarjuna Kuppauru-Oracle

HI @Juan Hurtado

You should consider drilling to GL journal details which supports the fiscal date.

It would be drilling from GL Balances to GL Journal and then to Configurable account analysis. Let me know if any further quesitons?

Regards,

Arjun