My Oracle Support Banner

PC_AP_TO_PC.11000000.INSDISC - Unique Constraint When Processing a Voucher with Discount (DSL) that is Copied from a PO where the PO has Multiple Lines using same Project Activity Distribution (Doc ID 1407744.1)

Last updated on FEBRUARY 01, 2022

Applies to:

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


When running the PC_AP_TO_PC process for processing a voucher that is copied from PO where the PO has multiple lines using same project activity distribution, the following error occurs:

abends at step PC_AP_TO_PC.11000000.INSDISC with a unique constraint violated.

The issue can be reproduced at will with the following steps:
1. Created a PO with multiple lines and each lines use the same project/activity for a discounted vendor.
2. Copy the PO to create the voucher after it is dispatched
2) Posted the voucher.
3) Ran PC_AP_TO_PC process on the voucher and got the following error:

ABENDED at Step PC_AP_TO_PC.11000000.INSDISCN (Action SQL) -- RC = 805
SQL Error: ORA-00001: unique constraint (SYSADM.PS_PC_AP_DISC_RES) violated


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.