Invoice On Hold report (APXINROH) erroring with REP-0069 and ORA-01722 error messages
(Doc ID 824416.1)
Last updated on MARCH 20, 2025
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
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
| Symptoms |
| Cause |
| Solution |
| References |