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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.