C1-OFFSETDET Zone Is Throwing "The zone SQL number 1 has encountered an exception" Error While Click On Pagination Next Button.
(Doc ID 2807040.1)
Last updated on SEPTEMBER 24, 2021
Applies to:
Oracle Financial Services Revenue Management and Billing - Version 2.5.0.3.0 and laterInformation in this document applies to any platform.
Symptoms
On : 2.5.0.3.0 version, ENV - Environment
ACTUAL BEHAVIOR
-------------------------
C1-OFFSETDET Zone is throwing error while click on Pagination Next Button
Getting SQL error for Zone while clicking on Pagination.
java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined
STEPS TO REPLICATE
-----------------------
Go to Bill -> Go to bill information -> Click on next button for offset detail zone.
It gives error: The zone SQL has encountered an exception.
Below is the error :
xxxx- 943545-1658-1 2021-06-23 06:10:00,967 [[ACTIVE] ExecuteThread:
'4' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO
(support.context.FrameworkSession) (Server Message)
Category: 11007
Number: 11013
Call Sequence:
Program Name: DataExplorerSQLProcessor
Text: The zone SQL number 1 has encountered an exception.
Description: SQL Exception
Table: null
Field: null
java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined
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 |
| References |