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 New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
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