R12: AP: Payables Open Interface Import Program is Creating Invoices with a Blank Hold Causing Invoice to be in Needs Revalidation Status. (Doc ID 3010463.1)

Last updated on MARCH 14, 2024

Applies to:

Symptoms

The Invoices imported using Payables Open Interface Import program are created with a Blank Hold.

There is no hold name or reason in the Holds tab of Invoice Workbench, but one row is visible. 

In ap_holds_all table, one row is inserted with invoice_id, hold_name and hold_reason is NULL.

User needs to delete the row from ap_holds_all table to validate the invoice.

STEPS TO REPLICATE
-----------------------
1. Payables Responsibility > Other > Requests > Run
2. Run Payables Open Interface Import to create invoice
3. Payables Responsibility > Invoices > Entry > Invoices
4. Query the invoice and go to holds tab, there is a row with no hold name

Cause

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