My Oracle Support Banner

The Script mrins002.sql Performs Slowly As Part of R12 Upgrade (Doc ID 550728.1)

Last updated on JUNE 16, 2021

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.1 and later
Information in this document applies to any platform.
***Checked for relevance on 20-OCT-2011***


Symptoms

As part of the R12 upgrade,
IF the file $MRP_TOP/patch/115/sql/mrpins002.sql does not exist on the 11.5 instance,
THEN the file will be run.

This file will have a performance problem for any customer with a large number of order lines in OE_ORDER_LINES_ALL since there is a full table scan being done on OE_ORDER_LINES_ALL.

Here is the original SQL:

 


 

Changes

This file should exist on the system if any of the following have been applied.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

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