search cancel

DWH database function DWH_INV_REMAINING_ALLOC_FCT compile error: "ORA-00600: internal error code, arguments: [17200], [ODF_NK_ALLOCCOST_CURVE]"

book

Article ID: 229301

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

After an upgrade to 15.9.3 and Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit, you see the following error when compiling the DWH_INV_REMAINING_ALLOC_FCT function in both DEV and QA environments

ERROR at line 1:

ORA-04052: error occurred when looking up remote object [email protected]@MYPPM

ORA-00600: internal error code, arguments: [17200], [ODF_NK_ALLOCCOST_CURVE], [121], [], [], [], [], [], [],[], [], []

Expected Results: The function should compile successfully. 

Actual Results: The function does not compile successfully. 

Cause

DE62829

Environment

Release : 15.9.3, 16.0.0

Component : CLARITY INTEGRATIONS & INSTALLATIONS

Database: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit

Resolution

Fixed 16.0.1 and patches: 16.0.0.1 and 15.9.3.2 as DE62829