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
Last updated on SEPTEMBER 05, 2017
Applies to:PeopleSoft Enterprise FIN Project Costing - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.
Checked for relevance on 17-Mar-2014
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
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 hundreds of Community platforms