Session Variable OTBI_IC_DEFAULT_PARTICIPANT Causes Error in Incentive compensation Subject Area
(Doc ID 2962485.1)
Last updated on OCTOBER 18, 2023
Applies to:
Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.23.04.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.13.23.04.0 version, Analytics
Changing report to OTBI_IC_DEFAULT_PARTICIPANT causes error
An analysis with the Session variable OTBI_IC_DEFAULT_PARTICIPANT as Participant value in the Incentive compensation subject area is throwing error when the analysis is executed.
ERROR
-----------------------
Error during query processing (SQLExecDirectW).
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 907, message: ORA-00907: missing right parenthesis at OCI call OCIStmtExecute. (HY000)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in the application
2. Go to BI analytics
3. Open the report with Session variable "OTBI_IC_DEFAULT_PARTICIPANT" as Participant in the Incentive Compensation subject area
4. Execute the analysis
5. The error appears
FUNCTIONAL IMPACT
-----------------------
The issue has the following functional impact:
Due to this issue, users cannot Use the Session variable as they expect
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |