CSTGPICQ - Slow Performance When Querying Cost Group Field In Periodic Item Cost Inquiry Screen (Doc ID 812167.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Cost Management - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

On 11i and R12, there is a performance problem when querying in the Periodic Item Cost Inquiry form, CSTGPICQ, after entering the cost group. When entering this field, the system takes around 90 seconds to return the necessary information.  The problem occurs for all cost groups in the application.

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