Why Is There a Delay in Populating AP_INTERFACE_REJECTIONS Table for Rejected Invoices? (Doc ID 2765362.1)

Last updated on AUGUST 09, 2024

Applies to:

Goal

Once the imported invoices are loaded into the AP_INVOICES_INTERFACE table, some of them are rejected due to various reasons.

Then, based on the rejection reason populated in the AP_INTERFACE_REJECTIONS table, the users can be informed about the rejection reasons.

When many import processes are running in parallel (around 5, 6 or more), the  AP_INTERFACE_REJECTIONS table is populated with a delay of 24 hours or more -  compared to the time when the records are stamped as 'REJECTED' in the AP_INVOICES_INTERFACE table.

Solution

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