EAP: Payment Posing Abends at Step AP_PSTPYMNT.BH100.BH100-13 With Unique Constraint Error When Trying to Escheat a Payment (Doc ID 2901891.1)

Last updated on DECEMBER 16, 2022

Applies to:

Symptoms

After upgrading from Image 33 to Image 41, Payment Posting abends at Step AP_PSTPYMNT.BH100.BH100-13 with an error when trying to escheat a Payment. Error occurs when the Ledger Group has multiple ledgers, Keep Ledgers in Sync is checked, Multibook entries is Subsystem is checked, and the External Bank Account has a GL Unit that is different than the GL Business Unit associated to the Voucher.

STEPS
1. Navigate to General Ledger > Ledgers > Define Ledger Group
2. Display the Ledger Group
  a. Ledger Group has 4 different Detail Ledgers -- 1 Primary Ledger that inherits the Base Currency and 3 Translation Ledgers
  b. Box checked for 'Keep Ledgers in Sync'
3. Navigate to Set Up Financials/Supply Chain > Install > Installation Options > Overall link
4. On the Overall page, box checked for 'Multibook entries in Subsystem'
5. Navigate to Banking > Bank Accounts > External Accounts
6. External Accounts page setup:
  a. Bank = XXXXX
  b. Bank Account = YYYY
  c. GL Unit = ZZZZZ
7. Navigate to Accounts Payable > Vouchers > Add/Update > Regular Entry
8. Create a new Voucher
9. On the Voucher > Invoice Information page:
  a. Business Unit = AAAAA
  b. Invoice Date and Accounting Date = 06/01/2019
  c. GL Unit = AAAAA
10. On the Voucher > Payments page:
  a. Schedule Due = 06/01/2019
  b. Bank = XXXXX
  c. Account = YYYY
11. Save the page
12. On the Voucher > Payments page, click Express Payment link
13. On the Express Payment page, Date = 06/01/2019 and click Create Payment
14. Complete the Express Pay Cycle
15. Navigate to Accounts Payable > Batch Processes > Payment > Payment Posting
16. Run Payment Posting to post the Payment
17. Through SQL, verify the Payment entries on VCHR_ACCTG_LINE for the Voucher
18. Navigate to Accounts Payable > Payments > Cancel/Void Payments > Escheat Payment
19. Escheat the above Payment
  a. Select Escheated Check
  b. Date Escheated = 06/29/2022
20. Run Payment Posting to post the Escheatment
21. Payment Posting abends at Step AP_PSTPYMNT.BH100.BH100-13 with the above error.

Changes

<Bug 30266162> - POST PAYMENT FAILED AT STEP AP_PSTPYMNT.BH100.BH100-13 DUE TO ORA-0001, which was originally fixed in Image 34, and included in Image 41, caused this issue.  

Cause

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