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. Log in to the Life Sciences Customer Support Portal.
  2. On the upper-right side of the screen, click Switch to old portal.

    Note:

    A new Oracle Life Sciences Support Cloud portal is currently rolled out, while the old portal is still available. Until the new portal is completely functional, all the information presented in this guide about the customer support portal is referring to the old portal.
  3. On the upper-side menu, click Change Requests.
  4. Under the menu bar, on the right side of the screen, click Create a new Change Request.
  5. On the General Information/Action tile, click Create a Request.
    The screen Submit a request to our hosting team appears.
  6. From the Category drop-down list, expand Service Request, then Application, General, and select Action.
  7. From the Customer drop-down list, search for your company's name and select it from the list.
  8. From the Product drop-down list, select Argus Safety.
  9. From the Business Service drop-down list, select the name of the server where you want to re-initialize the ETL process.
  10. From the Action drop-down list, select Other.
  11. From the Oracle Internal radio buttons, select No.
  12. From the Environment drop-down list, select the environment where you want to e-initialize the ETL process, and make sure your selection is consistent with the value you selected in the Business Service drop-down list above.
  13. In the Summary field, enter a short description of your request.

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

  14. 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.

  15. In the Additional Contacts field you can enter one or more email addresses to be notified about this change request, separated by a semicolon.
  16. If you use an sFTP location to exchange files with the Oracle team, enter its address in the sFTP path field.
    If you don't use sFTP and prefer to attach the documents directly to this change request, select Tick if sFTP path is not applicable for this request.
  17. Select appropriate values from the Severity and Implementation Window drop-down lists.
  18. In the Date Required By field, select a value from the calendar.
  19. Click Submit.