Margin Analysis Load Run CSTMRGLB - Severe Performance Issue (Doc ID 1981362.1)

Last updated on AUGUST 10, 2015

Applies to:

Oracle Cost Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Margin Analysis Load Run runs in about 40 minutes to complete for 22 days period (current month)


STEPS
1. Run Margin Analysis Load Run
2. Review trace file.

Changes

Margin Analysis Load Run is exhibiting poor performance before change and after change program exhibits better performance.

Replaced view from  cst_org_definitions to cst_act_info_v.Also added some hints to improve performance of Margin Analysis Load Program.

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