QA test plan 2.40/Web Services

Contents 1 Introduction 2 Aim of the project 3 Environment 4 Previous data 4.1 Two clients: 4.2 One user with no roles 4.3 Five Business Partners 5 Test cases 5.1 getCustomer - Request - Get by Id 5.2 getCustomer - Request - Get by Name 5.3 getCustomer - Request - Get by SearchKey 5.4 getCustomers - Request - Get all Customers 5.5 getCustomer - Request - Get by Name and SearchKey 5.6 getCustomerContact - Request - Get by Id 5.7 updateCustomer - Request - Update a customer 5.8 updateContact - Request - Update a contact 5.9 updateAddress - Request - Update an address 6 Results

Introduction

For Common Customer View demonstration between OSA partners applications is necessary to develop new web services.

Aim of the project

Develop new web services to achieve the objectives of Common Customer View demonstration between OSA partners applications.

Environment

For this test execution, it will be necessary:

• A properly setted OpenbravoERP, with active Webservices
• A TOAD with access to OpenbravoERP database
• Eclipse IDE with SoapUI plug in

Previous data

In order to test this module, it is a must to create some previous data.

Two clients:

Note: The clients must be created with a System Administrator user

• Client 1
  • Name: SampleClient
  • Organization: Pamplona
  • Client Username: SampleClientAdmin
  • Organization Username: SampleClientUser
  • Country: Spain
  • Region: Navarra
  • City: Pamplona
  • Currency: Euro
  • Dimensions Checked: Business Partner, Product and Project
  • Accounting File: AccountsESOpenbravo_v2_OB235_v3.csv (downloaded from Sourceforge )
• Client 2
  • Name: NewClient
  • Organization: Pamplona
  • Client Username: NewClientAdmin
  • Organization Username: NewClientUser
  • Country: Spain
  • Region: Navarra
  • City: Pamplona
  • Currency: Euro
  • Dimensions Checked: Business Partner, Product and Project
  • Accounting File: AccountsESOpenbravo_v2_OB235_v3.csv

One user with no roles

• First name: userA
• User name: userA
• Password: userA

Five Business Partners

Note:Except for Customer B, use SampleClientAdmin to create the rest of Business Partners.

• Three Customers
  • One Customer with one contact and one address
    • Search key: CUSA
    • Name: Customer A
    • Contact: contactCusA
    • Location: sampleStreet 00, Pamplona, Navarra, Spain
  • One Customer with three contacts and three addresses
    • Note: In order to create this record, use NewClientAdmin user, so this business partner will belong to NewClient instead of SampleClient
    • Search key: CUSB
    • Name: Customer B
    • Contact 1: directorCusB
    • Contact 2: secretaryCusB
    • Contact 3: salesmanCusB
    • Location 1: sampleStreet 00, Pamplona, Navarra, Spain
    • Location 2: warehouseStreet 00, Pamplona, Navarra, Spain
    • Location 3: branchStreet 00, Pamplona, Navarra, Spain
  • One Customer with no contacts and no addresses
    • Search key: CUSC
    • Name: Customer C
• One Vendor
  • Search key: VA
  • Name: Vendor A
• One Employee
  • Search key: EMPA
  • Name: Employee A

Note: Navigate Customer, Vendor and Employee tabs on each one to check the appropriate checkbox.

Test cases

getCustomer - Request - Get by Id

1. Send a request using valid data 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • CustomerID: the c_bpartner_id of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML contains the same data as the first step query

2. Send a request using non valid ClientId 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: 9999999
    • CustomerID: the c_bpartner_id of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

3. Send a request using non valid CustomerId 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • CustomerID: 99999999
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

4. Send a request using non valid Username/Password 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • CustomerID: the c_bpartner_id of the previous query
    • Username: SampleClientUser
    • Password: qwertyasdf
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

5. Send a request violating security policies 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer B';
  • This will show the Business Partner Customer B which belongs to NewClient client
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • CustomerID: the c_bpartner_id of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

getCustomer - Request - Get by Name

1. Send a request using valid data 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • Name: the name of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML contains the same data as the first step query

2. Send a request using non valid ClientId 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: 9999999
    • Name: the name of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML contains the same data as the first step query

3. Send a request using non valid Name 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • Name: XXXXXXXXXX
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

4. Send a request using non valid Username/Password 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • Name: the name of the previous query
    • Username: SampleClientUser
    • Password: qwertyasdf
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

5. Send a request violating security policies 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer B';
  • This will show the Business Partner Customer B which belongs to NewClient client
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • Name: the name of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

getCustomer - Request - Get by SearchKey

1. Send a request using valid data 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • SearchKey: the value column of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML contains the same data as the first step query

2. Send a request using non valid ClientId 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: 9999999
    • SearchKey: the value column of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML contains the same data as the first step query

3. Send a request using non valid Name 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • SearchKey: XXXXXXXXXX
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

4. Send a request using non valid Username/Password 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • SearchKey: the value column of the previous query
    • Username: SampleClientUser
    • Password: qwertyasdf
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

5. Send a request violating security policies 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer B';
  • This will show the Business Partner Customer B which belongs to NewClient client
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • SearchKey: the value column of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

getCustomers - Request - Get all Customers

1. Send a request using valid data 

• Steps:
  • Using TOAD execute the following query:
    • SELECT bp.* FROM c_bpartner bp inner join ad_client c on bp.ad_client_id=c.ad_client_id WHERE c.name like 'SampleClient' and iscustomer='Y';
  • This will show all the Customers of SampleClient client
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML contains the same data as the first step query

2. Send a request using non valid ClientID 

• Steps:
  • Using TOAD execute the following query:
    • SELECT bp.* FROM c_bpartner bp inner join ad_client c on bp.ad_client_id=c.ad_client_id WHERE c.name like 'SampleClient' and iscustomer='Y';
  • This will show all the Customers of SampleClient client
  • Fill the XML with this parameters:
    • ClientID: 99999999
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

3. Send a request using non valid Username/Password 

• Steps:
  • Using TOAD execute the following query:
    • SELECT bp.* FROM c_bpartner bp inner join ad_client c on bp.ad_client_id=c.ad_client_id WHERE c.name like 'SampleClient' and iscustomer='Y';
  • This will show all the Customers of SampleClient client
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • Username: SampleClientUser
    • Password: qwertyasdf
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

4. Send a request violating security policies 

• Steps:
  • Using TOAD execute the following query:
    • SELECT bp.* FROM c_bpartner bp inner join ad_client c on bp.ad_client_id=c.ad_client_id WHERE c.name like 'NewClient' and iscustomer='Y';
  • This will show all the Customers of NewClient client
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

getCustomer - Request - Get by Name and SearchKey

1. Send a request using valid data 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • Name: the name of the previous query
    • SearchKey: the value column of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML contains the same data as the first step query

2. Send a request using non valid ClientId 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: 9999999
    • Name: the name of the previous query
    • SearchKey: the value column of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML contains the same data as the first step query

3. Send a request using non valid Name 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • Name: XXXXXXXXXX
    • SearchKey: the value column of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

4. Send a request using non valid Username/Password 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • Name: the name of the previous query
    • SearchKey: XXXXXXXX
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

5. Send a request using non valid Username/Password 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • Name: the name of the previous query
    • SearchKey: the value column of the previous query
    • Username: SampleClientUser
    • Password: qwertyasdf
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

6. Send a request violating security policies 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer B';
  • This will show the Business Partner Customer B which belongs to NewClient client
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • Name: the name of the previous query
    • SearchKey: the value column of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

getCustomerContact - Request - Get by Id

1. Send a request using valid data 

• Steps:
  • Using TOAD execute the following query:
    • SELECT bp.name, bp.C_BPARTNER_ID, u.* FROM ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID WHERE bp.NAME like 'Customer A';
  • This will show the Contact for Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • CustomerID: the c_bpartner_id of the previous query
    • ContactID: the value column of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Additional tests:

• Verify that retrieving all the three contacts of Customer B (using NewClientUser user) has the same results too

Expected result: The response XML contains the same data as the first step query

2. Send a request using non valid ClientId 

• Steps:
  • Using TOAD execute the following query:
    • SELECT bp.name, bp.C_BPARTNER_ID, u.* FROM ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID WHERE bp.NAME like 'Customer A';
  • This will show the Contact for Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: 9999999
    • CustomerID: the c_bpartner_id of the previous query
    • ContactID: the value column of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

3. Send a request using non valid CustomerId 

• Steps:
  • Using TOAD execute the following query:
    • SELECT bp.name, bp.C_BPARTNER_ID, u.* FROM ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID WHERE bp.NAME like 'Customer A';
  • This will show the Contact for Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • CustomerID: 9999999
    • ContactID: the value column of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

4. Send a request using non valid ContactId 

• Steps:
  • Using TOAD execute the following query:
    • SELECT bp.name, bp.C_BPARTNER_ID, u.* FROM ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID WHERE bp.NAME like 'Customer A';
  • This will show the Contact for Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • CustomerID: the c_bpartner_id of the previous query
    • ContactID: 9999999
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

5. Send a request using non valid Username/Password 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer A';
  • This will show the Business Partner Customer A
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • CustomerID: the c_bpartner_id of the previous query
    • ContactID: the value column of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

6. Send a request violating security policies 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer B';
  • This will show the Business Partner Customer B
  • Fill the XML with this parameters:
    • ClientID: the ad_client_id of the previous query
    • CustomerID: the c_bpartner_id of the previous query
    • ContactID: the value column of the previous query
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML has no useful data

updateCustomer - Request - Update a customer

1. Send a request using valid data 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer C';
  • This will show the Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified
    • SearchKey: CUSCM
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is True and running the query again verifies data was updated

2. Send a request using non valid ClientId 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer C';
  • This will show the Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: 9999999
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified
    • SearchKey: CUSCM
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

3. Send a request using non valid Name 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer C';
  • This will show the Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified With a Name Too Long For The Database
    • SearchKey: CUSCM
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

4. Send a request using non valid SearchKey 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer C';
  • This will show the Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified
    • SearchKey: CUSC_MODIFIED_BUT_TOO_LONG_FOR_DATABASE
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

5. Send a request using non valid Username/Password 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer C';
  • This will show the Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified
    • SearchKey: CUSCM
    • Username: SampleClientUser
    • Password: qwertyasdf
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

6. Send a request using an existent Name and SearchKey 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer C';
  • This will show the Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer A
    • SearchKey: CUSA
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

7. Send a request violating security policies 

• Steps:
  • Using TOAD execute the following query:
    • SELECT * FROM c_bpartner WHERE name='Customer B';
  • This will show the Business Partner Customer B which belongs to NewClient client
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer B Modified
    • SearchKey: CUSBM
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

updateContact - Request - Update a contact

1. Send a request using valid data 

• Steps:
  • Using TOAD execute the following query:
    • select bp.name, bp.C_BPARTNER_ID, u.* from ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID where bp.NAME like 'Customer C';
  • This will show the Contacts for Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified
    • SearchKey: CUSCM
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Additional tests:

• Verify that updating all the three contacts has the same result

Expected result: The response XML is True and running the query again verifies data was updated

2. Send a request using non valid ClientId 

• Steps:
  • Using TOAD execute the following query:
    • select bp.name, bp.C_BPARTNER_ID, u.* from ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID where bp.NAME like 'Customer C';
  • This will show the Contacts for Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: 9999999
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified
    • SearchKey: CUSCM
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

3. Send a request using non valid Name 

• Steps:
  • Using TOAD execute the following query:
    • select bp.name, bp.C_BPARTNER_ID, u.* from ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID where bp.NAME like 'Customer C';
  • This will show the Contacts for Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified With a Name Too Long For The Database
    • SearchKey: CUSCM
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

4. Send a request using non valid SearchKey 

• Steps:
  • Using TOAD execute the following query:
    • select bp.name, bp.C_BPARTNER_ID, u.* from ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID where bp.NAME like 'Customer C';
  • This will show the Contacts for Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified
    • SearchKey: CUSC_MODIFIED_BUT_TOO_LONG_FOR_DATABASE
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

5. Send a request using non valid Username/Password 

• Steps:
  • Using TOAD execute the following query:
    • select bp.name, bp.C_BPARTNER_ID, u.* from ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID where bp.NAME like 'Customer C';
  • This will show the Contacts for Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified
    • SearchKey: CUSCM
    • Username: SampleClientUser
    • Password: qwertyasdf
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

6. Send a request using an existent Name and SearchKey 

• Steps:
  • Using TOAD execute the following query:
    • select bp.name, bp.C_BPARTNER_ID, u.* from ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID where bp.NAME like 'Customer C';
  • This will show the Contacts for Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer A
    • SearchKey: CUSA
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

7. Send a request violating security policies 

• Steps:
  • Using TOAD execute the following query:
    • select bp.name, bp.C_BPARTNER_ID, u.* from ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID where bp.NAME like 'Customer B';
  • This will show the Contacts for Business Partner Customer B
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer B Modified
    • SearchKey: CUSBM
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

updateAddress - Request - Update an address

1. Send a request using valid data 

• Steps:
  • Using TOAD execute the following query:
    • select bp.name, bp.C_BPARTNER_ID, u.* from ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID where bp.NAME like 'Customer C';
  • This will show the Contacts for Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified
    • SearchKey: CUSCM
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Additional tests:

• Verify that updating all the three contacts has the same result

Expected result: The response XML is True and running the query again verifies data was updated

2. Send a request using non valid ClientId 

• Steps:
  • Using TOAD execute the following query:
    • select bp.name, bp.C_BPARTNER_ID, u.* from ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID where bp.NAME like 'Customer C';
  • This will show the Contacts for Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: 9999999
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified
    • SearchKey: CUSCM
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

3. Send a request using non valid Name 

• Steps:
  • Using TOAD execute the following query:
    • select bp.name, bp.C_BPARTNER_ID, u.* from ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID where bp.NAME like 'Customer C';
  • This will show the Contacts for Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified With a Name Too Long For The Database
    • SearchKey: CUSCM
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

4. Send a request using non valid SearchKey 

• Steps:
  • Using TOAD execute the following query:
    • select bp.name, bp.C_BPARTNER_ID, u.* from ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID where bp.NAME like 'Customer C';
  • This will show the Contacts for Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified
    • SearchKey: CUSC_MODIFIED_BUT_TOO_LONG_FOR_DATABASE
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

5. Send a request using non valid Username/Password 

• Steps:
  • Using TOAD execute the following query:
    • select bp.name, bp.C_BPARTNER_ID, u.* from ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID where bp.NAME like 'Customer C';
  • This will show the Contacts for Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer C Modified
    • SearchKey: CUSCM
    • Username: SampleClientUser
    • Password: qwertyasdf
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

6. Send a request using an existent Name and SearchKey 

• Steps:
  • Using TOAD execute the following query:
    • select bp.name, bp.C_BPARTNER_ID, u.* from ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID where bp.NAME like 'Customer C';
  • This will show the Contacts for Business Partner Customer C
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer A
    • SearchKey: CUSA
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

7. Send a request violating security policies 

• Steps:
  • Using TOAD execute the following query:
    • select bp.name, bp.C_BPARTNER_ID, u.* from ad_user u inner join c_bpartner bp on u.C_BPARTNER_ID=bp.C_BPARTNER_ID where bp.NAME like 'Customer B';
  • This will show the Contacts for Business Partner Customer B
  • Fill the XML with this parameters:
    • ClientId: the ad_client_id of the previous query
    • Id: the c_bpartner_id of the previous query
    • Name: Customer B Modified
    • SearchKey: CUSBM
    • Username: SampleClientUser
    • Password: The encrypted password (as shown at SELECT name,password FROM ad_user WHERE name like 'SampleClientUser' )
  • Run the SOAPUI testcase with the XML and observe the resulting XML.

Expected result: The response XML is False and no data is updated

Results

All the bugs will be reported with the prefix QA-CCV2.

Please click here to see all the bugs

Please click here to see all the OPEN bugs

Category: QualityAssurance