Query For Current, Past and Future Inventory Period Statuses
(Doc ID 2787617.1)
Last updated on JULY 06, 2021
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Goal
We want to see next inventory period status. For example we are currently in MAY-21 and we want to see what is the status of JUN-21 Inventory period for particular inventory organization.
When we looked at table org_acct_periods, it doesn't show any record for JUN-21. When we looked at application, we can see JUN-21 period status as Future.
Is there any SQL to get this data from database.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |