My Oracle Support Banner

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 JULY 22, 2020

Applies to:

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


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.


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.