(2 votes, average: 3.50 out of 5)
Loading ...Requirement:
- We have Quote (Parent), Quote Item (Child) and Delivery Schedule (Grand Child).
- Quote Item is related to Quote and Delivery Schedule is related to Quote Item.
- There should be a button on Quote Item “Copy Delivery Schedule” when user clicks on this button he should get a prompt where he can put quote number and revision.
- The delivery schedule related to the source quote should get copied over to target quote provided by user.
- If there are any delivery schedule records present in target quote they should be deleted.
Problem:
There could be many (anywhere between 10-15) delivery schedule records related to a quote item which means, there could be performance issue if we go with traditional method of New Record and Delete Record through scripting.
Solution:
I am not going to provide any technical details of solution, I will just outline the steps performed to complete the requirement.
- Create IO based on Quote BO that will have three integration components Quote, Quote Item and Delivery Schedule
- Create NoUpdate user property on Quote IC and Quote IC (we do not want to update any information on Quote or Quote Item)
- Query for source quote using EAI Siebel Adapter BS (Query method and store the result in a property set).
- Query for target quote using EAI Siebel Adapter BS (store in another propertyset)
Now, we have two property sets one having Source Quote data and other having Target Quote data. - Get the Delivery Schedule child of source property set and attach it to target quote property set
- Use EAI Siebel Adapter Synchronize method
That’s it you are done. You can use this approach to copy any number of child entities and their records between different or same objects implementing you own custom copy routine. I know it will be much better if I could share more details related to solution but unfortunately cannot do that.
Note: I used browser script to get user input of target quote number.
Authors bio is coming up shortly.
Loading ...