My Oracle Support Banner

Invoice Induction Completed with Error "Invalid document date" (Doc ID 2699397.1)

Last updated on AUGUST 20, 2020

Applies to:

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

Symptoms

Invoice Induction with error in date format

Error while uploading invoices via spreadsheet related to invalid invoice date formats in the input ods file.
The error seems to be related to rule ‘PV_DOC_DATE’ as in ‘IM_INJECT_DOC_RULE’ table.
Several date formats were tested but all leads to error.
The date format should be either consistent with the 'BatchDate Format' system variable (yyyyMMddHHmmss) or the error message should provide the date format expected.

Steps to reproduce:
1. Download invoice template from ReIM (example used was Merchandise Invoice with Details and Tax)
2. Populate spreadsheet (set invoice date as 20200508000000)
3. Upload invoice
4. Check results in 'Manage Requests' Screen
5. Download errors and check that date format is wrong
As mentioned the message is not clear and documentation needs correction



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
Cause
Solution
References


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