Poor Performance In Item Supply/Demand Form Selecting POs (SPOIN Statement)
(Doc ID 2130253.1)
Last updated on JUNE 28, 2017
Applies to:Oracle Materials Requirement Planning - Version 184.108.40.206 and later
Information in this document applies to any platform.
You are querying an item in the Item Supply/Demand form and it's taking a long time in the SPOIN_STMNT.
First Cursor - Opening Cursor DMD_STMT at:25-MAR-16 19:28:26
- Opening Cursor SPOIN_STMT at:25-MAR-16 19:28:28
- Fetched: SPOIN_STMT, rows: 4 at 25-mar-16 19:30:46
So it STARTS 2 seconds later, but takes over 2 minutes to complete.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!