Standard Payables Invoice FBDI is causing error on the expenditure item date format
Summary:
When uploading invoices via FBDI Template, we are getting error on the expenditure item date field "Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column PJC_EXPENDITURE_ITEM_DATE.ORA-01861: literal does not match format string"
We are using the exact same date format provided in spreadsheet but still somehow its not reading, shows as bad text and converting the date automatically to a numeric number like 45826.Can someone please guide us on how can we rectify this issue and submit an invoice?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Tagged:
0