Oracle Application Testing Suite Test Starter Kits For .

2y ago
19 Views
2 Downloads
298.07 KB
37 Pages
Last View : 4d ago
Last Download : 2m ago
Upload by : Dani Mulvey
Transcription

November 2010Oracle Application Testing Suite Test StarterKits for Oracle E-Business Suite R12 & 11iATS Version 9.2

Oracle Application Testing Suite Test Starter Kits for Oracle E-Business Suite R12 & 11iIntroduction . 4Test Starter Kit for Automated Functional Testing Overview. 4Test Starter Kit for Automated Load Testing Overview . 5Functional Test Script Details . 7Financial Products: . 7Oracle Payables Test Details . 7Oracle Receivables Test Details . 7Oracle General Ledger Test Details . 8Oracle Fixed Assets Test Details . 9Oracle Internet Expense Test Details . 10Manufacturing Products: . 10Oracle Purchasing Test Details . 10Oracle Inventory Test Details . 11Oracle Materials Resource Planning . 12Oracle Order Management Test Details . 12Oracle Cost Management Test Details . 14Oracle Process Manufacturing Test Details . 14CRM Products:. 16Oracle Contracts Test Details . 16Oracle Service Test Details . 16Oracle Marketing Test Details . 16Human Resources Product:. 17Oracle Human Resources Test Details . 17Projects Product:. 18Oracle Projects Test Details . 18

Oracle Application Testing Suite Test Starter Kits for Oracle E-Business Suite R12 & 11iTechnology Product: . 19Oracle Application Object Library Test Details . 19Environment Tests: . 20Load Test Script Details . 22Order Management Cycle - Transaction Flow . 22OM Insert Order . 22OM Order Pick Release. 23OM Ship Confirm . 24OM Order Summary Report . 24AR Insert Manual Invoice . 25AR SS Customer Summary . 25AR View Customer Transactions . 26Procure to Pay Cycle - Transaction Flow. 26Create Query Requisition . 26Create and Approve Purchase Order . 28View Purchase Order . 29Create Payable Invoice . 29View Payable Invoice . 30PO Printed Report . 31GL Journal Entry . 31FA Create Asset . 32AR Aging Report. 33INV Insert Miscll Transactions . 34INV Min Max Report . 34INV View Item Attributes . 35

Oracle Application Testing Suite Test Starter Kits for Oracle E-Business Suite R12 & 11i

Oracle Application Testing Suite Test Starter Kits for Oracle E-Business Suite R12 & 11iIntroductionThe Oracle Application Testing Suite Test Starter Kits for Oracle E-Business Suite providesample automated test scripts for Oracle EBS Applications, created by Oracle, using theOracle Application Testing Suite 9.2 test automation solution. Separate ATS Test Starter Kitshave been created for Oracle E-Business Suite R12 (12.1.2 & 12.1.1) and 11i (11.5.10.2). Thekits now include both automated functional & regression test scripts and automated load &performance test scripts. The Test Starter Kit is available for download from the ApplicationTesting Suite download page on the Oracle Technology Network (OTN).Test Starter Kit for Automated Functional Testing OverviewThe Application Testing Suite (ATS) Test Starter Kit (TSK) for Oracle E-Business Suiteincludes automated functional test scripts that cover a total of 18 EBS transactions. Thesescripts were built using EBS R12 and 11i instances with Vision database, which is required torun these scripts directly. The scripts can also be modified or used as examples for creatingfunctional test scripts against your own EBS instance and database.All test scripts, databank files and properties file are included in this Test Starter Kit archive.These scripts will run in Oracle Functional Testing’s OpenScript scripting platform, which is acomponent of ATS.The "\Functional Testing" folder contains: EBS TSK Functional Testing Transaction & Script Folders: There are 18 EBStransaction folders with folder names ending in “ tsk” (i.e. ap tsk is for AccountsPayable). Each transaction folder contains all the necessary TSK functional testscripts to run that transaction in the ATS OpenScript product:oEach EBS transaction is broken down into one or more TSK scripts (i.e.ap 001a, ap 002a, ap 003a). All of these scripts and their steps aredescribed below.oThere is a “ launch” script for each EBS transaction (i.e. ap launch). This isused to start the browser, navigate to the EBS test server with the URLdefined in the ebs.properties file and login to EBS with a certain responsibilityoThere is a “ masterdrive” script for each EBS transaction (i.e.ap tsk masterdrive). This is the script you should run to launch all the TSKscripts for that EBS transaction.EBS Properties File: The “ebs.properties” file in the main folder is where users candefine the starting URLs for their EBS instances. This is stored as an ATS objectlibrary which can be edited from within OpenScript.4

Oracle Application Testing Suite Test Starter Kits for Oracle E-Business Suite R12 & 11i Databanks: The “Databanks” folder contains all the databank CSV files required byvarious TSK scripts in order to parameterize inputs to those scripts (i.e.ap tsk 0001a.csv). Users can modify and add data to these databank CSV files torun their TSK scripts with different inputs. Script Functions: The "ScriptFunction" folder contains an “EBSFunction” script thatis where all common script functions shared by various scripts are stored. EBS Master Driver Script: The "EBSMasterDrive" script is a master script that willplay all 18 EBS transaction scripts in sequence. You can use this if you want to kickoff all of the TSK scripts to run at once.These are the steps to execute EBS Test Starter Kit functional test scripts:1. Unzip “OATS92 EBS xxxx TSK.zip” file and copy the “OATS92 EBS xxxx TSK”folder to an existing OpenScript script repository location.2. Enter the proper starting URL for your EBS application in the “ebs.properties” file. The“ masterdrive” script for each transaction will access the ebs.properties file to get thestarting URL. If you open one of the “ masterdrive” scripts in OpenScript, you canaccess the “ebs.properities” file from the Script Properties dialog for editing.3. If you want to run a specific EBS transaction script, then run the “ masterdrive” scriptfor that transaction (located in each transaction folder).4. If you want to playback all the TSK scripts at once, then playback “EBSMasterDrive”script which will playback all 18 EBS transactions.5. If you want to view and edit any of the EBS TSK scripts, you can open themindividually through the OpenScript user interface.Test Starter Kit for Automated Load Testing OverviewThe Application Testing Suite (ATS) Test Starter Kit (TSK) for Oracle E-Business Suiteincludes automated load test scripts for EBS load & performance testing. This includes scriptsthat automate individual EBS transactions and end-to-end, multi-script EBS transaction flows.These scripts were built using EBS R12 and 11i instances with Vision database, which isrequired to run these scripts directly. The scripts can also be modified or used as examples forcreating load test scripts against your own EBS instance and database.5

Oracle Application Testing Suite Test Starter Kits for Oracle E-Business Suite R12 & 11iAll load test scripts are included in this Test Starter Kit archive. These scripts will run in OracleFunctional Testing’s OpenScript scripting platform and in Oracle Load Testing, which are bothcomponents of ATS.The "\Load Testing" folder contains: EBS TSK Load Testing Transaction & Script Folders: There are 19 total load testscripts included in the TSK:o“Order Management Cycle” end-to-end transaction flow includes 7 EBS loadtest scripts that automate different transaction components. There is also an“Order Management Master” script which will be used to call the 7component scripts sequentially.o“Procure to Pay Cycle” end-to-end transaction flow includes 6 EBS load testscripts that automate different transaction components. There is also an“iProcurement Master” script which will be used to call the 6 componentscripts sequentially.o“Miscellaneous Scripts” folder contains separate stand-alone load test scriptsfor additional EBS transactions.Each script or multi-script transaction flow can be run in the ATS OpenScript and LoadTesting products.These are the steps to execute EBS Test Starter Kit load test scripts:1. Unzip “OATS92 EBS xxxx TSK.zip” file and copy the “OATS92 EBS xxxx TSK”folder to an existing OpenScript script repository location.2. In order to run the load test scripts, you would need to enter the proper starting URLfor your EBS application instance with Vision database. In the OpenScriptPreferences Playback section, you will see a "Replace URL" field that can be usedto do this. For example: If you have recorded a script using http://testserver/ andwant to playback the script against http://productionserver/ - you need to enter thefollowing value in the "Replace URL" field: http://testserver/ http://productionserver/.3. If you want to run a multi-script EBS transaction flow, then open and run the “Master”script for that transaction flow (located in each transaction folder) in OpenScript orselect it in Oracle Load Testing.4. If you want to run a stand-alone EBS script, then open and run the script directly inOpenScript or select it in Oracle Load Testing.5. If you want to view and edit any of the EBS TSK scripts, you can open themindividually through the OpenScript user interface.6

Oracle Application Testing Suite Test Starter Kits for Oracle E-Business Suite R12 & 11iFunctional Test Script DetailsFinancial Products:Oracle Payables Test Detailsap0001a - Create an invoiceActions:1. Create a new invoice2. Validate the invoice3. Copy and delete an invoice4. Query on the deleted invoice to ensure that it can't be queriedVerifications:1. Invoice header record is saved when press the Distribution button2. Copy from Field above function works3. Distribution lines are saved4. Invoice status is updated to "Approved" after approval process5. Verify unique record constraints6. Verify second record is saved7. Verify delete transaction is committed8. Verify deleted record cannot be retrievedap0002a - Create a quick paymentActions:1. Create a payment against the invoice created in ap0001aVerifications:1. Verify the Total Amount is displayed2. Verify the select invoice transaction is saved3. Verify the payment transaction is saved4. Verify the invoice is paidap0003a - Create an expense reportActions:1. Create an expense report2. Query the expense reportVerifications:1. Expense Report is saved.2. Verify expense report is created by querying the recordOracle Receivables Test Detailsar0001a - Create a customerActions:1. Create a new customerVerifications:1. Verify that transaction is saved7

Oracle Application Testing Suite Test Starter Kits for Oracle E-Business Suite R12 & 11i2. Verify that updates on Business Purposes tab is saved3. Verify that updates on Contact Tab is savedar0002a - Create an invoiceActions:1. Create a new invoice using the customer in ar0001a2. Complete the new invoice using the customer in ar0001aVerifications:1. Verify that transaction is saved2. Verify the Line item is saved3. Verify the Transaction Total is correct4. Verify that tax rate has defaulted5. Verify Transaction is complete after pressing the Complete buttonar0003a - Create a cash receiptActions:1. Create a cash receipt for the invoice created in ar0002aVerifications:1. Verify status is cleared on the Receipt header2. Verify the Functional Amount is defaulted correctly3. Confirm header transaction is saved4. Confirm Cash Receipt data is saved5. Confirm apply box is checked6. Confirm the saved box is unchecked7. Verify Save checkbox is checked after saveOracle General Ledger Test Detailsgl0001a - Ensure the manual journal source does not require approvalActions:1. Ensure that the manual journal source does not require approvalVerifications:1. Verify the transaction of un-checking the required approval check box is savedgl0002a - Enter journal entriesActions:1. Create a journal batch2. Add two journals to the batch3. Re-query the journal batch to ensure the journals are in status "unposted"Verifications:1. Verify initial status of journal batch is UNPOSTED2. Verify Approval Status is N/A3. Verify that the journal source is MANUAL4. Verify debit and credit totals match5. Verify transaction is saved6. Verify debit and credit totals match for second journal entry7. Verify second journal transaction is saved8. Verify the Batch totals are correctgl0003a - Query journal entry and reverse the journal entryActions:8

Oracle Application Testing Suite Test Starter Kits for Oracle E-Business Suite R12 & 11i1. Query the first journal added for the batch created in gl0002a2. Reverse the first journal added for the batch created in gl0002a3. Ensure the reverse Journal process completes successfullyVerifications:1. Verify correct batch with two journals lines are retrieved2. Verify the correct journal batch and journals are retrieved3. Verify the correct request is displayed on the Requests form4. Verify if the report Status is completed or not5. Verify process completed with status of Normal6. Verify the correct batch is retrieved7. Verify debits and credits are reversedgl0004a - Post a journal batchActions:1. Post the journal batch created in gl0002a2. Ensure that the posting process completes successfully3. Query the journal batch created in gl0002a4. Ensure the journal batch created in gl0002a was posted5. Post the reversed journal created in gl0003a6. Ensure that the posting process completes successfully7. Query the journal reversal created in gl0003a8. Ensure the journal reversal created in gl0003a was postedVerifications:1. Verify the correct batch is retrieved2. Verify Post Status of the batch is POSTABLE3. Verify the correct request is displayed on the Requests form4. Verify if the report Status is completed or not5. Verify process completed with status of Normal6. Verify Correct batch is retrieved7. Verify Batch Status for two journals8. Verify the correct reversal batch is retrieved9. Verify Post Status of the batch is POSTABLE10. Verify the correct request is displayed on the Requests form11. Verify if the report Status is completed or notgl0005a - Ensure that the manual journal source check box is reset back to checkedActions:1. Ensure that the manual journal source check box is reset back to checkedVerifications:1. Verify the transaction of checking the Required Approval checkbox is savedOracle Fixed Assets Test Detailsfa0001a - Create asset from the asset workbenchActions:1. Create an asset through the asset workbench2. Query the assetVerifications:1. Verify Book value and no costs has been entered yet2. Verify values defaulted correctly3. Verify the Book is defaulted correctly to OPS CORP9

Oracle Application Testing Suite Test Starter Kits for Oracle E-Business Suite R12 & 11i4. Verify the Total Units is 15. Verify the Service date is correct6. Verify asset number after query7. Verify Book is OPS CORP8. Verify Expense Account is correct on the assignment form9. Verify Location is correct on the assignment form10. Verify service date on the Books formfa0002a - Adding a new asset through QuickAdditionsActions:1. Add a new asset through QuickAdditionsVerifications:1. Verify transaction is saved2. Verify the correct asset is retrieved after query3. Verify the book is OPS CORP on the Assignment form4. Verify the location on the Assignment form5. Verify current cost is correctOracle Internet Expense Test Detailsoie0001a - Create a new expense report without credit cardActions:1. Create a new expense report without credit card with two line items2. Modify the first line item3. Submit the expense reportVerifications:1. Verify expense report is created successfullyoie0002a - Search for an expense report created in oie0001aActions:1. Enter expense report number created in oie0001a to search for itVerifications:1. Verify the expense report amountManufacturing Products:Oracle Purchasing Test Detailspo0001a - Create a supplierActions:1. Create a supplier by entering the header, payment and site informationVerifications:1. Verify the status of the supplier number field is non-editable2. Verify the supplier header is saved3. Verify the supplier number is generated4. Verify the supplier site record is generatedpo0002a - Create a purchase order10

Oracle Application Testing Suite Test Starter Kits for Oracle E-Business Suite R12 & 11iActions:1. Create a purchase order2. Approve the purchase order3. Query the purchase order created in po0002aVerifications:1. Verify Distribution information is saved2. Verify a PO number is generated3. Verify PO Status is "Approved" after online approval4. Verify Purchase Order number exists5. Verify Purchase Order status is "Approved”po0003a - Create a requisitionActions:1. Create a requisition2. Approve a requisition3. Query the requisition created from the requisition summary formVerifications:1. Verify Requisition transaction is saved2. Verify Requisition exists in Requisition Summary form3. Verify Requisition has been approved.po0004a - Autocreate a POActions:1. Autocreate a PO from the requisition created in po0003aVerifications:1. Verify the following are displayed correctly: Purchase Order Type, Supplier Name, SupplierSite, Bill To, Ship To

Oracle Payables Test Details ap0001a - Create an invoice Actions: 1. Create a new invoice 2. Validate the invoice 3. Copy and delete an invoice 4. Query on the deleted invoice to ensure that it can't be queried Verifications: 1. Invoice header record is saved when press the Distr

Related Documents:

7 Messaging Server Oracle Oracle Communications suite Oracle 8 Mail Server Oracle Oracle Communications suite Oracle 9 IDAM Oracle Oracle Access Management Suite Plus / Oracle Identity Manager Connectors Pack / Oracle Identity Governance Suite Oracle 10 Business Intelligence

Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,

Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,

Regression Testing Process and Issues Test-suite maintenance Obsolete test cases Test suite Tval Regression test selection Test suite T' Test-suite prioritization Prioritized Test suite T' T est-suite augmentation Test suite Taug T est-suite minimization Redundant test cases Minimized test suite est-case manipulation

Load Testing Best Practices for Oracle E-Business Suite using Oracle Application Testing Suite 2 Oracle Load Testing Setup Oracle Load Testing (OLT) has three main components: Server, Agent, and Database. The OLT Server has a Controller module which connects to the Agent and sends execution information to simulate users for the load test.

PeopleSoft Oracle JD Edwards Oracle Siebel Oracle Xtra Large Model Payroll E-Business Suite Oracle Middleware Performance Oracle Database JDE Enterprise One 9.1 Oracle VM 2.2 2,000 Users TPC-C Oracle 11g C240 M3 TPC-C Oracle DB 11g & OEL 1,244,550 OPTS/Sec C250 M2 Oracle E-Business Suite M

the EBS instance specific configuration and form the complete ready-to-run Oracle E-Business suite instance. Certification of Oracle E-Business Suite on Oracle VM Oracle VM has been fully certified with Oracle E-Business Suite systems for more than 2 years and it's the only virtualization solution certified and supported by Oracle.

Toad for Oracle Base Edition Toad for Oracle Professional Edition Toad for Oracle Xpert Edition Toad DB Admin Module (add-on) Toad Development Suite for Oracle Toad DBA Suite for Oracle Toad DBA Suite for Oracle - RAC Edition Toad DBA Suite for Oracle - Exadata Edition Convert embedded SQL to other programming languages (Delphi, C, C ,