If Usage tracking is enabled and chosen “Direct insert” option, the Oracle BI Server collects usage tracking data for each query and inserts them directly to a database table S_NQ_ACCT.
But today when I was trying to track a query, I realized that particular query was not getting inserted. After some investigation I found that the column “QUERY_TEXT” size was just 1024 Bytes and the logical query that was generated by the BI Presentation server was bigger than that. So I have altered the column to varchar2 (4000 bytes) and executed the same analysis again… problem solved.
Alter table S_NQ_ACCT modify QUERY_TEXT varchar2(4000);
Till Next Time