My Oracle Support Banner

Receiving Open Interface - Create Receipt/ASN Runs In Error: "The value provided for column ITEM_ID is invalid" (Doc ID 2425026.1)

Last updated on JUNE 27, 2023

Applies to:

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


When attempting to run Manage Receiving Transactions process ( Import ASNs using FBDI)
the following error occurs.

"The value provided for column ITEM_ID is invalid. Value provided: 123456789. Expected value: 987654321."

The issue can be reproduced at will with the following steps:
1. use the Receiving Open Interface - Create Receipt/ASN template
2. Enter the required details, and upload the file
3. The Manage Receiving Transaction log file shows the errors


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.