1. Oracle® Customer Support Identifiler Document
  2. Using Datafix
  3. Scheduling Datafix Execution

Scheduling Datafix Execution

Learn how to schedule datafix execution.

About this task:

Each environment requires a separate MOS RFC, which can be created from Oracle Automated Data Fix Execution. If you have the CreateRFC and Authorized Approver privilege in MOS, you can use Packager to create and schedule RFCs for your environment. Otherwise, an authorized approver for your organization will need to schedule any RFCs you create.

This section describes how to schedule a data fix deployment using Packager. For more information, see Scheduling Datafixes Using Packager.

Note:

To schedule RFCs in Packager, you must have the MOS Authorized Approver privilege for the Oracle E-Business Suite environment where the Data fix will be deployed. Otherwise, request that a MOS authorized approver for your organization schedules the RFC through Oracle Automated Data Fix Execution.

  1. In the Self Service Management home page, under Customer Self Service, click Datafix.
  2. On the Datafix page, Click Files.
  3. The Execution page displays a list of SQL files for execution.
  4. Use the following options to manage execution files in the summary list:
    • Refresh. To refresh the Data Fix file list, click the refresh icon.
    • Search - To search a file and display selective files, enter a search criteria such as RFC, file name, and so forth and press enter.
    • RFC Status Open - By default, all the closed RFC patches. Toggle the switch to the right side to display all RFC files in Open status.

      Note:

      In general, you must close an RFC within 7 days or the RFC gets closed within 14 days.
    • View execution details - To view the details, select a files and click View Execution Details from the actions menu.
    • Export - To export the files in CSV format. In the Export dialog box, provide a data range and file parameter to export specific data within the selected date range.
  5. Click Initiate Datafix Activity to execute a SQL file.
  6. The Create Datafix Activity page enables you to complete the process as Initiate, Create, Schedule, and Approve in Wizards.
  7. In the Initiate wizard, set the following parameters:
    • Support identifier - This field value is automatically populated with the numbers of selected files. the summary field is automatically populated with the number of files to be applied.
    • Environment - Select a target environment where you want to deploy the files. This list is populated with all the environments associated with the Support Identifier (SI).
    • RFC Type - Click the RFC Type box, so the RFC Type and RFC Sub Type gets auto populated.
    • RFC Subtype - Value gets auto populated based on the RFC type that's selected as part of MOS Request for change.
    • Primary Contact E-mail - Primary contact of customer in ticketing application.
    • Estimated Time to Apply Changes - Estimated time required to complete the RFC execution.
    • Customer Note - Select an action plan or more information to customers as part of request for ChangRFC.
    • Summary - A brief description about the execution.
    • Hot Backup Options - For Prod instance, Hot Backup check box would be auto selected and not allowed to uncheck (if Auto Backup is selected YES under General Preferences). User will be allowed to uncheck the Hot backup for Prod instance only when Auto Backup is selected as NO under general Preferences.

      Note:

      Prefer to always select Hot Backup for Prod instances. For Non-Prod instance, Hot Backup check box is not auto selected or allowed to uncheck but, you can uncheck the Hot backup for Non-Prod instance.
  8. Click Next.