R12: AP/IBY: Cash Requirement Report Is Not Pulling The Discount Due Date Invoices Correctly (Doc ID 3039760.1)

Last updated on OCTOBER 07, 2024

Applies to:

Symptoms

Payables "Cash Requirement Report" not pulling discount invoices and due invoices correctly. This issue exists only with invoices whose due date / discount date fall on the sysdate.

The issue can be reproduced at will with the following steps:
1. Payables responsibility(N)>Payment>Entry>Payment Manager
2. Submit Cash Requirement report
3. Verify the output

Changes

Report main query modified to have trunc() on p_check_date to address the issue with invoices of this specific criteria.

Cause

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