EAP: Payment CANCEL Entries Are Not Created For Cancelled Payments (Doc ID 2988623.1)

Last updated on NOVEMBER 24, 2023

Applies to:

Symptoms

One payment is for multiple vouchers in different business units. When a Void/Close Liability is done against a payment and the Open Period is Closed for one of the business units included in the payment, Payment Post will generate the CANCEL entries for only the business units where the Open Period is Open. The CANCEL and CLOSURE entries are missing for the voucher/business unit in a Closed Period. There is no way to generate these missing entries.

 
STEPS
-----------------------
1. Set Up Financials/Supply Chain > Business Unit Related > Payables > Payables BU Definition: Box not checked for ‘Do Not Mix with other Units’

2. Accounts Payable > Vouchers > Add/Update > Regular Entry > add a 3 vouchers
    a. Add a Voucher for BU = US001 and Supplier USA0000007
    b. Add two more vouchers for BU = US003 and Supplier USA0000007
    c. Total for all three vouchers = 6000.00

3. Accounts Payable > Batch Processes > Vouchers > Voucher Posting
    a. Post all three vouchers
    b. VCHR_ACCTG_LINE shows all three vouchers posted

4. Accounts Payable > Payments > Pay Cycle Processing > Payment Selection Criteria > Pay Cycle Manager
    a. All three vouchers paid
    b. All three paid under Payment Reference 009113

5. PYMNT_VCHR_XREF shows all three vouchers share the same PYMNT_ID = 0000010231

6. PAYMENT_TBL has one entry for PYMNT_ID_REF = 009113, PYMNT_AMT = 6000.00

7. Accounts Payable > Batch Processes > Payment > Payment Posting: Post Payment Reference 009113

8. VCHR_ACCTG_LINE shows all three Voucher posted under Payment Reference 009113

9. Set Up Financials/Supply Chain > Business Unit Related > General Ledger > Open Periods > Open Period Update: Close Accounting Period for AP

10. Accounts Payable > Payments > Cancel/Void Payments > Payment Cancellation
      a. Select PYMNT_ID_REF = 009113
      b. Void - Do Not Reissue/Close Liability
      c. Message: “The transaction Date, 2023-09-08, is not open. The open period for US001 is from 10998-01-01 to 2023-08-31. (9000,301)”
.
11. Set Up Financials/Supply Chain > Business Unit Related > General Ledger > Open Periods > Open Period Update: Reopened Period

12. Accounts Payable > Payments > Cancel/Void Payments > Payment Cancellation
     a. Select PYMNT_ID_REF = 009113
     b. Void - Do Not Reissue/Close Liability

13. Accounts Payable > Batch Processes > Payment > Payment Posting: Post Payment Reference 009113

14. Accounts Payable > Batch Processes > Vouchers > Voucher Posting: Post all three vouchers

15. VCHR_ACCTG_LINE
      a. Voucher ID V1 = Missing CANCEL and CLOSURE entries
      b. Voucher ID V2 = CANCEL and CLOSURE entries present
      c. Voucher ID V3 = CANCEL and CLOSURE entries present

16. VOUCHER for Voucher ID V1
      a. MANUAL_CLOSE_DT = 09-SEP-23
      b. CLOSE_STATUS = O
      c. PROCESS_MANUAL_CLOSE = N

Changes

Cause

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