My Oracle Support Banner

Fusion Applications: How to set up and access the nqquery.log to troubleshoot a single OTBI or OBIA query (Doc ID 1469168.1)

Last updated on MAY 27, 2024

Applies to:

Oracle Fusion Accounting Hub - Version 11.1.5.0.0 to 11.1.5.0.0 [Release 1.0]
Oracle Fusion Performance Management Cloud Service - Version 11.1.8.0.0 to 11.1.8.0.0 [Release 1.0]
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.4.0.0 and later
Oracle Fusion Application Toolkit - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Purpose

Demonstrates how to setup and access the nqquery.log to troubleshoot a single OTBI or OBIA query.  This will allow the Physical SQL being sent to the Database to be captured.

Applies to the following Fusion Applications BI components : Oracle Transactional Business Intelligence (OTBI) , Oracle Business Intelligence Applications (OBIA)

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 Setting the Oracle BI Server Logging Level within Answers:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.