Work Order Upload
This integration uploads work orders.
File Formatting
Assumptions/Tips
-
For Rate schedules, if ‘Capture Time Worked on Time Sheet’ is not enabled and Time Sheet Type = Time In/Time Out, an error will be created.
-
If you want Consolidated Worker match logic, Combine attributes to create a strong match must be enabled in company configuration. When this configuration is enabled, if the only attribute that matches between a document and the Consolidated Worker is the Security ID or the Unique ID, the match is not considered Strong. Strong matches require one of the following combinations: Identical Name + Security ID + Unique ID, Identical Security ID + Unique ID, Identical Name + Security ID when document has no Unique ID, or Identical Name + Unique ID when document has no Security ID.
-
Amounts will be automatically rounded to whole number but displayed to two decimal points if currency is Yen.
-
When Tenure company configuration is enabled, validations are done using tenure policy lookup table. If Worker is in violation of a tenure policy, error will be displayed.
-
When a document from this upload picks up a new Tenure Policy, Display Tenure Notifications will default to Yes for that policy.
-
Even if the company configuration Supplier presented rate defaults as final rate is enabled, this upload will update the pay rate value from the upload file.
-
Combination of header 'Approval Required? = False' and header ‘Supplier Confirmation Required = True’ is not allowed.
-
In the event the Allow Daily Verification flag is locked on the Job Posting Template, then it cannot be overridden through this upload. The Allow Daily Verification flag must be made available for all types of time sheet frequencies.
-
Both buyer- and supplier-entered Custom Fields will display and can be updated by both parties regardless of who created the Custom Field first.
-
Auto Activate plays a role when Supplier Confirmation Required is set to True and Auto Engage is off on the Job Posting Template. Once the Work Order is uploaded, it goes into Created status and once the supplier accepts the Work Order, it goes into Activated status. No need to 'Activate' Work Order from the buyer's side.
-
For user-entered amounts, a validation has to happen on the upload to ensure that the value entered is a whole number for those currencies requiring the precision to be zero decimals.
-
If the Time Sheet Allotment is Mandatory, it must be included in the file. If [pr] or [br] is missing for the Time Sheet Allotment, an error is returned.
-
When the system processes Rate Change Matrix, the entire assignment is considered when applying Rate Change Matrix Sequences.
-
If the config Matches on Security ID only and Unique ID only are not considered Strong is disabled, the application will consider a match on SID Only a strong match (Example: FirstName+LastName NO Match + SID Match + UID Blank on document = STRONG). If there are no strong matches, or if there are multiple strong matches, the document will associate to a new Consolidated Worker.
-
During upload, when Approval Group is not present/no Business Unit is associated to any approval group, work order status will be set as follows:
Approval Required Flag
Supplier Confirmation Required Flag
Auto Register Job Seeker
Work Order Status
True / False
False
Yes
Confirmed
True / False
False
No
Activated
True / False
True
Yes
Created
True / False
True
No
Created
-
This connector considers the Corporate Calendar for spend calculation when the company configuration, Spend calculation is based on corporate calendar, is turned on.
-
The system auto generates a new line item number when a new work order or work order revision is created with new a cost center.
-
Activation_time and Respond_time are set to the upload time and are only set when the Supplier Confirmation Required header is set to False. Activation time is set only when a work order is moved to Activation or Confirmed status. Respond time is set only when a work order is moved to Accepted, Activated, or Confirmed status, whichever status happens first.
-
If company configuration 'Cost Allocation Percentage decimal precision' is enabled, when the system calculates the allocation percentage (Spend Matrix), rounding rules account for the company's set decimal precision. Spend matrix is converted from Amount to % base.
-
When 'Approval Required?' is set to False, the connector should behave as follows:
-
When Supplier Confirmation Required is set to True, the uploaded work order routes to the supplier for acceptance. The status is 'Created' and no Consolidated Worker generates until after the supplier accepts the work order.
-
When Supplier Confirmation Required is set to False, the uploaded work order is fully confirmed (assuming auto-register is enabled). Upon creation, a Consolidated Worker is generated.
-
-
Regarding leading and dependent custom fields:
When leading and dependent custom fields have been set up and a buyer downloads a blank upload template for this connector from the user interface, leading and dependent custom fields are automatically added as individual columns.
The system reads the value of the leading custom field and validates the first dependent custom field. This process continues for all dependent custom fields in the defined sequence until it is completed.
-
Each line item can be associated with only one rate category. A validation prevents multiple rate categories from being mapped to the same line item. To use multiple rate types, you must create separate line items under the same cost allocation. This validation applies to Contingent Work Orders when Spend Matrix is enabled.
Errors
The following errors can occur when processing this upload file:
|
Error Message |
Resolution |
|---|---|
|
Adjustment should be greater than zero. |
Enter a value greater than zero in the Flat Adjustments column. |
|
AP Code is invalid. |
Verify the value in the AP Code column matches an active AP code configured for this company. |
|
AP Code is required. |
AP Code is required when the company uses AP Code lists. Enter a valid AP Code in the AP Code column. |
|
Auto Invoicing Type must be Time Sheet, Expense Sheet, Both, or None. |
Enter one of the accepted values: Time Sheet, Expense Sheet, Both, or None in the Auto Invoicing column. |
|
Bill Rate {0} does not belong to Job Posting. |
The bill rate entered for rate category {0} is not associated with the Job Posting. Verify that the rate category exists on the Job Posting and re-enter the correct bill rate in the corresponding bill rate column. |
|
Bill Rate {0} should be greater than zero. |
The bill rate for rate category {0} must be greater than zero. Verify the value in the bill rate column for that rate category. |
|
Business Unit Code visibility: Creator or Owner does not have visibility to the Business Unit Code. |
Verify that the creator or owner specified has visibility to the Business Unit Code on this work order. Correct the value in the Business Unit Code column. Applies only when Enhanced Legal Entity configuration is enabled. |
|
Cannot upload Work Order since the Job Posting is not in a status to allow Work Order Upload. |
The Job Posting referenced is in a status (Rejected or Pending Submission) that does not allow Work Order uploads. Verify the Job Posting ID column references a Job Posting in an eligible status. |
|
Cost Center Code visibility: Creator or Owner does not have visibility to the Cost Center Code. |
Verify that the creator or owner specified has visibility to all cost center codes on this work order. Correct the value in the Cost Center Code column. Applies only when Enhanced Legal Entity configuration is enabled. |
|
Duplicate Job Posting found. |
Multiple Job Postings match the Job Posting ID value provided. Supply a unique Job Posting ID in the Job Posting ID column to disambiguate. |
|
End Date cannot be blank. |
End Date is required for Temp service type work orders. Enter a valid date in the End Date column. |
|
Evaluations need to be completed. |
The Job Seeker's evaluation must be completed before a Work Order can be created. Complete the evaluation for this Job Seeker before uploading. |
|
Hours per Day is invalid. |
Enter a valid numeric value for Hours Per Day in the Hours Per Day column. |
|
Hours per Day must be between 1 and 24. |
Enter a value between 1 and 24 in the Hours Per Day column. |
|
Hours per Week is invalid. |
Enter a valid numeric value for Hours Per Week in the Hours Per Week column. |
|
Hours per Week must be greater than or equal to Hours per Day and less than or equal to 7 times Hours per Day. |
Enter a value in the Hours Per Week column that is at least equal to Hours Per Day and no greater than 7 times the Hours Per Day value. |
|
Invalid values for Adjustment Group |
The Adjustment Group code could not be resolved. Verify the value in the Adjustment Group column matches an active adjustment group code for this company. |
|
Invalid values for Creator Username |
The Creator Username either is not a buyer user with Work Order Manage permission or the role is not permitted. Verify the value in the Creator Username column. |
|
Invalid values for Job Posting ID |
The Job Posting ID could not be resolved to a unique active Job Posting. Verify the value in the Job Posting ID column. |
|
Invalid values for Start Date |
The Start Date value could not be parsed. Verify the date format and correct the value in the Start Date column. |
|
Job Posting is not of Temp Service Type. |
Work Order uploads require a Job Posting with a Temp service type. Verify that the Job Posting ID column references a Temp-type Job Posting. |
|
Job Posting not found. |
No Job Posting was found for the resolved Job Seeker. Verify the Job Seeker ID column references a Job Seeker associated with a valid Job Posting. |
|
Job Seeker not found. |
No active Job Seeker was found matching the value in the Job Seeker ID column. Verify the Job Seeker ID value is spelled correctly and the Job Seeker is active. |
|
Legal Entity visibility: Creator or Owner does not have visibility to the Legal Entity. |
Verify that the creator or owner specified is associated with the Legal Entity on this work order. Correct the value in the Legal Entity column. Applies only when Enhanced Legal Entity configuration is enabled. |
|
Missing data for Job Posting ID |
Job Posting ID is required when the Job Seeker ID matches multiple Job Seekers with the same external reference. Enter a value in the Job Posting ID column to disambiguate. |
|
Missing data for Job Seeker ID |
Job Seeker ID is required. Enter a valid Job Seeker reference in the Job Seeker ID column. |
|
Missing data for Start Date |
Start Date is required. Enter a valid date in the Start Date column. |
|
MSP code of the {0} does not match the MSP code of {1}. |
The MSP code of the creator does not match the MSP code of the Job Posting. Verify that the Creator Username column references an MSP user whose MSP code matches the Job Posting's MSP code. |
|
MSP % for Rate {0} does not belong to Job Posting. |
The MSP rate for rate category {0} is not associated with the Job Posting. Verify that rate category {0} exists on the Job Posting and enter the correct MSP rate in the corresponding MSP % column. |
|
MSP % of Overtime Rate {0} should be greater than zero. |
Enter a valid MSP rate for rate category {0}. For MSP %, enter a value between 0 and 99. For MSP Flat Fee, enter a value of zero or greater. |
|
No Work Order can be created for this Job Seeker until the Supplier enters the Security ID. The Supplier can enter the Security ID by choosing 'Edit Security Information' from the Job Seeker's Action menu. |
The Job Seeker record is missing a required Security ID. The supplier must enter the Security ID on the Job Seeker before this Work Order can be uploaded. |
|
Number of Shift Positions must be greater than or equal to 0. |
Enter a value of 0 or greater in the Number of Shift Positions column. |
|
Pay Rate {0} cannot be negative. |
Enter a pay rate of zero or greater for rate category {0}. |
|
Pay Rate {0} does not belong to Job Posting. |
Verify that the pay rate for rate category {0} matches a rate category defined on the Job Posting. Correct the value in the pay rate column for that rate category. |
|
Pay Rate {0} should be equal to or greater than one. |
Enter a pay rate of 1 or greater for rate category {0}. |
|
Pay Rate {0} should be equal to or greater than zero. |
Enter a pay rate of 0 or greater for rate category {0}. |
|
Primary Cost Center Code visibility: Creator or Owner does not have visibility to the Primary Cost Center Code. |
Verify that the creator or owner specified has visibility to the primary cost center on this work order. Correct the value in the Primary Cost Center Code column. Applies only when Enhanced Legal Entity configuration is enabled. |
|
Rate Category / Rate UOM {0} is not valid. |
The rate category and unit of measure combination in the column header is not valid for this work order. Verify that the rate category column headers (for example, [br] ST/Hr or [pr] Regular/HR) use a Rate Category/UOM combination that is defined on the associated Job Posting. |
|
Rate Multiplier for Rate {0} does not belong to Job Posting. |
The rate multiplier for the specified rate category is not associated with the Job Posting. Verify that the rate category in the rate multiplier column header exists on the associated Job Posting, and enter the correct multiplier value. |
|
Remit-to Address is inactive. |
The Remit-to Address code provided references an inactive address. Enter an active Remit-to Address code in the Remit-to Address Code column. |
|
Remit-to Address is required. |
Remit-to Address is required for this company or division. Enter a valid code in the Remit-to Address Code column. |
|
Required data is missing for Bill Rate. Please enter value for at least one Rate Category that belongs to Job Posting. |
At least one bill rate for a rate category defined on the Job Posting is required. Enter a value in the bill rate column for at least one applicable rate category. |
|
Required data is missing for Pay Rate. Please enter value for at least one Rate Category that belongs to Job Posting. |
At least one pay rate for a rate category defined on the Job Posting is required. Enter a value in the pay rate column for at least one applicable rate category. |
|
Selected Cost Center(s) Total Allocation % must be 100. |
The percentages across all cost center rows do not add up to 100. Correct the cost center allocation percentages so they total 100. |
|
Selected Cost Centers Total Allocation amount must equal the Total Amount. |
The allocated amounts across all cost center rows do not equal the committed spend total. Correct the cost center allocation amounts to match the committed spend. |
|
Shift Position dates must be between Start Date and End Date entered for the Work Order. Adjust the Work Order dates or Shift Position assignments prior to proceeding. |
One or more Shift Position dates fall outside the Work Order Start Date and End Date. Adjust the Start Date or End Date columns, or update the Shift Position assignments before uploading. |
|
Site Code visibility: Creator or Owner does not have visibility to the Site Code. |
Verify that the creator or owner specified has visibility to the Site Code on this work order. Correct the value in the Site Code column. Applies only when Enhanced Legal Entity configuration is enabled. |
|
The Comments limit of 2000 characters has been exceeded for Work Order {0}. |
Shorten the value in the Comments column to 2000 characters or fewer. {0} resolves to the Work Order reference at runtime. |
|
The Work Order cannot be uploaded because multiple Job Seekers with the same External Reference ID exist. |
Multiple Job Seekers share the same external reference. Supply a Job Posting ID in the Job Posting ID column to disambiguate, or correct the Job Seeker ID column. |
|
The Work Order cannot be uploaded because multiple Job Seekers with the same Reference ID exist. |
Multiple Job Seekers share the same internal Reference ID. Verify the Job Seeker ID column value is unique, or use an external reference to identify the correct Job Seeker. |
|
Time In/Time Out cannot be enabled because Time Worked is not used by Rate Schedule: {0}. Please select a new Rate Schedule or Time Sheet Type. |
The selected Rate Schedule does not support Time In/Time Out. {0} resolves to the rate schedule name. Enter a compatible Time Sheet Type or change the Rate Schedule Code column to a rate schedule that allows Time Worked. |
|
Time Sheet Frequency entered is not applicable/enabled for the logged in Company. |
The time sheet frequency value provided is not enabled for this company. Enter one of the enabled frequency values for the company in the Time Sheet Frequency column. |
|
Time Sheet Frequency must be Weekly, Biweekly, Semimonthly or Monthly. |
Enter one of the accepted values: Weekly, Biweekly, Semimonthly, or Monthly in the Time Sheet Frequency column. |
|
Time Sheet Type entered is not applicable/enabled for the selected Site. |
The time sheet type value provided is not enabled for the site associated with this work order. Enter a time sheet type that is enabled for the selected site in the Time Sheet Type column. |
|
Time Sheet Type must be Standard, Time In/Time Out, or No Time Sheets. |
Enter one of the accepted values: Standard, Time In/Time Out, or No Time Sheets in the Time Sheet Type column. |
|
Users with the Configuration Manager role cannot be selected. |
The user specified in the Creator Username column has the Configuration Manager role, which is not permitted for work order creation. Enter the username of a buyer user with an eligible role. |
|
{0} does not have visibility permission to one or more of the following: Legal Entity, Business Unit, Site, and / or Cost Center. |
The Work Order Owner specified does not have the required visibility to the work order's Legal Entity, Business Unit, Site, or Cost Center. {0} resolves to "Owner" at runtime. Verify that the Work Order Owner Username column references a user with the appropriate visibility. Applies only when Enhanced Legal Entity configuration is enabled. |
|
Work Order already exists for Job Seeker. |
A Work Order already exists for the Job Seeker referenced. Each Job Seeker can have only one active Work Order. Verify the Job Seeker ID column or confirm whether this record was already uploaded. |
|
Work Order can not be created as the Job Seeker has been Withdrawn by the Supplier. |
The Job Seeker has been withdrawn and is no longer eligible for a Work Order. Update the Job Seeker status or use a different Job Seeker ID. |
|
Work Order cannot be uploaded because the Job Posting is closed. |
The Job Posting referenced is in Closed status. Verify the Job Seeker ID column references a Job Seeker associated with an open Job Posting. |