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 184.108.40.206 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 220.127.116.11 or 18.104.22.168, 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