My Oracle Support Banner

R12: AP: Which Tables Store Invoice Number in Payables (Doc ID 2798363.1)

Last updated on APRIL 27, 2023

Applies to:

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


On : 12.1.3 version, Invoice Issues

To check the Impact of the invoice before Updating in the AP_INVOICES_ALL

There is a special character in one of the invoice in AP_INVOICE_ALL table which is causing issue. So user needs to update that column in the base table 

User wants to know which all fields in Payables stores invoice numbers so they can update accordingly.

The invoice number is greyed out in invoice workbench for update.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.