My Oracle Support Banner

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:

Oracle Payables - Version 12.2 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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