Sourcing

Rate Maintenance Statuses

The following status types are used for uploading and approving rates:

  • LAST_UPLOAD: The last upload of a spreadsheet is tracked using this status type.
  • RATE_UPLOAD: When you upload a spreadsheet, each upload is tracked using this status type. View this upload status on the Upload History page.
  • RATE_APPROVAL: Indicates where in the approval process the approval summary is. Indicates the status of the approval summary.
  • RATE_RO_APPROVAL: Indicates where in the approval process an uploaded rate offering is.
  • RATE_RR_APPROVAL: Indicates where in the approval process an uploaded rate record is.

The tables below outlines the statuses you may see.

Status Type

Status Value

Explanation

LAST_UPLOAD

NEW

Default status for the latest uploaded spreadsheet.

SUCCESSFUL

All rate offerings and rate records included in the latest uploaded spreadsheet are successfully saved to the database.

PARTIALLY_SUCCESSFUL

Some rate offerings and rate records included in the latest uploaded spreadsheet are successfully saved to the database, but others failed to process due to errors.

To view the failed rates, you can download the failed rates spreadsheet.

FAILED

All of the rate offerings and rate records included in the latest uploaded spreadsheet failed to process due to errors.

To view the failed rates, you can download the failed rates spreadsheet.

RATE_UPLOAD

NEW

Default status for each uploaded spreadsheet. You see this status while the upload is still processing in the background.

SUCCESSFUL

All rate offerings and rate records included in the uploaded spreadsheet are successfully saved to the database.

PARTIALLY_SUCCESSFUL

Some rate offerings and rate records included in the uploaded spreadsheet are successfully saved to the database, but others failed to process due to errors.

To view the failed rates, you can download the failed rates spreadsheet.

FAILED

All of the rate offerings and rate records included in the uploaded spreadsheet failed to process due to errors.

To view the failed rates, you can download the failed rates spreadsheet.

RATE_APPROVAL

NEW

Default status of each approval summary on initial upload.

IN_PROCESS

Indicates that one or more rates uploaded against this approval summary are approved or rejected.

FINAL

Indicates that all rates uploaded against this approval summary have been finalized.

RATE_RO_APPROVAL

NEW

Indicates one of the following:

  • a new rate offering was uploaded and inserted into the database
  • Undo All action has been run for this rate offering
  • this rate offering in inactive

APPROVED

Indicates that the rate offering has been approved via either the Approve All or Approval only New actions. These actions are available from either the Approval Summary or Approval Detail pages.

You cannot update a rate with this status.

ACTIVE

Indicates that the rate offering is an active OTM rate and cannot be updated via Rate Maintenance. However, you can upload new rate records for this active rate offering.

REJECTED

Indicates that the rate offering has been rejected using the Reject All action from either the Approval Summary or the Approval Details page.

APPROVED_FINAL

If the rate offering is in APPROVED status and the Finalize All action is run, this status value is set.

The Active option on the rate offering is selected and this rate offering is now operational and can be used for shipment planning. Also, the Read Only option is deselected so that this rate offering can be edited through the rate offering manager.

REJECTED_FINAL

If the rate offering is in REJECTED status and the Finalize All action is run, this status value is set.

This rate offering remains inactive and read only. It cannot be used for shipment planning.

RATE_RR_APPROVAL

NEW

Indicates one of the following:

  • a new rate record uploaded and inserted into the database
  • Undo or Undo All actions have been run for this rate record

APPROVED

Indicates that the rate record has been approved via either the Approve All, Approval only New,or Approve actions. These actions are available from either the Approval Summary or Approval Detail pages.

You cannot update a rate with this status.

REJECTED

Indicates that the rate record has been rejected using the Reject or Reject All actions from the Approval Details page and the Reject All action from the Approval Summary.

APPROVED_FINAL

If the rate record is in APPROVED status and the Finalize All action is run, this status value is set.

The Active option on the rate record is selected and this rate record is now operational and can be used for shipment planning. Also, the Read Only option is deselected so that this rate record can be edited through the rate record manager.

REJECTED_FINAL

If the rate record is in REJECTED status and the Finalize All action is run, this status value is set.

This rate record remains inactive and read only. It cannot be used for shipment planning.

Related Topics