PC_AP_TO_PC Fails With Unique Constraint Error At PC_AP_TO_PC.MAIN.40000000 on MS SQL Server
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms