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

DM: how to lock users out of a DM Plan or end user session before running a BIP rpt or DM plan

edited Mar 17, 2026 1:48AM in Supply Chain Planning and Collaboration 1 comment

Summary:

Is there an automatic way to lock all users out of a Demand plan or end their session before running a BIP report, Demand Plan, or archiving a demand plan?

Content (please ensure you mask any confidential information):

Users during the weekend are making updates to a Demand Plan while a BIP report is running to pull data from the dynamic tables. Consequently, the BIP report errors because its timeouts.

Is there a SQL script that could help me identify when a user is in a Demand Plan or is using Demand Management?

Thanks in advance.

Oracle References: I have checked out.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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