B-Memory Based Snapshot 64 Bit Linux Program Performance Issue For ASCP Plan-DI-DMS-PLN & CS-DMS-PLN (Doc ID 2105753.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Memory Based Snapshot 64 bit Linux program performance issue on the following SQL:

SQL ID: 2rc480xw5tsyk Plan Hash: 2052884940

select nvl(conversion_rate,1.0) into :b0
from msc_uom_conversions_view
where ((((inventory_item_id=:b1
and organization_id= :b2)
and sr_instance_id=:b3)
and primary_uom_code=:b4)
and uom_code=:b5)

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