PC_AP_TO_PC Fails With Unique Constraint Error At PC_AP_TO_PC.MAIN.40000000 on MS SQL Server (Doc ID 2091429.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

When a voucher was unposted and reposted later, the Payables Cost Collection process PC_AP_TO_PC failed with the following error.

This problem is only apparent when using MicroSoft SQL Server.


The issue can be reproduced at will with the following steps:
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.

Due to this issue, a voucher that has been previously unposted cannot be successfully brought to Project Costing after reposting.

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