My Oracle Support Banner

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.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.