Determine Average Dock to Stock Time Per Day using a REST API
We’ve added a new Dock to Stock Per Day API that provides valuable insights into your shipment processes. With this API, you can now easily monitor and optimize the time it takes for your shipments to go from the receiving dock to the stock location.
Our API will generate a report on the dock-to-stock time for shipments received and put away in the past seven days. The report provides you a daily average, offering a general overview and valuable insights into your operations.
Dock to Stock Per Day
Here's how it works:
- Complete Shipment Data: The API considers only Inter-Branch (IB) shipments that have been fully received and put away. This includes shipments where all lpns have a 'first putaway timestamp'.
- Consistency in Metrics: Even if lpns are consumed, cancelled, or modified after being put away, they are still included in the metrics for their original shipments.
- Exclusions: Shipments with lpns that will never be put away due to flow-through operations (cross-dock, distribution, direct allocation) are excluded from this metric.
- Handling Rare Scenarios: In rare cases where shipment details are received into an LPN from a different shipment, the LPN and its putaway calculation will be included only in the metrics for the shipment it was first received from.
API URL:
GET /report/dock_to_stock_per_day/
AVAILABLE FILTERS FOR THIS REQUEST:
| Name | Required | Type | Description |
|---|---|---|---|
|
company_id |
C |
String |
Company ID |
|
facility_id |
C |
String |
Facility ID |
|
company_id__code |
C |
String |
Company Code |
|
facility_id__code |
C |
String |
Facility Code |
Steps to Enable
Review the REST service definition in the REST API guides to leverage (available from the Oracle Help Center > your apps service area of interest > APIs & Schema). If you are new to Oracle's REST services you may want to begin with the Quick Start section.