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 NOVEMBER 27, 2019

Applies to:

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

Symptoms

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.

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

STEPS
-----------------------
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.

Cause

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
Symptoms
Cause
Solution


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