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 11.13.17.11.0 and laterOracle 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 |