India GST:- PO_POCREATE Going to No Success at Step PO_CMBLDDST.BD4000.INDSTCSD (Doc ID 2284669.1)

Last updated on JULY 09, 2017

Applies to:

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

Symptoms

Issue:-

PO_POCREATE fails with customs duty and IGST on the transaction.
Process 37348423 ABENDED at Step PO_CMBLDDST.BD4000.INDSTCSD (SQL) -- RC = 805


Error:-
File: e:\pt85516b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #:
1723 Error Position: 0 Return: 805 - ORA-00001: unique constraint
(EMDBO.PS_PO_DSEXS_T4) violated
Failed SQL stmt: INSERT INTO PS_PO_DSEXS_T4 (PROCESS_INSTANCE , BUSINESS_UNIT
, PO_ID , LINE_NBR , SCHED_NBR , DST_ACCT_TYPE , DISTRIB_LINE_NUM ,
DISTRIB_PCT , BAL_STATUS , TXN_CURRENCY_CD , BASE_CURRENCY ,
EXS_CURRENCY_RPTG , RATE_MULT , RATE_DIV , EXD_TAX_AMT , EXD_TAX_AMT_BSE ,
EXD_TAX_AMT_RPT , EXD_BASIS_AMT , EXD_BASIS_AMT_BSE , EXD_BASIS_AMT_RPT ,
EXD_RCVRY_AMT , EXD_RCVRY_AMT_BSE , EXD_RCVRY_AMT_RPT , EXD_NRCVRY_AMT ,
EXD_NRCVRY_AMT_BSE , EXD_NRCVRY_AMT_RPT , STX_TAX_AMT , STX_TAX_AMT_BSE ,
STX_TAX_AMT_RPT , STX_BASIS_AMT , STX_BASIS_AMT_BSE , STX_BASIS_AMT_RPT ,
STX_RCVRY_AMT , STX_RCVRY_AMT_BSE , STX_RCVRY_AMT_RPT , STX_NRCVRY_AMT ,
STX_NRCVRY_AMT_BSE , STX_NRCVRY_AMT_RPT , CSD_TAX_AMT , CSD_TAX_AMT_BSE ,
CSD_RCVRY_AMT , CSD_RCVRY_AMT_BSE , CSD_NRCVRY_AMT , CSD_NRCVRY_AMT_BSE)
SELECT DIST.PROCESS_INSTANCE ,DIST.BUSINESS_UNIT ,DIST.PO_ID ,DIST.LINE_NBR
,DIST.SCHED_NBR ,DIST.DST_ACCT_TYPE ,DIST.DISTRIB_LINE_NUM ,DIST.DISTRIB_PCT
, 'I' ,CSD.TXN_CURRENCY_CD ,DIST.CURRENCY_CD_BASE ,CSD.EXS_CURRENCY_RPTG
,DIST.RATE_MULT ,DIST.RATE_DIV , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 ,
0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 ,CSD.EXS_TAX_AMT
,CSD.EXS_TAX_AMT_BSE ,CSD.EXS_RCVRY_AMT ,CSD.EXS_RCVRY_AMT_BSE
,CSD.EXS_NRCVRY_AMT ,CSD.EXS_NRCVRY_AMT_BSE FROM PS_PO_POB_DIST_T4 DIST ,
PS_PO_CSD_TXWK_T4 CSD WHERE DIST.PROCESS_INSTANCE = 126331 AND
DIST.PROCESS_INSTANCE = CSD.PROCESS_INSTANCE AND DIST.BUSINESS_UNIT =
CSD.BUSINESS_UNIT AND DIST.PO_ID = CSD.PO_ID AND DIST.LINE_NBR = CSD.LINE_NBR
AND DIST.SCHED_NBR = CSD.SCHED_NBR AND CSD.EXS_TAX_TYPE = 'C'

Process 126331 ABENDED at Step PO_CMBLDDST.BD4000.INDSTCSD (SQL) -- RC = 805
(108,524)

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

PSAESRV completed service request at 23.55.53 2017-07-02



Steps To Reproduce the Issue:-
Setup:
1) Setup the Foreign Supplier(Outside India) under Supplier Tax Applicability.Leave GSTN blank and enable GST and Custom duty
2) Setup the Item and Item BU Tax applicability to calculate GST and Custom Duty for Direct Import Case
3) Setup tax determination for GST and custom duty based on the Item Category

Replication Steps:
1.Create an Epro Requisition with the Item and the foreign Supplier.Save and Submit for Approval.
2.Approve the Requisition.
3.Navigate to Purchase Orders->Stage/Source Requests->Requisition Selection.Stage the Requisition
4.Run the PO_POCALC process.
5.Run PO_POCREATE process.Process goes to No Success.





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