ECM: Bank Recon (BNK_RECON) Process With Recon Date Tolerance Is Not Skipping Holidays (Doc ID 2781546.1)

Last updated on JUNE 02, 2023

Applies to:

Symptoms

Bank recon (BNK_RECON) process with recon date tolerance is not skipping holidays.

Steps:

    1. Bank tolerance setup : Day_30_30.
    2. Standard Business Calendar setup: Use delivered 01.
    3. Bank Account Reconciliation rules:
- AP_11_CHK_REF_02
- Date Tolerance: DAY_30_30
- Holiday list: 01 - Standard

    4. Enter a bankstatemnt:

- Statement date: 01/14/2021
- Creation date: 01/14/2021
- Statement code: 495
- Reference: 240221
- Transaction amount: -7
- Value date: 01/14/2021

    5. Create a voucher and pay it through manual payment:

- Payment date: 24 Feb 2021

    6. Process Reconciliation:

- Reconciliation status: Tran Date <> Value Date

    7. Select * from PS_BNK_RCN_ST_T14

- Recon_Bank_DT: 14-jan-2021
- To_Date: 13-Feb-2021

NOTE: System is not skipping the holidays (Saturdays and Sundays) for date tolerance DAY_30_30. When Bank recon date is 14 JAN 2021, the "from" and "to" dates should be 30 business days apart.

Cause

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