Re-initialize the ETL Process

Once an initial ETL process has been successfully executed on a database, it cannot be executed again until the mart environment is reset. To request this:

1. Navigate to Oracle Health Sciences Support, at https://hsgbu.custhelp.com/.
2. Click Login, and then enter your user credentials.
3. Click My Requests.
4. In the upper left side of the screen, click Change Requests.
5. In the upper right side of the screen, click Create a new Change Request.
6. In the General Information/Action tile, click Create a Request.
7. From the Category drop-down, select Service Request > Application > General > Action, and then click OK.
8. In the Select Customer drop-down, either type the name of your company in the search field or select it from the list, and then click OK.
9. In the Select Product drop-down, select Argus Safety, and then click OK.
10. In the Business Service drop-down, select the name of the server where you want to re-initialize the ETL process, and then click OK.
11. In the Action drop-down, select Other, and then click OK.
12. From the Oracle Internal radio buttons, select No.
13. In the Environment drop-down, select the environment where you want to re-initialize the ETL process, and make sure your selection is consistent with the value you selected in the Business Service drop-down above.
14. In the Summary field, enter a short description of your request.

    Example: Run re-initial <product name> ETL in the <environment name> environment.

15. In the Description field, enter a detailed description of your request.

    Example: Please run a re-initial <product name> ETL in the <environment name> environment.

16. Select appropriate values from the Severity and Implementation Window drop-downs.
17. In the Date Required By field, select a value from the calendar.
18. Click Submit.