Support JSON input for cubiscan item updates

Idea Lab

Cubiscan item updates help customers keep item dimensions and weights accurate in WMS. This enchantment introduces JSON support for Cubiscan interface via which user can now update standard pack/case Quantity and UOM through, reducing manual item maintenance and supporting more complete item setup through integration. WMS supports a JSON-based Cubiscan input interface using :

POST /wms/lgfapi/v10/stage/cubiscan

With existing Cubiscan interface field, the JSON interface now supports new fields : package_uom_qty and package_uom_code columns that updates standard pack or case setup based on the submitted UOM.

Submitted UOM WMS Update
PK Updates std_pack_qty and pack_uom_code
CS Updates std_case_qty and case_uom_code.
EA Does not allow package_uom_qty.

The API will expose the following parameter which are mentioned below:

Name Description
async_flg Controls processing mode.
Default is false.
When true, the interface runs asynchronously. When false, the interface runs synchronously.
only_load_flg Controls whether records are only loaded into the stage table.
Default is false.
When true, records are loaded into STAGE_CUBISCAN but are not processed.

WMS validates that package quantity is a whole number and that the package UOM code is valid, belongs to the item’s primary UOM class, and is defined as a package UOM.

Steps to enable and configure

Review the REST service definition in the REST API guides to leverage (available from the Oracle Help Center > your apps service area of interest > APIs & Schema). If you are new to Oracle's REST services you may want to begin with the Quick Start section.