Try to Delete Invoice From AP_INVOICES_INTERFACE With Error

(Doc ID 2088542.1)

Last updated on JANUARY 16, 2018

Applies to:

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


On : version, Open Interface and Inv Import

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

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.

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

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


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