My Oracle Support Banner

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 FEBRUARY 27, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

12.2.4
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

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
Cause
Solution
References


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