Poor Performance In Item Supply/Demand Form Selecting POs (SPOIN Statement)
Last updated on JUNE 28, 2017
Applies to:Oracle Materials Requirement Planning - Version 18.104.22.168 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms