Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 282 Oracle Analytics and AI News
- 59 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Data Variance in Configurable Account Analysis
Has anyone seen data variances in Account Analysis?
I am attempting to reconcile my Configurable Account Analysis to my GL Balances and Detail transaction subject area. I continue to see variances at a high level and detail level when comparing the debits/credits.
The only Subledger I am extending is Payables and that is the only Journal Source I am seeing the variance in.
Has any on else experienced variances and data missing in CAA?
Answers
-
Thank you for visiting and posting in Fusion Analytics Warehouse(FAW) Product Community Page.
The cause of the issue is related to limitation of the Debit and Credit Balance column width.
- The Debit and Credit Balance values are not matching because the numbers are very big and it cannot fit in the column width of FAW fields.
- This is a known limitation which is documented in the below document.
- https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-85D4A553-EB66-41B5-AC90-56F1FAB34951.htm
Thanks
Subha
0 -
Update on this post. I believe this is a bug I found in FAW.
In our situation we have posted a journal line with an associated Invoice. The Invoice was later cancelled and a new journal line was created to offset the cancelled invoice. So we have 2 Journal lines for this transaction.
However, when the CAA is created it does not pick up the Journal Line with the cancelled Invoice even though it was accounted for. The only detail that comes through in CAA is the offset of the cancelled invoice. This behavior is what makes it impossible to reconcile the CAA to your Journal Lines.
0 -
0
