GRC Controls TKProf Utility (GRC Controls TKPROF Utility) Is Not Generating Sql

(Doc ID 2058629.1)

Last updated on JUNE 17, 2017

Applies to:

Oracle Preventive Controls Governor - Version 7.3 and later
Information in this document applies to any platform.

Symptoms

On : 7.3 version, Other Issues not covered by existing components

ACTUAL BEHAVIOR
--------------
GRC Controls TKProf Utility (GRC Controls TKPROF Utility) is not generating Sql query in the log file required to modify the lov. And the 'LATKPROF: GRC Controls TKPROF Utility' program completes with error in the log file.


EXPECTED BEHAVIOR
-----------------------
GRC Controls TKProf Utility (GRC Controls TKPROF Utility) has to generate the SQL query once the 'LATKPROF: GRC Controls TKPROF Utility' program completes successfully.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open up Form Rules.
2. Enable Trace ( Help-> Diagnostics -> Trace-> Regular Trace radio button.)
3. Navigate to the LOV for which you intend to capture the query.
4. Click on GRC Controls Utilities in the menu bar, and then on Oracle Rules TKProf Utility in the Utilities menu.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot define PCG control.

Cause

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