Invoice On Hold report (APXINROH) erroring with REP-0069 and ORA-01722 error messages

(Doc ID 824416.1)

Last updated on SEPTEMBER 28, 2017

Applies to:

Oracle Payables - Version 12.0.1 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.

Symptoms

Runing the Invoice On Hold report (APXINROH), the following error message is displayed in the log file:

Enter Password:
MSG-00000: And so it begins ...
MSG-00001: After SRWINIT
MSG-00002: After Get_Company_Name
MSG-00003: After Get_NLS_Strings
MSG-00004: After Get_Base_Curr_Data
MSG-00008: After Get_Parameter_Disp_Value
MSG-00007: After Custom_Init
ORA-01722: invalid number
SELECT decode ( : P_ORDER_BY , 'Hold Name' , 'Do not sort by vendor name' , decode ( :
SORT_BY_ALTERNATE , 'Y' , upper ( hp . organization_name_phonetic ) , upper ( hp . party_name ) )
) C_SORT_VENDOR_NAME , hp . party_name C_MASTER_VENDOR_NAME , INV
MSG-00020: After SRWEXIT
REP-0069: Internal error
In-process job terminated:Terminated with error:
REP-300: MSG-00000: And so it begins ...
MSG-00001: After SRWINIT
MSG-00002: After Get_Company_Name
MSG-00003: After Get_NLS_Strings
MSG-00004: After Get_Base_Curr_Data
MSG-00008: After Get_Parameter_Disp_Value
MSG-00007: After Custom_Init
ORA-01722: invalid number
SELECT decode ( : P_ORDER_BY , 'Hold Name' , 'Do not sort by vendor name' , decode ( :
SORT_BY_ALTERNATE , 'Y' , upper ( hp . organization_name_phonetic ) , upper ( hp .

 

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