Credit Management: Unexpected Error In Customer Trends Page With Preferences Set to Number Format = 10.000,00 (Doc ID 1575659.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Credit Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On 12.1.3 in Credit Managment
Attempting to view Customer Trends in Credit Management and receive the following error:

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select hzp.party_number,
  cpa.account_number,
  cpa.PARTY_SITE_NUMBER site_number,
  to_char(cf.last_updated,'DD-MON-YYYY') Creation_date,
  cf.case_folder_number,
  to_number(bal.data_point_value) Receivable_Balance,
  to_number(days.data_point_value) Weighetd_Average_Days_Paid,
  to_number(dso.data_point_value) DSO,
  cf.party_id,
  cf.review_type,
  cf.creation_date_time,
  cf.last_updated,
  cf.limit_currency
from ar_cmgt_case_folders cf,
  ar_cmgt_party_accounts cpa,
  ar_cmgt_cf_dtls bal,
  ar_cmgt_cf_dtls Days,
  ar_cmgt_cf_dtls Dso,
  hz_parties hzp
where cf.party_id = cpa.party_id(+)
and cf.cust_account_id=cpa.cust_account_id(+)
and cf.site_use_id = cpa.site_use_id(+)
and hzp.party_id=cf.party_id
and cf.status = 'CLOSED'
and cf.type ='CASE'
and cf.case_folder_id =bal.case_folder_id
and bal.data_point_id = 34
and cf.case_folder_id =days.case_folder_id
and days.data_point_id = 5
and cf.case_folder_id =Dso.case_folder_id
and Dso.data_point_id = 2
order by cf.creation_date) QRSLT WHERE (party_id = :1)


java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

Steps to Reproduce:
Responsibility: Credit Management User
Navigation:  Search for a customer in Performance > Customer Trends > Click Go

The issue happens only if you have Preferences Set to Number Format = 10.000,00.

Number Format = 10,000.00, does not fail.

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