Finally, Oracle has released a Physical Inventory API: INV_PHY_INV_PUB

At long last, EBS customers can enter physical inventory counts and adjustment approvals through a new public API.

Phyiscal Inventory counts and approvals are one of the most tedious processes an organization can undertake.  After spending countless hours counting what feels like and endless inventory, someone (or multiple people) must enter those counts into Oracle.  On top of that, someone has to approve the adjustments (where the physical inventory count is above or below the system value * the tolerance).

Trying to enter tag counts in the Oracle forms is an exercise in futility, as it form is way to inefficient to process even a small inventory, let alone the large inventories that must EBS customers will have.

Finally, after all these years, Oracle has released the API: INV_PHY_INV_PUB which can be used to programmatically perform tag counts and approvals.  This is available in version 12.2.5 and later (sorry to those folks on earlier versions).

Here are the details:

1) Enter Tag Counts: 

inv_phy_inv_pub.update_tags

This API allows you to enter your tag counts.  Typical input parameters are:

Org:                   organization_id

Physical Inv Name:     physical_inventory_id

Tag Number:            adjustment_id

Item Number:           inventory_item_id

Subinventory:          subinventory

Tag UOM:               tag_uom

Count Qty:             count_quantity

Action:                action (default to U, for update)

2) Approve Adjustments:

inv_phy_inv_pub.approve_adjustment

This API allows you to approve adjustments.  Here the key is to pass the

Org:                   organization_id
Physical Inv Name:     physical_inventory_id
Tag Number:            adjustment_id
Approval Status:       approval_status
Approved by:           approved_by_employee_id

These two procedures work well and can make processing your physical inventory much easier.  Interestingly, there is also a Create_Tags procedure but Oracle says that the tags must be created using the concurrent process in the Oracle Forms.  For more information, please read Oracle Support document: 

How To Use The Physical Inventory API In 12.2.5 (Doc ID 2161869.1)

You can call these APIs directly or you can perform your Physical Inventory Counts and Approvals in API Wizard

API Wizard has prebuilt Loaders for Physical Inventory Counts and Adjustment Approvals and its Excel-based interface makes it incredibly easy to process huge numbers of records at one time.  You can purchase and deploy API Wizard in 15 minutes and start entering your counts and adjustment approvals faster than it would take you (or your IT team) to get up to speed on this API.  Plus, API Wizard's battle-tested, sophisticated interface makes data entry and update a breeze!  Here are some screenshots of the Tag Count and Adjustment Approval Loaders.

API Wizard Physical Inventory Count Loader

API Wizard Physical Inventory Adjustment Approval Loader:

In summary, it's a great thing for the EBS community that Oracle has released a public API for inventory counts and adjustment approvals.  If you want to build your own solution, good luck!  If you want to use API Wizard for your inventory counts and adjustment approvals, contact us at info@api-wizard.com.