Reconcile data between subledger and ledger in FDI

Question

Hi Team,

We are seeing the data in DW_FISCAL_DAY_D table starting from July 2020 and not before that. This is resulting in missing many records from previous years like 2017,2018 and so on till June 2020 when this dimension table is getting joined with AR Aging Fact - DW_AR_AGING_ACCT_INV_RCPT_CA.

Our calendar setup in GL from July 2020 (we cannot change the calendar now as its already LIVE) but the module has transactions (invoices) from 2017 onwards. This has created a scenario where we are not able to reconcile data between sub ledger and ledgers.

Can you please provide us any alternative workaround to resolve this issue.

Appreciate any quick response.

Regards,

Sreekar Suri

RVohra · Answer

Consider working with Oracle Support via SR, I am sure they might have already seen this behavior from some other clients as well and already discussed with the Product Development team to come up with a viable approach.

Alternative approach is going to be bit tedious in terms of using OTBL and finding the correct Subject Area or build a custom BIP report based on the related tables.

SunilKE · Answer

@Aslesha Sreekar Suri  : Did you get your answer, or did you find a solution ?

Aslesha Sreekar Suri · Answer

@Sumanth V -Oracle Any update on my comments?