Try to Delete Invoice From AP_INVOICES_INTERFACE With Error

(Doc ID 2088542.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 11.5.10.2 version, Open Interface and Inv Import

When attempting to run concurrent Payables Open Interface Purge
the following error occurs.

ERROR
-----------------------
MSG-00999: (Import_purge 4) Delete records in ap_invoices_interface...
MSG-00999: ORA-01722: invalid number
MSG-00999: Delete record in control table..
REP-1419: 'beforereport': PL/SQL program aborted.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Log in Payables responsibility
2.Navigate to (M)View> request,choose the concurrent 'Payables Open Interface Purge'
3.Error out
4.And try to delete invoice from ap_invoices_interface with error message:

ORA-01722: invalid number


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot delete invoice from ap_invoices_interface

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