New public API to create tags in Physical Inventory counting

With Contributing Author:  Sibghat Hussaini

Business operations with high volume of counting transactions specifically those using physical inventory counting functionality often require a fast and efficient method to create and update physical inventory tags.

In 12.2.5 release, Oracle provided a public API to update existing physical tag records and their corresponding adjustment records. However, there was no option to create dynamic tags. This was possible only from the UI – Inventory > Counting > Physical Inventory -> Tag Counts Stocks form where user must create a tag manually for each record.

Now in release 12.2.14, a new API INV_PHY_INV_PUB.CREATE_TAGS is introduced which will allow to create new tags. Additionally update Tag has been modified to support the 12.2.13 features of multiple tags per request for serial controlled items and Count history support.

The new API will allow bulk creation/update of tag records for a physical inventory. Data gets inserted into “MTL_PHYSICAL_INVENTORY_TAGS” table with corresponding adjustment in MTL_PHYSICAL_ADJUSMENTS table.

IMPORTANT: This public API is available only on upgrade to 12.2.14 or higher and is not available from any stand-alone patch at this time.

There are also sample code snippets available so you can test each of these APIs.

To know more about this feature, please refer below document.

Vision Demo – 12.2.14 API INV_PHY_INV_PUB To Create Or Update Tags in Physical Inventory Counting (Doc ID 3022631.1)