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 later
Information in this document applies to any platform.
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.
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