IMCS Invoices Failed To Import Into CFIN Due To Double Quotes In The Invoice Number (Doc ID 2947795.1)

Last updated on MAY 10, 2023

Applies to:

Goal

IMCS invoices are not reaching CFIN due to double quotes in the invoice number.

Steps to re-create issue:

1. Create an invoice in IMCS with the double quote character (e.g. 15859")

2. Match the invoice with the receipt

3. Invoice posted in IMCS

4. Invoice passes through BDI/RFI

5. In RFI, a failure is logged in the "ReIM To Financial - Invoice Entry" service adapter log:

ERROR ErpIntegrationServiceConsumer - File upload process complete with status: ERROR
ERROR ErpIntegrationServiceConsumer - Setting processed records from EXT_FIN_SYSTEM_FILES_CONTENT table as error
DEBUG BaseOracleDao - EXECUTING : update EXT_FIN_SYSTEM_FILES_CONTENT set STATUS = ?, LAST_UPDATE_DATE = sysdate, ERROR_MSG = ? WHERE EXT_FIN_SYSTEM_FILES_CONTENT.FILE_ID IN (?, ?)[E][Unable to upload File Content. Check INVOICE_HEADER INVOICE_DETAIL logs for more information ][yyyy][zzzz]
...
DEBUG BaseOracleDao - EXECUTING : insert into RFI_ODI_LOGS (SEQUENCE_NO, ERROR_TYPE, RUN_DATE, CONSTRAINT_NAME, CONSTRAINT_TYPE, ERROR_ORIGIN, IS_NOTIFIED, ERROR_MESSAGE, LOG_MESSAGE) values (?, ?, ?, ?, ?, ?, ?, ?, ?)[tttt][FILE_TRANSFER_NOTIFICATION][timestamp][null][null][RFI to CFIN - UCM Upload Error][N][Unable to upload File Content. Check INVOICE_HEADER INVOICE_DETAIL logs for more information ][[yyyy, zzzz]]
...
INFO InvoiceEntryBean - Upload file process complete with status : FAIL

Solution

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