Projected Gains And Losses Report ARXFRV Ends With An Error ORA-24323 (Doc ID 1470290.1)

Last updated on JULY 09, 2012

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

ARXFRV module: Projected Gains and Losses Report ends with an error fail with error:

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.US7ASCII

'.,'

MSG-00100: DEBUG:  Set Customer Name Low / High.
MSG-00100: DEBUG:  Set Customer Number Low / High.
MSG-00100: DEBUG:  Set Invoice Type Low / High.
MSG-00100: DEBUG:  Set GL Date Low / High.
MSG-00100: DEBUG:  Set Currency Code Low / High.
ORA-24323: value not allowed
select substrb ( party . party_name , 1 , 50 ) customer_name , cus . account_number customer_ ==> number , nvl ( ctr . sold_to_customer_id , ctr . bill_to_customer_id ) customer_id , ctt . name invoice_type , psc . invoice_currency_code currency_code , su


Program exited with status 1

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