Is it Possible to Update REV_APP_USER_PREFERENCES Directly in the Database
(Doc ID 2920337.1)
Last updated on JANUARY 11, 2023
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 22.214.171.124.0 and later
Oracle Financial Services Profitability Management - Version 126.96.36.199.0 and later
Oracle Financial Services Asset Liability Management - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI / AAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)
There is a requirement to toggle a batch user's debug level in the 'Application Preferences' screen under 'Processing-General -> Debugging output level'.
In the atomic schema table there REV_APP_USER_PREFERENCES there is a column DEBUG_LEVEL which has three possible values (1/2/3)
Would like to update this column directly by database update to change a batch user's debug level. Is making this change by direct update to the database table allowed and if yes, is the following mapping is correct?
DEBUG_LEVEL - 1 - Do not output SQL to log file
DEBUG_LEVEL - 2 - Show all SQL
DEBUG_LEVEL - 3 - Show significant calculation SQL
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