Error In Workflow APINVAPR/44244_2 3122:Duplicate Item 'APINVAPR/44244-10' Could Not Be Created (Doc ID 1990265.1)

Last updated on SEPTEMBER 18, 2017

Applies to:

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

Symptoms

Submitting the Invoice Approval Workflow for large number of invoices and then manually initiating one of these invoices for approval causes the request to error:

START:iteration as 1 for invoice_id xxxx
Before Calling WF_ENGINE.createProcess(APINVAPR,xxxx_1,APPROVAL_MAIN);
Error is :ORA-20002: 3122: Duplicate item 'APINVAPR/xxxx_1' could not be created.
l_debug_info : Before Calling
WF_ENGINE.createProcess(APINVAPR,xxxx_1,APPROVAL_MAIN);

OR

Correcting the Invoice and resubmitting it for approval, after it is Initially Rejected, results in the following

Error in Workflow APINVAPR/44244_2 3122: Duplicate item 'APINVAPR/44244-10' could not be created.



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