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

Last updated on FEBRUARY 28, 2017

Applies to:

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

Symptoms

Using Purchasing, Version 12.1.3


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

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