Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 293 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
AP and AR and many other facts should use dates from gregorian calendar
Luc Baert-Oracle
Rank 1 - Community Starter
AP and AR and many other facts should use dates from gregorian calendar, not fiscal calendar for dates like Due date, transaction date, etc. These dates could be in the past or future, beyond the range of dates in the related fiscal calendar. Only GL dates should use fiscal calendar. The workaround as mentioned in KB183312 means additional work, while this should be fixed by product development as it is clearly a bug. This can be seen from OTBI where the dimensions for dates like transaction date and due date are gregorian calendar, not fiscal calendar. The same should happen in FDI/OAC. Since we cannot change the semantic model of OOTB subject area's we cannot fix it ourselves.
Tagged:
3