Cloud Readiness / Oracle Warehouse Management Cloud
What's New
Expand All


  1. Update 20D
  1. Revision History
  2. Overview
  3. Feature Summary
    1. Functional Enhancements
        1. Drive Putaway Rules to Search for Locations with Same Item
        2. Support Overshipment and Undershipment Tolerances with Back Ordering
        3. Enhanced Purchase Order Based Receiving
        4. Scheduled Job to Verify Shipment
        5. Allow Receiving of QC Rejected LPNs and Return to Vendor
        6. New Parameter for Non-Multi-Field Barcodes
        7. Enhanced Configurability on Post-Pick Order Consolidation and Loading
        8. New Facility Parameter to Associate Blind ASNs
        9. Support for Legacy Company Parameter LEGACY_ACTUAL_WEIGHT_OVERRIDES_WT_VOL_CALC_IN_SHIPPING
        10. Backorder Processing Handling in WMS
        11. Allocation in Terms of Packs or Cases from Active Locations
    2. User Experience and Usability Enhancements
        1. Call Putaway from Receiving
        2. Enhancements to Single Item LPN Receipt
        3. Alert User During LPN Substitution
        4. Additional Filter Criteria on the User Interface
        5. Default Redwood Theme for WMS Application Pages and Mobile App
        6. Link to WMS Cloud Application Pages Using Deep Links
    3. Integration Enhancements
        1. WMS Cloud Lock Code to ERP Inventory Summary Alignment
        2. GET Available Warehouse Location for Putaway Using a REST API
        3. Additional Categories in Web Reports Gen 2
        4. Web Reports Optimization for Date/Time Functions
        5. Support ISO-8601 Format Date/Time Values
        6. Update Active Inventory for Serialized Product Using a REST API
        7. Update Location Counted to Be Counted Flag Using a REST API
        8. Locate LPN or Pallet to Location Using a REST API
        9. Update Orders with Ship Via and Shipment Number Using a REST API
        10. Expand Custom Fields in Inbound Shipment Interface and Inbound Shipment Verification Output
    4. Updates to WMS Cloud to SCM Cloud Integrator
        1. Support for WMS Cloud Lock Code to ERP Inventory Summary Bucket Alignment on Purchase Order Receipt Confirmation and Inventory Transactions
        2. Support Shipping Tolerances for Sales Orders
        3. Communicate Backordering for Sales Orders
        4. Provide Transaction Reference on Purchase Order Receipt Confirmation, Inventory Transactions, and Sales Order Shipment Confirmation
        5. Integration Properties Support in SCM Cloud Integrator

Update 20D

Revision History

This document will continue to evolve as existing sections change and new information is added. All updates appear in the following table:

Date Product Feature Notes
06 JUL 2021 Functional Enhancements Allow Receiving of QC Rejected LPNs and Return to Vendor Updated document. Revised feature information.
27 JAN 2021 Functional Enhancements Allow Receiving of QC Rejected LPNs and Return to Vendor Updated document. Revised feature information.
21 DEC 2020 Functional Enhancements WMS Cloud Lock Code to ERP Inventory Summary Alignment Updated document. Revised feature information.
11 DEC 2020 Functional Enhancements Allocation in terms of Packs or Cases from Active Location Updated document. Delivered feature in update 20D.
11 DEC 2020

Integration Enhancements

Backorder Processing Handling in WMS Updated document. Delivered feature in update 20D.
11 DEC 2020 Functional Enhancements Support for Legacy Company Parameter LEGACY_ACTUAL_WEIGHT_OVERRIDES_WT_VOL_CALC_IN_SHIPPING Updated document. Delivered feature in update 20D.
11 DEC 2020

Updates to WMS Cloud to SCM Cloud Integrator

Communicate Backordering for Sales Orders Updated document. Delivered feature in update 20D.
11 DEC 2020

Updates to WMS Cloud to SCM Cloud Integrator

Support Shipping Tolerances for Sales Orders Updated document. Delivered feature in update 20D.
11 DEC 2020

Updates to WMS Cloud to SCM Cloud Integrator

Support for WMS Cloud Lock Code to ERP Inventory Summary Bucket Alignment on Purchase Order Receipt Confirmation and Inventory Transactions Updated document. Delivered feature in update 20D.
11 DEC 2020 User Experience and Usability Enhancements Link to WMS Cloud Application Pages Using Deep Links Updated document. Revised feature information.
11 DEC 2020

Updates to WMS Cloud to SCM Cloud Integrator

Integration Properties Support in SCM Cloud Integrator Updated document. Delivered feature in update 20D.
11 DEC 2020

Updates to WMS Cloud to SCM Cloud Integrator

Provide Transaction Reference on Purchase Order Receipt Confirmation, Inventory Transactions, and Sales Order Shipment Confirmation Updated document. Delivered feature in update 20D.
11 DEC 2020 Functional Enhancements Allow Receiving of QC Rejected LPNs and Return to Vendor Updated document. Revised feature information.
11 DEC 2020

Integration Enhancements

Web Reports Optimization for Date/Time Functions Updated document. Delivered feature in update 20D.
11 DEC 2020 Functional Enhancements Enhanced Purchase Order Based Receiving Updated document. Revised feature information.
11 DEC 2020 Integration Enhancements Update Orders with Ship Via and Shipment Number using a REST API Updated document. Delivered feature in update 20D.
11 DEC 2020 Integration Enhancements Additional Categories in Web Reports Gen 2 Updated document. Delivered feature in update 20D.
11 DEC 2020 Integration Enhancements WMS Cloud Lock Code to ERP Inventory Summary Alignment Updated document. Revised feature information.
09 OCT 2020     Created initial document.

Overview

This guide outlines the information you need to know about new or improved functionality in this update, and describes any tasks you might need to perform for the update. Each section includes a brief description of the feature, the steps you need to take to enable or begin using the feature, any tips or considerations that you should keep in mind, and the resources available to help you.

Give Us Feedback

We welcome your comments and suggestions to improve the content. Please send us your feedback at owms-cloud-comms_us@oracle.com.

Feature Summary

Column Definitions:

Features Delivered Enabled

Report = New or modified, Oracle-delivered, ready to run reports.

UI or Process-Based: Small Scale = These UI or process-based features are typically comprised of minor field, validation, or program changes. Therefore, the potential impact to users is minimal.

UI or Process-Based: Larger Scale* = These UI or process-based features have more complex designs. Therefore, the potential impact to users is higher.

Features Delivered Disabled = Action is needed BEFORE these features can be used by END USERS. These features are delivered disabled and you choose if and when to enable them. For example, a) new or expanded BI subject areas need to first be incorporated into reports, b) Integration is required to utilize new web services, or c) features must be assigned to user roles before they can be accessed.

Ready for Use by End Users
(Features Delivered Enabled)

Reports plus Small Scale UI or Process-Based new features will have minimal user impact after an update. Therefore, customer acceptance testing should focus on the Larger Scale UI or Process-Based* new features.

Action is Needed BEFORE Use by End Users
(Features Delivered Disabled)

Not disruptive as action is required to make these features ready to use. As you selectively choose to leverage, you set your test and roll out timing.

Feature

Report

UI or
Process-Based:
Small Scale

UI or
Process-Based:
Larger Scale*

Functional Enhancements

Drive Putaway Rules to Search for Locations with Same Item

Support Overshipment and Undershipment Tolerances with Back Ordering

Enhanced Purchase Order Based Receiving

Scheduled Job to Verify Shipment

Allow Receiving of QC Rejected LPNs and Return to Vendor

New Parameter for Non-Multi-Field Barcodes

Enhanced Configurability on Post-Pick Order Consolidation and Loading

New Facility Parameter to Associate Blind ASNs

Support for Legacy Company Parameter LEGACY_ACTUAL_WEIGHT_OVERRIDES_WT_VOL_CALC_IN_SHIPPING

Backorder Processing Handling in WMS

Allocation in Terms of Packs or Cases from Active Locations

User Experience and Usability Enhancements

Call Putaway from Receiving

Enhancements to Single Item LPN Receipt

Alert User During LPN Substitution

Additional Filter Criteria on the User Interface

Default Redwood Theme for WMS Application Pages and Mobile App

Link to WMS Cloud Application Pages Using Deep Links

Integration Enhancements

WMS Cloud Lock Code to ERP Inventory Summary Alignment

GET Available Warehouse Location for Putaway Using a REST API

Additional Categories in Web Reports Gen 2

Web Reports Optimization for Date/Time Functions

Support ISO-8601 Format Date/Time Values

Update Active Inventory for Serialized Product Using a REST API

Update Location Counted to Be Counted Flag Using a REST API

Locate LPN or Pallet to Location Using a REST API

Update Orders with Ship Via and Shipment Number Using a REST API

Expand Custom Fields in Inbound Shipment Interface and Inbound Shipment Verification Output

Updates to WMS Cloud to SCM Cloud Integrator

Support for WMS Cloud Lock Code to ERP Inventory Summary Bucket Alignment on Purchase Order Receipt Confirmation and Inventory Transactions

Support Shipping Tolerances for Sales Orders

Communicate Backordering for Sales Orders

Provide Transaction Reference on Purchase Order Receipt Confirmation, Inventory Transactions, and Sales Order Shipment Confirmation

Integration Properties Support in SCM Cloud Integrator

Functional Enhancements

Drive Putaway Rules to Search for Locations with Same Item

In 20D, a new flag “Search Location with matching SKU” is available in the Putaway Priority View UI. After you enable this flag on putaway method priority, the system directs you to the location that already has a matching SKU required to be putaway. This new mechanism helps to optimize the location with identical SKU’s instead of having the same SKU spread across the different locations. This also helps to achieve a smooth picking transaction and thereby reduces accessing any further location.

Let's say, you have an IBLPN with a single SKU or pallets having IBLPN single SKU during directed putaway, all the eligible locations (satisfying capacity check), and putaway method priority. The system now further narrows down and prompts the location that already has the SKU (Physical Inventory not In-transit) similar to the SKU targeted for putaway.

ADDITIONAL KEY POINTS:

  • By default, this new flag is disabled on the Putaway Method Priority UI. Users need to check the flag explicitly to enable.
  • This function is applicable to both Active & Reserve Locations.
  • This new flag honors during Split Putaway to Active Location and Putaway Method  Location Sequence/ Radial.
  • On scanning an LPN, if there are multiple locations that have matching SKUs, then the system will apply putaway search mode to the eligible location (i.e locations that have matching SKUs).

NOTE: After scanning an IBLPN with multiple SKUs or pallets having an IB container containing multiple SKU, the system does not consider the Matching SKU criteria even though the flag on the Putaway method priority is enabled. If there are no locations with matching SKUs for the given putaway method priority, then the system will prompt location based on the putaway search mode from the respective putaway method priority.

Steps to Enable

  1. Go to PutawayPriorityView UI
  2. Click Create to create or Select the Putaway Type > Click edit icon.
  3. Check or un-check the Search Location with matching SKU checkbox to enable or disable the functionality.
  4. Click Save.  

Key Resources

Support Overshipment and Undershipment Tolerances with Back Ordering

INTRODUCING SHIPPING TOLERANCE PERCENTAGE IN THE ORDER DETAIL UI AND INTERFACE

Previously, the system did not allow packing of more than the ordered quantity.  Also, warehouses deal with a variety of items (such as produce or wires for example) where shipping an exact quantity or weight might not always be practical. To give users more flexibility in shipping item quantities, Shipping tolerance percentage is now available in Oracle WMS Cloud in 20D. You can now view and edit Shipping Tolerance Fields in the Order Header / Order Detail screen. You can also view Shipping Tolerance Fields in the Manual Wave and Order Detail screens.

You can also create/modify Shipping Tolerance Fields via:

  • the Order Input Interface (through ORR, OHD, or ORD)
  • the Order API

NOTE: The system will not allow tolerance% equal to 100% or more than 100% for the Minimum Shipping Tolerance% field.

WAVE ALLOCATION

In Order Type, if Partial allocated is enabled, the system will partially allocate the order. If the quantity allocated is within the tolerance threshold in the quantity to be allocated in the Order Detail, the order detail will be in a status of Allocated.

NOTE: During a wave, when the "Cancel Partially Unallocated" flag is enabled the system will not cancel the unallocated quantity from the order detail if the allocated quantity on the order detail is greater than or equal to minimum shipping tolerance% threshold value.

If allocated quantity is less than the minimum tolerance %, the order detail status will be partially allocated.

Order Order Quantity Min % Max % Allocated Quantity Order Detail Status
 Order1 - Dtl1  100  10  10  92  Allocated
 Order2 - Dtl1  100  10  10  80  Partly Allocated

NOTE: Even though the max tolerance% is defined, the system will never over allocate during allocation from the wave.

HONORING TOLERANCE PERCENTAGE WHILE PACKING AGAINST ALLOCATED QUANTITY

In the following transactions, the system now allows you to pick more than the allocated quantity, when the respective allocated order is defined with a maximum shipping tolerance percentage as greater than zero. Oracle WMS Cloud also updates the respective order detail status based on the inventory picked honoring the shipping tolerance percentage.

  • RF Pack NC Active Order
  • Pick {iblpn}
  • Pick Cart
  • Pick Confirm API
  • Distribute OBLPN for Allocation mode "Distribution residuals OK"

NOTE: When distribution mode is Distribution residuals OK, LPNs allocated by the system may have more inventory than the allocated quantity. In this mode, you can pickup extra inventory available to over pack within the tolerance%.

You can now pick excess quantity against the allocated quantity and tolerance% is considered with respect to the allocated quantity:

Example 1:  Let's say you have an order with 100 units with a max% of 10. If there are 2 allocations of 50 and 50, you can pick a max of 55 (subject to inventory availability) against each allocation.

While picking against allocated quantity if you pick in a single instance, then the overall max quantity that can be packed against an order detail may vary.

Example 2:  Let's say you have an order with 100 units with max% of 10. If there is one allocation of 100 units against the order, you can pick up to 110 (subject to inventory availability) if the picking is done in a single instance.

But if you pick 60 in the fist instance, then the system asks you to pack the remaining 40. You can pick up to a max of 44 (subject to inventory availability.) In this case, the total packed quantity against the order detail will be 104.

ALLOW OVER PACKING   

Oracle WMS Cloud now allows over packing based on the maximum shipping tolerance defined on the order detail during picking using the MHE API.

  • When the maximum tolerance on the order detail is defined with greater than a zero value, then during MHE picking, the system calculates the maximum quantity that can be picked against the order detail by applying the maximum tolerance % on the allocated quantity against the respective allocation detail. 
  • When the maximum tolerance on the order detail is not defined or zero, then the system doesn’t allow over packing of inventory. Upon over packing, the error message "Only (Available Quantity) units available for packing" displays.

NOTE: Over Packing is allowed only when respective inventory is available (not allocated to any order) in the source location.

HONORING TOLERANCE PERCENTAGE DURING SUBSTITUTION

During the following RF Pack {oblpn}, the system now allows you to substitute inventory within the min/max threshold percentage, as long as the substituted LPN is allocated for an order that the original LPN can fulfill.

Example 1:

The Location has 2 LPNs:

LPN LPN Quantity LPN Status Order Allocated
 LPN1  100  Allocated  order 1
 LPN2  90  Allocated   -

User substitutes LPN1 with LPN2. Because LPN2 meets the tolerance limit and it is not allocated to an order, the user can substitute.

Order Order Quantity Min % Max %
 order 1  100  10  10

Example 2:

The Location has 2 LPNs:

LPN LPN Quantity LPN Status Order Allocated
 LPN1  100  Allocated  order 1
 LPN2  90  Allocated  order 2
Order Order Quantity Min % Max %
 order 1  100  10  10
 order 2  100  10  10

The Location has 2 LPNs: User substitutes LPN1 with LPN2. Because LPN2 meets the tolerance limit for order 1 and LPN1 meets the tolerance limit for order 2, the allocation can be exchanged and the user is allowed to substitute.

Example 3:

LPN LPN Quantity LPN Status Order Allocated
 LPN1  100  Allocated  order 1
 LPN2  90  Allocated  order 2
Order Order Quantity Min % Max %
 order 1  100  10  10
 order 2  90  10  10

User tries to substitute LPN1 with LPN2.  Even thought LPN 2 is within the percentage tolerance for Order 1, LPN 1 is NOT with in the percentage tolerance for order 2. Therefore, Substitution is not allowed. 

DIRECT ALLOCATION WHEN LPN QUANTITY IS WITHIN THE SHIPPING TOLERANCE LIMIT OF THE ORDERED QUANTITY

Users can now allocate LPNs with a higher quantity than the ordered quantity. Also, allocating LPNs with a quantity within the shipping tolerance limit of the ordered quantity will mark the order detail as Allocated.

The following table is an example of the resulting Order Detail and LPN status during RF Direct Allocation based on the minimum and maximum shipping tolerance set:

Ordered Qty LPN Qty Min ToI % Max ToI % Rem Ord Qty Order Detail Status LPN Status

100

80

10

10

20

Partly Allocated

Consumed

100

90

10

10

10

Allocated

Consumed

100

90

0

10

10

Partly Allocated

Consumed

100

110

0

10

0

Allocated

Consumed

100

110

10

0

0

Allocated

Consumed

100

111

10

10

100

Error message- system should restrict

Received

PICK AND ALLOCATE WITH RESPECT TO THE SHIPPING TOLERANCE LIMIT

Users can now over pick quantity greater than the ordered quantity within the shipping tolerance limit applied. During Pick and Allocate, when LPNs with a higher quantity than the ordered quantity are packed based on the shipping tolerance%, the original allocated quantity will not be more than the original order quantity on the allocation record.

The following table is an example of the resulting Order Detail and Order Header status during RF Pick and Allocate based on the minimum and maximum shipping tolerance set:

Ordered QTY Allocated QTY Packed Qty Min ToI % Max ToI % Mode Ord Detail Status Ord Header Status

100

100

50

10

10

System Directed

Allocated

In Packing

100

100

90

10

10

System Directed

Allocated

Packed

100

100

110

10

10

System Directed

Allocated

Packed

100

50

50

10

10

User Directed

Created

Partly Allocated

100

90

90

10

0

User Directed

Allocated

Packed

100

90

90

0

10

User Directed

Created

Partly Allocated

100

110

100

0

10

User Directed

Allocated

Packed

COMPUTE ORDER DETAIL STATUS BY HONORING SHIPPING TOLERANCE PERCENTAGE ON THE ORDER

Previously, Oracle WMS Cloud computed Order Detail status based on the ordered, allocated and packed quantity for each order detail under it. With the introduction of shipping tolerance, the order detail status might get changed even if the allocated/packed quantity is more or less than the ordered detail quantity but within the tolerance. Now, the system computes the Order Detail status by honoring the shipping tolerance percentage defined on the respective order.

The following listed statuses are supported for order detail based on shipping tolerance percentages:

Order Detail Status Order Detail Data Condition

Created

Allocated Quantity = 0

Partly Allocated

Allocated Quantity > 0 Allocated Quantity < Minimum Shipping Tolerance% threshold value

Allocated

Allocated Quantity >= Minimum Shipping Tolerance% threshold value

In Picking

Allocated Quantity >= Minimum Shipping Tolerance% threshold value and order detail has container which is in "In Picking" status

Picked

Packed Quantity >= Minimum Shipping Tolerance% threshold value && If Any associated container status is Picked && there should not be any pending allocation against the order detail

In Packing

Allocated Quantity >= Minimum Shipping Tolerance% threshold value & order detail has container which is in "In Packing" status

Packed

Packed Quantity >= Minimum Shipping Tolerance% threshold value && If all the associated container status are packed && there should not be any pending allocation against the order detail

Loaded

Loaded quantity against the order detail is > = Minimum Shipping Tolerance% threshold value && there should not be any pending inventory against the order detail 

Shipped

Shipped quantity  against the order detail is > = Minimum Shipping Tolerance% threshold value && there should not be any pending inventory  against the order detail

CHANGES IN THE SHIPPED LOAD INTERFACE

Oracle WMS Cloud can now derive order detail status whenever the order detail is shipped.  Order Quantity Consume is meant to be used by integration to consume quantity against the shipped quantity.The ability to derive the status on the order detail will help the end user to know about order status, so that user can plan further activity during shipping and manifest.

After loading all of an order’s packed OBLPNs, the user will perform shipping. If the shipped quantity is within the maximum/minimum shipping tolerance percentage defined on the order detail and the order detail doesn't have any pending allocation/picks, then the order detail status will be derived as "Shipped".

  • Order detail status is shipped when shipping is performed via the RF or UI Ship Load transaction.
  • Order header status is marked as shipped when all the order details against the order are shipped.

When inventory is shipped against the order detail, the order detail will be updated with:

  • Shipped Quantity: Total inventory shipped against the order detail.
  • Order Quantity to consume: Total order quantity to consume sent against the order detail.

NOTE: During Ship Load, the system generates the Outbound Load Export (SLS) file which has  information associated with the order detail including:

  • Maximum Shipping Tolerance%
  • Minimum Shipping Tolerance%
  • Order Quantity to Consume

DETERMINE BACK ORDER QUANTITY AS ORDER DETAILS ARE SHIPPED/CANCELLED

In the warehouse when orders are received, the warehouse tries to fulfill the order up to the ordered quantity. But sometimes, due to the unavailability of inventory, orders cannot be fulfilled completely. To handle these scenarios, Oracle WMS Cloud communicates to the host system how much quantity was not fulfilled, and based on that information, the host system creates back orders for further processing.

The system will now determine the Back Order quantity when an order detail is Shipped. It will then populate the back order quantity on the reference field for Order Detail Status change Inventory History Transaction (IHT) (ref value 4.)

When the system cancels the Order Detail, Back Order Quantity against the Order detail is now computed and displays in the Ref Code 4 (Back Order Quantity) of the Order Detail Status change Inventory History Transaction (IHT- 85). When order detail is cancelled, Back Order Quantity will be equal to the Original Order Quantity.

The following are the some of trigger points associated when the order detail is cancelled:

  • Wave (when Cancel Fully Unallocated flag is enabled)
  • IB Shipment UI ("Unallocated order details to cancel on ASN verify" mode on the IB Shipment Type)
  • Interface
  • Order Interface

The following RF Transactions are triggered (when allocated inventory against the order detail is shorted and the Only deallocate on short flag is disabled on the Order Type)

  •  RF Pack NC Active Order
  •  Modify Cancel {oblpn}
  •  Pick {iblpn}
  •  Distribute {oblpn}
  •  Pack {oblpn}
  •  Pick Cart
  •  Outbound Audit
  •  Repack OBLPN
  •  RF Move LPN

The following APIs are triggered (when allocated inventory against the order detail is shorted and the Deallocate on Short flag is disabled on the Order Type)

  • Pick_Confirm API
  • Legacy Pick_Confirm API 

PROCESSING BACK ORDER IN ORACLE WMS CLOUD

When an order is not fulfilled, the Oracle Inventory Fusion Management Cloud sends the backorder back with the same order number to Oracle WMS Cloud. To address this instance, the Oracle WMS Cloud is enhanced to suffix the original order number in the order interface. This suffixed order number interface payload is processed to the external system. However, when the Oracle Inventory Fusion Management Cloud system downloads the payload, the generated payload will carry the original order number WITHOUT the suffix. 

The system calculates the back order quantity against each order detail only when the respective order's order type has the Require Back Order flag set to true in conjunction with Deallocate on Short flag set to false on the Order Type UI.

NOTE: Adding a suffix for an order number is applicable for Oracle Inventory Fusion Management Cloud only. Other ERP systems are recommended to send a new order number to process the backorder and avoid sending the same order numbers. For more information, refer to the Back Order Processing Handling feature.

Steps to Enable

In order for the system to derive back order quantity, you must enable the Require Back Order flag from the Order Type UI.

Key Resources

Enhanced Purchase Order Based Receiving

PURCHASE ORDER AND PO SEQUENCE PROMPT

Prior to 20D, Purchase Order (PO)-based receiving updates were happening for a single detail even if a PO had multiple details, leading to reconciliation issues. In order to support reconciliation of Purchase Order (PO) lines under receipt, a new RF Parameter (prompt_po-seq-line) is now available in RF Receive (LPN) Shipment (rf.inbound.cwrfrecvlpnshpmt)  and RF Receive Load (rf.inbound.cwrfrecvlpnload) modules which supports prompting for the PO sequence number or the PO line schedule number based on the configuration.

PARAMETER DETAILS

The prompt_po-seq-line parameter has the following options under the drop-down:

  • PO Sequence
  • PO line schedule

NOTE: The default value of the prompt_po-seq-line parameter is Blank. When the parameter is set to Blank, the system exhibits the existing behavior and should not prompt for the PO sequence or line schedule number.

Companies using Oracle WMS Cloud together with Oracle SCM Cloud should set the parameter "prompt_po-seq-link" screen parameter to be "PO Line Schedule."

This parameter can be used in the following flows:

  • PO Based Receiving
  • RF Receiving Flow
  • RF Receive by Load

The following table provides details about the parameter behavior for these flows when the prompt_po-seq-line parameter is set to PO Sequence or PO line schedule:

Flow prompt_po-seq-line set to: Purchase Order (PO) Sequence prompt_po-seq-line set to: Purchase Order (PO) Line Schedule

PO Based Receiving

  • If a PO has multiple details with the same SKU, the system prompts for the PO sequence list.
  • If a PO only has a single detail for a SKU, (if there is no conflict), the system will not prompt for the PO sequence number.
  • for an Attribute tracked item, if the item level configuration is set to Required, validate, Allow user override the system prompts for the attribute even if the the system can determine the attribute from the PO sequence PO line schedule scan.
  • For an attribute tracked Item, if the Attribute prompt is set to Required, validate, Allow user override and the PO detail is already populated with an Attribute value, the system throws the following error message upon overriding the defaulted attribute during PO based receiving:  "Scanned Attribute is not valid for the PO detail."
  • In case a user receives more quantity than the order quantity for a PO sequence number, the system prompts for the following warning message: "QTY received is more the anticipated PO detail qty, proceed?"
  • If a PO has multiple details with the same SKU, the system prompts for the PO line schedule list.
  • If the line schedule number is not populated on the PO, then the system should prompt for PO sequence number even if the prompt_po-seq-line set to PO line schedule.
  • If a PO only has a single detail for a SKU, (if there is no conflict), the system will not prompt for the PO line schedule number.
  • for an Attribute tracked item, if the item level configuration is set to Required, validate, Allow user override the system prompts for the attribute even if the the system can determine the attribute from the PO sequence PO line schedule scan.
  • For an attribute tracked Item if the Attribute prompt is set to Required, validate, Allow user override and the PO detail is already populated with an Attribute value, the system throws the following error message upon overriding the defaulted attribute during PO based receiving: "Scanned Attribute is not valid for the PO detail."
  • In case a user receives more quantity than the order quantity for a PO line schedule number, the system prompts for the following warning message: "QTY received is more the anticipated PO detail qty, proceed?"

RF Receive Shipment

  • If there is only one detail/SKU for a PO or if the system can determine the PO sequence from the remaining PO details. the Purchase Order sequence list during RF IB shipment receiving does NOT appear.
  • The Purchase Order sequence list during RF IB shipment receiving appears if an IB shipment details has multiple PO numbers or PO -sequence combinations for the same SKU.
  • After selecting the PO number, if the selected PO has multiple lines for the same SKU, the system prompts for another pop up displaying the PO sequence numbers. 
  • After scanning a SKU if multiple purchase orders are found, the system prompts for the purchase order list for the SKU.
  • After selecting the PO number, if the selected PO has multiple lines for the same SKU, the system prompts for another pop up displaying the PO sequence numbers.
  • For an Attribute tracked item, if the item level configuration is set to Required, validate, Allow user override the system prompts for the attribute even if the system can determine the attribute from the PO sequence scan.
  • For an attribute tracked Item, if the Attribute prompt is set to Required, validate, Allow user override and the PO detail is already populated with an Attribute value, the system throws the following error message upon overriding the defaulted attribute during PO based receiving: "Scanned Attribute is not valid for the PO detail."
  • This error message should not appear when prompt-po-seq-line is not configured. In that case, users can scan an unanticipated attribute. A new shipment detail will be created with 0 shipped qty without the PO number populated.
  • If a user receives more quantity than the order quantity for a PO sequence number, the system prompts for the following warning message: "QTY received is more the anticipated PO detail qty, proceed?"
  • If there is only one detail/SKU for a PO or if the system can determine the PO line schedule from the PO details, the Purchase Order line schedule number list during RF IB shipment receiving does NOT appear.
  • The Purchase Order line schedule number list during RF IB shipment receiving appears if an IB shipment detail has multiple PO numbers or Purchase Order line schedule number combinations for the same SKU.
  • After scanning a SKU if multiple purchase orders are found the system prompts for the purchase order list for the SKU.
  • After selecting the PO number, if the selected PO has multiple lines for the same SKU, the system prompts for another pop up displaying the PO line schedule numbers.
  • If the line schedule number is not populated on the PO, then the system should prompt for PO sequence number even if the prompt_po-seq-line set to PO line schedule.
  • For an Attribute tracked item, if the item level configuration is set to Required, validate, Allow user override the system prompts for the attribute even if the the system can determine the attribute from the PO line schedule scan.
  • For an attribute tracked Item if the Attribute prompt is set to Required, validate, Allow user override and the PO detail is already populated with an Attribute value, the system throws the following error message upon overriding the defaulted attribute during PO based receiving: "Scanned Attribute is not valid for the PO detail."
  • This error message should not appear when prompt-po-seq-line is not configured. In that case, users can scan an unanticipated attribute. A new shipment detail will be created with 0 shipped qty without the PO number populated.
  • If a user receives more quantity than the order quantity for a PO line schedule number, the system prompts for the following warning message: "QTY received is more the anticipated PO detail qty, proceed?"

RF Receive by Load

  • System prompts for the PO number and the sequence list after scanning the SKU in case the PO has multiple details for the same SKU or the IB Shipment has multiple POs for the same SKU.
  • User is prompted for the PO number as a list right after the SKU scan (showing all the eligible PO number-PO sequence number for the scanned SKU that the user can receive for the IB Shipment) .
  • After selecting the PO number, if the selected PO has multiple lines for the same SKU, the system prompts for another pop up displaying the PO sequence numbers. 
  • In case an IB Shipment has only one detail, or if the IB shipment has multiple details carrying different PO for different SKUs, the system doesn’t prompt for the PO number list because the system can identify the sequence number to be received.
  • For an attribute tracked Item if the Attribute prompt is set to Required, validate, Allow user override and the PO detail is already populated with an Attribute value, the system throws the following error message upon overriding the defaulted attribute during PO based receiving: "Scanned Attribute is not valid for the PO detail."
  • This error message should not appear when prompt-po-seq-line is not configured. In that case, users can scan an unanticipated attribute. A new shipment detail will be created with 0 shipped qty without the PO number populated.
  • In case, a user receives more quantity than the order quantity for a PO sequence number, the system prompts for the following warning message:  "QTY received is more the anticipated PO detail qty, proceed?"
  • System prompts for the PO number and the Line schedule list after scanning the SKU in case the PO has multiple details for the same SKU or the IB Shipment has multiple POs for the same SKU.
  • User is prompted for the PO number as a list right after the SKU scan (showing all the eligible PO number for the scanned SKU that the user can receive for the IB Shipment) .
  • After selecting the PO number, if the selected PO has multiple lines for the same SKU, the system prompts for another pop up displaying the PO line schedule numbers.
  • In case an IB Shipment has only one detail, or if the IB shipment has multiple details carrying different PO for different SKUs, the system doesn’t prompt for the PO line schedule number list because the system can identify the line schedule number to be received.
  • For an attribute tracked Item if the Attribute prompt is set to Required, validate, allow user override and the PO detail is already populated with an Attribute value, the system throws the following error message upon overriding the defaulted attribute during PO based receiving: "Scanned Attribute is not valid for the PO detail."
  • This error message should not appear when prompt-po-seq-line is not configured. In that case, users can scan an unanticipated attribute. A new shipment detail will be created with 0 shipped qty without the PO number populated.
  • In case, a user receives more quantity than the order quantity for a PO sequence number, the system prompts for the following warning message: "QTY received is more the anticipated PO detail qty, proceed?"
  • If any of the PO line schedule number is not populated on the PO details. the system prompts for the PO sequence number. However, the PO sequence number is prompted only if the scanned PO has multiple details with the same SKU on the IB shipment.

QUANTITY DISTRIBUTION FOR PO AND SHIPMENT BASED RECIPT 

Prior to 20D, if a purchase order had multiple lines for the same SKU, Purchase Order (PO)-based receiving updates were happening for a single detail even if a PO had multiple details, leading to reconciliation issues. Oracle WMS Cloud has been updated so that when the prompt_po-seq-line screen parameter is set to blank, the system evenly distributes the received SKU quantity across multiple Purchase Orders or purchase order lines, which resolves purchase order line reconciliation issues. Quantity distribution is only supported for IB shipments details carrying multiple purchase orders for the same SKU or a purchase order with multiple lines for the same SKU.

The following table provides details about the system behavior for these flows when the prompt_po-seq-line parameter is set to blank:

Flow Behavior

PO Based Receiving

  • When set to blank and the Purchase Order has a tolerance, the excess quantity is latched to the first detail after the quantity distribution happens evenly across the PO line numbers.  
  • If the PO does NOT have tolerance defined, the system should evenly distribute the quantity across the IB shipment details for the respective PO and PO line numbers.
  • If a PO has multiple lines with an attribute tracking SKU, the system will not distribute the qty across the PO line evenly if the PO lines are populated with different Attributes.

RF Receive Shipment

(Shipment is carrying multiple PO numbers or PO details of the same SKU)

  • When set to blank and the Shipment has a tolerance, the excess quantity is latched to the first detail after the quantity distribution happens evenly across the IB shipment details for the respective PO and PO line numbers.
  • If a shipment is carrying multiple Purchase Orders of the same SKU and the tolerance percentage is at the PO or both at shipment and PO, the system evenly distributes the quantity across the POs and the excess qty for the tolerance percentage will be carried forward to the next eligible PO after the tolerance limit of the first PO is exhausted.
  • If the shipment does NOT have tolerance defined, the system should evenly distribute the quantity across the IB shipment details for the respective PO and PO line numbers for the same SKU.

RF Receive Load

(Shipment is carrying multiple PO numbers or PO details of the same SKU)

  • When set to blank, and users try to receive an IB shipment with multiple details for the same SKU converted from a PO, the system should evenly distribute the SKU quantity across the IB shipment details for the respective PO and PO line numbers.
  • If the PO/IB shipment does NOT have tolerance defined for the SKU, the system evenly distributes the quantity across the details carrying multiple PO numbers or PO details for the same SKU.
  • If a shipment is carrying multiple POs of the same SKU and the tolerance percentage is at the PO or both at shipment and PO, the system evenly distributes the quantity across the POs and the excess qty for the tolerance percentage will be carried forward to the next eligible PO after the tolerance limit of the first PO is exhausted.

PREVENT CONSUMING ENTIRE PURCHASE ORDER DURING PO-BASED RECEIVING

Prior to 20D, during PO based receiving the entire PO was getting converted to a shipment right after scanning the PO number. As a result, the host system could not reduce the purchase order quantity or delete a PO line (a shipment against the purchase order quantity was already being created.) A new screen parameter prevent-entire-po-to-asn-conversion-flg, in the RF Receive Shipment (rf.inbound.cwrfrecvlpnshpmt) module allows you to restrict the system from converting the entire PO to a shipment right after the PO scan during PO based receiving. The screen parameter receiving mode should be set to PO based receiving.

PARAMETER DETAILS

The prevent-entire-po-to-asn-conversion-flg parameter has the following options under the drop-down:

  • No (default behavior)
  • Yes

When the prevent-entire-po-to-asn-conversion-flg is set to Blank or No,

  • The system converts the entire PO to an ASN during PO based receiving. However, the system converts the entire PO to an ASN only after you scan or skip the trailer scan during PO based receiving.
  • In case multiple shipments are created prior to PO based receiving, the system will throw the following error message right after the PO scan.

“Cannot receive PO linked to Multiple ASNs”

  • Vendor QC will be supported for this mode and the quality check will happen based on the shipped quantity and the vendor QC configuration.
  • Users will not be able to reduce the purchase order quantity once the entire PO is converted to a shipment during PO based receiving.

When the prevent-entire-po-to-asn-conversion-flg is set to Yes:

During PO Based Receiving, the system can now create the ASN details based on the PO quantity a user is receiving from PO-based receiving mode, so that the whole PO does not get converted to an ASN and its respective details. This allows purchase orders that have been partially received to be updated. For example, supply chain planning may send a recommended change for a purchase order when the supplier was not able to ship the full expected quantity.

NOTE: The purchase order quantity can’t be updated for less than the received quantity.

  • The system now prevents consuming the entire PO to the respective IB shipment details when you scan a PO in PO-based receiving mode. After scanning the PO number, the system creates only the IB shipment header based on the PO and the trailer number combination (if no IB shipment with status less than Verification in progress is found for the same PO and trailer number combination.)
  • After you scan the trailer number, if no open ASN is found, then the system creates a new ASN associating the trailer number to proceed with PO based receiving. The ASN header won't be created until you scan or skip the trailer number.  
  • You can press the Ctrl-E hot key to end receiving on the PO based receiving transaction and the shipment details created will have 0 as the shipped quantity if no prior shipment is created for the PO from the UI or the interface.
  • Vendor QC is not supported in this mode of PO based receiving as the shipped quantity for the shipments created during this mode of PO based receiving will be 0.
  • The shipment verification files generated upon ASN verification of the ASNs created during PO-based receiving will also have a shipped quantity as 0.
  • The system will create a new trailer number record if you scan a trailer number which is not present in the system and the system latches the trailer number to a Shipment with ‘In transit’ status and which does not have a trailer number populated. If no eligible shipment is found for the PO trailer combination, the system then creates a new Shipment with the PO trailer combination.
  • Users can receive the remaining PO order in different trailers. The system creates a new Shipment with 0 as shipped quantity with the PO and trailer combination and allow users to receive the outstanding PO quantity against the shipment.
  • In case the system finds multiple shipments created prior to PO based receiving, and if it cannot identify the shipment even after you scan the trailer number, the system will throw the following error message:

“PO linked to Multiple ASNs created prior to receipt, cannot perform PO based receipt

However, the system will allow you to proceed with PO based receiving if multiple shipments are created with 0 as shipped quantity in this mode of PO based receiving. The shipments will be identified and picked based on the PO trailer combination.

BEHAVIOR FOR PO BASED RECEIVING BASED ON FLAG

Transaction 

prevent-entire-po-to-asn-conversion-flg = Blank /NO

prevent-entire-po-to-asn-conversion-flg = Yes

Entire PO gets converted to shipment

YES NO

Shipped qty is more than zero

YES

NO

PO order qty can be reduced after users starts receiving partially

NO

YES

PO Seq /Line prompt is supported

YES

YES

Attribute Prompt is based on shipment dtl

YES

NO

Vendor QC is supported

YES

NO

(based on PO details -if PO has Attribute)

Shipment is created/Identified After trailer scan

YES

YES  

(Only if shipment is created Prior to PO receiving)

verification file has 0 as Shipped qty

NO

YES

Allow PO recv when Multiple Shipments are found

NO

YES

(If system can identify shipments after trailer scan)

Additional PO qty or PO details gets latched to the same ASN

YES

NO

INTRODUCTION OF NEW MESSAGES

Parameter status Use case Error message

prevent-entire-po-to-asn-conversion-flg= Yes

Multiple IB shipments are found with more than 0 as shipped qty in less than verification in progress

PO linked to Multiple ASNs created prior to receipt, cannot perform PO based receipt

prevent-entire-po-to-asn-conversion-flg= Yes

Shipment is attached to an appointment and the scanned trailer does not match with the shipment

Trailer and shipment do not match

Marking the Reference Purchase Order column as '*' when an LPN is Received With Multiple POs 

Prior to 20D, when you receive an IBLPN from RF Recv Shipment or RF Recv load or from the IB Shipment header or detail UI, with multiple purchase orders, the IB container UI gets populated with only one PO number on the REF PO column. With the 20 D enhancement, the system now will mark the REF PO number column on the IB container UI as "*" for the IBLPNs received with multiple purchase orders. This will indicate that the LPN is carrying multiple purchase orders.

NOTE: The IHT-1 LPN received inventory history will continue to get split based on the PO numbers getting received in the IBLPN. Additionally, The REF PO number column on the IB container UI will show the PO number if the IBLPN is being received with only a single purchase order.

Steps to Enable

  1. To prompt for PO-sequence number or the PO-line schedule number during Inbound Receiving, from the prompt_po-seq-line parameter drop-down, select the PO Sequence or PO line schedule option.
  2. In order to evenly distribute SKU quantity received across multiple Purchase Order or IB Shipment details, set the prompt_po-seq-line parameter to blank.

Key Resources

Scheduled Job to Verify Shipment

A new scheduled job type Auto Verify IB Shipment will mark shipments that are received and due for verification for a specified duration (or 72 hours from the last LPN received time) as verified depending on the configuration of the scheduled job. Auto Verify IB Shipment will not only mark shipments as verified, it will also generate the shipment verification output file. This feature is beneficial because users now don't have to verify the shipment, if they are not interested in tracking the shipment.

The following table describes the Auto Verify IB Shipment job type parameters:

Field Name Description

Username

  • Mandatory field for the job type. Valid username (Login) in WMS should be provided.

Shipment Type

  • Mandatory field for the job type.
  • At least one Shipment Type should be selected.
  • If nothing is selected and user attempts to save the job, error 'The field %s cannot be blank' displays.
  • Users can provide one or more shipment types with comma(,) as the delimiter.
  • When the job is run, all IB Shipments that have matching Shipment Type and fulfill other criteria for verification will be considered.

Time since last receipt (hrs)

  • The field indicates the time elapsed since the last LPN was received for the IB Shipment.
  • This field accepts decimal values.
  • If no value is provided, system will consider 72 hrs as default duration. 

NOTE: When configuring lesser values, make sure to provide the right shipment type and time since last shipment, otherwise the system could update the status while receiving is still in process.

NOTE: Shipments with Receiving Started and Receiving Complete status are eligible for verification. Also, shipments will not be verified if they have QC pending LPNs even if the shipments match the job parameter criteria for auto-verify through the scheduler.

Steps to Enable

To mark shipments that are received and due for verification, go to the Scheduled Jobs UI, and create a Scheduled Job with Job Type Auto Verify IB Shipment.

Key Resources

Allow Receiving of QC Rejected LPNs and Return to Vendor

Generally, inventory is subjected to Quality Check (QC) at the dock station. During QC, when inventories are rejected, the system marks these IB containers to Cancelled status and are physically left behind at the QC location. This may create certain difficulties for the warehouse users to differentiate between the actual containers received to put away and the QC rejected container.

In 20D, Oracle WMS Cloud has taken an efficient approach in handling such inventories, where operations can now allow the QC rejected containers inside four walls of the warehouse, track and monitor, and ship out to the faulty or defect inventories to the respective vendors. 

ALLOW QC REJECTED INVENTORY INTO THE WAREHOUSE

New parameters are added in the RF QC Complete (rf.inbound.cwrfqccomplete) module that prompts users to provide a lock code (un-allocatable) on completing for the RF QC Complete transaction. On applying the lock code, the QC rejected status remains in Rejected status but the LPN status now moves to Received, thus allowing rejected inventories to be brought inside the warehouse.

The benefit of applying lock code is to avoid QC rejected inventories to be merged with the mainstream inventories during any movement of inventory.

NOTE: All the lock code prompts that are displayed are based upon the parameter configuration only on LPN that is QC rejected and do not prompt any lock code if the LPN is QC accepted.

  • rejected-inventory-handling
    Selections Description

    Blank (default)

    Does not track any QC rejected inventory and the system falls back to existing behavior where LPNs are marked to Cancelled status upon QC rejection.

    Lock rejected inventory

    Prompts for lock code during the RF QC complete transaction to apply an un-allocatable lock code for the rejected LPNs.

  • rejected-lock-code
    Parameter Choice Description

    Blank (default)

    Prompt for the lock code if the Rejected inventory handling is set to Lock rejected inventory.

    NOTE: The system will not Prompt for the lock code if the Rejected inventory handling is set to Blank.

    Text Field

    Users can explicitly define the parameter to set the lock code. 

    NOTE: If the rejected-lock-code has defaulted with a valid and un-allocatable lock code, then the system will not Prompt for the lock code. The LPNs will be marked as Received and QC status as QC rejected. 

The following table depicts the behavior of the parameter:

QC Status Rejected Inventory Handling Rejected Inv LC LPN Status LPN Lock Code

QC rejected

Blank

Blank

Canceled

N/A

QC rejected

Lock rejected inventory

Blank

Received

Users need to provide an un-allocatable lock code (if not defaulted) when prompted.

QC rejected

Blank

Lock code provided

Canceled

The lock code is not honored.

QC rejected

Lock rejected inventory

Lock code provided

Received

Lock code defaults and the system does not show any prompt to users.

  • When the parameter rejected-lock-code is set to Blank and if the Rejected inventory handling is set to Lock rejected inventory, then the system prompts users for the lock code. The system displays un-allocatable lock codes available in the system during the QC complete transacting for users to select a lock code from the list. 
  • If the Rejected inventory handling is set to Lock rejected inventory and the rejected lock code screen parameter is configured with an un-allocatable lock code, the system will default the lock code from the rejected lock code screen parameter upon QC rejection and will not prompt for lock code. 

NOTE: If the lock code is provided in the rejected lock code text field, the system will not prompt for lock code in RF.

  • If the defaulted lock code is invalid, the system displays the following message, “Invalid lock code for facility or company" (Message code 2013). Upon accepting the message, the un-allocatable lock codes are displayed for users to choose from.
  • The system updates the shipment and associated PO quantity (if any) considering the QC rejected inventories.

IMPORTANT NOTE: If an un-allocatable lock code is removed from the QC rejected LPN, then the rejected inventories will be at risk of getting allocated and picked by the wave or non-wave transactions.

  • A new error message "Cannot QC reject with an allocatable lock code" is introduced and displayed when the user applies an allocatable lock code on the QC rejected LPN or configured from the rejected lock code parameter, and is by default enabled for all respective facilities.
  • A new column “Lock Code” is added in the Verification History view UI screen to displays the un-allocatable lock code applied on the QC rejected LPNs from the RF QC Complete transaction.

APPLY LOCK CODE VIA IB CONTAINER AND IB SHIPMENT UI

A new pop-up window is introduced and displayed in the IB Container (IbContainerView) and IB Shipment (IBShipmentView) UI when users click the Reject button on the respective UI. This pop-up window lists only an un-allocatable lock code for users to select from the drop-down. On applying the lock code, the QC rejected LPN status moves to Received and thus allowing users to bring the LPN within the four walls.

NOTE: Applying a lock code upon rejecting an LPN is not mandatory. However, if users do not select a lock code, the system retains the original behavior where the LPN status moves to Cancelled upon performing QC reject.

  • Users can select multiple records for the Quality Check from the IB Container (IbContainerView) and IB Shipment header (IBShipmentView) UI. The applied lock code will be applicable to all the selected LPNs subjected to QC.
  • When multiple QC rejected LPNs are pending, and the user proceeds to apply an un-allocatable lock code to reject the LPNs, the system will only process those LPNs which do not have the same lock code. Thus, marks such LPN as Received with QC status as QC rejected. But, for some LPNs which already has the same lock code, the system displays an error “Successfully completed:<LPN> Some of the LPNs are not rejected with lock code as the same lock is already applied to them <LPN>”, and retains the same LPN status and do not get QC rejected. 

ORDER CREATION FOR QC REJECTED LPNS

You can now create an order manually to ship out rejected inventories from designated locations.

A new “Lock Code for QC Reject Allocation” text field is introduced in the Order Type UI where:

  • You can define both allocatable and un-allocatable lock codes that allow IBLPNs to be allocated and shipped to the vendors via RF Direct Allocation and RF Pick and Allocate transactions.
  • When you define the lock code in the “Lock Code for QC Reject Allocation”, the system tries to match the lock code on the IBLPN against the lock code on the order type. If the lock code on the IBLPN matches with the order type lock code, only then the QC rejected IBLPN is allocated.
  • Supports configuring one or more valid lock codes separated by a comma only. The system will display an error if any other characters are used to add more than one lock code.
  • The system erases any leading and trailing spaces between two consecutive commas provided in the “Lock Code for QC Reject Allocation” field when saving the record.

The following table depicts the allocation of IBLPNs via RF Direct Allocation and RF Pick and Allocate:

IBLPN

Lock Code Lock Code Type Lock Code for Order type Description
LPN01

LC01

Allocatable

 

Not required. Do not provide any lock code.

LPN01

LC01

Allocatable

LC02 (un-allocatable)

Users will be prompted "Lock code mismatch".

LPN01

   

LC02 (un-allocatable)

Users will be prompted "Lock code mismatch".

LPN01

LC02

Un-allocatable

LC02, LC03 (both un-allocatable)

IBLPN gets allocated.

LPN01

LC02, LC03

Un-allocatable

LC02, LC03 (both un-allocatable)

IBLPN gets allocated, if you are using lock code priority, then LC02 should have lesser priority than LC03.

ALLOCATING FOR QC REJECTED LPNS 

Oracle WMS Cloud also allows you to ship out of QC rejected LPN to vendors via RF Pick and Allocate and RF Direct Allocation transactions. 

NOTE: The allocation of QC Rejected inventory is supported only through User directed mode in the RF Pick and allocate transaction.

  • Allocation for QC rejected inventories is supported only if the LPNs are in Reserve/Drop locations, LPNS that are not located are in Received status, and LPNs that have matching Allocatable/ un-allocatable lock code defined in the Lock Code for QC Reject Allocation on Order type UI.
  • If the scanned LPN has multiple un-allocatable lock codes, but only one of them matches with the Lock Code for QC Reject Allocation in the Order Type, then the lock code with higher priority will take precedence. 
  • In case a QC rejected LPN has two un-allocatable lock codes and the matching lock code defined on the order type has a higher priority than the other un-allocatable lock code present on the LPN, the system successfully performs allocation of the rejected LPN.
  • In case a QC rejected LPN has two un-allocatable lock codes and the matching lock code defined on the order type has a lower priority than the other un-allocatable lock code present on the LPN, the system displays the newly introduced error message “Scanned LPN has another un-allocatable lock code with a higher priority" and does not perform allocation of the rejected LPN.
  • During the Pick and Allocate transaction to allocate a QC Rejected LPN, when the user scans the active location, the system displays a newly introduced error “Order Type has lock code for QC Reject. <%> location is not supported for allocation.”
    • If the allocated Order Type does not have 'Lock Code for QC Reject Allocation' configured and upon scanning a reserve location and IBLPN with an un-allocatable lock code, then the system displays an error “Scanned LPN has un allocatable lock.”

RESTRICT RF SPLIT IBLPN AND RF IB SORT DURING QC COMPLETE TRANSACTION

Users can now split, and sort similar QC rejected inventory via the RF Split IBLPN (rf.inbound.cwrfsplitcntr) transaction and thus restricting splitting of QC rejected inventory into non-rejected LPN when performing the split transaction.

When performing RF Split IBLPN (rf.inbound.cwrfsplitcntr), the system behaves in the following manner:

Source LPN Destination LPN Behavior

QC rejected inventory

With New LPN

Inventory is split from the source LPN and moved to the destination LPN and therefore, the lock code and QC status will be transferred to the destination LPN.

QC rejected inventory

An existing QC rejected LPN

Allows the inventory to be split for source and destination LPN having the same or different lock code.

NOTE: When the Required Validation parameter is set to All, and if the source LPN has an un-allocatable lock code present, the same lock code should be matched with the destination LPN as well. Otherwise, the system will say Lock code mismatch. Users can perform RF split transactions when the source and destination IBLPN has different lock codes and the Required Validation parameter is set to None.

QC rejected inventory

Existing LPN without any reject inventory

Displays a newly introduced error “QC Reject inventory cannot be mixed with non-reject inventory' should be displayed” message.

Existing LPN without any reject inventory QC Reject LPN Displays a newly introduced error “QC Reject inventory cannot be mixed with non-reject inventory' should be displayed” message.

When performing RF IB Sort (rf.inbound.cwrfibsortlpn) transaction, the system behaves in the following manner:

Source LPN Destination LPN Behavior

QC rejected inventory

With New LPN

Upon merging, inventory is fetched from the source LPN and moved to the destination LPN, and therefore, the lock code and QC status will be transferred to the destination LPN.

QC rejected inventory

An existing QC rejected LPN

Allows the inventory to be merge from source and destination LPN having the same or different lock code.

QC rejected inventory

Existing LPN without any reject inventory

Displays a newly introduced error “QC Reject inventory cannot be mixed with non-reject inventory' should be displayed” message.

Existing LPN without any reject inventory QC Reject LPN Displays a newly introduced error “QC Reject inventory cannot be mixed with non-reject inventory' should be displayed” message.

NOTE: It is recommended that user users Container QC status as the sort criteria to sort the QC rejected IBLPNs. Otherwise, users are required to scan a different sort zone to sort the QC rejected LPNs if the sorting zone already has mainstream inventories. We will introduce skip location functionality or allow users to scan a different location within the sort zone at a later version release.

RESTRICT CREATING LPNS FROM ACTIVE LOCATION

When LPNs are created from active using the RF Create LPN module, WMS allows an existing IBLPN to be used, as long as the shipment associated with the IBLPN is verified.  A new error “Invalid LPN status, LPN is QC rejected” is introduced in this module which is encountered when users scan an existing IBLPN that is QC Rejected and is in Received status.

NOTES:

  1. The new error is applicable only when LPNs are created with inventory out of an active location. This is because the WMS does not allow existing IBLPNs to be used by RF Create LPN if inventory is not from active location. 
  2. The new error is applicable only for LPNs that are associated with a shipment that is verified.  This is because WMS does not allow existing IBLPNs to be used by RF Create LPN if the associated shipment is not verified.

RESTRICT QC REJECTED LPNS DURING PALLETIZATION

Enhancements are made to prevent the combining of rejected inventory with regular inventory on the pallet. A newly introduced error “Pallet cannot have a mix of QC rejected and non-rejected inventory” message is displayed under the following conditions:

RF Palletization (rf.inbound.cwrfpalletizeplt) transaction: 

  • When the user scans an existing pallet during palletization containing QC rejected LPNs, and user scans a regular LPN.

RF putaway (rf.inbound.cwrfputaway) transaction:

  • When the prompt-dest-pallet parameter is set to yes and the user scans a QC rejected LPN for putaway and pallet contains good LPN.
  • When the prompt-dest-pallet parameter is set to yes and the user scans a regular LPN for putaway and pallet contains QC rejected LPN.

RF Locate LPN/pallet (rf.inbound.cwrflocatelpnpallet) transaction:

  • When the prompt-dest-pallet parameter is set to yes and the user scans a QC rejected LPN to locate and pallet contains good LPN.
  • When the prompt-dest-pallet parameter is set to yes and the user scans a regular LPN to locate and pallet contains QC rejected LPN.

Palletize via API:

  • When performing palletization form the API where the user provides a QC rejected LPN and the destination pallet has a regular LPN.
  • When performing palletization form the API where the user provides a regular LPN and the destination pallet has a QC rejected LPN.

This enhancement also focuses on improving screen flow during various transactions for QC rejected inventories.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

RECOMMENDATIONS:

  • Users are advised not to remove the un-allocatable lock codes from the QC rejected inventories. If the un-allocatable lock codes are removed from the QC rejected yet LPNs are received, the system will consider the rejected LPNs as mainstream inventories and can be allocated through the wave or non-wave transactions.
  • Users must ensure not to putaway QC rejected LPN's to an Active location. Currently, the system has no restriction to prevent the putaway of QC rejected LPNs to an Active location and can only be controlled by enabling the Prevent Putaway flag on the lock code applied.
  • It is recommended to disable the Unlock on locating to Reserve flag so that the un-allocatable lock code is not removed from the QC rejected LPNs upon locating to a reserve location.

Key Resources

New Parameter for Non-Multi-Field Barcodes

Prior to update 20D, the barcode type “Count” only applied in Multi-Field Barcode (MFB) scenarios, and only when the Multi-Field Barcode was scanned in a non-quantity barcode field. Now with update 20D, you can use the Count barcode type for both MFB scenarios, and non-MFB scenarios. A new Company parameter “ENABLE_NON_MFB_COUNT_BARCODES” has been added to control this behavior. The default is No, but If set to Yes, it will allow:

  • The count barcode type to be used in a non-MFB scenarios.
  • Single barcodes for count (ie quantity) to be scanned into the quantity field.     
  • To validate against the barcode type rules as defined for the count type.   
  • All quantity entry fields will recognize this barcode type.
  • The "numeric" flag on the barcode type detail should be ignored for Count and the behavior should be as if it was enabled.
  • Any non-numeric (ie except numbers, decimal point) values other than the prefix will result in an error message.

NOTE: The quantity entry field currently accepts non-numeric characters and ignores them silently. This behavior will continue when the new parameter is disabled

3PL CONSIDERATIONS

Oracle WMS Cloud only looks up this value for the users default company. If a user at the parent company level logs in and starts receiving a shipment for a child company, the parameter value that gets used is the one for the user's default company which is the parent company. If a user that belongs to a child company logs in, the parameter at that level is what applies.

Steps to Enable

You don't need to do anything to enable this feature.

Enhanced Configurability on Post-Pick Order Consolidation and Loading

In order to streamline throughput in the warehouse, Oracle WMS Cloud has added a new feature to manage and control Outbound LPN movements after picking/packing using Outbound LPN/Pallet Putaway.

This makes your time to market faster and reduces user clicks and screen time – ultimately reducing bottlenecks within the warehouse.

CONFIGURATION

New Transaction - RF Module OBLPN Directed Putaway

Outbound LPN/Pallet Putaway is a new module (rf.outbound.cwrfputawayoblpn) that will be used for pushing picked or packed OBLPN's to relevant locations or to call other transactions like Loading or Dynamic Staging.

NOTE: The Outbound LPN/Pallet Putaway transaction can be called standalone or through tasking.

  • Users should be able to scan single or multiple LPNs or a Pallet. If they are scanning multiple LPNs a counter will also be displayed.
  • When scanning, OBLPN status must be "Picked or Packed”.
  • When scanning, a Pallet status must be "In-use”.
  • If user scans an LPN on the Pallet, the following message will appear -- "LPN will be depalletized, proceed further".
  • We do not support multiple pallet scan with this transaction. 

SCREEN PARAMETERS FOR THE NEW DISPATCH MODULE

Parameter Description

putaway-type-determination-rule

This is a free form text box where you can add the rule name you configured in OBLPN Putaway type determination UI. Rule name provided will determine the putaway type by going through the individual rule sequences.

determine-patype-for-each-lpn

If _determine-patype-for-each-lpn is set to "No":

  • Then when users scan multiple LPNs, the putaway type is not going to be calculated for each LPN. Instead the system is only going to calculate the putaway type according to the rules and inventory. Incompatible putaway types will not come into play as there will only be one putaway type determined for all LPNs on a pallet or all the LPNs scanned or passed through tasking mode.

If _determine-patype-for-each-lpn is set to "Yes":

  • System will calculate the putaway type for each LPN scanned.
  • If a common putaway type is determined for all LPNs on the pallet or all individual OB LPNs scanned in OBLPN Putaway or all LPNs passed through tasking mode. User will be prompt with the action configured in OBLPN Putaway Action UI.
  • If Putaway types determined for all LPNs on the pallet or all LPNs passed through tasking is different and are incompatible then message will be displayed "Putaway types are different and not compatible for proceeding with next action," and user will be prompted with a drop location.
  • If Putaway Type determined is not same(heterogeneous) and OBLPN Putaway is invoked Standalone. Putaway type determination to happen after each LPN scan, and if putaway type determined for next LPN scanned is not compatible with previously scanned LPNs display error message "Putaway type determined for %LPN% is not compatible with previously scanned LPNs, scan different LPN".

default-drop-location

This is a free form text box, which will allow users to configure the drop location.

NOTE: Drop Location configured should not be part of Inbound Sort Zone or Outbound Sort Zone.

Recalculate Putaway type

  • If screen parameter recalculate Putaway type is set to "Yes", putaway type will be determined even though container has putaway type.
  • If screen parameter recalculate Putaway type is set to "No", putaway type will not be determined if container has putaway type. Putaway type determination will be invoked only if container does not have Putaway type.
  • If Pallet is subjected for Putaway type determination, and recalculate Putaway type is set to "Yes" Putaway type will be computed for each LPN on the Pallet, even though putaway type is populated on the LPN's.
  •  If Pallet is subjected for Putaway type determination, and recalculate Putaway type is set to "No" Putaway type will not be computed if all outbound LPN's have Putaway type populated. Determine Putaway type only for those LPN's which do not have PA type.

NOTE:  Putaway type determination is based on the configuration of determine-patype-for-each-lpn screen parameter. The configuration of this parameter is very important as it drives the whole logic of how the putaway type is determined. 

DETERMINING PUTAWAY TYPE

New UI - OBLPN Putaway Type Determination 

OBLPN Dispatch assigns an OBLPN Putaway Type to OBLPNs or Pallet according to the rules configured in the new OBLPN Putaway Type Determination UI. The New RF OBLPN Direct Putaway will look into the rules and the selection criteria that the user has set up in the new UI – OBLPN Putaway Type Determination, and if the selection criteria matches the inventory in the OBLPN, it will assign the Putaway type configured in that rule. In the New OBLPN Putaway type Determination UI you can configure the rule name. This rule name is configured in the screen parameter "putaway-type-determination-rule" of the RF OBLPN Direct Putaway.

Putaway Type Determination Sequence

  • In the OBLPN Putaway Type Determination UI, the user must configure a putaway-type-determination-rule. Each rule can have a set of Putaway type determination sequences that can be configured in the detail screen.  The system will assign a putaway type by looking at the sequence and its corresponding selection criteria. If selection criteria configured matches against the container's attributes, then the system will assign the putaway type configured on that particular sequence. If selection criteria is not configured then Putaway type will be assigned as per that sequence.
  • If LPN which is subjected for Putaway type determination contains multiple SKUs and if the underlying selection rule has item/item facility attributes used in the rule, then any one of the item's attributes can be considered, and if one matches the selection criteria then system will assign that putaway type.
  • If LPN which is subjected for Putaway type determination contains multiple orders and if the underlying selection rule has order header attributes used in the rule, then any one of the order header's attributes can be considered.
  • If LPN which is subjected for Putaway type determination contains multiple order details and if the underlying selection rule has order detail attributes used in the rule, then any one of the order details attributes can be considered.
  • If LPN which is subjected for Putaway type determination contains multiple allocations and if the underlying selection rule has allocation attributes used in the rule, then any one of the allocation's attributes can be considered.
  • If selection criteria does not pass based on the containers contents (items, orders, allocation), then proceed with next sequence.
  • If Putaway type is not determined then a drop location will be prompted. If Putaway type determination fails for one or more LPN then the system will display the message "Putaway type determination failed for some of the LPN's, locate to drop location".

Selection Criteria

Selection Criteria can be assigned for each Putaway Type Determination Sequence. Selection criteria has fields from tables such as Container, Order, Allocation, and more. We have also added a list of additional functions. These new functions can be useful to assign a Putaway Type.

Complex Function Comments

Has All LPNs on Single Load. 

If all OBLPNs are assigned to same Load, then Loading Module could be called. If all OBLPNs are assigned to same Load, then operator can directly perform Loading. Typically useful when LPNs are called in tasking mode or while picking a Pallet or while picking multiple LPNs in standalone mode and Putaway type is not determined by LPN. LPNs without a load number are not evaluated.  

Total Weight by LPN

Will yield the summation of OBLPNs' weight on all the participating LPNs. Actual weight determined can be different than estimated weight. This function could be used in operations after capturing the actual weight. Typically useful when LPNs are called in tasking mode or while picking a Pallet or while picking multiple LPNs in standalone mode and Putaway type is not determined by LPN.

Total Volume by inventory

Sum (curr_qty * unit_volume) across all inventory lines.

Has All_LPNs on Single Stop

If all OBLPNs are assigned to the same Stop, then Loading Module could be called. If all OBLPNs are assigned to same Stop, then operator can directly perform Loading. Typically useful when LPNs are called in tasking mode or while picking a Pallet or while picking multiple LPNs in standalone mode and Putaway type is not determined by LPN. LPNs without a load stop are not evaluated.

Has All LPNs on Active Stop

If all OBLPNs are assigned to the Active Stop (the first non-closed stop on the specified load), then Loading Module could be called. If all OBLPNs are assigned to the Active Stop, then operator can directly perform Loading. Typically useful when LPNs are called in tasking mode or while picking a Pallet or while picking multiple LPNs in standalone mode and Putaway type is not determined by LPN. LPNs without a load stop are not evaluated.

Has complete orders

All underline orders must be present in the task, pallet or scan OBLPN, and they must be completely packed.

Has complete pick orders

All underline orders in the task pallet or scanned OBLPN , and they must be completely in pick status for final packing to be started using RF Repack.

Has mix destination facilities

Checks the selected inventory orders' DESTINATION facility, if there's more than one, true.

Has mix order type

Checks orders' type, if there's more than one, true.

Has mixed shipto

checks orders' SHIP TO facility, if there's more than one, true.

Is multi sku

Returns true if there is more than one type of item in the selected inventory.

Number of orders

Counts all the orders in the selected inventory.

Total weight by inventory

Sum (curr_qty * unit_weight) across all inventory lines.

Inventory exceeds LPN type capacity

Checks to see inventory uses any LPN types. If it does, it tests if LPN total volume or weight exceeds the LPN types capacity. It returns true if ANY of the LPNs exceed it's LPN type capacity.

New OBLPN Putaway Action UI

Once your Putaway Type has been determined as per the configuration rules above, you may configure activity based on the determined Putaway type in a new web UI screen. The OBLPN Putaway Action configuration will decide if the LPNs or Pallet will be either “Locate,” “Stage,” or “Load.” This is going to save you time and you will not need to exit one transaction before logging in to the next transaction. This is crucial for warehouses that only have a single user who performs multiple steps from pick to load.

DISPATCH ACTIONS

OBLPN Putaway Action - Locate

After Putaway type is determined, the system will check the configuration for that putaway type. If the action is to Locate, the following will happen:

  • If resultant action has destination location barcode configured, user will be prompted with location and will have to confirm location.
  • If the resultant action has destination location type and destination zone configured, then user will be suggested a Task Zone and user will be free to put the OBLPN or Pallet in a location with that task zone.
  • WMS activity records needs to be written as configured.

Let's say you have LPNs in a pallet with different putaway types and those putaway types have an OBLPN Putaway Type equal to Locate. However, those putaways are all set up to be located in different locations. The system will prompt you to depallatize the pallet, and to scan each LPN, so that they are located in the correct location.

NOTE: Customers will have to configure task zones for the locations like drop/packing station/Staging/Pack and Hold.

OBLPN Putaway Action - Stage

Currently, pickers have to drop picked LPNs in a drop location and the next operator has to pick the LPNs for staging. For small warehouses where staging locations are nearby, it will be beneficial to call a dynamic staging transaction right after picking is completed. Without this feature, users will have to come out of tasking and invoke the transaction standalone which can result in productivity issues.

With this new feature, customers will be able to configure staging transaction to be called upon completion of picking and users will be prompted for performing dynamic staging or invoke staging transaction for the LPN's or Pallets post packing based on Putaway type determination.

Please note that if Dynamic staging transaction is being called from Outbound LPN Putaway Module, the transaction will allow you to scan more than one LPN, and the system will ask the user to scan each LPN to be staged one by one.

OBLPN Putaway Action - Load

To facilitate loading, users are now able to load LPNs or single pallet right after picking. Now, you will be able to call Loading upon completion of picking, so the same user can be prompted to do the loading of the LPNs or Pallet packed using the new RF OBLPN Putaway Directed transaction. If user has configured loading as the putaway action, users will be able to easily load into the truck. Some examples of validations included:

  1. Prevent loading onto inactive stop
  2. Prevent loading if LPNs are assigned to multiple loads
  3. Prevent loading if some LPNs are NOT assigned to a load
  4. Prevent loading if order is blocked for shipping

The system will prompt for a message to perform Loading. Loading is completed by scanning a dock door/trailer/load number. You will not be Prompted to rescan the LPN or Pallet, after scanning in OBLPN/Pallet Putaway. To speed up the process, you will be prompted to either scan a dock number (if dock is assigned via appointment) or trailer number/load number.

NOTE: Users are only allowed to scan OBLPNs that have been passed thru OBLPN Directed Putaway transaction. If users scan an OBLPN which is not passed from OBLPN Directed Putaway transaction the system will display error message "Scanned LPN/Pallet not part of OBLPN Putaway".

LOCATE

If system is not able to determine a putaway type, then users will be prompted to scan a location or to confirm a location if default is set up in transaction. This location must be a “Drop” Location, and the type of the location should be ‘drop’ for the logged facility. Drop Location configured should not be part of Inbound Sort Zone or Outbound Sort Zone.

Once users confirm the location, if dealing with LPNs alone, the current location of the LPNs is updated. If dealing with pallets, ensure current location of the pallet is updated to the drop location scanned.

Change in Task Type detail UI to make System Call New Transaction

The following Allocation types have a new entry to task type detail screen. This new entry is Putaway OBLPN, and users will be able to add the new RF OBLPN Directed Putaway screen. The entry is not mandatory.

  • Full LPN/FULL-LPN-PALLET or FULL-CONTAINER (Post full LPN picking)
  • LPN Cases/LPNCases (Post Non cubed Active Picking)
  • LPN Packs/LPNPacks (Post Non Cubed Active Picking)
  • LPN Units/LPNUNITS (Post Non Cubed Active Picking)
  • Full LPN/PLTMV_AUTOPK (Post Pack OBLPN, with Pallet being pulled)
  • Active Pick/NC-ACTIVE-PICK (Post Non Cubed Active Picking)

Multiple Types/PICK_CART (Post Pick Cart)

In tasking flow, you can either get task zone movements (and then you can use oblpn putaway standalone) or you can get oblpn_putaway built in, but you cannot configure both.

OBLPN  Inquiry and Item inventory by LPN Screens – Now Displays Putaway Type 

  • Putaway type column is exposed in Outbound LPN Inquiry.
  • Putaway type column is exposed in Item Inventory by LPN.
  • Not by default.
  • You can search by putaway type.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

New Facility Parameter to Associate Blind ASNs

The ability to associate a shipment type for blind shipments is now available in 20D. A new facility parameter SHIPMENT_TYPE_FOR_BLIND_IBSHIPMENT allows you to associate a Shipment Type to a blind ASN and also harness additional flags on the shipment type during receipt like the "allow receipt of expired inventory" flag.

The SHIPMENT_TYPE_FOR_BLIND_IBSHIPMENT parameter includes the following details:

  • By default the Parameter Value is <Blank>.
  • The parameter should be configured with a valid 'Shipment Type' configured in the system. 
  • When SHIPMENT_TYPE_FOR_BLIND_IBSHIPMENT is <blank>, during RF Recv Shipment (Blind ASN Receiving) - blind ASNs are created without a Shipment Type.

When SHIPMENT_TYPE_FOR_BLIND_IBSHIPMENT is configured with a valid value (Shipment Type configured in the logged in company), during Blind ASN Receiving:

  • After receiving the first LPN, when the system displays the LPN prompt screen, the system displays the configured Shipment Type in the "Shipment Type" field.
  • Blind ASNs are created with the configured Shipment Type.
  • When a blind shipment is defined with a shipment type, the ASN should honor the Allow Expired Inventory field.

Steps to Enable

To facilitate auto-verification of blind ASNs, configure facility parameter SHIPMENT_TYPE_FOR_BLIND_IBSHIPMENT with a valid shipment type.

Key Resources

Support for Legacy Company Parameter LEGACY_ACTUAL_WEIGHT_OVERRIDES_WT_VOL_CALC_IN_SHIPPING

As part of 20D, a new company parameter LEGACY_ACTUAL_WEIGHT_OVERRIDES_WT_VOL_CALC_IN_SHIPPING is introduced in the system to re-compute the weight/volume for the OBLPN based on the Item's unit weight and quantity on the OBLPN when the OBLPN gets loaded and shipped. This company parameter is set to No, by default.

If the parameter is set to YES, the system does not re-compute the weight/volume on the OBLPN and OBLOAD and will retain the actual weight/volume captured either via UI/RF or API.

NOTE: If the actual weight and volume are recorded post packing and if the actual weight does not change, then it's recommended to set the parameter to Yes so that the actual weight recorded is not overwritten.

After performing Picking, the actual weight/volume/dimensions of the LPN can be recorded. Even though the actual weight and volume are recorded upon performing ship load, the OBLPN’s weight and volume were previously recomputed. As part of this change, the application will provide the ability to retain the actual weight and volume of the OBLPN recorded during ship load.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

Backorder Processing Handling in WMS

The system allows the processing of orders with the same order number only when the "Require Back Order Flag" on the order's order type is enabled and the existing order with the same order number is in Shipped or Canceled status.

Users can process the order from:

  • Order Interface
  • Init stage API for order
  • Order UI

NOTE: IF the "Require Back Order Flag" on the order's order type is disabled and the existing order with the same order number is in Shipped/Canceled status, then the system displays an error message.

A new column "Original Ord Number (original_order_ndr)" is introduced on the Order header. By default, the value in the column is set to Blank.

During backorder processing, the existing order present in the system with the same order number is renamed with timestamp suffix (YYYYMMDDHHMMSS) and the renamed order number is displayed in the order number field in the Order UI. On renaming the order number during backorder processing, the original order number (before renaming) is stored in the Original Order Number column in the Order Header UI. The Original Order Number column is also displayed in the Order Header category in Web Reports.

The system considers the order number from the Original Order Number column present on the order. If the value is blank, then the order number is considered from the Order Number column of the respective order for the following interfaces:

  • Inventory History (IHT)
  • Shipped Load (SLS)
  • Order Outbound Load Export (PLS)
  • Pallet Shipping Info (PLO)
  • OBLPN Shipping Info (OLO)
  • Container Outbound Load Export (LLS)

When Oracle Inventory Management Cloud sends an unfulfilled order back with the same order number to Oracle WMS Cloud, the system was not processed because of an already existing order number present in the system whose order status was greater than created.

Back Order Processing has been enhanced so that you can now process back orders with the same order number even if an earlier order with the same number is in Shipped/Cancelled status.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

Allocation in Terms of Packs or Cases from Active Locations

In 20D, Oracle WMS Cloud is enhanced to support Picking allocations from the Wave in terms of Packs or Cases from active locations. Now, users who track inventory in terms of item’s standard pack or item’s standard case quantity can use the feature for allocating in terms of packs or cases from active.

Highlights of the enhancements include:

PICKING WAVE ALLOCATION 

Previously, the allocation mode sequence in a wave template allowed users to define the Allocation UOM in terms of Units only when the location type is Active. Now, the allocation mode sequence allows the user to define the Allocation UOM in terms of Packs, Cases, and Units when the location type is Active. When performing the picking wave, if the allocation UOM is set to Pack or Cases and the Location type is Active, the system creates allocations with an allocation UOM of packs or cases. That is, if the allocation UOM is Packs, then the system considers the item's standard Pack quantity, and if the allocation UOM is Cases, then the system considers an item's standard case quantity. While allocating in terms of packs or cases, WMS falls back to an item's standard pack or item's standard case quantity given the active inventory pack and case quantity values of 0.

ALLOCATION MODE SEQUENCE 

The Allocation Mode Sequence UI allows configuring UOM of Packs or Cases when the Location type is "Active".

NOTE: If the Location Type is "Active" and Allocation UOM is not Units or Packs or Cases, OR enabled with only Units/Packs/Cases, then an error is displayed.

NC ACTIVE PICKING 

RF NC Active Picking is enhanced to displays quantity in terms of the number of Packs or number of Cases when users are picking from Active. The number of Units per pack or case is considered from the item's master.

  • The system now allows you to pick per Packs or Cases when the wave has allocated Active Inventory with Allocation UOM of Packs or Cases while performing:
    • Non-Cubed Active Picking.
    • Cubed Picking.
    • Non-Cubed Picking with Final OBLPN Status as Packed.
    • The system will display the number of cases based on the item's standard pack or case quantity in Sku Scan Mode. Each Scan of Sku should correspond to 1 Case per pack to be Picked (The number of Units to be considered is an item master's standard case or pack quantity).
  • The screen parameter auto-pack-one-uom works with allocation from active in Packs or Cases if allocation UOM is Packs or Cases and Wave has allocated with allocation UOM of Packs or Cases from the active location.

NOTE: While allocating in terms of Packs or Cases from Active, the underlying task type must populate is "NC-Active-Pick" and Allocation type of "Active Pick" for the allocations and tasks created.

RF PICK CART 

The RF Pick Cart is now enhanced to display quantity in terms of Packs or Cases when your picking from an Active location.

  • The system now allows you to pick in Packs or Cases when the wave has allocated Active Inventory with Allocation UOM of Packs or Cases while performing Cubed picking:
    • The system will display the number of packs or cases based on the item's standard pack quantity or item's standard case quantity in Sku Qty Entry Mode.
    • The system will display the number of packs or cases based on item's standard pack or case quantity in Sku Scan Mode. Each Scan of Sku corresponds to 1 Case or pack to be Picked (The number of Units to be considered is an item master's standard case or pack quantity).

RF PICK IBLPN 

RF Pick IBLPN with Consolidate and Distribution is now enhanced to support picking into temporary inbound LPN and displaying the quantity in terms of Packs or Cases from Active Location.

  • The system now allows you to Pick in Packs or case when the wave has allocated Active Inventory with Allocation UOM of Packs or Cases:
    • The system will display the number of packs or cases based on the item's standard pack quantity or item's standard case quantity in Sku Qty Entry Mode.
    • The system now allows you to Pick in Packs when the Wave has allocated Active Inventory with Allocation UOM of Cases while performing Cubed picking. The system will display the number of cases based on item's standard case or pack quantity in Sku Scan Mode.
  • Displays correct Packs and Case Qty values during RF Distribute LPN transaction:
    • If the initial Picks into temporary inbound is in terms of Packs (allocation UOM of Packs) and Pick IBLPN has screen parameter distribution-uom is set to "Use Source Inventory UOM", then the system displays quantity to be packed in Packs while performing RF Distribute LPN.
    • If the initial Picks into temporary LPN is happening in terms of Cases (allocation UOM of Cases ) and Pick IBLPN has screen parameter distribution-uom is set to "Use Source Inventory UOM", then the system displays quantity to be packed in Cases while performing RF Distribute LPN.

PUTAWAY  

To support allocate inventory in Packs or Cases from Active Location, Oracle WMS Cloud considers pack quantity and case quantity from the item master's pack and case quantity.

NOTE: The system does not support tracking of multiple packs or Case Qty in a single active location.

Putaway Type Determination Rules is now enhanced where you can control LPN's with non-standard Pack or Case quantities to be moved to different Active Locations. You can now move LPN's to different Reserve Locations if the incoming LPN's have a different Pack or Cases quantity other than the Item master's Pack or Case quantity.  This will help in segregating items with a non-standard pack or case quantity from the active location.

The following two functions are introduced in the Putaway type determination Rule Selection Criteria:

  • FUNC_INVN_PACK_QTY_MATCHES_ITEM: The system will compare the item's standard Pack quantity against the inventory's pack quantity. If the item's Pack quantity matches with the Inventory's Pack quantity, then the Function will evaluate to true.
  • FUNC_INVN_CASE_QTY_MATCHES_ITEM: The system will compare the item's standard Case quantity against the inventory's Case quantity. If the item's Case quantity matches with the Inventory's Case quantity, then the function will evaluate to true.

MHE Pick Confirmation Changes

From Release 20D, you can use the MHE Pick Confirmation API to pick from active with allocation UOM of Packs or Cases. Currently, as allocation in terms of packs or cases is not supported through Picking Wave from active, users did not have ab ability to use MHE Pick Confirmation.

The MHE Pick Confirmation API is now enhanced to pick inventory in terms of Pack and Cases from an active location with Allocation of Packs or Cases. The MHE Pick Confirmation API has Allocation UOM and UOM quantity fields that convert Packs to Units or Cases to Units. These fields are used to perform picking updates if the original allocation is in Packs or Cases.

  • If MHE Pick Confirmation payload has allocation UOM of Packs or Cases and the determined allocation is in Packs or Cases from "Active”, then the system determines the quantity be picked or packed by multiplying the item's std pack qty if allocation UOM is Packs or item's Standard Case quantity, if the allocation UOM is in Cases.
  • The MHE Pick confirmation API throws an error in the following conditions:
    • If "allocation_uom" is passed without "uom_qty".
    • If the passed "allocation_uom" does not match the Wave Allocation UOM, the API errors "No open allocations for LPN".
    • If the passed "uom_qty" does not match the item's-Standard Pack quantity/Standard Case quantity, then the API errors "Item std pack/case qty does not match with UOM qty, for pick from active use item std pack/case qty".
    • MHE Pick Confirmation API errors on the quantity mismatch, if the quantity to be packed is < than the quantity to be picked.
    • If the passed "qty"*"uom_qty" > ( Allocated quantity - Packed quantity) of the item, the API errors "Entered qty is greater than ordered qty, overpack not allowed", if the short_flg" = false during Packing.
    • If the passed "qty"*"uom_qty"> ( Allocated quantity - Packed quantity) of the item, the API errors "Error: qty is too high", if the short_flg" = true during Packing.

NOTE: As we are not supporting active inventory with non-standard pack or case quantity values, the UOM_Qty field in MHE Pick Confirmation API payload will not be relevant when determining allocation is from active and allocation UOM is Cases or Packs

The Oracle WMS Cloud supported the allocation of inventory in terms of Units from the Active location. Due to non-availability of allocation in terms of Packs or Cases from active location, users had to allocate in terms of units from active even though the physical form of inventory is in Packs or Cases. This was a challenging factor, where the picking professionals had to break open the sealed box that led to tampering with the original LPN Label.  Through this enhancement, users are no longer required to model the pick location to the active location for allocating in terms of Packs and Cases. Instead, users can now allocate in terms of an item’s standard packs or item’s standard cases from active locations and the floor users do not have to compute the number of Packs or Cases manually.

Steps to Enable

To Allocate Inventory quantity in terms of Packs or Cases:

  1. Go to Wave Template>>Inventory Allocation Mode>>Inventory Allocation Mode Sequence UI.
  2. Set Location type = Active and Allocation UOM = Packs or Cases.

To Apply configuration changes in Putaway:

  1.  Go to Putaway Determination Rule.
  2.  Select the Final Putaway Type > Click Selection Criteria.
  3.  Go to Insert basic Operation > From Column name drop-box, select the function Function - Inventory Pack Qty matches Item or Function - Inventory Case Qty matches Item.
  4.  Click Save.

Key Resources

User Experience and Usability Enhancements

Call Putaway from Receiving

When inventory arrives at the warehouse, the LPNs or Pallets are received at the receiving station. Generally, on completing the receiving process, users call for the putaway of the LPN or pallet to the location based on the putaway type. This two-way process of receiving and then performing a putaway results in consuming extra time. In order to simplify the process of receiving and moving the LPN/Pallet directly to its location as soon as the inventory is received, the Oracle WMS cloud introduces a new enhancement to the Receiving transaction (Receive by Shipment & Receive by Load).

HIGHLIGHT OF THE ENHANCEMENT

  • Ability to perform Directed Putaway from Receive by Shipment / Receive by Load.
  • Ability to perform Directed Putaway for Upfront Palletization from Receive by Shipment / Receive by Load.
  • Improved Putaway screen flow on invoking Distributed LPN transactions.

DIRECTED PUTAWAY FROM RF RECEIVE BY SHIPMENT / RF RECEIVE BY LOAD

An existing screen parameter "next-screen-to-launch", available in the RF Receive by shipment (rf.inbound.cwrfrecvlpnshpmt)/ RF Receive by Load (rf.inbound.cwrfrecvlpnload) module is now extended to call directed putaway when the user receives an LPN/Pallet during Receiving transaction.

The following table lists the support of calling the Putaway screen when receiving of LPN/ Pallet by Shipment or by Load:

Receive LPN/ Pallet by Shipment or by Load

Supports Directed Putaway During Receiving

Cartonize and Non- Cartonize LPN (Single/ Multi SKU)

Yes

LPN with Flow-Through Successful 

Yes

LPN as Physical Pallet

Yes

LPN or Pallet receiving

Yes

Palletize Up Front

Yes

Received LPN is subjected to successful Xdock

No

Received LPN is subjected to QC.

No

Received LPN is subjected to VAS.

No

When receiving mode is set to Palletize after receipt

No

Received LPN having Lock code (if Prevent putaway flag enabled)

No

  • When an LPN/Pallet/LPN as Pallet is received during Cartonize or Non-cartonized Shipment, the system displays the putaway location confirmation screen based on the Putaway method priority associated with the putaway type available on the LPN received. On completing the Putaway transaction, the system navigates back to the receiving screen.
  • If the received LPN has a successful flow through, then the system performs Putaway of respective LPN.  

 NOTE: If received LPN/Pallet fails to Putaway, then the system prompts for drop location if the screen "prompt-location" is not set to "Do not prompt" in the receiving screen.

  • If the configured Putaway screen is invalid or unavailable,  then the system displays an error message "Cannot call next screen. Screen configured % screen name % is not valid".

DIRECTED PUTAWAY FOR UPFRONT PALLETIZATION FROM RECEIVE BY SHIPMENT / RECEIVE BY LOAD

  • On performing Upfront palletization, after users receive LPN’s with respect to Pallet and on ending the Pallet (CTRL+E), the system invokes the Putaway screen (Putaway location confirmation) configured in the Receiving transaction.

NOTE: When the user ends the pallet (CTRL+E), the system displays a confirmation message. Upon accepting, the Putaway location is prompted. After completion of Putaway, the screen navigates back to the Receiving screen.

  • An error "Cannot call next screen. Screen configured % screen name % is not valid" message is displayed when calling putaway fails due to invalid screen during END Pallet.

IMPROVE CALLING DISTRIBUTE LPN FROM PUTAWAY

Previously, when an LPN was scanned in the Putaway transaction (with Distribute LPN  configured), the system reverted to putaway if the allocation during distribution failed. Now, users can scan LPNs after receipt in the Putaway transaction (when configured to call distribution.) The system will first try to allocate the LPN for Xdock or flow through allocations and if unsuccessful, then the system falls back to Location determination logic.

Oracle WMS Cloud has been updated so that when the system invokes Distribute LPN (rf.outbound.cwrfdistributelpn) from RF Directed Putaway (rf.inbound.cwrfputaway) if there are no eligible orders (for Xdock and flow-through) for distribution, the system will automatically proceed with putaway for the respective LPN.

NOTE: After the system performs putaway against the scanned LPN, the system will display a message for you to confirm that you want to proceed with the putaway. If the distribution allocation fails for any reason, the system will display a message and then proceed with the putaway.

ALLOW DISTRIBUTION OF ALLOCATED LPNS ON A PALLET FROM PUTAWAY

To help users move allocated LPNs from pallets for packing, the system now allows you to perform Distribute LPN for allocated LPNs present on the pallet when you scan a pallet in the RF Directed Putaway transaction.

As long as RF Directed Putaway is configured with the Distribute LPN transaction:

  • The system performs Putaway of a Pallet when all the LPN's on the pallet are not in allocated status by displaying the message "LPN's on the pallet are not allocated proceeding with Putaway".

When all the LPNs on the pallet are in allocated status, the system performs distribute LPN for all the LPN's present on the pallet:

  • When there are multiple LPNs on the pallet in allocated status, the system prompts for each allocated LPN (In descending order of each LPN’s last modified time) for performing distribution. 

NOTE: It's not advised to modify LPNs after allocation as this may impact the sequence of LPNs getting prompted for distribution.

  • The system prompts for the LPN, then on confirming, the system proceeds with the message to perform Depalletize and distribute the LPN.

As part of 20D, users can now invoke Putaway transactions from RF Receiving and locate the inventory to the respective destination, if the putaway type is defined on the LPN/Pallet. This functionality is made available when performing the RF Receive by Shipment (rf.inbound.cwrfrecvlpnshpmt) /RF Receive by Load (rf.inbound.cwrfrecvlpnload)  transaction.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

Enhancements to Single Item LPN Receipt

Prior to 20D, users had to scan the LPN every time for a template-based receiving where the SKU's and quantity were defaulted when performing RF Single SKU receiving. Now in 20D, users can define the number of LPN scans or can auto-populate the LPN numbers without scanning any LPN.

BENEFITS OF THIS FUNCTIONALITY ARE:

  • Single SKU receiving is an efficient way of receiving inventories when the fewer SKU's are involved.
  • Template-based receiving provides an opportunity for users to scan the LPN without scanning the SKU and quantity for each LPN.
  • Ability to cartonize the SKU's and then receive the inventory.  

EXTENDED UOM SUPPORT

A new screen parameter “qty-uom” is available in the RF Single SKU (rf.inbound.cwrfrecvsinglesku) receiving module where users can receive inventory in cases and packs, and can define the current case or pack quantity.

Parameter Values Description

Blank (Default)/Units

Receives the inventory in terms of Units.

Cases

Receives the inventory in terms of Cases.

Packs

Receives the inventory in terms of Packs.

When the screen parameter “qty-uom” = Packs or Cases:

  • The system considers the following logic to calculate the received quantity:

Total received quantity=   (Pack/Case quantity/Units X Quantity provided X number of LPNs received).

  • Users can override the defaulted pack or case quantity configured from the item detail. However, such overrides are limited to the received inventories alone, as an overriding standard pack or case qty will not update the item's standard pack or case quantity.

NOTE: If the standard pack or case quantity exceeds the totals shipped quantity, then the system displays an error message “Not enough shipped quantity”.

PRINT INBOUND LPN LABELS

A new screen parameter “print-labels" is available in the RF Single SKU receiving (rf.inbound.cwrfrecvsinglesku) module where users can print the labels for received LPNs.

Parameter Values Description 
Blank (default) Does not print IBLPN labels after LPN is scanned. 
Inbound LPN Label Prints the labels for the received LPNs. 
  • The system fetches the appropriate label template from the Label Template View UI screen to print the IBLPN labels.
  • A new message “No default printer found label printing will fail, proceed?” is available in the Message Code UI. The newly introduced warning message is displayed right after launching the transaction from RF when:
    • If the default printer is not configured for a user.
    • The user has configured an invalid printer name, as the default printer.
    • The Print label parameter is set to Inbound LPN label.
  • To update/modify the default printer, users can change form the Main RF menu option.

PROMPT BATCH NUMBER AND EXPIRY DATE

The RF Single SKU Receiving transaction honors the non-cartonized ASN type prompt control for batch and expiry tracked items. When performing a single SKU receiving, the system is now enhanced to prompt for the batch number or expiry date for the batch/expiry tracked items based on the item level or Shipment type-level configuration.

NOTE: The RF Single SKU receiving transaction does not support receiving of Inventory Attribute tracked SKU's having multiple details for the same SKU in an ASN, or have missing attribute values for the ASN details.

  • When the screen parameter “rcv-sku-not-on-shpmnt” is set to Yes and the user scans an attribute tracked item that is not present on the ASN, a newly introduced error message “Sku not on shipment, the item is attribute tracked" will be displayed.
  • Prompting of batch or the expiry date is based on the item level configuration and Shipment Type "Non-Cartonized receiving batch and expiry prompt control" config.
  • When a user scans a batch number or the expiry date other than the batch number or expiry date populated on the shipment detail when the prompt is set to Always prompt, the system displays the following warning message respectively; "Batch number does not match the SKU-shipment combination"/ "Expiry date does not match the SKU-shipment combination".
  • When the user scans an existing batch number from the batch master which is populated with an expiry date and overrides the defaulted expiry date on the RF single SKU receiving flow, the system displays the following error message: “Expiry date already exists on the batch master, cannot override".
  • If an item is a batch or expiry tracked, the system displays the batch and expiry date fields based on the item or ASN type configurations.

LPN PROMPT BEHAVIOR

A new screen parameter “LPN prompt behavior” is available in the RF Single SKU receiving module that allows you to define the number of IBLPN's to generate when receiving an ASN detail for the same SKU.

This will help the users to cartonize and receive the ASN details simultaneously without scanning the LPNs multiple times.

Parameter Values Description

Blank (default)

Prompts for the LPN number and can scan only one LPN at a time.

Auto-generate

On enabling, the LPN number is populated automatically. Users can either scan an LPN or can hit the tab to generate the LPN number automatically.

NOTE: Only a single LPN will be generated. The system prompts to scan the Shipment, the SKU, and the quantity. If a quantity has defaulted from the screen parameter, then the user is required to press the tab twice after scanning the SKU to receive the LPN.

Enter LPN count

Prompts the number of LPNs to be received instead of the LPN prompt. 

  • When the LPN prompt is set to Auto-generate, after pressing the tab button from the LPN prompt field, the system displays the following confirmation message indicating the LPN that is received., “LPN %s received” with the scanned or auto-generated LPN”.

NOTE: This message will appear only when the LPN prompt behavior is set to Auto generate.

  • If the LPN count exceeds the total Shipped quantity of the ASN details for the SKU after multiplying with the default quantity, the system displays “Not enough shipped qty” error message.
  • The system limits the maximum LPN count to 24. If users provide any count more than 24, the system displays the following error message; "Maximum LPN Count Limit Reached, Cannot Receive More than 24 LPNs".

UPFRONT PALLETIZE LPNs

A new screen parameter “palletize-upfront” is available in the RF Single SKU receiving module that allows you to palletize LPNs upfront. Palletizing the LPNs on the fly when the LPNs contain the same Inventory-quantity combination will increase floor productivity.

Parameter Values Description 

Blank (default)/No

Does not prompt for the Pallet. Users will not be able to palletize the received LPNs upfront.

Yes

Prompts for the pallet number so that users can palletize the received LPNs upfront.

  • A new hotkey CTRL+E - End pallet is available in the RF Single SKU receiving transaction and visible only when the palletize-upfront Yes

NOTE: If the Palletize upfront parameter is set to blank or NO, the hotkey CTRL+E  will not be visible on the screen.

  • If the LPN prompt behavior = Enter LPN count and Palletize-upfront = Yes, then the system moves all the generated LPNs to the scanned pallet. 

ASSIGN LOCK CODE FOR EXPIRED INVENTORY

A new screen parameter “expired-invn-lockcode” is available from the RF Single SKU receiving transaction. This parameter assigns a lock code automatically when the user receives an expired inventory. This will help users to differentiate expired inventories from the mainstream inventories with the help of the assigned lock code.

Parameter Value Description

Blank (default)

Does not assign any lock code to the LPNs when the user receives an expired inventory. 

Text field

Allows users to define the parameter with a lock code (allocatable or un-allocatable) and thus the system assigns the defaulted lock code to the LPNs when the user receives an expired inventory.

  • When you provide an expiry date prior to the current date and the Allowed Expired Inventory flag on the Shipment type is enabled, the system will display the following warning message: “Inventory already expired, proceed?”.
  • When you define the expired-invn-lockcode screen parameter with an invalid lock code, the system displays the following message, “Expired Inventory, but no valid lock code set in screen param - expired-invn-lockcode”.
  • When you receive an LPN with an expired inventory, the Auto-assign lock code triggers IHT-22 - Lock Container - Before ASN Verification.

The Oracle WMS Cloud has enhanced the RF Single SKU Receiving flow wherein the template-based receiving, the system auto-populate LPNs, support batch number, and expiry date prompts.

Steps to Enable

  1. Go to rf.inbound.cwrfrecvsinglesku module 
  2. Select the screen parameter and click on the module parameter you want to enable:
    1. For UoM, select the quantity-uom > Click Edit and choose from the drop-down.
    2. For pallet upfront, select palletize-upfront > Click Edit and choose from the drop-down.
    3. To print the LPN label, select print-label > Click Edit and choose from the drop-down.
    4. To configure LPN prompt behavior, select lpn-prompt-behavior > Click Edit and choose from the drop-down.
    5. To enable lock code for expiry inventory, click Edit and enter the value in the expired-invn-lockcode field.
  3. Click Save.

Key Resources

Alert User During LPN Substitution

When performing picking of allocated LPNs during the packing process, users may scan and pick an unanticipated LPN instead of the originally allocated LPN due to the close proximity of inventory placed in the warehouse. This leads to the de-allocation of LPNs and may also break the picking sequence during the transaction.

In 20D, the Oracle WMS Cloud has introduced a new messages or alert that triggers in the system when users perform LPN substitution. This provides an opportunity for floor users to control substitution from a different location.

NOTE: Users can accept and proceed with substitution only if these messages are configured as a warning message.

These new messages are applicable via the following transaction:

  • Pack OBLPN (rf.outbound.cwrfpackncoblpn)
  • Pack NC Active Order (rf.outbound.cwrfpackncactiveorder)
  • RF Move LPN (rf.inbound.cwrfmovelpn)

HIGHLIGHTS OF THE ENHANCEMENT

  1. A new message "Do you want to substitute %LPN Number (User scanned LPN number) %"  is displayed when the user scans an unintended IBLPN and substitutes with another LPN from the same location.
  2. A new message "Do you want to substitute %LPN Number  (User scanned LPN number) % from different location" is displayed when the user scans an unintended IBLPN and substitutes with another LPN from a different location. Note: By default, these new messages are enabled and can be configured as Warning message & Error Message. If users do not wish the system to displays this message, can disable. 
  3. By configuring these messages as an error, the system restricts and does not permit users to proceed with the substitution.

This enhancement also provides an ability for the user to restrict such substitution by configuring these messages as an error message.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

Additional Filter Criteria on the User Interface

  • The Origin Code is now exposed to the IB Shipment UI (IBShipmentView) and is available on the data grid on enabling the corresponding column flag from the data selector. This origin code is used to map supplier code from Inventory management and can be added/modified from the Add or Edit modes.
  • The “From Expiry Date” and “To Expiry Date” columns are now exposed in the filter search criteria in the IB Shipment Detail UI for better usability purposes. You can now search for records using the calendar wizard provided in the filter search pane and select the date range for Expiry date using the “From Expiry Date” and “To Expiry Date” field.

Additional filter criteria is added in the IB Shipment (IBShipmentView) UI.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

Default Redwood Theme for WMS Application Pages and Mobile App

Redwood is the new user experience design language that Oracle is rolling out across all of its applications.

  • The Web UI will default to a new Redwood theme; although the earlier themes are also available for the user to change to:
    • The UI also defaults to the Home springboard page with the user’s most commonly needed screens. The user can configure this home screen.
    • The user has the option to go directly to the recent tabs for future logins.
    • The mobile app on Android and iOS also gains the Redwood design language.

SPRINGBOARD AND RECENT TABS VIEW

  • During login, you will be placed in the springboard home page which contains launch icons for frequently used screens. While the springboard home page was introduced last year, prior to 20D, users would not be placed on this page at login, unless they had manually setup the launch icons. If none were setup, the user would have been taken directly to the “Recent” tab view of the application.
  • With the 20D release, this behavior changes slightly to improve the ease of use. If you have never setup the springboard home page before, it will be automatically pre-populated with the top most recently used transactions, or the top entries from your menu if this is the first time you’ve logged in. If you have already setup springboard launch icons, they will remain as is. As a reminder, these springboard launch icons can be manually edited using the settings gear icon to the right on this page.
  • During subsequent logins, if you would like to go directly to the Recent tabs view (bypassing the springboard home page), a checkbox Go to recent tabs at login is available for you to select. Leaving it unselected means you will continue to be placed in the springboard home page upon login.
  • The “star” icon to the right of the search field, in the top of the application page, will take you to the “Recent” tabs view and the “Home” icon to the left of search will take you back to the springboard home page.

Steps to Enable

If you disable the Go to recent tabs on login checkbox, you can click the Home icon to the left of the search bar to return to your Springboard page.

Link to WMS Cloud Application Pages Using Deep Links

Deep Linking in Oracle WMS Cloud provides the ability to launch specific WMS screens using a direct URL.

  • If the external application and WMS are configured with single sign on against the same identity provider, the same user credentials can be used to access these screens.

  • The URL is of the format  https://<domain>/<customer-env-name>/direct/<product>/<module-name>/
    • where module-name can match any module on the modules page where product = ‘wms’ or ‘wfm’.
    • certain wms modules such as InputInterfaceView and ScheduledJobView are not exposed via this mechanism as well as modules belonging to the product ‘common’. These are considered administrative pages not suitable for embedding externally.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

Integration Enhancements

WMS Cloud Lock Code to ERP Inventory Summary Alignment

When integrating Oracle WMS Cloud to ERP systems, the ERP’s inventory system virtually tracks and has visibility to the the inventory in each Oracle WMS Cloud facility.  The ERP System creates Inventory Summary Buckets to track on-hand and available inventory levels; the ERP System should not track the specific stock location of the material or the details of how the material is packed into containers (LPNs/Pallets).

As inventory in the warehouse is subjected for changes due to various operational (quality check, cycle count, etc.) flows, external ERP systems want to know the real time status of the inventory present in the warehouse. External ERP systems maintain ERP buckets at a high level, knowing the ERP bucket associated with the inventory present in the Warehouse allows external ERP systems to plan Order Fulfillment and Order Reservation accordingly.

Prior to 20D, external systems depended on the IHT’s generated by WMS, to determine which bucket to  consider for change based on the information associated with the IHT.

In 20D, WMS is enhanced to define an ERP bucket on the lock code. When Lock Codes are added to or removed from inventory, then the corresponding ERP bucket on the inventory is updated. ERP bucket information associated with the inventory is then relayed back through IHT’s generated during inventory updates. External systems can consume these IHT’s to update the bucket change on the inventory information maintained by them. As Oracle WMS Cloud allows you to define multiple lock codes on the inventory, lock code prioritization logic has been added. You can define priority values on the lock code. Based on the highest priority value, the corresponding ERP bucket is considered.

The following are the major highlights of changes done as part of this enhancement:

LOCK CODE UI

The Inventory Lock Code screen now has an ability to associate an Inventory Bucket (ERP Bucket) and tag a lock code priority.

ERP Bucket: is a free form field where ERP buckets against the lock code can be defined. By default, this field is blank. You can track ERP buckets on the inventory by defining values in this field.

Lock Code Priority: is a numeric field where priority of the lock code can be defined, by default value in this fields is blank. It’s advised to define distinct lock code priority value, when inventory is associated with multiple lock codes then lock code having highest priority is considered for ERP bucket. Lower numeric value is considered as highest priority value.  You should prioritize the lock codes from most restrictive (Priority 1) to least restrictive.

FACILITY AND COMPANY PARAMETERS

  • Two new Facility and Company parameters are available. These parameters will provide ability for the customers to define default ERP buckets for Inbound Inventory and Default ERP bucket for Outbound Inventory, when inventory is not subjected to any lock code or inventory is having operational lock codes which are not defined with any ERP bucket.
  • Facility parameters will take higher precedence over company parameter.
  • Default Facility and Company Parameter for Inbound Inventory is “DEFAULT_ERP_BUCKET_FOR_INBOUND_INVENTORY”.
    • User can define the default ERP bucket for inbound inventory in the above parameter. When inbound inventory does not have lock code or lock code present is not defined with ERP bucket, then system will populate the value from inbound facility parameter.
    • If the facility parameter is set to blank, then the value in the ERP bucket is considered from the Inbound company parameter.
  •  Default Facility and Company Parameter for Outbound Inventory is “DEFAULT_ERP_BUCKET_FOR_OUTBOUND_INVENTORY”.
    • User can define the default ERP bucket for outbound inventory in the above parameter. When inventory associated with outbound LPN does not have any lock code or lock code present is not defined with ERP bucket, then system will populate value from outbound facility parameter.
    • If the facility parameter is set to blank, then value in the ERP bucket is considered from the Outbound company parameter.
    • Customers who wants to maintain same default ERP bucket for both Inbound and Outbound inventory can define same value in the Inbound and Outbound Facility/Company parameters.

INVENTORY HISTORY

Inventory History is now enhanced to display Previous and Current ERP bucket of inventory.

  • Previous ERP Bucket:  Value in this field represents the previous ERP bucket associated with the inventory before the inventory is subjected for update (Lock, Unlock, Adjustments, Inventory transfer etc…).
  • Current ERP Bucket:  Value in this field represents the current ERP bucket associated with the inventory after the inventory is updated (Lock, Unlock, Adjustments, Inventory transfer etc…).
  • Value in the Previous ERP Bucket can be blank and Current ERP bucket is populated or Current ERP bucket will have value and Previous ERP bucket is populated or Both Current and Previous ERP bucket will have value.
  • Values in Previous and Current ERP bucket are derived based on the lock code associated with the inventory, if lock codes are not present then default value from Facility/Company parameter is considered.
  • All the IHT’s are not subjected for ERP Bucket population, only IHT’s which impact inventory change are subjected for ERP Bucket value population. Refer the appendix section to know the IHT’s which are subjected for ERP bucket change.
  • There are transactions which results in multiple IHT’s, user should consider all the generated IHT’s for ERP bucket processing to know the final state.
  • Inventory History file that is generated will now have Previous ERP bucket, Current ERP bucket and the lock code priority fields.
  • Lock Code Priority value on the IHT is populated only for Lock/ Unlock container IHT’s.

UPGRADE NOTES

  • Customers who are updating to 20D, will have Previous and Current ERP bucket value as blank on IHT’s as ERP Bucket will not be present on the Lock Code and Default Facility/Company parameters.

LOCK CODE PRIORITY

When inventory is subjected for multiple lock codes, then there comes the question of ERP bucket from which lock code needs to be considered against the inventory. To overcome this scenario, WMS is enhanced to determine priority associated with the Lock Code and consider ERP bucket from highest priority lock code.

  • New Company Parameter “HONOR_LOCK_CODE_PRIORITY” is available. To enable Lock Code Priority logic value should be set to Yes. Default value in this parameter is blank (No).

The following table describes the behavior for Company Parameter honor_lock_code_priority:

Company Parameter honor_lock_code_priority set to: Description

Yes

  • ERP bucket corresponding to the lock code with highest priority is picked up while writing inventory history. Lock Code priority is used while determining the ERP bucket.
  • If new lock code is applied on the inventory, then previous ERP bucket value is based on the highest priority lock code present on inventory prior to new lock being applied. Current ERP bucket value is based on the highest priority lock code present on inventory after lock is applied.
  • If existing lock code is removed from the inventory, then previous ERP bucket value is based on the highest priority lock code present on inventory prior to lock being removed. Current ERP bucket value is based on the highest priority lock code present on the inventory after lock is removed.
  • Previous and Current ERP bucket on the inventory can be same when inventory is having highest priority lock code and new lock getting applied or removed on the inventory is of lower lock code priority.
  • If inventory is being adjusted, then the Previous and Current ERP bucket is determined by considering the existing lock codes on the inventory.
  • If Inventory history has old and new lock codes populated, then lock codes are ordered based on descending order of the lock code priority value.
  • If inventory has multiple lock codes with conflicting lock code priority, then ERP bucket is picked up from the lock code which was applied last.
  • Lock Codes are ordered based on lock code priority value.
  • Lock applied on the container also having batch lock (if underlying inventory has batch lock) is considered while determining ERP bucket. ERP bucket is determined by considering the locks present on the container/location and the batch lock.
  • If highest priority lock code on the inventory is not defined with ERP bucket, then ERP bucket value is considered from default Facility/Company parameter.

No

  • Customers who don’t want to use priority defined on the lock code for ERP bucket consideration, can set the value to No (Default value) in this parameter.
  • When value is set to No, the ERP bucket is determined based on the order in which the lock code is applied. ERP bucket corresponding to the last applied lock code is considered.
  • Lock applied on the container and the batch lock (if underlying inventory has batch lock) is considered while determining ERP bucket. If inventory being dealt with has container/active location lock and batch lock, then ERP bucket is determined by giving priority to batch lock.
  • If new lock code is applied on the inventory, then previous ERP bucket value is based on the last applied lock code on inventory prior to new lock being applied. Current ERP bucket value is based on the new lock code applied.
  • If existing lock code is removed from the inventory, then previous ERP bucket value is based on the last applied lock code present on inventory prior to lock being removed. Current ERP bucket value is based on the last applied lock code present on inventor   after lock is removed.
  • If inventory is being adjusted, then Previous and Current ERP bucket is determined by considering the existing lock codes on the inventory.
  • If Inventory history has old and new lock codes populated, then lock codes are ordered based on the ascending order of lock code applied timestamp.

OUTPUT INTERFACE

Shipment Verification:

  • Shipment verification file has been enhanced to include the lock codes present on the LPN during shipment verification and the ERP bucket. If multiple lock codes are present on inbound LPN then corresponding lock codes are separated with a delimiter. ERP bucket is determined by considering the lock code priority or based on last lock code applied.

Ship Load (SLS):

  • Ship Load (SLS) file has been enhanced to include the lock codes present on the OBLPN during Ship Load and the ERP bucket. If multiple lock codes are present on outbound LPN then the corresponding lock codes are separated with a delimiter. ERP bucket is determined by considering the lock code priority or based on last lock code applied.

Lock Code Configuration:

  • Facility Parameter “DEFAULT_ERP_BUCKET_FOR_INBOUND_INVENTORY” is set to “AVAILABLE”
  • Company Parameter “honor_lock_code_priority” is set to Yes

Lock Code Configuration is as defined below:

Scenario: the following example depicts the inventory flow from one bucket to other bucket when LPN is applied with multiple lock codes.

LPN is received in the warehouse with default Pending Putaway Lock Code, Inventory is moved to Pending Putaway bucket:

Inventory is located to reserve location in the warehouse, where pending putaway lock code is removed and inventory is moved to default available bucket.

Lock Code Cycle Count is applied, now inventory is moved to Cycle Count bucket.

Again, Lock Code Damage is applied, now inventory is moved to damage bucket as the Damage lock code has the highest priority.

FEATURE USAGE GUIDELINES

  • Existing users who don’t want to track ERP bucket, then ERP bucket value should not be configured on the Lock Codes and Default Facility/Company parameter for ERP buckets.
  • Customer must decide when inventory is subjected to multiple lock codes then ERP bucket should be considered based on lock code priority or lock code applied sequence, based on that Honor Lock Code Priority company parameter should be set.
  • When company parameter Honor Lock Code Priority is enabled, then lock code priority should be populated with proper numeric value and care should be taken in setting up the value. Blank value on the lock code priority column will have lesser weightage compared to lock codes with numeric value.
  • If Lock Codes are not defined with ERP Bucket, then system will consider default ERP bucket from Inbound Facility parameter for inbound inventory and default ERP bucket from Outbound Facility parameter for outbound inventory.
  • If highest priority lock code is not defined with ERP bucket, then value is considered from default facility/company parameters
  • Changing the ERP bucket and lock code priority once set might cause issues in regard to integration set up. Newly reflected ERP bucket value is considered for future Inventory History records that are written and not for previously created records.
  • Default ERP bucket is considered when there is no outstanding lock code on the inventory being dealt with.
  • It’s suggested not to have conflicting priority for lock codes, If multiple lock codes on the inventory have same priority then ERP bucket is picked up from the lock code that was applied last.
  • Populating ERP Bucket with names such as (Prevent Loading, Unavailable for Allocation) alone will not prevent inventory for allocation or Loading. Corresponding Lock code properties should be set for WMS to achieve those operations.
  • Considering Adjusted Quantity/ Original Quantity for ERP bucket are based on the IHT’s.
  • For existing customers, who are using lock codes which are not defined with ERP bucket for them previous/current ERP bucket will not be populated.

The following are the list of transactions where ERP bucket value is considered from default Facility/Company parameters even though lock codes are populated on the IHT’s. During those transactions, the system writes Lock Inventory History Transactions, to avoid double dipping of the inventory in the ERP bucket this change is done.

Activity Inventory History Transaction

Container Received with default lock code

System will populate the lock codes on the IHT with respect to receiving (IHT- 1 and IHT- 72), even though the receiving inventory is subjected to lock, but current ERP bucket is populated from facility parameter “DEFAULT_ERP_BUCKET_FOR_INBOUND_INVENTORY ".

Container Creation with default lock code:

When you create a container with a default lock code, then system writes IHT for the container creation (IHT 29 -Create Allocatable Container / IHT 30 -Create Unallocatable Container) by populating a default lock code on it, but current ERP bucket value is populated from facility parameter " DEFAULT_ERP_BUCKET_FOR_INBOUND_INVENTORY "

Container Shipped IHT

When a container with a lock code is shipped, then system populates the lock codes in the IHT-3 Container Shipped.

Inventory Movement to Active Location

When inventory is moved to an active location which is having a lock code, then system will populate the lock code in the Inventory adjustment IHT (IHT- 4 / IHT- 17) for active location, but current ERP bucket value is populated from facility parameter " DEFAULT_ERP_BUCKET_FOR_INBOUND_INVENTORY "

Inventory Transfer from IB to OB

The system now writes the Unlock Container IHT (24 or 25) when inbound inventory with a lock code is transferred to an outbound container.

  • Inventory History (IHT 63 - Lock Update Pre-verification and IHT 64 - Lock Update Post-verification).
  • WMS populates ERP bucket on IHT 63/64 during lock update, ERP bucket populated on this IHT act’s like summary of bucket transfer with respect to subsequent adjustment IHT’s.

It’s advised that:

  • If IHT63 and 64 are considered for ERP bucket processing, then ignore subsequent inventory adjustment IHT’s for correct flow of inventory from one bucket to another bucket.
  • If IHT63 and 64 are not considered for ERP bucket processing, then consider subsequent inventory adjustment IHT’s for correct flow of inventory from one bucket to another bucket.
  • On considering IHT 63 and 64 along with subsequent inventory adjustment IHT’s will result in improper movement of inventory from one bucket to another bucket.
  • Additional reference fields are added on the IHT’s (Inbound inventory adjustment IHT’s) such as ERP Vendor ID, Vendor Site ID, Unlock on Locate etc… Refer to the IHT Trigger Point Document for details.

Inventory History Transactions subjected for ERP Bucket

For more details on previous and current ERP bucket population for the following list if IHT’s, refer to the interface specification (IHT Trigger Point Document).

Inventory History Transaction Description

IHT 1

 LPN Received

IHT 2

 Container Consumed

IHT 3

 Container Shipped

IHT 4

 Inventory Adjusted pre verification

IHT 10

 Container Detail Packed

IHT 11

 Container Packed

IHT 14

 Container Cancelled

IHT 16

 Pre receive inventory Adjusted pre verification

IHT 17

 Inventory Adjusted Post verification

IHT 19

 Inventory Adjustment Cycle Count Active

IHT 22

 Lock Container Before ASN Verification

IHT 23

 Lock Container After ASN Verification

IHT 24

 Unlock Container Before ASN Verification

IHT 25

 Unlock Container After ASN Verification

IHT 29

 Create Allocatable Container

IHT 30

 Create Unallocatable Container

IHT 31

 OB Container Modified

IHT 32

 OB Container Cancelled

IHT 34

 Split Container Before ASN Verification

IHT 35

 Split Container After ASN Verification

IHT 36

 Split Container Lock Acquired

IHT 49

 Lock Active

IHT 50

 Unlock Active

IHT 52

 Audit Adjustment

IHT 53

 Cycle Count Reserve SKU Counted

IHT 54

 Container Detail Picked

IHT 62

 POS Interface

IHT 63

 Lock Update Pre verification

IHT 64

 Lock Update Post verification

IHT 65

 Lock OBLPN

IHT 66

 Unlock OBLPN

IHT 69

 Kitting Complete

IHT 70

 Kitting Inventory Consumed

IHT 72

 Container Received Subject to QC

Steps to Enable

You need to configure the following:

  1. ERP Bucket in the Lock Code Field.
  2. Set Lock Code priority in the Lock Code Field to prioritize lock code based on lock code priority value. (Applicable when inventory has multiple lock codes.) 
  3. Default ERP Bucket should be configured in Facility and Company parameters.
  4. Company Parameter Honor Lock Code Priority should be set to Yes (Applicable when inventory has multiple lock codes) to prioritize lock code based on lock code priority value.

Key Resources

GET Available Warehouse Location for Putaway Using a REST API

Previously, you were only able to perform putaway using RF Putaway.  The Directed Putaway Location API now allows you to determine the putaway location for a given Inbound LPN or Pallet via a POST request, so that you can locate the LPN/Pallet to its respective destination.

You can determine the putaway location for an IBLPN using the following POST request:

POST .../entity/iblpn/directed_putaway_location/

You can determine the putaway location for a pallet using the following POST request:

POST .../entity/pallet/directed_putaway_location/

NOTE: Oracle WMS Cloud will check the putaway type associated with the  IBLPN/ Pallet and check the respective putaway method priority configured for the putaway type.  The system then determines the putaway location honoring the putaway method priority rule.

RECALCULATE PUTAWAY TYPE

Request Options Parameters

Name Required Type Default Description

recalculate_putaway_type_flg

 

Boolean

 False

 

validate_critical_dimensions_flg

 

Boolean

False

 

NOTE: Parameter: validate_critical_dimensions is only applicable for the IBLPN entity.

In addition to determining the putaway location, the Directed Putaway Location API can perform the  following tasks:

  • As there may be chances that the putaway type rule or the putaway type on the container may be manually updated, when recalculate_putaway_type_flg is set to true, this API will recalculate the putaway type which allows you to get the correct putaway type for an IBLPN and therefore the exact/correct putaway location.
  • When set to false/no, if the IBLPN has a putaway type, then the system will use the Putaway type from the IBLPN to determine location.
  • When the Validate Critical Dimension value (optional parameter) is set to True, the system will perform critical dimension checks for the incoming IBLPN only (Not for Pallet) along with the location dimension.

PUTAWAY TYPE DETERMINATION

The system will determine the putaway type for a single sku IBLPN in the following sequence:

  • Inbound LPN
  • Putaway type from Putaway Type Determination Rule
  • Item Facility
  • Item
  • Facility parameter "PUTAWAY_TYPE"

The system will determine the putaway type for a multi-sku IBLPN in the following sequence:

  • When the Facility Parameter "TRIGGER_PATYPE_RULES_FOR_MSKULPN" is True then the Putaway type is determined from: 
    • Putaway Type Determination Rule
    • Item facility
    • Item
    • When the Facility Parameter "TRIGGER_PATYPE_RULES_FOR_MSKULPN"  is False then the Putaway type is determined from:
      • Facility Parameter "DEFAULT_MULTI_SKU_LPN_PATYPE"

Steps to Enable

Review the REST service definition in the REST API guides, available from the Oracle Help Center > your apps service area of interest > REST API. If you're new to Oracle's REST services you may want to begin with the Quick Start section.

Additional Categories in Web Reports Gen 2

Some Web Reports users may need to build reports with various user access information including user change history. To support additional reporting capabilities in Web Reports Gen 2, the following two new entities have been added:

Web Reports Entity

Function

ENTITY_CHANGE_HISTORY

Allows you to report changes to users in the system.

COMMON_LOG

Allows you to report logins and logouts.

NOTE:

  • For ENTITY_CHANGE_HISTORY, filter the records that have an "entity" field that contains 'USER'.

  • For COMMON_LOG, filter records that have a "module" field value of 'LOGIN' or 'LOGOUT'.

Filtering Web Reports

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

Web Reports Optimization for Date/Time Functions

An optional feature is available in Oracle WMS Cloud that optimizes the performance of Web Reports that use facility timestamps in its filters. This feature is controlled via a company parameter WR2_EVAL_FORMULAS_IN_DB. This parameter defaults to no.

However, if set to yes, the new feature is turned on and this pushes the evaluation of filters to the database that speed up the overall performance of the report.

Steps to Enable

To enable performance optimization for date/time functions,  set the company parameter "WR2_EVAL_FORMULAS_IN_DB" to yes.

Key Resources

Support ISO-8601 Format Date/Time Values

A new company parameter ENABLE_ISO_8601_OUTPUT_DATE_TIME_FORMAT is available in Oracle WMS Cloud that gives users the ability to control the output format of date/time values in Inventory History and Shipped Load output. This will allow for all date/time output to be in the widely accepted and used ISO-8601 standard. This standard will not only give date, time, and date/time consistency across the output data, but it will provide the time zone offset from UTC as part of the date/time format. The addition of the time zone context into the date/time value will allow external systems to know the actual time zone value and will remove any ambiguity.

The ISO-8601 standard is a widely used and accepted format for exchanging date/time information between systems.

Type Format Example

Date

yyyy-mm-dd

2020-08-01

Time

HH:MM:SS

15:01:30

Datetime

yyyy-mm-ddTHH:MM:SSz

2020-08-01T15:01:30-04:00

Format Definition

YYYY

4 digit year

MM

2 digit month

DD

2 digit day

T

The literal letter "T" used as a delimiter between the date and time components.

HH

2 digit hour (24-hour clock)

MM

2 digit minute

SS

2 digit seconds

z

Time zone offset from UTC in the format (+/-)HH:MM

Steps to Enable

In order to enable control of the output format for date/time values, set the company parameter ENABLE_ISO_8601_OUTPUT_DATE_TIME_FORMAT parameter to "yes"/"true".

Key Resources

Update Active Inventory for Serialized Product Using a REST API

The Update Active Inventory API allows you to adjust the quantity in an active location for a specific item/inventory. Only a single location and item may be updated per request. In update 20D, this API has been enhanced to accept serial numbers to cater to serial number tracked inventories.

As part of this update, you can now adjust serial number tracked inventory for incremented/decremented adjustments. You can send adjustment or actual quantity in the request to update the location’s inventory. In either case, the number of serial numbers sent should be distinct to each unit of the inventory being updated.

For positive adjustments, the serial numbers sent can be:

  • New serial numbers (or)
  • Serial numbers existing in the warehouse that are delinked and not associated with any other inventory

For negative adjustments, the serial numbers sent should be the ones that are already present in the location where inventory is being updated.

The following is an example body for serial number adjustments:

{

"parameters": {

"facility_id__code": "FAC-1",

"barcode": "LOCN1"

},

"options": {

"item_barcode": "ITEM1234",

"adjustment_qty": -3,

"batch_nbr": "BATCH1234",

"invn_attr_a": "A",

"invn_attr_b": "B",

"reason_code": "RC",

"transaction_ref_nbr": "TX123457890",

"serial_nbr_list": [

"SrlNbr1",

"SrlNbr2",

"SrlNbr3"

]

}

}

NOTE:  The serial number is required only if the item being adjusted is tracked for serial numbers.

Steps to Enable

Review the REST service definition in the REST API guides, available from the Oracle Help Center > your apps service area of interest > REST API. If you're new to Oracle's REST services you may want to begin with the Quick Start section.

Update Location Counted to Be Counted Flag Using a REST API

There are some warehouse scenarios where an external system such as a slotting or inventory management system can request counting for a certain location. To facilitate triggering of inventory count in a location by external systems, the PATCH Location API (.../lgfapi/v10/entity/location/)  has been enhanced to update cycle count related fields.

Previously, you could only update some custom fields for the Location entity.  Now, the 'to_be_counted_flg' and 'to_be_counted_ts' fields have been added as part of the PATCH request for the Location entity. Once these inputs are sent, the user can count locations in tasked/non-tasked mode. The following table shows the data types and formats for these fields:

Field Data Type Valid Values/Formats

to_be_counted_flg

boolean

  • true
  • false

to_be_counted_ts

date and time

All Date-time objects are assumed to be in the time zone of the user's facility context.

JSON: {"field_ts": "2018-01-30T18:30:00"}} XML: <field_ts>2018-01-30T18:30:00</field_ts>

The following is an example body for the To Be Counted flag:

{

"fields":

{

"cust_field_1": "Test1",

"cust_field_2": "Test2",

"cust_field_3": "Test3",

"cust_field_4": "Test4",

"cust_field_5": "Test5",

"to_be_counted_flg": "true",

"to_be_counted_ts": "2020-07-29T18:30:00"

}

}

NOTE:  If a location was previously due for counting (To be counted flag = yes) and had a cycle count task and API updates result in the location being updated with the To be counted flag = no, then the cycle count task will NOT be cancelled automatically. You need to identify these tasks and cancel them if needed.

Create a Task Template with To be Counted TS

A new field, Location-To be counted TS has been added to the selection criteria in Task Creation Template where Task Type = CC. You can now create a task template with 'To be counted TS' configured as the search criteria option.

Steps to Enable

Review the REST service definition in the REST API guides, available from the Oracle Help Center > your apps service area of interest > REST API. If you're new to Oracle's REST services you may want to begin with the Quick Start section.

Locate LPN or Pallet to Location Using a REST API

In addition to the current option to locate an LPN or Pallet from the RF Locate LPN transaction, you can now locate an LPN/ Pallet to its respective destination location with the Locate LPN/Pallet API.

You can locate an Inbound or Outbound LPN to its respective destination using the following POST requests:

Inbound LPN

POST .../entity/iblpn/{id}/locate/

POST .../entity/iblpn/bulk_locate/

Outbound LPN

POST .../entity/oblpn/{id}/locate/

POST .../entity/oblpn/bulk_locate/

Example requests for Locate IBLPN and OBLPN:

POST .../entity/iblpn/bulk_locate/

{

"parameters": {

"id__in": [1, 2, 3]

},

"options": {

"location_barcode": "R1-R2-RB1-Rl1",

"depalletize_on_putaway": false

}

}

POST .../entity/oblpn/bulk_locate/

{

"parameters": {

"container_nbr__in": ["LPNPTW0102"]

},

"options": {

"location_barcode": "R1-R2-RB1-Rl1",

"depalletize_on_putaway": false

}

}

You can locate a Pallet to its respective destination using the following POST requests:

Pallet

POST .../entity/pallet/{id}/locate/

POST .../entity/pallet/bulk_locate/

Example Request for Locate Pallet:

POST .../entity/pallet/bulk_locate/

{

"parameters": {

"id__in": [1, 2, 3]

},

"options": {

"location_barcode": "R1-R2-RB1-Rl1",

"depalletize_on_putaway": false

}

}

Parameters

Name Required Type Default Description

facility_id

 

Integer

 

Facility context by id.

facility_id__code

 

String

 

Facility context by code.

company_id

 

Integer

 

Company context by id.

company_id__code

 

String

 

Company context by code.

container_nbr

 

String

 

 The allowed parameter filter conditions are "container_nbr" and "container_nbr__in"

id

 

Integer

 

The allowed parameter filter conditions are "id" and "id__in":

Request Options Parameters

Name Required Type Default Description

location_barcode

 X

String

   

depalletize_on_putaway

 

Boolean

False

 

Steps to Enable

Review the REST service definition in the REST API guides, available from the Oracle Help Center > your apps service area of interest > REST API. If you're new to Oracle's REST services you may want to begin with the Quick Start section.

Update Orders with Ship Via and Shipment Number Using a REST API

The Update Parcel Shipment Info API allows you to associate Oracle WMS Cloud (WMS) orders with the appropriate ship-via and Oracle Transportation and Global Trade Management (OTM’s) planned shipment number.

You can update Parcel Shipment Information using the following POST request:

POST ..lgfapi/v10/order_hdr/update_parcel_shipment_info/

NOTE: The order status must be LOADED.

FILTER FIELDS 

You can update each of the following fields using the API for a specific order:

  • facility_code (optional)
  • company_code (optional)
  • One of the following combinations is required:
    • order nbr
    • Also support "in" ("__in=")
  • erp_source_hdr_ref, erp_source_system_ref, order_dtl.erp_source_line_ref, and order_dtl.erp_source_shipment_ref
  • order_dtl.erp_fulfillment_line_ref
    • Also support "in" ("__in=")
  • tms_order_hdr_ref
    • Also support "in" ("__in=")

PARAMETERS

You can update the following input field values on the matching order_hdr:

  • ship_via_code
    • Lookup ship via using the ship_via_code.
  • tms_parcel_shipment_nbr
  • tms_order_hdr_ref

TMS  PARCEL SHIPMENT NUMBER ACTION BUTTON AND FIELD ADDED TO ORDER HEADER UI

The TMS Parcel Shipment Number field has been added to the WMS Order Header UI and it is accessible via an order_hdr entity GET request.

  • You can edit the TMS Parcel Shipment Number field for orders in CREATED status.

A new action button Reset TMS Parcel Shipment Number is also now available from the Order Header UI. This button is enabled only if the TMS Parcel Shipment Number field has a value and the order status is in a status before LOADED.

Steps to Enable

Review the REST service definition in the REST API guides, available from the Oracle Help Center > your apps service area of interest > REST API. If you're new to Oracle's REST services you may want to begin with the Quick Start section.

Expand Custom Fields in Inbound Shipment Interface and Inbound Shipment Verification Output

The following fields are added to STAGE_IB_SHIPMENT and STAGE_IB_SHIPMENT_DTL tables and also available in the IB Shipment interface allowing users to create/update the IB Shipments with the values populated through CREATE, UPDATE, and DTLUPDATE action code.

Table Name Column Name

STAGE_IB_SHIPMENT

CUST_DATE_1

STAGE_IB_SHIPMENT

CUST_DATE_2

STAGE_IB_SHIPMENT

CUST_DATE_3

STAGE_IB_SHIPMENT

CUST_DATE_4

STAGE_IB_SHIPMENT

CUST_DATE_5

STAGE_IB_SHIPMENT

CUST_DECIMAL_1

STAGE_IB_SHIPMENT

CUST_DECIMAL_2

STAGE_IB_SHIPMENT

CUST_DECIMAL_3

STAGE_IB_SHIPMENT

CUST_DECIMAL_4

STAGE_IB_SHIPMENT

CUST_DECIMAL_5

STAGE_IB_SHIPMENT

CUST_NUMBER_1

STAGE_IB_SHIPMENT

CUST_NUMBER_2

STAGE_IB_SHIPMENT

CUST_NUMBER_3

STAGE_IB_SHIPMENT

CUST_NUMBER_4

STAGE_IB_SHIPMENT

CUST_NUMBER_5

STAGE_IB_SHIPMENT

CUST_LONG_TEXT_1

STAGE_IB_SHIPMENT

CUST_LONG_TEXT_2

STAGE_IB_SHIPMENT

CUST_LONG_TEXT_3

STAGE_IB_SHIPMENT

CUST_SHORT_TEXT_1

STAGE_IB_SHIPMENT

CUST_SHORT_TEXT_2

STAGE_IB_SHIPMENT

CUST_SHORT_TEXT_3

STAGE_IB_SHIPMENT

CUST_SHORT_TEXT_4

STAGE_IB_SHIPMENT

CUST_SHORT_TEXT_5

STAGE_IB_SHIPMENT

CUST_SHORT_TEXT_6

STAGE_IB_SHIPMENT

CUST_SHORT_TEXT_7

STAGE_IB_SHIPMENT

CUST_SHORT_TEXT_8

STAGE_IB_SHIPMENT

CUST_SHORT_TEXT_9

STAGE_IB_SHIPMENT

CUST_SHORT_TEXT_10

STAGE_IB_SHIPMENT

CUST_SHORT_TEXT_11

STAGE_IB_SHIPMENT

CUST_SHORT_TEXT_12

STAGE_IB_SHIPMENT_DTL

CUST_DATE_1

STAGE_IB_SHIPMENT_DTL

CUST_DATE_2

STAGE_IB_SHIPMENT_DTL

CUST_DATE_3

STAGE_IB_SHIPMENT_DTL

CUST_DATE_4

STAGE_IB_SHIPMENT_DTL

CUST_DATE_5

STAGE_IB_SHIPMENT_DTL

CUST_DECIMAL_1

STAGE_IB_SHIPMENT_DTL

CUST_DECIMAL_2

STAGE_IB_SHIPMENT_DTL

CUST_DECIMAL_3

STAGE_IB_SHIPMENT_DTL

CUST_DECIMAL_4

STAGE_IB_SHIPMENT_DTL

CUST_DECIMAL_5

STAGE_IB_SHIPMENT_DTL

CUST_NUMBER_1

STAGE_IB_SHIPMENT_DTL

CUST_NUMBER_2

STAGE_IB_SHIPMENT_DTL

CUST_NUMBER_3

STAGE_IB_SHIPMENT_DTL

CUST_NUMBER_4

STAGE_IB_SHIPMENT_DTL

CUST_NUMBER_5

STAGE_IB_SHIPMENT_DTL

CUST_LONG_TEXT_1

STAGE_IB_SHIPMENT_DTL

CUST_LONG_TEXT_2

STAGE_IB_SHIPMENT_DTL

CUST_LONG_TEXT_3

STAGE_IB_SHIPMENT_DTL

CUST_SHORT_TEXT_1

STAGE_IB_SHIPMENT_DTL

CUST_SHORT_TEXT_2

STAGE_IB_SHIPMENT_DTL

CUST_SHORT_TEXT_3

STAGE_IB_SHIPMENT_DTL

CUST_SHORT_TEXT_4

STAGE_IB_SHIPMENT_DTL

CUST_SHORT_TEXT_5

STAGE_IB_SHIPMENT_DTL

CUST_SHORT_TEXT_6

STAGE_IB_SHIPMENT_DTL

CUST_SHORT_TEXT_7

STAGE_IB_SHIPMENT_DTL

CUST_SHORT_TEXT_8

STAGE_IB_SHIPMENT_DTL

CUST_SHORT_TEXT_9

STAGE_IB_SHIPMENT_DTL

CUST_SHORT_TEXT_10

STAGE_IB_SHIPMENT_DTL

CUST_SHORT_TEXT_11

STAGE_IB_SHIPMENT_DTL

CUST_SHORT_TEXT_12

Also, the following additional fields are added in the shipment verification output interface in order to enable host systems to validate the receipt.

Interface section XML Element

ib_shipment_hdr

cust_date_1

ib_shipment_hdr

cust_date_2

ib_shipment_hdr

cust_date_3

ib_shipment_hdr

cust_date_4

ib_shipment_hdr 

cust_date_5

ib_shipment_hdr 

cust_decimal_1

ib_shipment_hdr 

cust_decimal_2

ib_shipment_hdr 

cust_decimal_3

ib_shipment_hdr 

cust_decimal_4

ib_shipment_hdr 

cust_decimal_5

ib_shipment_hdr 

cust_number_1

ib_shipment_hdr 

cust_number_2

ib_shipment_hdr 

cust_number_3

ib_shipment_hdr 

cust_number_4

ib_shipment_hdr 

cust_number_5

ib_shipment_hdr 

cust_long_text_1

ib_shipment_hdr 

cust_long_text_2

ib_shipment_hdr 

cust_long_text_3

ib_shipment_hdr

cust_short_text_1

ib_shipment_hdr

cust_short_text_2

ib_shipment_hdr

cust_short_text_3

ib_shipment_hdr

cust_short_text_4

ib_shipment_hdr

cust_short_text_5

ib_shipment_hdr

cust_short_text_6

ib_shipment_hdr

cust_short_text_7

ib_shipment_hdr

cust_short_text_8

ib_shipment_hdr

cust_short_text_9

ib_shipment_hdr

cust_short_text_10

ib_shipment_hdr

cust_short_text_11

ib_shipment_hdr

cust_short_text_12

ib_shipment_dtl

cust_date_1

ib_shipment_dtl

cust_date_2

ib_shipment_dtl

cust_date_3

ib_shipment_dtl

cust_date_4

ib_shipment_dtl

cust_date_5

ib_shipment_dtl

cust_decimal_1

ib_shipment_dtl

cust_decimal_2

ib_shipment_dtl

cust_decimal_3

ib_shipment_dtl

cust_decimal_4 

ib_shipment_dtl

cust_decimal_5 

ib_shipment_dtl 

cust_number_1

ib_shipment_dtl 

cust_number_2

ib_shipment_dtl 

cust_number_3

ib_shipment_dtl 

cust_number_4

ib_shipment_dtl 

cust_number_5

ib_shipment_dtl 

cust_long_text_1

ib_shipment_dtl 

cust_long_text_2

ib_shipment_dtl

cust_long_text_3

ib_shipment_dtl

cust_short_text_1

ib_shipment_dtl

cust_short_text_2

ib_shipment_dtl

cust_short_text_3

ib_shipment_dtl

cust_short_text_4

ib_shipment_dtl

cust_short_text_5

ib_shipment_dtl

cust_short_text_6

ib_shipment_dtl

cust_short_text_7

ib_shipment_dtl

cust_short_text_8

ib_shipment_dtl

cust_short_text_9

ib_shipment_dtl

cust_short_text_10

ib_shipment_dtl

cust_short_text_11

ib_shipment_dtl

cust_short_text_12

New fields are added in IB Shipment and Shipment Verification Output interface files.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

Updates to WMS Cloud to SCM Cloud Integrator

Support for WMS Cloud Lock Code to ERP Inventory Summary Bucket Alignment on Purchase Order Receipt Confirmation and Inventory Transactions

In order to ease the process of inventory transactions between the ERP system and Oracle WMS Cloud, enhancements are now available in 20D that allows customers to utilize the relevant services in SCM integration with respect to ERP bucket changes. For more details on the ERP Bucket enhancement, refer to the WMS Cloud Lock Code to ERP Inventory Summary Alignment section

The following are highlights of the pre-build integration enhancement to support the configuration of Sub-Inventory:

  • Previously, the pre-built integration was tied to the integration - Received and Stores. In 20D, the pre-built integration now supports a configurable Sub-Inventory that is dynamically accepted.  
  • Oracle Inventory Management Cloud Sub-Inventory is now mapped to Oracle WMS Cloud (Previous and Current ERP bucket) in the Inventory History Transaction (IHT) via SubinventoryCode (Previous) and TransferSubinventory (Current) field.
  •  Configuring inventory Lock Code priority to lock inventory during the receipt "pending putaway" with the code name "PP" is now removed. That is, the restriction of applying lock code with "PP" code is relaxed. Customers now have the flexibility to define their preferred lock code.
  • Oracle WMS Cloud has the ability to send ERP buckets in the SLS payload. This SLS payload contains ERP Bucket which is used by the integration service to map with Sub-Inventory of the Oracle Inventory Management Cloud.
  • You can perform post receipt corrections before Putaway including:
    • Change of batch/ expiry/ serial number
    • Transfer of inventory from 1 LPN to another

NOTE: Modification of attributes like Batch and Serial before Putaway are supported only under certain conditions.

  • Additional IHTs are handled by the Oracle WMS Cloud and SCM Integration with respect to Oracle Inventory Management Cloud.

FEATURE GUIDELINES:

  • Customers willing to utilize the Oracle Integration Cloud features must-have OIC Integration v20D with Oracle WMS Cloud v20D and later version installed. 
  • Lock Code Priority on Lock Code should be configured appropriately based on business needs.
  • The ERP bucket value on lock code and ERP bucket value with corresponding facility and company parameter should match with appropriate Sub-Inventory name in Oracle Inventory Management Cloud.
  • Changes to ERP bucket value in Oracle WMS Cloud will not change the Sub-Inventory name in Oracle Inventory Management Cloud or vice versa.
  • Changing the priority value or ERP bucket on lock code in Oracle WMS Cloud with the pending transactions can cause discrepancies in the inventory bucket.
  • It’s recommended to have a single Receiving  Sub-Inventory in Oracle Inventory Management Cloud and Sub-Inventory for Integration to work.

NOTE: Multiple lock code should not carry Unlock on Locate (UOL) flag set to Yes in Oracle WMS Cloud.

  • Output File Format Configuration for Inventory History and Ship Confirmation payload should be as per 20D.
  • If an item is a serial number tracked and to share this serial number with Oracle Inventory Management Cloud, the customer should enable the corresponding Inventory History (relevant for integration) to break by Serial number.

SCM INTEGRATION – ERP BUCKET ENHANCEMENT

The following changes are applicable for customers running on the latest 20C OIC integration and current 20D OIC integration version build.

  1. The corresponding ERP bucket with the "PP" lock code should be populated with the "Received" value.
  2. The default company parameter for Inbound ("DEFAULT_ERP_BUCKET_FOR_INBOUND_INVENTORY") and Outbound ("DEFAULT_ERP_BUCKET_FOR_OUTBOUND_INVENTORY") should be configured with “Stores” value.
  3. All the lock codes applied post-Putaway with Unlock on Locate (UOL) set to No should have corresponding ERP bucket populated with "Stores" value.

SCM INTEGRATION SERVICE ENHANCEMENT

The following section describes the corresponding changes in integration services:

Receipt Confirmation for Purchase Orders Service

  1. Prior to 20D, updates to Receiving Sub-Inventory was achieved with one Sub-Inventory called "Received". In 20D, the requirement for a single Receiving Sub-Inventory still holds good but the Receiving Sub-Inventory name not associated with the keyword "Received". The Receiving Sub-Inventory is configured on a lock code via ERP bucket field in Oracle WMS Cloud. The corresponding lock code should have Unlock on Locate (UOL) flag set to Yes. The Oracle Inventory Management Cloud integration utilizes IHT 1 or 72 to update the corresponding Receiving Sub-Inventory through ref field -16 (REB).
  2. Change of Sub-Inventory from "Received" to "Stores" was happening through Putaway process based upon lock code called "PP". Dependency for a lock code tied to code name “PP” is removed. In 20D, customers can configure any lock code without depending on the keyword "PP" as long as Unlock on Locate (UOL) is set to Yes.

The SCM integrator utilizes the Unlock on Locate (UOL) flag value to determine whether the Receiving Sub-inventory needs to be updated or not. Then, Oracle WMS Cloud exposes the Unlock on Locate (UOL) value from the lock code in the ref field - 16 (UOL).

  • If Receipt Confirmation for Purchase Order’s Unlock on Locate (UOL) value is set to "Yes", the service interprets as modification required for Receiving Sub-Inventory.
  • If Receipt Confirmation for Purchase Order’s Unlock on Locate (UOL) value is set to "Removed", the service performs Putaway (movement of inventory from configurable Receiving Sub-inventory to Storage Sub-inventory). 

NOTE: Prior to this change, integration service was dependent upon following IHT (24 or 25 along with 51) or IHT (24 or 25 along with 4) combination. Now, this dependency of the IHT combination is replaced by looking at the Unlock on Locate (UOL) value "Removed".

IMPORTANT: Receipt Confirmation for Purchase Order service will not process IHT with Unlock on Locate (UOL) value "No".  It is advisable in Oracle WMS Cloud to have relevant Output Interface Configuration based upon ref field 16 that sends Unlock on Locate (UOL) value.

The following image depicts the output interface configuration for Receipt Adjustment endpoint processing:

  1. Receipt Confirmation for Purchase Orders is enhanced to handle the following Receive-Adjustment scenarios:
  • Modify batch/expiry date and serial number 
  • Partial and full Transfer of inventory from one LPN to another

To utilize this feature, the previous receiving transaction should be Cancelled, or Adjusted in Oracle Inventory Management Cloud and a new Receiving should be posted. Previously, the creation of a new Receipt was handled via IHT 1 or 72. Now, to handle fresh Receipt post Receiving, the IHT 34 and 35 is enhanced in Oracle WMS Cloud by populating in the following Ref Field:

  1. Ref Field 13 (VENDORID) and Ref Field 14 (SUPPLIERSITEID) are now supported in the following list of IHTs:
    • IHT-4(Inv Adjusted Pre-Verification
    • IHT-14(Container Cancelled)
    • IHT-16 Pre receive inventory Adjusted pre-verification
    • IHT-17 Inventory Adjusted post verification
    • IHT-33 Split Container Cancelled
    • IHT-34 Split Container Before ASN Verification
    • IHT-35 Split Container After ASN Verification
  2. Ref field 8 (PO Detail Line Schedule Number) and ref Field (Inbound Shipment Receipt Advice Line) are now supported in the following IHTs:
    • IHT-33 Split Container Cancelled
    • IHT-34 Split Container Before ASN Verification
    • IHT-35 Split Container After ASN Verification

NOTE

  • RF Change SKU and Sort IBLPN transactions from Oracle WMS Cloud does not support the integration of ERP bucket to Oracle Inventory Management Cloud.  

  • Prior to Putaway, it’s recommended to use a single lock code that has Unlock on Locate (UOL) flag value set to Yes. If the workflow demands an additional lock code to be applied prior to putaway, such lock code should be of lower priority value in comparison to pending putaway lock code. 

The following table lists the supported Inventory History Transactions (IHTs) mapped to Integration Service - Receipt Confirmation to Purchase Order service in 20C and 20D:

Inventory History Transaction 20C 20D
IHT-1 - LPN Received  Yes Yes
IHT-2 - Container Consumed ~ Yes
IHT-4 - Inventory Adjusted  Pre-Verification Yes Yes
IHT-14- Container Cancelled Yes Yes
IHT-16 - Pre-receive inventory Adjusted Pre-verification  ~ Yes
IHT-17 - Inventory Adjusted Post Verification ~ Yes
IHT-22 - Lock Container Before ASN Verification  ~ Yes
IHT-23 - Lock Container After ASN Verification  ~ Yes
IHT-24 - Unlock Container Before ASN Verification Yes Yes
IHT-25 - Unlock Container After ASN Verification Yes Yes
IHT-34 - Split Container Before ASN Verification ~ Yes
IHT-35 - Split Container After ASN Verification ~ Yes
IHT-51 - Inventory Movement  Yes Yes
IHT-63 - Lock Update Pre-Verification  Yes Yes
IHT-64 - Lock Update Post- Verification Yes Yes
IHT-72 - Container Received Subject to QC Yes Yes
IHT-73 - QC Accepted ~ Yes
IHT-74 - QC Rejected ~ Yes

Inventory Transactions Service

Inventory Transaction service posts Sub-Inventory transfer for Storage Sub-Inventory. Prior to 20D, integration between Oracle WMS Cloud and Oracle Inventory Management Cloud via Inventory Transaction service was mapped to a single Storage Sub-Inventory called "Stores". In 20D, the restriction for a single Storage Sub-inventory has been removed. The Sub-inventory transfer across other Sub-Inventory is accomplished by looking at the previous and current ERP buckets shared by Oracle WMS  in the IHT.

Inventory Transaction service utilizes the Unlock on Locate (UOL) value "No" to process the IHT from Oracle WMS Cloud to perform Storage Sub-Inventory transfer. Customers can take advantage of defining multiple Storage Sub-Inventory, for example, different Storage Sub-Inventory for available and damaged inventory, or different Storage Sub-Inventory for Inbound and Outbound inventory.

NOTE: Lock code with Unlock on Locate (UOL) flag of “Yes” should not be applied for inventory post-Putaway. The Sub-Inventory transfer from Storage to Receiving is not supported.

The following image shows you the output interface configuration for Inventory Adjustment endpoint processing:

The following table lists the supported Inventory History Transactions (IHTs) mapped to Integration Service - Inventory Transactions service in 20C and 20D.

Inventory History Transaction 20C 20D
IHT-2- Container Consumed ~ Yes
IHT-4 - Inventory Adjusted Pre-Verification Yes Yes
IHT-10 - Container Detail Packed ~ Yes
IHT-11 - Container Packed ~ Yes
IHT-14 - Container Cancelled ~ Yes
IHT-17 - Inventory Adjusted Post Verification Yes Yes
IHT-19 - Inventory Adjustment Cycle Count Active  Yes Yes
IHT-22 - Lock Container Before ASN Verification ~ Yes
IHT-23 - Lock Container After ASN Verification  ~ Yes
IHT-29- Create Allocatable Container Yes Yes
IHT-30 - Create Unallocatable Container Yes Yes
IHT-31 - OB Container Modified ~ Yes
IHT-32 - OB Container Cancelled  ~ Yes
IHT-34 - Split Container Before ASN Verification  ~ Yes
IHT-35 - Split Container After ASN Verification  ~ Yes
IHT-36 - Split Container Lock Acquired ~ Yes
IHT-39 - Cycle Count - Lost IBLPN Counted Yes ~
IHT-40 - IBLPN Lost  Yes ~
IHT-49 - Lock Active Yes Yes
IHT-50 - Unlock Active  Yes Yes
IHT-52 - Audit Adjustment  Yes Yes
IHT-53 - Cycle Count Reserve SKU Counted Yes  Yes
IHT-54 - Container Detail Picked ~ Yes
IHT-62 - POS Interface ~ Yes
IHT-65 - Lock OBLPN ~ Yes
IHT-66 - Unlock OBLPN  ~ Yes
IHT-69 - Kitting Complete ~ Yes
IHT-70 - Kitting Inventory Consumed ~ Yes

Shipment Confirmation for Sales Orders

The storage sub-inventory upon shipping inventory from the warehouse or store was happening from “Stores” Sub-inventory.

The Shipment Confirmation for Sales Order service posts Sub-inventory transfer for Storage Sub-Inventory. Prior to 20D, integration between Oracle WMS Cloud and Oracle Inventory Management Cloud via Shipment Confirmation service was reducing inventory from a single Storage Sub-inventory called "Stores" when inventory was shipped from the warehouse.

As integration supports multiple sub-inventory in Stores bucket, Oracle WMS Cloud is enhanced to send the corresponding Storage Sub-inventory in Ship Confirmation (SLS) payload. The Shipment Confirmation integration utilizes ERP bucket value from SLS payload to reduce inventory from corresponding Storage Sub-inventory.

When integrating Oracle WMS Cloud to ERP systems, the ERP’s system virtually tracks to have visibility on the available inventory in every facility of the Oracle WMS Cloud system. The ERP system creates Inventory Summary Buckets to track availability of inventory levels; however, the system does not track the specific stock location of the material or the details of how the material is packed into containers (LPNs/Pallets).

As inventory in the warehouse is subjected for changes due to various operational (quality check, cycle count, etc.) flows, external ERP systems demand to know the real time status of the inventory present in the warehouse. These ERP systems maintain ERP buckets at a high level, knowing the ERP bucket are associated with the inventory present in the warehouse,  allows these ERP systems to plan Order Fulfillment and Order Reservation accordingly.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

Support Shipping Tolerances for Sales Orders

When orders are received in WMS, the system honors the order’s tolerance values for allocation and packing. An integration service - Shipment Requests for Sales Orders is enhanced to map order tolerance % value from Oracle Inventory Management Cloud to Oracle WMS Cloud. The below table depicts the mapping:

Oracle Fusion Inventory Management Cloud Fields

Corresponding Fields in Oracle WMS Cloud

"OverShipTolerancePercentage"

Max Shipping Tolerance %

"UnderShipTolerancePercentage"

Min Shipping Tolerance %

Oracle Inventory Management Cloud now sends the tolerance behavior at the order detail level to define whether to ship equal to/or more than the order quantity, or less than/or more than the order quantity based on the behavior defined via the tolerance % field.

  • Under tolerance – Orders can be marked as satisfied when quantity shipped is within the minimum and maximum of tolerance % for the order quantity.
  • Requested Quantity – Orders can be marked as satisfied when the quantity shipped is equal to/or more than the tolerance % for order quantity.

Key Points:

  • If the order details sent from the Oracle Inventory Management Cloud system have tolerance behavior defined with the value “Requested Quantity”, the integration considers the Minimum Shipping tolerance% as Zero against the respective order detail. On processing this file in WMS, the Minimum Shipping Tolerance% against the respective order detail is displayed as Zero in the WMS system.
  • If the order details sent from the Oracle Inventory Fusion Management Cloud has tolerance behavior other than "Requested Quantity", the integration system does not update the Minimum Shipping Tolerance% and Maximum Shipping Tolerance%.

The integration service Shipment Request for Sales Order is based on the tolerance % which accepts the maximum % and ignores the minimum%.

For more information on the allocation of orders with minimum and maximum tolerance quantity, refer to Support Overshipment and Undershipment Tolerances with Back Ordering.

ORDER QUANTITY TO CONSUME TO ORACLE INVENTORY MANAGEMENT CLOUD 

When inventory is shipped, Oracle WMS Cloud generates a Ship Confirmation (SLS) payload. This payload contains information pertaining to order detail and corresponding outbound LPN with qty information. The Oracle Inventory Fusion Management Cloud records the shipped qty for an order line via mapping through integration service - Shipment Confirmation for Sales Orders. Once the shipped qty reaches the order qty, the order is closed in the Oracle Inventory Fusion Management Cloud.

With shipping tolerance in Oracle WMS Cloud, the system can ship inventory more or less than the order qty which is sent in multiple loads which leads to marking the order as shipped based on the order’s minimum and maximum tolerance % value. Thereby, the dependency on shipped qty for closing order line becomes crucial where the order may be prematurely closed if same order line is Shipped in multiple loads (meeting the tolerance %) or because of various in shipped timestamp information.

To overcome such an instance, a new field called order_qty_to_consume is introduced in the ship confirmation payload which conveys the actual qty to be reduced from the order. The Oracle Inventory Fusion Management Cloud has introduced “RequestedQuantityToConsume” which is mapped to the “order_qty_to_consume” of the Oracle WMS Cloud. The integration service package - Shipment Requests for Sales Orders maps the field “order_qty_to_consume” value present in ship confirmation payload from Oracle WMS Cloud to "RequestedQuantityToConsume" in Oracle Inventory Fusion Management Cloud. When the summation of  order_qty_to_consume becomes equal to order line qty, then the system marks the order as closed.

NOTE: If ship OBLPN does not generate the SLS file, then the order_qty_to_consume will not be sent to the Oracle Inventory Fusion Management Cloud system.

For example: Let’s say you have interfaced order with 100 units where the Minimum and Maximum tolerance % = 20.

  • User packs Outbound LPN 1 = 15 units and Outbound LPN 2 = 90 units.
  • Due to load restriction for various reasons like truck capacity and so on:
    • Outbound LPN 1 is assigned to Load 1.
    • Outbound LPN 2 is assigned to Load 2.
 

Order Qty

Packed qty

Shipped qty

Order Qty to Consume

Order Interfaced (100) units

100 0 0  

Information shared for Load 1 in SLS payload

100 15 15 15

Information shared for Load 2 in SLS payload

100 90 90

85 – Summation of Order qty to consume will be equal to the order line.

Case 1: Oracle Inventory Management Cloud system refers to the order_qty_to_consume value. In the above case, the summation of order_qty from Load 1 and Load 2 sums to 100 units which satisfies the order qty, and thereby system will not prematurely close the order.

Case 2: When the user ships Load 1 and Load 2, and if information for Load 2 reaches Oracle Inventory Fusion Management Cloud-first, the system can prematurely close the order because the shipped qty (90 units) is within the order tolerance limits.  At this stage, information for Load 1 will get rejected if shipped qty is used for reconciliation.

NOTE: If shipped qty is > than order qty, then the summation of order_qty_to_consume will not go beyond the order qty.

Generally, warehouses deal with a variety of items (such as wires for example) where shipping an exact quantity or weight might not always be practical. To give flexibility in shipping item quantity, tolerance % on orders are introduced in Oracle WMS Cloud in 20D and Oracle Inventory Management Cloud is 20C.

NOTE: To use this functionality, the system must run on 20 D and above versions along with 20D integration package installed.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

Communicate Backordering for Sales Orders

SCM Cloud Integrator now supports backorder functionality via the newly introduced integration API service BackOrder To shipmentLines. This integration service utilizes IHT 85 -Order detail status change to communicate backorder quantity to Oracle Fusion Inventory Management Cloud system. This integration service communicates the back order quantity when the status of order detail is Shipped or Cancelled. While IHT 85 -Order detail status change retains the previous status and the new status columns are exposed in the reference fields. When the new status of the order detail changes to Shipped or Cancelled, and if Backorder quantity is shared in the IHT, then SCM Cloud Integrator will make the relevant API call to the Fusion system. Refer to the IHT trigger point documentation for more information on Order Detail Status Change IHT.

NOTE: The system calculates the back order quantity against each order detail, only when the respective order's order type has Require Back Order flag set to true in conjunction with Deallocate on Short flag set to false on the Order Type UI.

Key Notes:

  • The Output Interface Configuration screen in Oracle WMS Cloud must be configured to call the relevant endpoint for Back Order a Shipment Line. That is, the endpoint URL of the backorder integration must be configured as the target URL of Inventory History export. Refer to the Integration Guide for more information.

  • When Oracle Inventory Management Cloud sends SO (this happens through Shipment Request integration) for backorder quantity, the system sends the original order number. Oracle WMS Cloud will fail the order interface as already the order is interfaced into WMS which has a status greater than created. To support the same order number sent from Oracle Fusion Inventory Management Cloud, the order interface is enhanced in Oracle WMS Cloud to suffix order numbers so that the backorder from fusion can be accepted and processed in WMS for processing.

NOTE: Adding a suffix for an order number is applicable for Oracle Fusion only. Other ERP systems are recommended to send a new order number to process the backorder and avoid sending the same order numbers. For more information, refer to the Back Order Processing Handling section.

In Oracle WMS Cloud, when order details go to Shipped or Cancelled status with shipped quantity less than the ordered quantity (after considering the order detail tolerance percentages), Oracle WMS Cloud now has an ability to signal Oracle Inventory Management Cloud on the quantity that was not fulfilled for respective order detail. The unfulfilled quantity is referred as backorder quantity. This backorder quantity is communicated to the Oracle Fusion Inventory Management cloud so that the Oracle Inventory Management system can create back order against the unfulfilled quantity.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

Provide Transaction Reference on Purchase Order Receipt Confirmation, Inventory Transactions, and Sales Order Shipment Confirmation

The pre-built OIC-based integrations between Oracle WMS Cloud and Oracle Inventory Management Cloud now leverage Oracle Inventory Management Cloud’s ability to link transactions from an external WMS for reconciliation.  To make identifying problem transactions more efficient, the pre-built OIC-based integrations to Oracle Inventory Management Cloud now includes a transaction reference identifier for every transaction that Oracle WMS Cloud sends to Oracle Inventory Management Cloud.

This enhancement incorporates the reference field mappings from all Oracle WMS Cloud transactions into the existing WMS to Inventory integrations, where available. Not all Oracle Inventory Management Cloud’s APIs support transaction references at the transaction level. Some are done at the header level and will have to represent a grouping of transactions. The end result is added traceability between these two systems that will help with inventory summary and error reconciliation.

FIELD MAPPINGS

Oracle Inventory Management Cloud APIs each expose a new field, "ExternalSystemTransactionReference", which are mapped to  the following integrations:

Integration REST API

WMS Output Type

WMS fields mapped to ExternalSystemTransactionReference

Receipt Confirmation Receiving API (Receiving Receipt Requests) Inventory History (IHT)

MessageId (Inventory History Export File name)

Receipt Confirmation

Post receiving API (Receiving Receipt Transactions Requests)

Inventory History (IHT)

group_nbr-seq_nbr

Shipment Confirmation

Shipment Transaction Requests

Shipped Load (SLS)

load_manifest_nbr

Inventory Transaction

Inventory Staged Transactions

Inventory History (IHT)

group_nbr-seq_nbr

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

Integration Properties Support in SCM Cloud Integrator

You may need to add some configured values in the applications you are integrating into the prebuilt integration mappings so that the correct values for your operations are passed. Examples include WMS values like company codes and units of measure. The SCM Cloud Integrator's Integration Wizard makes the process seamless and prevents you from needing to manually update the field mappings yourself in Oracle Integration Cloud (OIC.)

To address these challenges, SCM Cloud Integrator and the prebuilt integrations now support OIC's new "Integration Property" functionality.  This functionality allows the prebuilt integrations to define multiple properties per version with a default value that can be overridden by customers. This  provides:

  • a cleaner mechanism for dealing with field values that may change per customer
  • a default value so that the recommended or base value is not compromised

Each OIC prebuilt integration (where applicable) is now enhanced to replace hard-coded field values with a configurable integration property.

SCM INTEGRATOR UI ENHANCEMENTS

A new dynamic tab "Integration Properties" now displays the integration property(s) for the given integration version, the current value, and default value in the deployed integration details. This can be used to update the integration property values for deployed integrations as long as the integration is not enabled in OIC.

Integration Properties Tab

If the integration version has no integration properties, the message "Nothing to configure." will display.

NEW INTEGRATION WIZARD SETUP - CONFIGURE

A new step, "Configure", is now added to the Integration Wizard which allows you to override the default integration property values as part of the prebuilt integration process.

For each integration version that has at least one integration property, a card will be displayed. The default value will be displayed in the input box, which can be overridde with  your configured values. Once deployed, these may still be updated from the respective deployed integration’s detail page in SCM Cloud Integrator, or from within OIC.

Configure

DEPLOYMENT PROCESS UPDATES

As part of the deployment process, any integration property values that are changed from their default are pushed to OIC. This happens as a final step after the integration has been deployed and the connection configured.

If the push to OIC fails, an error alert will display and all deployment changes are rolled back for that integration version.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources