My Oracle Support Banner

R12.1:JL:AP: 26168502 Due Date Is Not Being Calculated Based On The Holidays Using Con Program (Doc ID 2271730.1)

Last updated on AUGUST 19, 2020

Applies to:

Oracle Financials for the Americas - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Brazil AP Globalization

The due date is not being calculated based on the holidays and/or weekends
 as per Brazilian calendar setup.

Expect to see the correct due date.

The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables - Brazil localization
2. Path: Other -> Requests -> Run
3. Run the Payables Open Interface Import Report
Source Name: '&SOURCE_NAME'

4. Path: Invoices -> Entry -> Invoices
5. Query the invoice 

The due date is example Apr, 21 2017.
As this is a holiday in the calendar the correct is to have it changed to the next business day (24-APR-2017) after Invoice validation.

6. Validate the invoice manually.

The due date is updated correctly.

7. Other -> Requests -> Run
8. Run Invoice Validation concurrent program

The due date is not being calculated based on the holidays and/or weekends as per Brazilian calendar setup.
The due date should consider the holidays and/or weekends as per Brazilian calendar.

The problem occurs for ALL invoices (matched or not to a PO).
The issue also occurs with customization disabled.

The problem occurs ONLY when invoices are validated by the concurrent Import Validation program. When the invoice is validated manually the issue does not occur even if
it was imported from different source.
It does not work with another payment term.

WORKAROUND: Online invoice validation.
Not feasible as there are thousands of invoices per day.

Created the invoice with the payment term for example (5 DDL) and invoice date for example 15-may.
The correct would be to update the payment date to May 22, but the validation program kept the date of May 20 (Saturday). Did not change to 22-May (Monday), which is the next business day.

The issue has the following business impact:
Due to this issue, users cannot see the correct due date on the invoice.




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

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