Sales Order Data Extract Job History

Purpose: Use the Sales Order Data Extract Job History screen to review summary information on the sales order data extracts that have taken place for an organization.

Used for the Routing Engine module.

How to display this screen: Click the history icon () for an organization at the View Active Schedules screen.

Note:

• Only users with View Active Schedules authority can display this screen. See the Role Wizard for more information.
• Available only if the Sales Order Data Extract is currently enabled, or if there are any data extract records that have not been purged.
• If the Sales Order Data Extract Job History screen was already open in another tab when you clicked the history icon, you advance to this screen with the order data extract history of the previously-selected organization displayed.
• History is retained for the number of days specified in the Job History retention setting at the Tenant-Admin screen.

Maximum number of orders: The extract fails if the total number of orders to extract exceeds 500,000. If this occurs, use the Extract Orders with Activity From and To at the Schedule Jobs screen to run the extract for smaller segments by specifying date ranges to include each time, rather than including all orders.

For more information: See the Sales Order Data Extract for information on generating the extract, and see Sales Order Data Extract Files for information on the data included in the extract files.

Options at this screen

Option	Procedure
Search for an extract process	Use the Job Number, Start Date, or Status fields to restrict the displayed extract to those that match your entries and click Search: Job Number = Optionally, enter an extract job number to display this extract process only. Start Date = Optionally, enter a date to display extracts that started on that date. Status = Optionally, select a status of: Error to display an extract process that ended in error. Rejected if the submitted export was rejected due to a conflict with another instance of the job that was already running. Running to display an extract process that is currently running for the organization. Failed to display extract processes that included any records in error. Success to display extract processes that completed without any errors. Note: You cannot select a status of Paused; however, a job stays in this status only briefly when it switches to another server to complete running.
Understand general errors	If an error occurred for an extract process itself, it is displayed in the Error field. This might occur if, for example, the number of orders to extract exceeded the limit of 500,000.

Fields at this screen

Field	Description
Summary fields:
Organization	The code identifying the organization that generated the extract process, and the description of the organization.
Search fields:
Job Number	A unique ID number assigned by Order Broker to identify an export job. Optionally, enter a number and click Search to display this export process only.
Start Date	Optionally, enter a date to display extracts that started on that date.
Status	Optionally, select a status of: Error to display an extract process that ended in error if, for example, the number of orders to extract exceeded the limit of 500,000. Rejected to display an extract process that was rejected because another instance of the job was already running. Running to display an extract process that is currently running for the organization. Failed to display extract processes that included any records in error. Success to display extract processes that completed without any errors. Note: You can select a status of Paused; however, a job stays in this status only briefly when it switches to another server to complete running.
Results fields: Note: History is retained for the number of days specified in the Job History retention setting at the Tenant-Admin screen.
Job Number	A unique number assigned by Order Broker to identify an export process.
Start Date	The date and time when the export process started.
End Date	The date and time when the export process ended.
Duration	The amount of time it took for the export to run. HH:MM:SS format, but displayed in MM:SS format if the export took less than an hour.
Submitted By	Indicates how the export was submitted. This could be the ID of the user who submitted or scheduled the process, or the client ID used to authenticate the run job API request message. SYSTEM is displayed here if the job ran successfully through a schedule; however, if a scheduled job was rejected, the ID of the user who scheduled the job is displayed.
Status	Indicates whether any errors occurred for the export process: A running person () indicates that the export process is currently running (status = Running). A green check () indicates that no errors occurred (status = Success). Note: The green check is also displayed if there were no records to export. A yellow triangle () indicates that the job was rejected because another instance of the job was already running. A red X () indicates that an error occurred (status = Error). A pause icon () indicates that the job has paused briefly while it switches to another server to finish running. This status might be displayed only briefly.
Error	The error that occurred, if any.
Order Records	The total number of order records included in the export process. This total can include both sales orders and purchase orders.