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 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

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

SPOIN_STMT
- 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.

 

Cause

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