Dimension validation issue where you have to "Clear all dimension caches" to fix. According to support (SR2507090040004360), there was a flight DimensionStorageSegmentCollectionQueryOptimizationFlight which apparently was enabled in customer environments and had a bug which caused validation to be bypassed for Ledger dimensions and would allow financial dimensions which are suspended to be posted.
Although this feature ("flight") has now been turned off for all customers, cached ledger combinations may still exist as "valid."
The issue may not be reproducible in your non-prods because these dimension validation cache tables appear to be cleared during database refreshes.
The issue for us occurred from June 20 to June 27 (based on dates in the dimension*status cache tables), but we were still seeing issues today July 10 related to this due to cached dimension validation records which were flagged as valid even though they were not. We saw this issue on 10.0.42 PQU4 and PQU5, but I'm not not sure which other versions were impacted. The main issue we saw related to this was that financial dimensions which were flagged as "suspended" were allowed to post, but we haven't fully analyzed all recent postings to know if any other advanced rule structures were bypassed.
To fix, you need to:
This post is just an FYI in case you are experiencing similar issues where invalid dimension combinations are being allowed to post
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 777 User Group Leader
André Arnaud de Cal... 630 Super User 2025 Season 2
Martin Dráb 602 Most Valuable Professional