New Comment System@Siebel Unleashed.. Do Try and give me feedback | Next Tip »Home

Siebel message and Product Configurator

OkAvarageGoodVery GoodExcellent (4 votes, average: 5.00 out of 5)
Loading ... Loading ...

Let me clarify this in start this post discuss kind of advance concepts so if you are not able to understand the terms Quote Line items, Product Configurator, SiebelMessage, EAI Siebel Adapter, Root Item then this post is not for you.

Few days back I had a chance to work on interesting requirement. We were to receive an XML in form of SiebelMessage that will have basic information for Quote and complete information about Product (Quote Item) and its attributes (Quote Item XA)

We needed to provide user with a button which will allow user to browse for XML file on his system and once he chooses correct XML it will update the Quote with new information and create Quote Item and Quote Item XA records.

Solution Approach:

I am not going to share complete technical details but just going to provide approach for the solution.

  • Create a New Form Applet based on attachment BC
  • Create a button control on applet, on which you want user to click
  • Have method name as ShowPopup
  • Create control user property specifying Mode and Name of Applet that you created above
  • On Submit button of this pop up applet call a workflow or business service that will do processing on this attachment.

Problem:

Updating Quote, creating Quote Item and Quote Item XA record was pretty straight forward using EAI Siebel Adapter bs with Upsert method we created records successfully but we were not able to customize those products in Product Configurator.
As soon as we clicked on customize button which opened Product Configurator session, all the product attributes and products there were inserted from XML were removed and we used to get a default product structure.

Solution:

After lot of R&D we were able to find root cause of the problem.
There are three important fields in Quote Item which should be populated with correct values, if we want Product Configurator to work correctly

  • Cfg State Code
  • Cfg Type
  • Product Port Id

Cfg State Code: This field should have value ‘Saved Item’ (without quotes). When you configure a product in product Configurator session and click on ‘Done’ button, Product Configurator sets this value and if this value is missing then Product Hierarchy is considered to be invalid and it is reset.

Cfg Type: This field should have value ‘eConfigurator’ (without quotes). I haven’t tried it with other values but I think Product Configurator requires some value in this field and if it is null then it will reset the hierarchy.

Product Port Id: This field should have the Relationship Id of the product that you are trying add. Only way I know to get the correct value is to use business service ‘Remote Complex Object Instance’ with  GetAllPorts method, which gives you a hierarchy as an output and you need to traverse that hierarchy to get the correct value.

Cfg Type and Cfg State Code values only needs to be set at Root Quote Item but Product Port Id field needs to be set for all the sub products that are part of hierarchy. Once you populate these fields with correct values you will be able to customize the product correctly.

  • Share/Bookmark

Related Posts


Article by neel

Authors bio is coming up shortly. neel tagged this post with: , Read 387 articles by neel
  • Vijay
    hi Nisha,
    This is possible when two records with different user key values were loaded and then by interface (EAI not EIM) someone changed the name and made both the records with the same user keys.

    For ex: Customer Name and LOC fields in S_ORG_EXT

    Rec 1. TESTC1 1234

    Rec 2. TESTC2 1234

    Now EAI updated the second record to TESTC1

    Now the values are

    Rec 1. TESTC1 1234

    Rec 2. TESTC1 1234

    Now that two of the records have the same user keys , if you try to update with EIM , it will not understand which one to update so AMBIGOUS error will occur.
  • nisha
    Hi,

    I am new to siebel EIM.
    can any one clarify about AMBIGUOUS error.

    It is been mentioned in document that two records with same userkey values with different conflict Ids.

    My question is how can it be possible having two records with same user key values?

    Thanks
    Nisha
  • Ravi Nagam
    Can u please provide the technical details regarding upserting the Quote , Quote Item and XA details in to the database.When ever i am trying to upsert the same i am facing lot of isssues.Can u send me the fields at quote item level that are to be provided mandatorily(Data Mapper Details)
  • Anon
    We faced the same issue when we loaded Quotes, Orders via EIM. EIM doesn't have user key for above configurator columns. We ended up runing business service ‘Remote Complex Object Instance’ after EIM and it worked fine
  • Very useful stuff for those working with Customer Order Management. Thanks!
  • kusum
    Good Information
blog comments powered by Disqus

Polls

Do you like the new Comment System and new look to Site?

View Results

Loading ... Loading ...