My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.