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 MAY 30, 2017

Applies to:

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

Symptoms

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: CLL F189 INTEGRATED RCV

4. Path: Invoices -> Entry -> Invoices
5. Query the invoice (INVOICE_test_-_error_calendar.doc)

The due date is 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 CLL F189 INTEGRATED RCV.
It does not work with another payment term.

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

NOTE:
Created the invoice with the payment term for (5 DDL) and invoice date 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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms