Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GL Balance Fact Data not match with ERP.

Jeng-DawDec 16 2009 — edited Jul 26 2011
Our system is OBIA 7.9.5.
Some data in table W_GL_ BALANCE_F doesn't match with original ERP.

Original Data in ERP is
BEGIN_BALANCE_DR - BEGIN_BALANCE_CR + PERIOD_NET_DR - PERIOD_NET_CR

37471615248600300 - 37471615236165100 + 222905016 - 228730719 = *6609546*

But,
Balance Data in DW is *6609500*

How can I fix the issue?

Regards,
Roger
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2011
Added on Dec 16 2009
#business-intelligence-applications
14 comments
3,667 views