Inventory Transaction Web Service Failing Error: JBO-27014: Attribute ExternalSystemRefId in StagedInventoryTransactionCostEO is required.

(Doc ID 2340549.1)

Last updated on DECEMBER 18, 2017

Applies to:

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

Symptoms

On Fusion Inventory Management: 11.13.17.09.0
When attempting to create an Account Alias Receipt via the Transaction Manager Version 2 web service, the following error occurs.

-- Error
JBO-27023: Failed to validate all rows in a transaction.
JBO-27024: Failed to validate a row with key oracle.jbo.Key[null ITEM_PRICE ] in StagedInventoryTransactionCostEO
JBO-27014: Attribute ExternalSystemRefId in StagedInventoryTransactionCostEO is required.

-- Expected Behaviour
Expect the transaction payload to be submitted successfully and the transaction to be created

 -- Steps
The issue can be reproduced at will with the following steps.
1. SOAP UI
2. Access the Transaction Manager Version 2 Web Service
3. Open a request for the insertAndProcessInterfaceRows operation
4. Enter payload data
5. Submit the payload -> Error Occurs

-- Business Impact
The issue has the following business impact:
Due to this issue, users cannot provide transaction cost information via the web service payload

Cause

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