You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need backend SQL table or API to extract below values from “Item Quantities” screen

Summary:

Need backend SQL table or API to extract below values from “Item Quantities” screen to populate the data in On Hand custom screen.

Available to Reserve

Available to Transact

Secondary Available to Reserve

Secondary Available to Transact

As per oracle document , “Available to Reserve” & “Available to Transact” column are calculation fields . We need to check which table contains “Pending Transactions” & “Reservations” to calculate the fields.

Link : https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/25b/famml/available-to-reserve-and-available-to-transact-values.html

These fields are calculated fields and in of km-article # KB17259 , Oracle has mentioned there is complex algorithm to calculate the fields and suggesting to check directly from UI.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!