My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

Oracle Advanced Supply Chain Planning - Version and later
Information in this document applies to any platform.


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.

  • For 11.5.8 customers, the file is included in MRP Planning Manager patch 3283218
  • For customers on 11.5.9 or 11.5.10, then the file is delivered in the following MRP patches
    6086627, 5979763, 5874448, 5739188, 5599937, 5373686, 4629442, 4087308
  • For customers on or, the file is included in these releases


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.