Loading Contractor Licenses
You can use batch processing to load contractor license records manually from a file or through an integration with a licensing body. Merge options enable you to load a full file or update licenses matching those in the agency-maintained contractor list.
Processing can be executed as needed, such as when you want to migrate contractor data from a legacy system, or on a scheduled basis to refresh license records in the contractor list.
Before You Begin
Oracle provides a prebuilt Oracle Integration Cloud (OIC) integration to load licenses. You import a package and activate integration settings in OIC before you run batch processing.
For information about OIC configuration for an integration with a licensing body and connections for loading a file with license records, see Setting Up Contractor Integration and Preparing to Load Contractor Licenses.
Entering Parameters
-
Select
. -
Access the Parameters tab on the Load Contractor Licenses page.
-
Enter the parameters for your batch process.
Elements in the Parameters tab for loading contractor licenses
Page Element
Description
Data Source
Select an option to indicate the source of the license records that you want to load:
File – Processing picks up license information from a file to merge with license records.
Integration service – Processing connects with a licensing body through an integration service to get the license file and merge license records.
Merge Option
Select how you want to merge the data from the source with your system:
The Entire file option works in two ways:
Loads any new licenses from the file that do not exist in the contractor list.
Updates existing licenses in the contractor list from the file.
Use the Contractor list option to update licenses that already exist in the contractor list. The process skips licenses that don't exist in the contractor list.
Period in Which Licenses Were Last Updated
Identify which records you want to merge by when they were last updated. For example, if you want to merge the records from the source that were updated in the last two weeks, select the number 2 and the unit of time, Weeks.
Select a number 1 or greater.
Select a unit of time, including None, Days, Weeks, or Months. If you don't want to load records based on a given period, select None.
Note: To identify licenses that were updated in the specified period only, the license data must have a last updated date. If a licensing body doesn't use a last updated date, select None.
Scheduling the Process
-
Access the Schedule tab.
-
To immediately add the process to the queue, select the As soon as possible option.
-
To create a schedule for the process, select the Using a schedule option, and enter values using the following fields:
Elements of the Scheduling tab
Page Element
Description
Frequency
Select how frequently you want to run the process. Values are:
-
Once: Select to run the process one time only.
-
Hourly or minute: Select to run the process at regular time intervals.
-
Daily: Select to run the process at regular intervals in days.
-
Weekly: Select to run the process at regular intervals in weeks.
-
Monthly: Select to run the process on specific days of the month.
-
Yearly: Select to run the process during specific months.
Start Date
Enter the date on which you want to begin your scheduled processing.
End Date
Enter the date on which you want to end your scheduling processing.
Hours and Minutes
Enter the time interval between scheduled processes. For example, if you enter 2 in the Hours field and 30 in the Minutes field, the process will run every 2 hours and 30 minutes beginning on the specified start date.
Note: These fields are available only if you select a process frequency of Hours or Minutes.Days
Enter the number of days between scheduled processes. For example, if you enter 3, the process will run every 3 days beginning on the specified start date.
Note: This field is available only if you select a process frequency of Daily.Weeks
Enter the number of weeks between scheduled processes. For example, if you enter 6, the process will run every 6 weeks beginning on the specified start date.
Note: This field is available only if you select a process frequency of Weekly.Repeat – By day
Select this option to run the process on specific days of the month irrespective of the date. For example, if you select the Secondand Wednesday options, the process will run on the second Wednesday of every month.
You can select more than one week of the month and day of the week option. For example, you could schedule the process to run on the first and third Monday of every month.
Note: This option and its associated fields are available only if you select a process frequency of Monthly or Yearly.Repeat – By date
Select this option to run the process on specific dates of the month. You can select more than one date.
Note: This option and its associated fields are available only if you select a process frequency of Monthly or Yearly.Month
Select the months in which you want your process to run.
Note: This option and its associated fields are available only if you select a process frequency of Yearly. -
Setting Up Process Notifications
You can set up the process to send notifications to you and others when it runs.
-
Turn on the Notify Me When This Process Ends switch to send yourself a notification when the process finishes.
-
Access Notification tab.
-
Click Add.
-
On the Create Notification page, enter the email address of the person you want to receive notifications.
By default, the recipient will receive a notification when the process ends with the following conditions:
-
On success
-
On error
-
On warning
You can remove any of these process notification conditions.
-
-
Click OK to save the notification recipient.
-
(Optional) To delete a notification recipient, select the recipient in the Notification tab and click Delete.
Submitting the Process
Once you’ve entered your process parameters, scheduling information, and notification recipients, you’re ready to submit the process. Enter any additional information in the Submission Notes field and click Submit. Click Process Monitor to check the status of your process.