Html Contact Center Dashboard Errors for Customers with More than 1000 Contracts
(Doc ID 2672324.1)
Last updated on JULY 21, 2020
Applies to:Oracle Customer Care - Version 12.2.8 and later
Information in this document applies to any platform.
When attempting to open customers with more than 1000 contracts, the following error occurs.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select id,contract_number from (select id,contract_number from okc_k_headers_all_b where id in
The issue can be reproduced at will with the following steps:
1. Open the the HTML Contact Center Dashboard
2. For customers with more than 1000 contracts, it shows the error.
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