ECM: Book to Bank Reconciliation Details > Payments in Transit Page Displays the Wrong Reference IDs When Expense Report Is Cancelled And Re-Issued (Doc ID 3030273.1)

Last updated on JUNE 24, 2024

Applies to:

Symptoms

Book to Bank Reconciliation Details > Payments in Transit page is displaying the same Transaction Reference ID for the original Expense Report, the Cancelled Expense Report, and the Re-issued Expense Report, which is incorrect. All three Expense Reports should not have the same Transaction Reference ID. The Transaction Reference ID that is displaying is the Transaction Reference ID for the Re-issued Expense Report. The original Expense Report and the Cancelled Expense Report should have a different Transaction Reference ID.

STEPS TO REPLICATE
1. Set Up Financials/Supply Chain > Install > Installation Options > Expenses 
    a. Workflow Enabled box is checked
    b. Accounts Payable is selected
    c. HR Manager – Supervisor is selected
2. Set Up Financials/Supply Chain > Product Related > Expenses > Management > Approval Setup > Map Approval Trans Definition - Transaction Type = Expense Report, Active box is checked for HR Supervisor
3. Log in as xxxx
4. Employee Self Service Fluid Homepage, click the Expenses tile
5. Click the Create Expense Report tile - Create an Expense Report and Submit
6. My Expense Reports page, under Awaiting Approval, confirm the transaction has been routed to the HR Supervisor
7. Log in as yyyy (Expenses HR Supervisor)
8. Employee Self Service Fluid Homepage, click the Approvals Tile - Select the Expense Report, click Approve and Submit
9. Log in as zzz (System Administrator)
10. Travel and Expenses > Process Expenses > Expense Processing - Run Expense Processing with the following options checked:
      a. Stage Payments
      b. Post Liabilities
11. General Ledger > Journals > Subsystem Journals > Generate Jrnl from Subsystem - Run Journal Generator with the following options:
      a. Edit and Post boxes are checked
      b. Accounting Definition Name = EXDEFN
      c. Template = EXACCRUAL
12. Travel and Expenses > Process Expenses > Update Staged Payments > Expense Report Payments - Verify that the Expense Report is staged for Payment
13. Accounts Payable > Payments > Pay Cycle Processing > Payment Selection Criteria
      a. Payment Selection Criteria > Source / BU page, specify Source Transaction = EXPN
      b. Payment Selection Criteria > Dates page, click the Pay Cycle Manager link
      c. Pay Cycle Manager page, pay the Expense Report
      d. First Payment = 009130
14. Run Expense Processing with the following options checked:
      a. Post Payments
      b. Update Paid Statuses
15. Run Journal Generator with the following options:
      a. Edit and Post boxes are checked
      b. Accounting Definition Name = EXDEFN
      c. Template = EXPAYMENT
16. Accounts Payable > Payments > Cancel/Void Payments > Payment Cancellation
      a. Cancel the Payment with Void / Re-open Voucher(s) Re-issue
      b. Click OK to the message:
          Warning -- Treasure or Expense transaction payment is being processed (7015,406)
          This is a Treasure or Expense transaction payment, you will need to go back to Treasure or Expense to manually reverse any accounting entries affected by this process. Proceed?
17. Run Expense Processing with the option of Cancel Payments checked
18. Run Journal Generator with the following options:
      a. Edit and Post boxes are checked
      b. Accounting Definition Name = EXDEFN
      c. Template = EXCANCEL
19. Expense Report Payment page, verify that the Expense Report is staged for Payment
20. On the Pay Cycle Manager page, pay the Expense Report - First Payment = 009131
21. Run Expense Processing with the following options checked:
      a. Post Payments
      b. Update Paid Statuses
22. Run Journal Generator with the following options:
      a. Edit and Post boxes are checked
      b. Accounting Definition Name = EXDEFN
      c. Template = EXPAYMENT
23. Accounts Payable > Vouchers > Add/Update Regular Entry
      a. Add a Voucher for Total = 300.00
      b. Voucher > Payments page, click the Express Payment link to pay the Voucher through Express Payment Manager – Pay Cycle
24. Accounts Payable > Batch Processes > Payment > Payment Posting - Run Payment Posting to post the Payment
25. Banking > Bank Statements > Enter Bank Statements > Bank Transaction Entry page - Create a Bank Transaction for the amount of the above Voucher that was paid (300.00)
26. Banking > Reconcile Statements > Semi-Manual Reconciliation - Reconcile the above Bank Transaction to the Voucher Payment
27. Banking > Reconcile Statements > Select Book To Bank Statements - Select the above Bank Statement and click Select and Calculate
28. Banking > Reconcile Statements > Book to Bank Reconciliation
      a. Display the above Bank Statement and click the Details icon
      b. Book to Bank Reconciliation Details page, click the Payments in Transit icon
      c. Payments in Transit page, above 3 Expense Reports are displayed with the same Transaction Reference ID of 009131, which is incorrect
29. The Re-issued Expense Report is the only row that should have the Transaction Reference ID of 009131
30. The Original Expense Report and the Cancelled Expense Report should have the same Transaction Reference ID of 009130

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.