OBIA 220.127.116.11.1 Performance issue on SDE_ORA_STAGE_GLHIERARCHY_SEGMENTRANGE_DERIVE.W_ORA_GL_HIER_RGE_DERV_DH_TMP
(Doc ID 1960958.1)
Last updated on FEBRUARY 25, 2019
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.1 and later
Information in this document applies to any platform.
After installing OBIA 22.214.171.124.1 and completing the Setup and Functional configuration following oracle documentation, the initial load of Financial Analytics started.
However, there are performance issues on the task W_ORA_GL_HIER_RGE_DERV_DH_TMP in the SDE_ORA_STAGE_GLHIERARCHY_SEGMENTRANGE_DERIVE mapping. The process was running for more than 6 Hours. During troubleshooting, the solution in the following note was applied:
But the performance problem persists.
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