Solved

Siebel letters generated in bulk and attached to the account

Posted on 2009-05-18
4
1,191 Views
Last Modified: 2012-05-07
I am a business analsyt and I have just been assigned to the implementation of a Siebel 8 system on Oracle. (No previous Siebel experience)

We are trying to find a way to send letters out to accounts. They need to:
1. Include fields from Siebel and standard text (I.e. like a mail merge)
2. be sent based on specific criteria (some of the criteria includes customised fields),
3. Generated in bulk (there are too many to be created individually)
4. Attached to the account record (so we have a record of the correspondence sent to the account).

We have been informed by the consulting company that is providing the implementation that this is not technically feasible using Siebel/Oracle.

We have been told that
A. Correspondence templates will provide us with the bulk generation but will not provide us with the customised criteria and will not automatically attach the letter to the account record.
B. Proposals will allow us to attach the record to the account record, but will not allow us to generate the letters in bulk.

They have suggested using Microsoft Word to do a mail merge in bulk or to use proposals to create the letter individually.

Does anyone know of a way to meet all four of our requirements using Siebel?

Thank you heaps,
Nikki
0
Comment
Question by:NikkiGu
  • 2
  • 2
4 Comments
 
LVL 18

Accepted Solution

by:
BigSchmuh earned 500 total points
ID: 24420341
All this needs can be solved using some script on the Correspondence feature.
This is technically feasible...I did it on SIA 7.7 for a large french retail company.

What I think are good starting point to evaluate your specifications:
-Build a script to generate the Correspondence rows using any specific criteria
-Automatically pool for Correspondence to be generated and call the browser script BusinessService function that calls the Word merge embedded in the eDocument component
-Activities will be generated by the standard Correspondence "Generate" function
-Activities may be later modified to account for specific parameters (Attaching to Account?)

(From BearingPoint France, Business System Integration team)
0
 

Author Comment

by:NikkiGu
ID: 24427781
Hi BigSchmuh,

Thank you for your response. This is very encouraging. Can I check a few more things with you.

A. Can the criteria come from other tabs within Siebel? For example a lot of our criteria is on a tab caled "Reviews" and a tab called "Actions" which I believe are customised. (a lot of the fields for the letters also come from these tabs).
B. You have said that "Activities" will be generated. Is this a letter? or an Alert. We need a letter.
C. The have also told us that Correspondence can only contain simple letters and some of our letters are too complex and will need to be proposals. Is this true?
D. Since all the letters have a clear trigger (I.e. state change or field entry or date passing) is it possible to automatically trigger correspondence? (if not it's not a problem as this is a desirable requirement as opposed to an essential requirement).
E. I will be passing on this information to the consulting company. Will I need extra information or should they be able to investigate it using the response you made?

Thanks heaps,
Nikki
0
 
LVL 18

Expert Comment

by:BigSchmuh
ID: 24429516
A. Using Scripts allows almost anything...at the cost of development and maintenance !
B. What you need are some SIEBEL experts locally to support your project
C. Correspondence is the Word Merge function, if you can use it for your "complex" needs then it's possible using the eDocument (Correspondence) component
D. Workflows are good at triggering things
E. Enrole some consultants to challenge them...or pay with eyes closed
0
 

Author Comment

by:NikkiGu
ID: 24436830
Thanks Big Schmuh
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In today’s complex data management environments, it is not unusual for UNIX servers to be dedicated to a particular department, purpose, or database.  As a result, a SAS® data analyst often works with multiple servers, each with its own data storage…
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now