My Oracle Support Banner

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 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!

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