Inventory Transaction Web Service Failing Error: JBO-27014: Attribute ExternalSystemRefId in StagedInventoryTransactionCostEO is required.
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.
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.
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
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
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