PC_AP_TO_PC Unique Constraint Error PC_POADJUST.AMOUNT_COND_4

(Doc ID 2394157.1)

Last updated on MAY 07, 2018

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Batch

PC_AP_TO_PC Unique Constraint Error PC_POADJUST.AMOUNT_COND_4

ERROR
-----------------------
Cannot insert duplicate key r ow in object 'dbo.PS_PC_RES_PA_TA14' with unique index 'PS_PC_RES_PA_TA14'.


File: e:\pt85606b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key r ow in object 'dbo.PS_PC_RES_PA_TA14' with unique index 'PS_PC_RES_PA_TA14'. The duplicate key value is (291434, SCCA0, 10000076, OTHER_OPER_EXP, CRVSCCA00000309465#1 #1 Failed SQL stmt: INSERT INTO PS_PC_RES_PA_TA14 (PROCESS_INSTANCE, BUSINESS_UNIT, PROJECT_ID, ACTIVIT Y_ID, RESOURCE_ID, RESOURCE_ID_FROM, BUSINESS_UNIT_GL, JOURNAL_ID, JOURNAL_DATE, UNPOST_SEQ, JOURNAL _LINE, FISCAL_YEAR, ACCOUNTING_PERIOD, ACCOUNT, ALTACCT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CH ARTFIELD2, CHARTFIELD3, BUS_UNIT_GL_FROM, CURRENCY_CD, STATISTICS_CODE, LEDGER_GROUP, ANALYSIS_TYPE, 

STEPS
-----------------------
Possible recreation steps.

0. From Feed check box turned on in the Installation Options for Project Costing for PO Reversals.
1. Create a voucher linked to a PC BU, Project and Activity.
2. Post the voucher and run PC_AP_TO_PC
3. Unpost then repost the voucher.
4. Run PC_AP_TO_PC again.

 

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