Invoices Are Getting Created With System Timestamp For Doc Date

(Doc ID 2338315.1)

Last updated on DECEMBER 18, 2017

Applies to:

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


Invoices getting created with system timestamp for Doc Date irrespective of the value of time component in the EDI file.

Suppose Invoice having timestamp as 000000(HH24MISS) in EDI file is getting created in im_doc_head with SYS timestamp (e.g. 144901)
Noticed that this is allowing Duplicate Invoices as timestamp in doc date is different for the same invoice when loaded again.

Steps To Recreate:

   1. Upload invoice using EDI injector, Invoice will be created in IM_DOC_HEAD table.
   2. Upload again for the same invoice number, supplier and invoice date.

       Noticed that the second invoice is uploaded successfully.


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