My Oracle Support Banner

Error JBO-27122: SQL Error During Statement Preparation While User Is Clicking On Claim Number From Claim Summary (Doc ID 2895140.1)

Last updated on SEPTEMBER 16, 2022

Applies to:

Oracle Trade Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

User is receiving error when clicking on claim number from Trade Management claim summary screen.


Error:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT /*+
opt_param('_optimizer_cost_based_transformation','off'&#41
; */ ClaimHeaderEO.CLAIM_ID, ClaimHeaderEO.OBJECT_VERSION_NUMBER,
ClaimHeaderEO.LAST_UPDATE_DATE, ClaimHeaderEO.LAST_UPDATED_BY,
ClaimHeaderEO.CREATION_DATE, ClaimHeaderEO.CREATED_BY,
ClaimHeaderEO.LAST_UPDATE_LOGIN, ClaimHeaderEO.REQUEST_ID,
ClaimHeaderEO.PROGRAM_APPLICATION_ID, ClaimHeaderEO.PROGRAM_UPDATE_DATE,
ClaimHeaderEO.PROGRAM_ID, ClaimHeaderEO.CREATED_FROM,



Steps:
The issue can be reproduced at will with the following steps:
1. Trade Management > Claims
2. Click on claim to open the claim details
3. Error



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.