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 |