Error Invoking Service 'Row Set Transformation Toolkit', Method 'Hierarchical Transform' (Doc ID 1547059.1)

Last updated on AUGUST 02, 2017

Applies to:

Siebel Communications - Version 8.1.1.7 SIA [21238] and later
Information in this document applies to any platform.

Goal

Customer facing an issue for orders placed via B2B. In the xml received we are getting the Integration Id value for both the root
and the child order line item as the same value from the B2B interface and when it hits Siebel the order creation fails.
When we manually change the Integration Id to unique values and hit the XML it works fine.
 
We had taken the log (attached of EAI Object manager)and analyzed the issue, we found that the following error is
coming up in the workflow "CRM Product Validation Workflow" in the step "Create Session" that calls the business service "Complex Object Instance Service".
So when trying to click on Save in the eConfigurator screen we got the following error captured,
 
 
---------------------------
Windows Internet Explorer
---------------------------
Error invoking service 'Row Set Transformation Toolkit', method 'Hierarchical Transform' at step 'Customizable Product Roll-Down'.(SBL-BPR-00162)
The [Hierarchical Transform] encountered two rows in the input Row Set with the same value '1' in field 'Id'. This field needs to have a unique value.(SBL-PSP-00601)
---------------------------
OK
---------------------------
 
Since the Row Set Transformation Toolkit is present only in 8.1 and not in 7.7,
we are able to create the orders successfully in 7.7 even for the cases where the Root and Child have the same Integration Id.
 

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