27
Mar
Posted by Suansh Singhal in Utility/Tool. Tagged: siebel, document, excel, extract, Siebel Repository Extract, Repository, object, siebel tool, copy, export, macro, technical design, low level design, MS Excel, Changed object, tdd, lld, S_PICKLIST, S_APPLET, S_BUSOBJ, S_BUSCOMP, S_LINK, S_VIEW, S_SCREEN, S_INT_OBJ, S_TABLE, S_WFR_PROC, S_CONTROL, S_APPLET_UPROP, S_BUSCOMP_UPROP, S_BC_VIEWMODE, S_FIELD, S_JOIN, S_MVLINK, S_BOCOMP, S_SCREEN_VIEW, S_INT_COMP, S_COLUMN, S_WFR_PROC_PROP, S_WFR_STP, S_LIST_COLUMN, S_FIELD_UPROP, S_PICKMAP, S_JOIN_CONSTRNT, S_JOIN_SPEC, S_INT_FIELD, S_VIEW_WTMPL_IT, S_WFR_STP_ARG. 5 Comments
Launching
Pic – Dashboard
Development Challenge
- Manually extracting new/modified object details from Siebel repository to prepare Technical Design Document.
- Time-consuming process – With the increase in number of objects, time taken to extract them also increases proportionally.
Solution
- Siebel Repository Extract (SRE) Tool
- SRE Tool will automate the process of extracting Siebel object details from Siebel repository to excel sheets.
- It will also formats the data, making it ready to be used in your Technical Design Document.
Process Improvement
- Eliminates the need of manual efforts.
- Achieves time reduction of 99.29%.
Features
- Supports 31 most commonly worked upon Siebel Object Types.
- Supports access to Server, Local or Sample databases through ODBC connections.
Versions Available
Trial vs Full Version
Download Presentation/User Guide
Download Trial Version
Purchase Full Version
In case, you face any difficulty downloading/purchasing the tool, please leave a comment.
19
Feb
Posted by Suansh Singhal in Books - Siebel, Functional Topic, Party Data Model. Tagged: Generate Reporting Hierarchy, INT_ORG_FLG, Party Data Model, Party Model, PRTNR_FLG, siebel, Siebel 8.1.x, siebel party, Siebel party model, S_BUS_PARTY_RPT_REL, S_CONTACT, S_EMP_PER, S_GROUP_CONTACT, S_ORG_EXT, S_ORG_GROUP, S_ORG_PRTNR, S_PARTY, S_PARTY_GROUP, S_PARTY_PER, S_PARTY_REL, S_PARTY_RPT_REL, S_PER_RESP, S_POSTN, S_USER, S_USERLIST, What is a Contact or Person, What is a Division, What is a Household, What is a Partner Organization, What is a Position, What is a S_PARTY_PER Table, What is a S_PARTY_REL Table, What is a S_PARTY_RPT_REL Table, What is a User, What is a User List, What is an Access Group, What is an Account, What is an Employee, What is an Organization. Leave a Comment
Launching eBook
Party Data Model
(Siebel 8.1.x)
TO PURCHASE/PREVIEW
For eBook edition (at 50% discount), go to - http://pothi.com/pothi/book/ebook-suansh-singhal-siebel-8-1-x-party-data-model-0
For printed edition, go to - http://pothi.com/pothi/book/suansh-singhal-siebel-8-1-x-party-data-model-paperback
INTRODUCTION
This book starts with an introduction to the concept of Siebel’s Party Data Model. Then, it describes each entity under the model with examples and practice labs. At last, this book summarizes all the concepts in two diagrams for quick reference.
– Target Audience –
• Business Analysts
• Siebel Consultants (Techno-Functional)
• EIM Specialists
• EAI Specialists
– Distinguishing features of the book –
• Detailed discussion on each Party entity
• 60+ colored diagrams
• 20+ practice labs
TOPICS COVERED
- Party Data Model – Introduction
- Party Data Model – History
- What is a Contact or Person
- What is a User
- What is an Employee
- What is a Position
- What is an Account
- What is a Division
- What is an Organization
- What is a Partner Organization
- What is a Household
- What is a User List
- What is an Access Group
- What is a S_PARTY_PER Table
- What is a S_PARTY_REL Table
- What is a S_PARTY_RPT_REL Table
- Generate Reporting Hierarchy
22
Sep
Posted by Suansh Singhal in Q and A. Tagged: business component, event, interview question, runtime event, script, siebel, writerecord. Leave a Comment
Question
Which executes first – An escript on WriteRecord of a BusComp or a Runtime Event on Writerecord of same BusComp?
Answer
Runtime Events fire before any script events.
13
Aug
Posted by Suansh Singhal in Functional Topic, Party Data Model. Tagged: Administration – User, Data Model, Party Model, siebel, S_CONTACT, S_PARTY, S_PER_RESP, S_USER, User, User Id. Leave a Comment
User is a person/contact with User ID. For example – A registered customer on your Web site browsing/ordering products online.
Parties Person – Venn Diagram
User records can be seen in following application view:
- Administration – User > Users
- Contacts > All Contacts
Characteristics of a User
- May have associated responsibility leading to application access.
- May have any associated positions.
- Must have a User ID leading to database login.
- It is possible to promote a contact/person to a user.
- Adding a User ID value for a person record in Persons view causes it to appear as a user in the Users view.
What is User – Application View
Database Tables
Tables representing a User record are highlighted below:
- Base Table – S_PARTY
- Extension Tables
- S_CONTACT – Stores First and Last Name of user.
- S_USER – Stores User ID.
- Intersection table – S_PER_RESP (not shown) stores responsibilities for users.
Table Architecture – User
Complete Overview of Party Data Model
To study Siebel’s Party Data Model in detail, please preview/download:
5
Aug
Posted by Suansh Singhal in Utility/Tool. Tagged: attachment, attachment file, EIM, EIM_OPTY_DTL, Enterprise, extract, how to extract attachments, IFB, Integration, Manager, opportunity, siebel, S_OPTY, S_OPTY_ATT. 5 Comments
Scenario
During upgrade process, over 11,000 Opportunities were identified for migration. Also there were attachments associated with these opportunities.
Approaches
I short-listed following two ways to pull out the attachment files:
- Client-side Business Service
- EIM export
After initial POC, I settled down with EIM export option.
Reason - EIM job extracts the attachment files and place them at specified location. Now suppose if there are multiple files with the same name, what will happen? In this scenario, EIM job automatically appends file name with numerals (like 1, 2, 3 and so on) and further saves the file.
But with the client-side scripting, this scenario needs to be handled explicitly.
Solution
To download the required IFB file (enclosed in word document), click here >> ExtractOptyAttachments – IFB
Limitation: Only 1000 Row Ids can be specified at maximum in each IFB file. Therefore to extract attachment files for 11,000 opportunities, I had to prepare 11 IFB files and run each of them.
