PO_POCALC Process Failing Due To Unique Constraint In PS_PO_ITM_STG_SUT Violated (Doc ID 1970251.1)

Last updated on JUNE 12, 2017

Applies to:

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

Symptoms


PO_POCALC process failing due to unique constraint in PS_PO_ITM_STG_SUT violated.



Steps to reproduce the issue:

1) Business Unit setup. Tax exempt is enabled
2) Create a new Requisition with 4 lines
3) Using Req Selection, Select first 2 lines. Please make sure to uncheck “Define PO”
4) Now Run Auto Source
5) Process fails with below error

Error:


PO_POCALC - File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 805 - ORA-00001: unique constraint
(SYSADM.PS_PO_ITM_STG_SUT) violated Failed SQL stmt: INSERT INTOPS_PO_ITM_STG_SUT (PROCESS_INSTANCE, BUSINESS_UNIT, PO_ID, PO_STG_TYPE,
PO_STG_ID, LINE_NBR, SCHED_NBR, TAX_CD_SUT_PCT, FREIGHT_SUT_PCT,TITLE_PASSAGE, TAX_TRANS_TYPE, TAX_TRANS_SUB_TYPE, TAX_JOB_NUM,
TAX_USER_AREA, SALETX_AMT, SALETX_AMT_BSE, USETAX_AMT, USETAX_AMT_BSE,FREIGHT_SUT_AMT, FRGHT_SUT_AMT_BSE, CURRENCY_CD, CURRENCY_CD_BASE,
SUT_PRODUCT_CD, SUT_FREIGHT_CD) SELECT S.PROCESS_INSTANCE, S.BUSINESS_UNIT, S.PO_ID, S.PO_STG_TYPE, S.PO_STG_ID, S.LINE_NBR, S.SCHED_NBR, 0, 0, ' ', '
', ' ', ' ', ' ', 0, 0, 0, 0, 0, 0, S.CURRENCY_CD, S.CURRENCY_CD_BASE, ' ', ' ' FROM PS_PO_STG_UD_T4 S, PS_PO_SRC_HDR_T4 H WHERE S.PROCESS_INSTANCE =
328545 AND S.PROCESS_INSTANCE = H.PROCESS_INSTANCE AND S.BUSINESS_UNIT = H.BUSINESS_UNIT AND S.PO_ID = H.PO_ID AND (H.TAX_EXEMPT = 'Y' OR
S.TAXABLE_CD = 'N')

Process 328545 ABENDED at Step PO_POCALC.VS8600.NOTAX3 (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s


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