Fusion Receiving: Interface API Returns "Item Description Invalid Error" (Doc ID 1584603.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Fusion Receiving - Version 1.0-Beta to 11.1.7.0.0 [Release 1.0]
Information in this document applies to any platform.
Checked for relevance on 14-Mar-2015

Goal

Background
===============
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).

Questions
===============
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.
 

Solution

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