My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2019

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 = xx
and cf.case_folder_id =days.case_folder_id
and days.data_point_id = y
and cf.case_folder_id =Dso.case_folder_id
and Dso.data_point_id = z
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.




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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.