ORA-01843 occured When upload invoice trough FBDI from Japanese Client

(Doc ID 2228049.1)

Last updated on MARCH 15, 2018

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

When upload the invoice data trough FBDI, following error occurs:

ERROR
---------------
Record 1: Rejected - Error on table AP_INVOICES_INTERFACE, column
INVOICE_DATE.
ORA-01843: not a valid month

STEPS TO REPRODUCE:
1. Enter the data into Spread sheet.
2. Create CSV file.
3. Upload the CSV file.

ADDITIONAL INFO
----------------
This issue happens on Japanese client and also, Microsoft Office is installed for English only.

Solution

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