My Oracle Support Banner

RPAS Cloud: Batch Rule Group Calculation with Parallel Groups Results in Failure and Error "PL/SQL: ORA-30483: window functions are not allowed here'" (Doc ID 2928514.1)

Last updated on FEBRUARY 15, 2023

Applies to:

Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service Plus - Version 23.1 and later
Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service Plus - Version 23.1 and later
Oracle Retail Demand Forecasting Cloud Service Plus - Version 23.1 and later
Oracle Retail Predictive Application Server Cloud Edition - Version 22.1 and later
Information in this document applies to any platform.

Symptoms

After an upgrade a rule group batch_upd_abcd is failing with the below error in the log. The rule group updates multiple measures that are split into two parallel groups within the rule group batch_upd_abcd. The first parallel group succeeds, however the second parallel group fails. There were no configuration changes following the upgrade.

RunSubGroupTask(batch_upd_abcd, 1, 1) starts
Starting task <taskid>/3/step_1/pgrp_01
Calculating RuleGroup: batch_upd_abcd Step: 1 SubGrp: 1

Exp 1: AbcdBOPC = if(AbcdElapsedB || lag(AbcdElapsedB), AbTyBOPC, ignore)

Exp 2: AbcdBOPU = if(AbcdElapsedB || lag(AbcdElapsedB), AbTyBOPU, ignore)

RunSubGroupTask post execution exception handling: OciErrorException
OCI_ERROR - (20999):
SQL Sid 'rpas_batch_conn' ORA-20999: ORA-06550: line 17, column 1222:
PL/SQL: ORA-30483: window functions are not allowed here
ORA-06512: at "RPAS_DATA_MART_PDS.RP_RULEGROUP_PKG", line 197

Changes

 

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!

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