My Oracle Support Banner

EAP: Payment Post Abends At Step AP_PSTCOMMON.CF_INH3.STEP01 (SQL) -- RC = 805 (Doc ID 2552475.1)

Last updated on DECEMBER 20, 2019

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Payment Post abends for a Payment that includes a zero dollar payment created through Manual Payment Creation.

ERROR:
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PST_APCAP_TMP4) violated
Process 1639014 ABENDED at Step AP_PSTCOMMON.CF_INH3.Step01 (SQL) -- RC = 805

STEPS:
1.  Posting Method = Detail Offset Method
2.  USBNK / CHCK > Cash-AP ChartField Options = Fund Code and Department = Always Inherit
3.  Add two zero dollar Voucher
    a.  Line 1 and 2 = 10.00 and -10.00
    b.  Add Fund Code for both Distribution Lines
    c.  Zero dollar Voucher has 2 Schedule Payments = 10.00 and -10.00
3.  Add a second Voucher for same Supplier > Add Fund Code for Distribution Line
4.  Manual Payment Creation
    a.  Click Build Worksheet icon
    b.  Enter Amount
    c.  Apply Voucher tab > Select the Vouchers added
    d.  Save
    e.  Message:  Payment is successfully created (7250,321)
5.  Payment Post > No Success
6.  Message Log:  Process 179208 ABENDED at Step AP_PSTCOMMON.CF_INH3.Step01 (SQL) -- RC = 805

Cause

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
Symptoms
Cause
Solution
References


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