My Oracle Support Banner

ASN FBDi Import Fails:Error The Value Provided For Column {COLUMN} Is Invalid. Value Provided: {ROI_VALUE}. Expected Value: {SYS_VALUE}. (Doc ID 2417923.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Oracle Fusion Inventory Management Cloud Service - Version and later
Oracle Fusion Receiving - Version and later
Information in this document applies to any platform.


Importing multiple ASN lines through FBDI, following error is seen in the output file of "Manage Receiving Transaction" job.
As result the ASN lines are not successfully imported.

The value provided for column {COLUMN} is invalid. Value provided: {ROI_VALUE}. Expected value: {SYS_VALUE}.

The issue can be reproduced at will with the following steps:
1. Download the FBDI template
2. Provide the shipment header details in RCV_HEADERS_INTERFACE tab
3. Provide the ASN lines in RCV_TRANSACTIONS_INTERFACE tab.
4. Generate the CSV files
5. Run the process "Load Interface File for Import" to load the interface file for "Receiving Receipt"
6. Run the process "Manage Receiving Transaction".
7. The program completes with error with the above error message in the output file.


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.