PO_AUTO_SRC Fails At Step PO_POCALC.VS8600.NOTAX1 (SQL) With A Unique Constraint Error (Doc ID 1662134.1)

Last updated on NOVEMBER 23, 2019

Applies to:

Symptoms

On Purchase Orders

PO_AUTO_SRC fails at step PO_POCALC.VS8600.NOTAX1 (SQL) with a unique constraint error. When two requisitions are created and one of them is sourced to existing PO and when we run PO_AUTO_SRC , process fails with unique constraint error . And the issue can be replicated only if we have multiple requisitions for PO_AUTO_SRC process. TAX_EXEMPT is set to N at Business unit level
 

ERROR
-----------------------
Process 12613 ABENDED at Step PO_POCALC.VS8600.NOTAX1 (SQL) -- RC = 805

12613 PO_POCALC VS8600 NOTAX1 SQL 805


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Set Up
-----------
1)-Purchasing BU Option-Tax Exempt is set to N at BU Level
2)-Approval is not enabled at Requisition or Purchasing
3)-Vendor is not applicable for Sales Tax. Navigate to Vendor-Add/Update Vendor –Location-Sales/Use Tax. Sales /Use Tax Applicability is Non Taxable.
  
Replication Starts
--------------------
1)-Create a PO using Older date for a Business Unit and Vendor X. Use Adhoc/Special item for PO creation. Save and Approve the PO
 
2)-Navigate to PO header Details and ensure Tax Exempt Flag is checked and ID is selected as EXEMPT
 
3)-Save and Approve the PO
 
4)-Create another using Same date for the same BU and the same Vendor X. Use Adhoc/Special item for PO creation as for the previous PO. Change the Quantity and Price.
 
5)- Navigate to PO header Details and ensure Tax Exempt Flag is checked and ID is selected as EXEMPT
 
6)-Save and Approve the PO.
 
7)-Note down the 2 PO numbers.
8)-Now create a eProcurement Requisition for the same BU and same Vendor using Special item ,”TEST1”
 
9)-Create another eProcurement Requisition using same BU and Same Vendor . Use Special Items ,”TEST” and ,”TEST2” both this time. Use the qty and rate as shown below.
 
10)-Note down the Requisition No for the 2 requisitions

11)-Now Source first Requisition ID to the second PO ID.

12)-Navigate to Purchasing > Purchase order > Stage / Source Requests > Requisition Selection. Fetch the first Requisition  for Sourcing
 
13)-Click on Staging Information Link –Select ,”User Assign ID” –Enter the second PO ID -Enter the Due date as any future date. Save the Page

14)-Now Select the second Requisition ID and source it to new PO. Navigate to Purchasing > Purchase order > Stage / Source Requests > Requisition Selection > Fetch the second Requisition for Sourcing
 
15)-Save the Page
 
16)-Run PO Auto Sourcing i.e. PO_AUTO_SRC process
 
17)-Process Fails with a Unique Constraint error at Step PO_POCALC. S8600.NOTAX1 (SQL)
 

Changes

Cause

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