My Oracle Support Banner

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:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.


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

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

12613 PO_POCALC VS8600 NOTAX1 SQL 805

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)




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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