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 and later
Information in this document applies to any platform.
***Checked for relevance on 20-OCT-2011***


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:




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


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

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