Due Date is Getting Calculated Incorrectly

(Doc ID 2411160.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle Retail Invoice Matching - Version 16.0.1 and later
Information in this document applies to any platform.

Symptoms

Following error occurs when calculating Due Date with following values for Terms:
post_dated_doc_days = 400
doc_date: 29-Jan-2017
Vdate: 30-Jan-2018
fixed_date = null
discdays = 0
duedays = 0
disc_dom = 5
due_dom = 30
cutoffday = 30
disc_mm_fwd = 1

ERROR
-----------------------
ORA-01839: date not valid for month specified

Steps to Recreate:
1. Setup the Terms with following parameters:
    post_dated_doc_days = 400
    doc_date: 29-Jan-2017
    Vdate: 30-Jan-2018
    fixed_date = null
    discdays = 0
    duedays = 0
    disc_dom = 5
    due_dom = 30
    cutoffday = 30
    disc_mm_fwd = 1

2. Create an invoice using the above terms.
3. Try to calculate Due Date and notice the below error:
    "ORA-01839: date not valid for month specified"

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