Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

Purge Cache log

Question

Views

Comments

Hesh Rank 5 - Community Champion

Apr 6, 2017 5:58AM edited Aug 13, 2024 5:24PM in Oracle Analytics Cloud and Server

HI,

OBIEE 12.2.1.0.0

We are using event pulling tables to purge cache, we do manual inserts into BI12C_BIPLATFORM.S_NQ_EPT as a last step of our daily ETL.

I can find entries in BI12C_BIPLATFORM.S_NQ_EPT at 6.20 am today, but when I run the dashboard it was pointing to old data.

when I verified BI12C_BIPLATFORM.S_NQ_ACCT for usage tracking first query was logged at 6:200 and hit the cache .

There were no issues earlier, this is just happening last couple of days .

Where can I find somewhere in the logs when my cache is purged?

Appreciate your help.

Thanks

Hesh