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 AUGUST 30, 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

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

To view full details, 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 a vibrant support community of peers and Oracle experts.