This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Prerequisite Packages

Overview

Test Automation offers two prerequisite packages — Bundles and Configuration Migration Assistant (CMA). These packages serve as the foundation for the operation of Test Automation.

Services

The following are the services included in a pre-requisite package:

ServiceService TypeDescription
TA-IWSRestCatalogInbound web serviceReturns the catalog of REST-based web services with details based on the REST web service catalog.
TA-GetOpenAPISpecInbound web serviceGenerates the OpenAPI Specification for a given REST Inbound Web Service and version of OpenAPI Specification.
TA-GetBatcCtInbound web serviceRetrieve batch controls configured on the extendable lookup TA-AutomationBatchControls and their corresponding value TA-ValidAutomationBatchControls.
TA-RestBatchSubmissionInbound web serviceProvides functionalities to manage and monitor batch jobs through RESTful APIs.
TA-BatchStatsInbound web serviceReturns the statistics of a batch job, including the number of records processed, the threadpool used, start time, and end time.
TA-BatchJobSubmissionBusiness serviceSubmits a batch job instance for a given batch control.
TA-CheckBatchJobStatusBusiness serviceReturns the status of a batch job run, such as Started, Pending, or Ended.
TA-GetBatchControlBusiness serviceReturns the details of a given batch control.
TA-GetBatchRunStatusBusiness serviceRetrieves the status and run number of a batch run for a given batch control.
TA-BatchErrorBusiness serviceReturns an error message when a batch run encounters any error.

Bundles

Test Automation integrates with ORMB through the use of REST APIs. Components that may not be readily available in the base or framework version of ORMB can be added by importing bundles. This simplifies the integration process by removing the need to create new APIs.

Download

You can download the bundles here.

Apply a bundle on your ORMB web application

  1. Log in to your ORMB web application.
  2. On the Admin Menu, click B > Bundle Import > Add.
  3. On the Bundle Import popup window, input a value for the External Reference and Detailed Description fields.
  4. Open a downloaded bundle XML file and copy the contents. Then, paste the contents to the Bundle Details field on the Bundle Import popup window.
  5. Click Save. The Bundle Import popup window will be closed upon clicking Save.
  6. On Main > Bundle Import > Record Actions, click Apply.

Configuration Migration Assistant (CMA)

CMA is a set of pre-defined configurations and SQL queries, such as Inbound web services, that help trigger batch executions and check the status of these executions.

Download

If you are using a TA Banking starter pack or an ORMB environment, download the files here.

If you are using a C2M environment, download the files here.

Import CMA files to your OUAF environment

  1. Run the downloaded streamlineCMAProcess_script.sql in both the source and target environments.
  2. Copy the created migration data export file, TA-EXPFINAL.cma, and paste it into the target environment:
    • If you are using ORMB 5.0, /u01/app/sploutput/ORMB5000/F1_CMA_FILES/export.
    • If you are using ORMB 6.0, /u01/app/sploutput/ORMB6000/F1_CMA_FILES/export.
  3. Import the C2M_TA_C2M_Pre_Requisite.cma dataset to your target environment.

1 - TA Downloads

Overview

The downloads were generated using the following environment versions:

ORMB 6.0.0.0

  • Customer Release V4.5.0.1.1 000 000
  • Oracle Revenue Management and Billing for Financial Services V6.0.0.0.0 205149 000
  • Oracle Utilities Application Framework V4.5.0.1.1 008 000

C2M 2.7.0.3

  • Customer Release V4.3.0.4.0 000 000
  • Oracle Utilities Customer To Meter V2.7.0.3.0 024 000
  • Oracle Utilities Customer Care and Billing V2.7.0.3.0 078 000
  • Oracle Utilities Meter Data Management V2.3.0.2.0 082 000
  • Oracle Utilities Work and Asset Management V2.2.0.6.0 096 000
  • Oracle Utilities Application Framework V4.4.0.2.0 008 000

C2M 2.9.0.1

  • Customer Release V4.3.0.4.0 000 000
  • Oracle Utilities Customer To Meter V2.9.0.1.1 110 000
  • Oracle Utilities Customer Care and Billing V2.9.0.1.1 101 000
  • Oracle Utilities Meter Data Management V2.5.0.1.1 102 000
  • Oracle Utilities Work and Asset Management V2.4.0.1.1 103 000
  • Oracle Utilities Application Framework V4.5.0.1.1 008 000

The following are the items for which the packages are created:

  • Field: TA_FIELD_CONFIG_LBL
  • Zone: TA-SERBATCTL
  • Business Object: TA-AutomationBatchControls
  • Extendable Lookup: TA-AutomationBatchControls, TA-ValidAutomationBatchControls
  • Service Script: TA-GetBatcCt
  • IWS: TA-GetBatcCt
  • IWS: TA-IWSRestCatalog
  • IWS: TA-GetOpenAPISpec
  • Zone: TA-GETBTRNST
  • Business Service: TA-BatchJobSubmission
  • Business Service: TA-CheckBatchJobStatus
  • Business Service: TA-GetBatchControl
  • Business Service: TA-GetBatchRunStatus
  • IWS: TA-RestBatchSubmission
  • Zone: TA-BATCHSTAT
  • Zone: TA-BATCHERR
  • BS: TA-BatchStatus
  • BS: TA-BatchError
  • IWS: TA-BatchStats

C2M downloads

VersionCMAPrerequisite bundle
2.9.0.1TA_C2M_Pre_Requisite.cmaTA-IWS_Service_Prereq_Bundle_C2M_2.9.0.1.xml
2.7.0.3TA_C2M_Pre_Requisite.cmaTA-IWS_Service_Prereq_Bundle_C2M_2.7.0.3.xml

ORMB downloads

VersionJSONPrerequisite bundle
6.0.0.0TA - ORMB IWS Services.postman_collection.jsonTA-IWS_Service_Prereq_Bundle_ORMB_6.0.0.0.xml
4.0.0.0TA - ORMB IWS Services.postman_collection.jsonTA-IWS_Service_Prereq_Bundle_ORMB_4.0.0.0.xml
2.9.0.0TA - ORMB IWS Services.postman_collection.jsonTA-IWS_Service_Prereq_Bundle_ORMB_4.0.0.0.xml

2 - Batch prerequisites

Add batches

To ensure batches are loaded in Test Automation (TA) tool and configured for execution, you need to ensure following steps are followed for every configured OUAF environment in TA.

  1. Navigate to Admin > E > Extendable lookup.
    You can also enter /Extendable lookup in the search bar.
  2. Enter TA-AutomationBatchControls in the Business Object field. Click Search.
  3. Click the link in the Description column of the TA-AutomationBatchControls object.
  4. Click the edit icon for the TA-AutomationBatchControls in the Extendable Lookup Value List.
  5. Click + in the Field Configurations section of the Extendable Lookup window.
  6. Enter the batch name under the Batch Control column.
  7. Copy the automatically generated description to the Description column. If the batch name is incorrect, the description will not be generated. Click Save.
  8. Repeat Steps 7-8 for all other batches that will be configured in TA.

Troubleshooting

Batches are still not loading

  • Ensure the required OUAF environment from which the batches need to load is set up as default.
  • Ensure if the Authentication type is correct.
  • Ensure the OUAF environment is whitelisted.

3 - IWS prerequisites

Add services

To ensure configured IWS are loaded in Test Automation (TA) tool and configured for execution, you need to ensure that the following steps are followed for every configured OUAF environment in TA.

  1. Navigate to Admin > W > Extendable lookup page.
    You can either click or enter `/Web Service Catalog` in the search bar.
  2. Click the broadcast button beside the REST Web Service Class.
  3. Select all the required services in the Candidate Services section, then click Add to Catalog.

Troubleshooting

REST Catalogs are not loading

  • Ensure the required OUAF environment from which the IWS services need to load is set up as default.
  • Ensure if the Authentication type is correct.
  • Ensure that the OUAF environment is whitelisted.