Show All SQL Checkbox is not Working Properly in Performance Analyzer UI

(Doc ID 753866.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Data Manager - Version: 4.5.20 to 4.5.39
This problem can occur on any platform.
Oracle Financial Services Applications (OFSA)
Oracle Performance Analyzer (PA) 4.5.39


When attempting to check the 'Show all SQL' checkbox in Performance Analyzer Configuration ID, the checkbox was not saved.

1. Navigation: Performance Analyzer --> Configuration ID.
2. Check the  'Show all SQL' checkbox and save.
3. Open an Allocation ID.
4. Debug SQLs are generated properly.
5. Close and re-open the Configuration ID,  the checkbox is unchecked. No SQL is generated.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms