Fusion Receiving: Interface API Returns "Item Description Invalid Error"
Last updated on AUGUST 21, 2016
Applies to:Oracle Fusion Receiving - Version 1.0-Beta to 188.8.131.52.0 [Release 1.0]
Information in this document applies to any platform.
Checked for relevance on 14-Mar-2015
Users are trying to perform the PO Receiving transaction by inserting data in RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE and then calling RCV_PROCESSOR_PUB_WRAPPER.PROCESS_TRANSACTIONS (wrapper to Oracle API RCV_PROCESSOR_PUB.PROCESS_TRANSACTIONS) to process the record. The API returns Success (S) but there is an error message records in RCV_INTERFACE_ERRORS table reflects error for the interface record.
The error returned is - The value provided for column ITEM_DESCRIPTION is invalid. Value provided: CHEESE PEPPER-JACK SLICED. Expected value: CHEESE PEPPERJACK SLICED.
The error is due to different item description values on the Purchase Order line (PO_LINES_ALL) and Item in Inventory (EGP_SYSTEM_ITEMS_TL).
1) Should Item Description be different on Purchase Order line and the one in inventory, what is the reason behind it,
2) We are not populating the item description value in RCV_TRANSACTIONS_INTERFACE, the value gets calculated when the processing API - RCV_PROCESSOR_PUB_WRAPPER.PROCESS_TRANSACTIONS hence the value needs to be calculated correctly else the column should be ignored since the Item number and Inventory Item Id is already validated
3) The processing API - RCV_PROCESSOR_PUB_WRAPPER.PROCESS_TRANSACTIONS should return 'E' if there is an error in RCV_INTERFACE_ERRORS table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms