Autocreate in Buyer Work Center (BWC) Ends in Error - Unexpected Error Occurred During Autocreate (Doc ID 2238628.1)

Last updated on SEPTEMBER 21, 2022

Applies to:

Symptoms

Using Purchasing, Version 12.X


Actual:
Using the demand workbench in the Buyer Work Center (BWC) to conduct the autocreate is ending in error.

Expected:
The demand workbench - autocreate - should not end in error - but should be successful in autocreating the requisitions to purchase orders.

Error:
Error Messsge: Unexpected error occurred during auto create


Replication:
The issue can be reproduced at will with the following steps:
1. Demand workbench
2. Select the requisition lines for autocreate - add
3. Find that the error occurs upon choosing create


Core Autocreate form is working properly and there is not an error.

FND_LOGGING revealed the following error message:
ORA-00001: unique constraint (PO.PO_LINES_U2) violated in Package po.plsql.PO_LINES_DRAFT_PKG. Procedure merge_changes.10;SQLERRM = ORA-00001: unique constraint (PO.PO_LINES_U2) violated
User-Defined Exception in Package po.plsql.PO_LINES_DRAFT_PVT. Procedure apply_changes.40;SQLERRM = User-Defined Exception
User-Defined Exception in Package po.plsql.PO_DRAFTS_PVT. Procedure apply_changes.10;SQLERRM = User-Defined Exception
User-Defined Exception in Package po.plsql.PO_DRAFTS_PVT. Procedure transfer_draft_to_txn.40;SQLERRM = User-Defined Exception
User-Defined Exception in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure transfer_draft_to_txn.10;SQLERRM = User-Defined Exception
User-Defined Exception in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure create_update_doc.60;SQLERRM = User-Defined Exception
rollback to savepoint po_pdoi_doc_postproc_sp
User-Defined Exception in Package po.plsql.PO_PDOI_POSTPROC_PVT. Procedure process.80;SQLERRM = User-Defined Exception
User-Defined Exception in Package po.plsql.PO_PDOI_PVT. Procedure start_process.120;SQLERRM = User-Defined Exception

Changes

 
Patches were introduced into the system and seems to possibly be impacting the issue.

Cause

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