Receiving Java Error When Attempting to Open a Claim (Doc ID 2094678.1)

Last updated on FEBRUARY 26, 2016

Applies to:

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

Symptoms

Nav: Oracle Trade Management > Claims

User is receiving the below error when attempting to access a claim. 

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT 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, ClaimHeaderEO.BATCH_ID, ClaimHeaderEO.CLAIM_NUMBER, ClaimHeaderEO.CLAIM_TYPE_ID, ClaimHeaderEO.CLAIM_DATE, ClaimHeaderEO.DUE_DATE, ClaimHeaderEO.SPLIT_FROM_CLAIM_ID, ClaimHeaderEO.AMOUNT, ClaimHeaderEO.ACCTD_AMOUNT, ClaimHeaderEO.CURRENCY_CODE, ClaimHeaderEO.EXCHANGE_RATE_TYPE, ClaimHeaderEO.EXCHANGE_RATE_DATE, ClaimHeaderEO.EXCHANGE_RATE, ClaimHeaderEO.SET_OF_BOOKS_ID, ClaimHeaderEO.ORIGINAL_CLAIM_DATE, ClaimHeaderEO.SOURCE_OBJECT_ID, ClaimHeaderEO.SOURCE_OBJECT_CLASS, ClaimHeaderEO.SOURCE_OBJECT_TYPE_ID, ClaimHeaderEO.SOURCE_OBJECT_NUMBER, ClaimHeaderEO.CUST_ACCOUNT_ID, ClaimHeaderEO.CUST_BILLTO_ACCT_SITE_ID, ClaimHeaderEO.LOCATION_ID, ClaimHeaderEO.REASON_TYPE, ClaimHeaderEO.REASON_CODE_ID, ClaimHeaderEO.STATUS_CODE, ClaimHeaderEO.SALES_REP_ID, ClaimHeaderEO.COLLECTOR_ID, ClaimHeaderEO.CONTACT_ID, ClaimHeaderEO.BROKER_ID, ClaimHeaderEO.TERRITORY_ID, ClaimHeaderEO.CUSTOMER_REF_DATE, ClaimHeaderEO.CUSTOMER_REF_NUMBER, ClaimHeaderEO.ASSIGNED_TO, ClaimHeaderEO.RECEIPT_ID, ClaimHeaderEO.RECEIPT_NUMBER, ClaimHeaderEO.DOC_SEQUENCE_ID, ClaimHeaderEO.DOC_SEQUENCE_VALUE, ClaimHeaderEO.PAYMENT_METHOD, ClaimHeaderEO.VOUCHER_ID, ClaimHeaderEO.VOUCHER_NUMBER, ClaimHeaderEO.PAYMENT_REFERENCE_ID, ClaimHeaderEO.PAYMENT_REFERENCE_NUMBER, ClaimHeaderEO.PAYMENT_REFERENCE_DATE, ClaimHeaderEO.PAYMENT_STATUS, ClaimHeaderEO.APPROVED_FLAG, ClaimHeaderEO.APPROVED_DATE, ClaimHeaderEO.APPROVED_BY, ClaimHeaderEO.SETTLED_DATE, ClaimHeaderEO.SETTLED_BY, ClaimHeaderEO.ATTRIBUTE_CATEGORY, ClaimHead

 

 

Cause

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