17Sample Database Test Scripts

Sample Database Test Scripts

The following table shows the list of scripts available in the sample database.

Master Suite	Test Set	Sequence	Test Scripts	Description
COM_SampleDBDemo _Desktop	COM_Sample DB_ABOFlows	1	COM_SampleDB_ NewOrderFlow	Ron Weasley is a residential customer looking for a good deal on a new family wireless plan. Ron calls the wireless carrier for a quotation. The contact center agent looks up Ron Weasley's account, browses the product catalog, selects the best family wireless package and offers three new phones for Ron's family at varying price points.
COM_SampleDBDemo _Desktop	COM_Sample DB_ABOFlows	2	COM_SampleDB_ UpdateOrder	David Smith is an existing residential customer who has a family wireless plan. David calls the wireless carrier to add additional lines to his family package. Contact Center agent looks up David Smith's account and adds 5 new lines to David's account. The CRM system notifies the agent that David's current package is limited to 4 lines. The agent adds 3 new lines as one line is already associated to David, selects the options for text messages, data plan and reviews the order details with David.
COM_SampleDBDemo _Desktop	COM_Sample DB_ABOFlows	3	COM_SampleDB_ DebundlePromotion	David is an existing residential customer who has a family wireless plan. David calls the wireless carrier to remove his spouse from the family package and make it an individual plan.
COM_SampleDBDemo _Desktop	COM_Sample DB_ABOFlows	4	COM_SampleDB_ Upgrade PromotionFlow	Suzie Harera is a residential customer who has a basic quad play bundle - Internet, TV, Home Phone and Wireless Phone. Suzie calls the contact center to upgrade to a premium quad play bundle.
COM_SampleDBDemo _Desktop	COM_SampleDB_ BulkOrder	1	COM_SampleDB_ BulkOrder_New OrderFlow	Axiom Financial Group is a business customer that purchases 50 wireless service plans with pre-assigned numbers from the Communication Service Provider's Account Manager. The Account Manager connects to the CSP's commerce application, creates an account list, and places a bulk order to onboard 50 new users. Alternatively, Axiom Financial Group requests an optional feature "WLAN Subscription" to be added for 20 of its loyal users. Competitive pressure requires the communication service provider to upgrade all Promo 60 plan customers to Promo 120 plan.
COM_SampleDBDemo _Desktop	COM_SampleDB_ BulkOrder	2	COM_SampleDB_ BulkOrder_Modify Flow	Same description as in previous row.
COM_SampleDBDemo _Desktop	COM_SampleDB_ BulkOrder	3	COM_SampleDB_ BulkOrder_Upgrade OrderFlow	Same description as in previous row.
COM_SampleDBDemo _Desktop	COM_SampleDB_ ProductOffer	1	COM_SampleDB_ ProductOffer_Data Setup	Communication Service Provider creates a targeted mass market offer across varying channels (Web, Retail store, SMS). Customer accepts the offer(s) using a single click: offer to add free worldwide calls to their current wireless package at a 50% discount during the holiday season, upgrade their SMS package to higher package or auto-renew their contract.
COM_SampleDBDemo _Desktop	COM_SampleDB_ ProductOffer	2	COM_SampleDB_ ProductOffer_ ModifyAdd	Same description as in previous row.
COM_SampleDBDemo _Desktop	COM_SampleDB_ ProductOffer	3	COM_SampleDB_ ProductOffer_ ModifyReplace	Same description as in previous row.
COM_SampleDBDemo _Desktop	COM_SampleDB_ ProductOffer	4	COM_SampleDB_ ProductOffer_ ModifyUpgrade	Same description as in previous row.
COM_SampleDBDemo _Desktop	COM_SampleDB_ PG_Flows	1	COM_SampleDB_ PG_Data_Setup_1	Product administrator verifies the community offer (promotion group) defined in the system using Siebel administrator (SADMIN) login. PG Scenario 3 disconnects a Silver Participant membership and Nation 550 Minutes bundle promotion for PGA2 child account and it also disconnects the entire promotion group from PGA1 account.
COM_SampleDBDemo _Desktop	COM_SampleDB_ PG_Flows	2	COM_SampleDB_ PG_Data_Setup_2	Same description as in previous row.
COM_SampleDBDemo _Desktop	COM_SampleDB_ PG_Flows	3	COM_SampleDB_ PG_Scenario_1	Same description as in previous row.
COM_SampleDBDemo _Desktop	COM_SampleDB_ PG_Flows	4	COM_SampleDB_ PG_Scenario_2	Same description as in previous row.
COM_SampleDBDemo _Desktop	COM_SampleDB_ PG_Flows	5	COM_SampleDB_ PG_Scenario_3	Same description as in previous row.
COM_SampleDB Demo_Telco	COM_SampleDB_ Telco_Desktop	1	COM_SampleDB_ Telco_DataSetup Flow	CitiExpress is a business customer. Tim is a B2B sales rep for a leading Communication Service Provider (CSP). CitiExpress is Tim's customer with a wireless contract for 1000 employees. CitiExpress wants to change the barring options for 4 of their employees' phones and change the SIM number for an employee who had recently lost his phone. Tim connects to CSP's commerce application, searches for his customer, and place an order to change the barring options and change the SIM card number.
COM_SampleDB Demo_Telco	COM_SampleDB_ Telco_Mobile	1	COM_SampleDB_ Telco_ChangeSIM _Messages	Same description as in previous row.
COM_SampleDB Demo_Telco	COM_SampleDB_ Telco_Mobile	2	COM_SampleDB_ Telco_SelectAll _Remove	Same description as in previous row.
COM_SampleDB Demo_Telco	COM_SampleDB_ Telco_Mobile	3	COM_SampleDB_ Telco_ChangeSIM_ SubmitOrder	Same description as in previous row.
COM_SampleDB Demo_Telco	COM_SampleDB_ Telco_Mobile	4	COM_SampleDB_ Telco_AddRemove_ Flow1	Same description as in previous row.
COM_SampleDB Demo_Telco	COM_SampleDB_ Telco_Mobile	5	COM_SampleDB_ Telco_AddRemove_ Flow2	Same description as in previous row.
COM_SampleDB Demo_Telco	COM_SampleDB_ Telco_Mobile	6	COM_SampleDB_ Telco_DataCleanUp	Same description as in previous row.
COM_SampleDBDemo _Mobile	COM_SampleDB _PartnerCommerce	1	COM_SampleDB_ PartnerCommerce_ NewOrder	Samuel Crenshaw is a partner user and places an order on the wireless carrier's partner portal. Samuel uses his iPad to login to the partner portal, browses the partner catalog, compares product attributes and prices, adds the best product to his cart, selects and configures options and places an order on behalf of his customer.
COM_SampleDBDemo _Mobile	COM_SampleDB _PartnerCommerce	2	COM_SampleDB_ PartnerCommerce_ Compare	Same description as in previous row.
COM_SampleDBDemo _Mobile	COM_SampleDB_ eSales	1	COM_SampleDB_ eSales_ERIGBY Login	Kate Allison is shopping for a high speed Internet, TV and long distance phone service for her home. Kate uses her iPad to navigate to the communication service provider's web store, browses the product catalog and adds the standard triple play package to her shopping cart. Kate completes the new user registration form, reviews the shipping and pricing details and submits an order. Eleanor Rigby is a business user and logs in to the communication service provider's web store to track the orders placed on behalf of her company. Additionally, Eleanor registers and administers other users of her company.
COM_SampleDBDemo _Mobile	COM_SampleDB_ eSales	2	COM_SampleDB_ eSales_Flow1	Same description as in previous row.
Demo Flow for Service Request	Service Request Test Set	1	Workflow Activation	Eric Hess is an existing customer, who calls up to the customer care to raise a service request, that could be a problem related to products or services purchased from the company. Tim Malone the call center agent receives the call and creates an SR for the issue raised by the customer. Tim enters the required details to the SR including description, asset details, contact details, etc.
Demo Flow for Service Request	Service Request Test Set	2	Create SR	Same description as in previous row.
Demo Flow for Service Request	Service Request Test Set	3	Associate Product	Same description as in previous row.
Demo Flow for Service Request	Service Request Test Set	4	Update SR	Same description as in previous row.
Demo Flow for Service Request	Service Request Test Set	5	Check Entitlements	Tim checks customer's entitlements for the service. Once done, he looks for the possible solution for the issue raised by the customer and adds the solution to the SR. He decides that a field engineer needs to visit the customer site, so he creates an activity and assign it to an appropriate field engineer to fix the problem.
Demo Flow for Service Request	Service Request Test Set	6	Associate Asset	Same description as in previous row.
Demo Flow for Service Request	Service Request Test Set	7	Associate Entitlements	Same description as in previous row.
Demo Flow for Service Request	Service Request Test Set	8	Associate Solution	Same description as in previous row.
Demo Flow for Service Request	Service Request Test Set	9	Add Activity Plan	Same description as in previous row.
Demo Flow for Service Request	Service Request Test Set	10	Delete Data	Delete all the newly created data from the environment.

The following table shows the actions to be performed by the scripts in the sample database.

Sl #	Script Name	Action to be Performed	Test Step #	Current Data	Proposed Change
1	Script - COM_SampleDB_ Telco_ChangeSIM_ SubmitOrder	N/A	34	Row Number is NULL	Row Number > Active_Record
2	Script - COM_SampleDB_ Telco_DataSetupFlow	Action ->Update	1	Component Alias > Siebel Power Communications	Component Alias >Siebel Power Communications_Setup
2	Script - COM_SampleDB_ Telco_DataSetupFlow	Action ->Insert @ Test Step #26	27	N/A	Click on New and enter the below values. Keyword ->HierarchicalList Applet RN - > Order Entry - Line Item List Applet (Sales) Row # -> 2 Action -> Expand Variable ->NULL Save the record Note: Select Renumber from the Menu.
2	Script - COM_SampleDB_ Telco_DataSetupFlow	Action ->Insert @ Test Step #108	109	N/A	Click on New and enter the below values. Keyword ->HierarchicalList Applet RN - > Order Entry - Line Item List Applet (Sales) Row # -> 2 Action -> Expand Variable ->NULL Save the record Note: Select Renumber from the Menu.
2	Script - COM_SampleDB_ Telco_DataSetupFlow	Action ->Insert @ Test Step #133	134	N/A	Click on New and enter the below values Keyword ->HierarchicalList Applet RN - > Order Entry - Line Item List Applet (Sales) Row # -> 2 Action -> Expand Variable ->NULL Save the record Note: Select Renumber from the Menu.
3	Script - COM_SampleDB_ Telco_ChangeSIM_ Messages	Action ->Update	1	User Name > ANTHYAGA	User Name > SADMIN
3	Script - COM_SampleDB_ Telco_ChangeSIM_ Messages	Action ->Update	22	ExpectedMessage Substring> Unable to complete SIM Swap. There is a stolen or admin bar for the selected service. Remove the stolen or admin bar to continue with your request.(SBL-ORD-51426)	ExpectedMessageSubstring > "Unable to complete SIM Swap. There is a stolen or admin bar for the selected service. Remove the stolen or admin bar to continue with your request."(SBL-ORD-51426)
4	Script - COM_SampleDB_ Telco_SelectAll_Remove	Action ->Update	12	Item RN >Select All|Select All	Item RN > SelectAll|Select All
4	Script - COM_SampleDB_ Telco_SelectAll_Remove	Action ->Update	13	End Action >OK	End Action > NULL
4	Script - COM_SampleDB_ Telco_SelectAll_Remove	Action ->Update	14	Item RN >Select All|Select All	Item RN > SelectAll
4	Script - COM_SampleDB_ Telco_SelectAll_Remove	Action ->Update	22	Item RN >Select All|Select All	Item RN > SelectAll
4	Script - COM_SampleDB_ Telco_SelectAll_Remove	Action ->Update	24	Item RN >Select All|Select All	Item RN > SelectAll
5	Script - COM_SampleDB_ Telco_ChangeSIM _SubmitOrder	Action ->Update	34	Row Number is NULL	Row Number > Active_Record
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Action ->Update	4	Value>TelcoExpress_ 05252017_22343988	Value>@TelcoAccName
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Action ->Update	6	Value>TelcoExpress_ 05252017_22343988	Value>@TelcoAccName
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Action ->Update	9	ItemRN> Select All	ItemRN > SelectAll
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Action ->Update	11	ItemRN> Select All	ItemRN > SelectAll
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Action ->Update	13	ItemRN> Action	ItemRN> Product Name
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Action ->Insert @ Test Step #8	9	N/A	Click on New and enter the below values. Keyword ->ClickButton Applet RN- >TOUI AssignBar Buttons ItemRN -> Cancel Request End Action -> NULL Save the record Note: Select Renumber from the Menu.
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Action ->Insert @ Test Step #9	10	N/A	Click on New and enter the below values. Keyword - > ClickLink Applet RN -> TOUI CustDash Action Launchpad ItemRN ->Expand Applet Value/Variable -> NULL Save the record Note: Select Renumber from the Menu.
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Action ->Insert @ Test Step #10	11	N/A	Click on New and enter the below values Keyword -> ClickButton Applet RN -> TOUI CustDash Action Launchpad Item RN -> AddRemoveBar EndAction -> NULL Save the record Note: Select Renumber from the Menu.
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Action ->Insert @ Test Step # 21	22	N/A	Click on New and enter the below values Keyword -> SortColumn Applet RN -> TOUI AssignBar Order Items Item RN -> Service Id Sorting Order -> Asc Save the record. Note: Select Renumber from the Menu.
7	Script - COM_SampleDB _Partner Commerce_Compare	Action ->Update	6	ItemRN>Select All	ItemRN> SelectAll
8	Script - COM_SampleDB _eSales_Flow1	Action ->Update	1	User Name > GUESTCST	User Name> PortalApplication
8	Script - COM_SampleDB _eSales_Flow1	Action ->Update	15	Row Number > 3 Value/Variable > NULL	Row Number > remove value in this field. Value/Variable>IPTV Service
8	Script - COM_SampleDB _eSales_Flow1	Action ->Update	38	ItemRN > Select All|Select All	ItemRN> SelectAll

Actions Performed by Sample Database Test Scripts

The following table desccribes the actions performed by test scripts in the sample database.

Sl #	Script Name	Action to be Performed	Test Step #	Current Data	Proposed Change
1	Script - COM_SampleDB_ Telco_ChangeSIM_ SubmitOrder	N/A	34	Row Number is NULL	Row Number: Active_Record
2	Script - COM_SampleDB_ Telco_DataSetupFlow	Update	1	Component Alias: Siebel Power Communications	Component Alias: Siebel Power Communications_Setup
2	Script - COM_SampleDB_ Telco_DataSetupFlow	Insert @ Test Step #26	27	N/A	Click New, enter the following values, and then save the record: Keyword: HierarchicalList Applet RN: Order Entry - Line Item List Applet (Sales) Row #: 2 Action: Expand Variable: NULL Note: Select Renumber from the Menu.
2	Script - COM_SampleDB_ Telco_DataSetupFlow	Insert @ Test Step #108	109	N/A	Click New, enter the following values, and then save the record: Keyword: HierarchicalList Applet RN: Order Entry - Line Item List Applet (Sales) Row #: 2 Action: Expand Variable: NULL Note: Select Renumber from the Menu.
2	Script - COM_SampleDB_ Telco_DataSetupFlow	Insert @ Test Step #133	134	N/A	Click New, enter the following values, and then save the record: Keyword: HierarchicalList Applet RN: Order Entry - Line Item List Applet (Sales) Row #: 2 Action: Expand Variable: NULL Note: Select Renumber from the Menu.
3	Script - COM_SampleDB_ Telco_ChangeSIM_ Messages	Update	1	User Name: ANTHYAGA	User Name: SADMIN
3	Script - COM_SampleDB_ Telco_ChangeSIM_ Messages	Update	22	ExpectedMessage Substring: Unable to complete SIM Swap. There is a stolen or admin bar for the selected service. Remove the stolen or admin bar to continue with your request.(SBL-ORD-51426)	ExpectedMessageSubstring: "Unable to complete SIM Swap. There is a stolen or admin bar for the selected service. Remove the stolen or admin bar to continue with your request."(SBL-ORD-51426)
4	Script - COM_SampleDB_ Telco_SelectAll_Remove	Update	12	Item RN: Select All | Select All	Item RN: SelectAll | Select All
4	Script - COM_SampleDB_ Telco_SelectAll_Remove	Update	13	End Action: OK	End Action: NULL
4	Script - COM_SampleDB_ Telco_SelectAll_Remove	Update	14	Item RN: Select All | Select All	Item RN: SelectAll
4	Script - COM_SampleDB_ Telco_SelectAll_Remove	Update	22	Item RN : Select All | Select All	Item RN: SelectAll
4	Script - COM_SampleDB_ Telco_SelectAll_Remove	Update	24	Item RN: Select All | Select All	Item RN: SelectAll
5	Script - COM_SampleDB_ Telco_ChangeSIM _SubmitOrder	Update	34	Row Number is NULL	Row Number: Active_Record
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Update	4	Value: TelcoExpress_ 05252017_22343988	Value: @TelcoAccName
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Update	6	Value: TelcoExpress_ 05252017_22343988	Value: @TelcoAccName
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Update	9	ItemRN: Select All	ItemRN: SelectAll
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Update	11	ItemRN: Select All	ItemRN: SelectAll
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Update	13	ItemRN: Action	ItemRN: Product Name
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Insert @ Test Step #8	9	N/A	Click New, enter the following values, and then save the record: Keyword: ClickButton Applet RN: TOUI AssignBar Buttons ItemRN: Cancel Request End Action: NULL Note: Select Renumber from the Menu.
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Insert @ Test Step #9	10	N/A	Click New, enter the following values, and then save the record: Keyword: ClickLink Applet RN: TOUI CustDash Action Launchpad ItemRN: Expand Applet Value/Variable: NULL Note: Select Renumber from the Menu.
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Insert @ Test Step #10	11	N/A	Click New, enter the following values, and then save the record: Keyword: ClickButton Applet RN: TOUI CustDash Action Launchpad Item RN: AddRemoveBar EndAction: NULL Note: Select Renumber from the Menu.
6	Script - COM_SampleDB_ Telco_AddRemove_ Flow2	Insert @ Test Step # 21	22	N/A	Click New, enter the following values, and then save the record: Keyword: SortColumn Applet RN: TOUI AssignBar Order Items Item RN: Service Id Sorting Order: Asc Note: Select Renumber from the Menu.
7	Script - COM_SampleDB _Partner Commerce_Compare	Update	6	ItemRN: Select All	ItemRN: SelectAll
8	Script - COM_SampleDB _eSales_Flow1	Update	1	User Name: GUESTCST	User Name: PortalApplication
8	Script - COM_SampleDB _eSales_Flow1	Update	15	Row Number: 3 Value/Variable: NULL	Row Number: remove value in this field. Value/Variable: IPTV Service
8	Script - COM_SampleDB _eSales_Flow1	Update	38	ItemRN: Select All | Select All	ItemRN: SelectAll