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

Last updated on FEBRUARY 01, 2022

Applies to:

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: A B-C D. Expected value:A BC D.

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

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