Is it Possible to Update REV_APP_USER_PREFERENCES Directly in the Database
(Doc ID 2920337.1)
Last updated on MAY 14, 2024
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 8.1.0.0.0 and laterOracle Financial Services Profitability Management - Version 8.1.0.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.1.0.0.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)
Goal
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
Solution
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
| Goal |
| Solution |