Trial Bill UI Error

(Doc ID 2387991.1)

Last updated on APRIL 23, 2018

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.6.0.1.0 to 2.6.0.1.0 [Release 2]
Information in this document applies to any platform.

Goal

On :ORMB 2.6.0.1.0 version, BI - Billing

Trial Bill UI Error

The Trial Bill UI displays only 10 bill segments. On clicking Next option, the error message The zone SQL number 1 has encountered an exception is displayed. On checking the logs, we found that the issue is with prepared statement:Caused by: oracle.jdbc.OracleDatabaseException: ORA-00904: "BSG"."BSEG_ID": invalid identifier.
 

Solution

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