Did you know there are Physical Inventory APIs to update existing Physical Inventory records?
Some businesses with a high volume of physical inventory transactions need a fast and efficient method for updating existing physical inventory records. For this requirement, Oracle Inventory provides a public Physical Inventory API for updating existing physical tag records and their corresponding adjustment records.
For more information on using this functionality, please review (Doc ID 2161869.1).
This document includes an overview along with the below information:
- Patching Requirement for the APIs
- Setup and starting On-hand information
- Example of the INV_PHY_INV_PUB.UPDATE_TAGS API
- Example of the INV_PHY_INV_PUB.APPROVE_ADJUSTMENT API
- Helper SQLs to find the Information needed
- Log File Examples
This functionality is available in 12.2.5 or higher, and currently only provides the ability to update existing records and not to create new tags or a Snapshot.
You can also review the following note to find out how to get more information on this and other existing API’s
R12: How To Access API References via the Oracle Integration Repository (Doc ID 462586.1)