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.


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.PARTY_SITE_NUMBER site_number,
  to_char(cf.last_updated,'DD-MON-YYYY') Creation_date,
  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,
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.


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