Field
Description
(Job Name)
The job available for scheduling. Displayed at the top of the right-hand area. Available jobs are:
Data Hygiene Folder:
• Completed Order Private Data Purge
Exports Folder:
Orders Folder:
If this flag is selected, the job runs according to the defined schedule.
Only jobs whose schedules are enabled are listed at the View Active Schedules screen.
Note: The additional fields displayed vary for each job, and are described separately below.
Completed Order Private Data Purge
The Completed Order Private Data Purge job in the Data Hygiene folder anonymizes customer data on sales orders that closed (fulfilled, canceled, unfulfillable, completed) and purchase orders that have been closed (shipped, complete, or canceled) and that are older than the number of days specified in the Days Old field.
If the same external order number is assigned to multiple sales or purchase orders, each purchase order is purged only if if is closed and is older than the retention days. For example, order number 12345 is assigned to two purchase orders created on February 1 and another was created on February 6. If the current date is February 15 and the retention days is set to 10, then the third purchase order cannot yet be purged.
The order’s age is calculated based on the CREATE_TIMESTAMP from the XOM_ORDER table or the CREATED_DATE from the PO_HEADER table. This is the date and time when Order Broker created the sales order or purchase order, which might be different from when the order was created in the originating system.
About anonymization: When the customer data is anonymized, all information is replaced with asterisks. Anonymized data cannot be recovered. Data that is anonymized includes sold-to and ship-to customer names, address, email addresses, and phone numbers for sales orders and purchase orders. Even if a field, such as one of the address lines, did not previously contain data, the purge populates the field with asterisks. See Anonymizing Data for a discussion.
A Transaction Note is written for each order line: Private Data Anonymized.
Scheduling the Completed Order Data Purge
• Select the Day of Week when the job should run.
• Enter the Time when the job should run.
• Enter the Days Old an order or purchase order must be to be eligible for anonymization.
• Select Schedule Enabled.
• Select Save.
Orders across all organizations are anonymized.
Completed Order Data Purge Fields
• Schedule Interval: Set to Weekly. Display-only.
• Day of Week: Use the dropdown menu to select the day of the week when the job should run.
• Time: The time of day, in HH:MM format (24-hour clock) when the job runs. Required.
• Days Old: The number of days old a completed order must be to be eligible for purge.
• Last Run
• Next Run
For more information: See the Operations Guide for information on web service requests that support inquiring on private data and requesting to anonymize it.
The Daily Clean Up job in the Daily Hygiene folder clears outdated information, including:
• Pack slip records generated through the Vendor Portal, after the number of days specified in the Pack Slip Files field under Retention Settings at the Tenant-Admin screen.
• Reports, after the number of days specified in the Report Files field under Retention Settings at the Tenant-Admin screen.
• Pack slip records generated through Store Connect, after one day.
• Shipping label records generated for integrated shipping with ADSI, in either the Vendor Portal or Store Connect, after one day.
• Email notification records, after three days.
• Product import error files and part files, after the number of days specified in the Product Import Error Files field under Retention Settings at the Tenant-Admin screen, if Cloud Storage is used.
• Records in the RICS_LOG table of messages between Order Broker and Oracle Retail Integration Cloud Service (RICS), based on the number of days specified in the RICS Log History field under Retention Settings at the Tenant-Admin screen. See Order Fulfillment through RICS Integration for background.
RICS log records whose Retry Status is Failed are not eligible to be purged.
• Sales Extract Job History, records, as displayed at the View Sales Order Data Extract Job History screen, which are older than the Extract Log History setting at the Tenant - Admin screen.
The Daily Clean Up job does not clear log files. The Cloud Operations staff is responsible for clearing these files.
Scheduling the Daily Clean Up Job
• Enter the Time in HH:MM format (24-hour clock) when the job should run.
• Select Schedule Enabled.
• Select Save.
Daily Clean Up Fields
• Schedule Interval: Set to Daily. Display-only.
• Time: The time of day, in HH:MM format (24-hour clock) when the job runs. Required.
• Last Run
• Next Run
Note: After a new install, the job settings are blank, and the job is not yet enabled.
For more information: See the Tenant - Admin screen for information on Retention Settings fields.
You can use the sales order data extract to export data related to sales orders and purchase orders. The data that you can extract includes:
• sold-to and ship-to customers
• customization details
• items ordered
• status history
The extract writes the information to pipe-delimited files, which are bundled into a compressed zip file. See File Storage API for Imports and Exports for more information on obtaining export files, and see Sales Order Data Extract Files for information on the naming and contents of these files.
Extract by organization: You need to schedule this job separately for each organization whose order data should be extracted. Click the plus sign next to the job name in the left-hand panel to display a list of existing organizations.
Note: The list of organizations is available only if Use Routing Engine is selected at the Tenant - Admin screen.
Scheduling the Sales Order Data Extract
• Click the plus sign next to the Sales Order Data Extract job in the left-hand panel to display a list of existing organizations.
• Click the organization whose sales data should be extracted. When you select an organization, the Sales Order Data Extract Fields are displayed to the right.
Note: The list of organizations is available only if Use Routing Engine is selected at the Tenant - Admin screen.
• Use the Schedule Interval field to select:
• Day(s) of Week to have the extract run at a regular time on one or more days of the week to periodically extract all orders with any activity since the last extract, or,
• Initial Load to extract:
• All order data, if you do not specify an Activity From and Activity To date, or
• Data for orders that have had activity during the Activity From and Activity To dates.
Note: The job fails if the total number of orders to extract exceeds 500,000. If this occurs, you can use the Initial Load option with the Activity From and Activity To dates to complete the extract of historical orders in increments until the extract is up to date. For example, if there is a total of 750,000 orders from the past year, you might use the Initial Load option with the Activity From and Activity To dates to break the extract into two six-month increments, each for less than the 500,000-order limit.
• If you selected a Schedule interval of Day(s) of the Week, select one or more Day(s) of Week when the job should run.
• Enter the Time when the job should run.
• If you selected Initial Load as the Schedule Interval, optionally enter the Extract Orders with Activity From and To, as described above.
• Optionally, select Include Private Data to have the extract files include personal data, such as name, address, and email address; otherwise, leave this flag unselected to have personal data for customers replaced with asterisks or with text such as ***** Data Privacy Blocked *****.
Note: User names are not replaced in the extract files, regardless of the setting of the Include Private Data flag.
• Select Schedule Enabled.
• Select Save.
Sales Order Data Extract Fields
• Organization: The code and name of the organization selected in the left-hand panel. Display-only.
• Schedule Interval:
• Day(s) of Week to have the extract run at a regular time on one or more days of the week to periodically extract all orders with any activity since the last extract, or,
• Initial Load to extract:
• All order data, if you do not specify an Activity From and Activity To date, or
• Data for orders that have had activity during the Activity From and Activity To dates.
See Scheduling the Sales Order Data Extract, above, for a discussion.
• Day(s) of Week: Use these fields to select one or more Day(s) of Week when the job should run.
• Time: The time of day, in HH:MM format (24-hour clock) when the job runs. Required, regardless of the selected Schedule Interval.
• Extract Orders with Activity From and To: Optionally, enter a From and To date to include order data for orders with activity during this date range. These fields are enterable only when the Schedule Interval is set to Initial Load.
• Include Private Data: Select this flag to include personal data, such as names, addresses, and email addresses in the data extract files; otherwise, leave this flag unselected to have this information anonymized. See anonymized in the glossary for more information.
• Last Run
• Next Run
For more information: See Sales Order Data Extract Files for information on the content of the extract files.
Auto Cancel Unclaimed Pickup Orders
This job cancels unclaimed pickup or ship-for-pickup orders based on the settings of the Auto Cancel Days of Unclaimed Pickup Orders and Auto Cancel Days of Unclaimed Ship For Pickup Orders at the Preferences screen. This job uses a Schedule Interval of Daily, and runs at the specified Time.
Scheduling the Auto Cancel Unclaimed Pickup Orders Job
• Enter the Time in HH:MM format (24-hour clock) when the job should run.
• Select Schedule Enabled.
• Select Save.
Auto Cancel Unclaimed Pickup Order Fields
• Schedule Interval: Set to Daily. Display-only.
• Time: The time of day, in HH:MM format (24-hour clock) when the job runs. Required.
• Last Run
• Next Run
Note: After a new install, the job settings are blank, and the job is not yet enabled.
For more information: See Auto-Cancel Unclaimed Orders for a discussion.
This job generates email notifications to store locations, vendors, customers, retailers, or systems operations staff based on the unprocessed records that are currently in the EMAIL_NOTIFICATION table.
Scheduling the Email Notifications Job
• Use the Minutes field to enter the number of minutes to wait before generating any emails to store locations, vendors, customers, retailers, or systems operations staff.
• Select Schedule Enabled.
• Select Save.
Auto Cancel Unclaimed Pickup Order Fields
• Schedule Interval: Set to Minutes. Display-only.
• Minutes: Enter the number of minutes to wait before generating any emails to store locations, vendors, customers, retailers, or systems operations staff.
• Last Run
• Next Run
Note: After a new install, the job settings are blank, and the job is not yet enabled.
Use the dropdown menu to select the day of the week when a Weekly job should run.
Minutes
The number of minutes to wait before running the scheduled job. Displayed for jobs only if the Schedule Interval is set to Minutes.
Used for the email generation job to indicate the number of minutes to wait before generating any emails to store locations, vendors, customers, retailers, or systems operations staff. Required if the job’s Schedule Interval is Minutes and the Schedule Enabled flag is selected.
If you change this setting and click Save, the job is rescheduled to use the entered number of minutes.
The time of day, in HH:MM format (24-hour clock) when the job runs. Displayed for jobs only if the Schedule Interval is set to Daily or Weekly. Required if the job’s Schedule Interval is Daily or Weekly and the Schedule Enabled flag is selected.
If you change this setting and click Save, the job is rescheduled to run at the entered time.
The last date and time when the schedule was updated for the job, and the ID of the user who performed the update.
The last date and time when the job ran.
The next date and time when the job is scheduled to run. Blank for any job that is not currently enabled.