Allocation Process Failed ORA-00001 Constraint (PO.PO_REQ_DISTRIBUTIONS_U1) Violated (Doc ID 1355051.1)

Last updated on MAY 03, 2021

Applies to:

Symptoms

When amount based requisitions are autocreated to Request for Quotation (RFQ) and the RFQ is being awarded to a Purchase Order, encounter Allocation Process Failed.  Cannot proceed to create (award) the PO.

Error:
10: ALLOC_ALL_UNALLOC_ITEMS: auction_header_id: xxxx
35: AUTO_ALLOC_AND_SPLIT_REQ
10: SPLIT_REQ_LINES
20: SPLIT_REQ_LINES
30: SPLIT_REQ_LINES
40: SPLIT_REQ_LINES
50: SPLIT_REQ_LINES:
60: SPLIT_REQ_LINES: U
65: SPLIT_REQ_LINES: 2 messages: Unexpected System Error: ORA-00001: unique constraint (PO.PO_REQ_DISTRIBUTIONS_U1) violated in Package PO_NEGOTIATIONS4_PVT Procedure SPLIT_REQUISITIONLINES
70: SPLIT_REQ_LINES
40: AUTO_ALLOC_AND_SPLIT_REQ
40: AUTO_ALLOC_AND_SPLIT_REQ
60: AUTO_ALLOC_AND_SPLIT_REQ

From the fnd debug log:
pnls_sort is BINARY
final setting of pdate_lang is AMERICAN
ICX session generated forms URL is /dev60cgi/f60cgi?colorScheme=BLUE&digitSubstitution=CONTEXT〈=US&env=NLS_LANG='AMERICAN_AMERICA.UTF8'+FORMS60_USER_DATE_FORMAT='DD-MON-RRRR'+FORMS60_USER_DATETIME_FORMAT='DD-MON-RRRR HH24:MI:SS'+NLS_DATE_LANGUAGE='AMERICAN'+NLS_SORT='BINARY'+NLS_NUMERIC_CHARACTERS='.,'&form_params=+config='com-365-ppdb01_tcmemi'+icx_ticket='.BCbVuHdiiAP8jULp03O1CQ..'+resp='XXX/APPLICATIONS_ADMINISTRATION'+secgrp='STANDARD'+start_func='XXX_FNDSCAUS'&encoding=UTF-8
EXCEPTION: Location is 160; SQLCODE = -1; SQLERRM = ORA-00001: unique constraint (PO.PO_REQ_DISTRIBUTIONS_U1) violated
"Excption: Create distributions lines for all the newly created requisition lines"
; Location is 160; SQLERRM = ORA-00001: unique constraint (PO.PO_REQ_DISTRIBUTIONS_U1) violated
End executing PLSQL procedure - PON_AUCTION_CREATE_PO_PKG.AUTO_ALLOC_AND_SPLIT_REQ [End time .........] [Time taken - 3.24 secs]
BEGIN
END
BEGIN

Steps to reproduce:
The issue can be reproduced at will with the following steps:
1. Create a Amount based requisition with 1 line (Quantity = 100, Price =1).
Split the line into 3 distributions.
Dist 1 (Quantity 10, Price 1)
Dist 2 (Quantity 30, Price 1)
Dist 3 (Quantity 60, Price 1)

2. Autocreate the approved requisition to Sourcing RFQ (Sealed RFQ). Sourcing RFQ converts the line quantity to 1 and Price to 100.

3. Publish the RFQ

4. Log in as iSupplier and Bid on the RFQ (@ $70).

5. Close, Unlock, Unseal the RFQ.

6. Award the RFQ to the supplier and complete the award.

7. Award completion ends with Allocation Process Failed.

Cause

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