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
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.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 = 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!