My Oracle Support Banner

Received Error When Creating An Invoice With Document Date < Vdate -1 (Doc ID 2307849.1)

Last updated on MARCH 04, 2019

Applies to:

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


The following error is received when trying to create an invoice with document date < vdate-1.

Steps to Reproduce:
1. Create Purchase Order (PO), ship and receive it fully.
2. Create invoice for the PO with document date < vdate-1 and click on save.
3. Notice that error message "ORA-01858: a non-numeric character was found where a numeric was expected" appears.
4. Create invoice for the PO with document date>=vdate-1 and click on save.
5. Notice that the invoice is created.

Note: issue began after applying PATCH_26611786




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.