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.
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!