PO Auto Sourcing PO_AUTO_SRC Process Fails at Step PO_POCREATE.PB8500.INS_CMT (SQL) With Unique Constraint Error When Using “Mass Change” and “Show at Receipt” on Comment (Doc ID 3074292.1)

Last updated on FEBRUARY 27, 2025

Applies to:

Symptoms

PO Auto Sourcing PO_AUTO_SRC process fails at Step PO_POCREATE.PB8500.INS_CMT (SQL) with Unique Constraint error.
The issue occurs when using the “Mass change” option and the “Show at receipt” option on a comment. This makes the PS_REQ_COMMENTS table have duplicated lines.

Steps to reproduce the issue

1. Navigate to Set up financials/supply chain > Product related > Procurement options > Purchasing > Ship to locations.
  Search for the ship to location.  Insert a comment and check the “Copy to transactions” check box then save.

2. Navigate to eProcurement > Create requisition.
  Search for an item and add it to the requisition. Save and Submit.

3. Make a copy of the requisition to create a new requisition.
  Search for the requisition then select the copy option and GO.

4. Select the line and click on the Mass change icon.
   Comments 1 and 3 are identical.

5. Check the “Show at Receipt” box on comment 3.
  
6. Navigate to Purchasing > Purchase orders > Stage/source request > PO auto sourcing.
   Run the PO_AUTO_SRC process.

Replication document

Cause

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