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

Symptoms


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:

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


STEPS
-----------------------
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

Cause

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