Using Archive Function in Custom Measure Throws Error in Planning Table

(Doc ID 2325081.1)

Last updated on DECEMBER 05, 2017

Applies to:

Oracle Fusion Planning Central Cloud Service - Version 11.13.17.09.0 and later
Information in this document applies to any platform.

Symptoms

After creating a custom measure using the Archive function in the expression and enabling the measure in a custom table, the following error occurs when opening the table:

exception in createPivotViewModel, exception in createPivotViewModel
oracle.apps.scm.advancedPlanning.planningAnalytics.worksheetEngine.exceptions.WorksheetE
ngineExecutionException:
oracle.apps.scm.advancedPlanning.planningAnalytics.worksheetEngine.exceptions.SQLBuildin
gException:
oracle.apps.scm.advancedPlanning.planningAnalytics.measureExpression.function.ParseExcep
tion: Error analyzing measure dependencies measure. Measure id: 300000001225290 , error:
Invalid dependent's code 'measure_300000001225290' does not exist Error parsing measure.
Measure id: 300000001225290 , error: Encountered " "\"Version\" "" at line 1,
column 20. Was expecting: <QUOTED_STRING> ...

weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2235)
weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1545)
weblogic.work.ExecuteThread.execute(ExecuteThread.java:376)
weblogic.work.ExecuteThread.run(ExecuteThread.java:305) pivotInfo: edge[COLUMN_EDGE]=
Level[Week]=visible:true,35001,dimId:0,false,summary:false
Level[Day]=visible:false,51,dimId:0,false,summary:false edge[ROW_EDGE]=
Level[Item]=visible:true,1,dimId:0,false,summary:false Level[Category Level
36003]=visible:true,36003,dimId:0,false,summary:false Level[Category Level
36005]=visible:true,36005,dimId:0,false,summary:false
Level[Organization]=visible:true,40,dimId:0,false,summary:false measure layer has mDef=Net
Forecast,1511,NUMBER,SUM,net_fcst,net_fcst,null,null,-1,0,null,null,null,VALUE,true
mDef=Archived
Forecast1,300000001225290,NUMBER,SUM,Archive(net_fcst,1,"Version","Rolling"),measure_3
00000001225290,null,null,-1,0,null,null,null,VALUE,false edge[PAGE_EDGE]= AFTER_DATA
drillPath = (Week:35001) to (Day:51), hashCode=1086043 (Category Level 36005:36005) to
(Item:1), hashCode=1117117 drillContext =null , sortProp=
Level[Item]=visible:true,1,dimId:0,false,summary:false,ASCENDING Level[Category Level
36003]=visible:true,36003,dimId:0,false,summary:false,ASCENDING Level[Category Level
36005]=visible:true,36005,dimId:0,false,summary:false,ASCENDING
Level[Organization]=visible:true,40,dimId:0,false,summary:false,ASCENDING null
300000001680639:,mDef=Net Forecast,1511,NUMBER,SUM,net_fcst,net_fcst,null,null,-
1,0,null,null,null,VALUE,true,mDef=Archived
Forecast1,300000001225290,NUMBER,SUM,Archive(net_fcst,1,"Version","Rolling"),measure_3
00000001225290,null,null,-1,0,null,null,null,VALUE,false level:,(40,Organization,2,-
1),(35001,Week,7,28001),(51,Day,7,-1),(1,Item,1,-1),(36005,Category Level
36005,1,29003),(36003,Category Level 36003,1,29005) unAssolevel:,(51,Day,7,-1),(1,Item,1,-
1),(36003,Category Level 36003,1,29005),(40,Organization,2,-
1),(35001,Week,7,28001),(36005,Category Level 36005,1,29003) filters: ((L:Item M:[-9999])
AND (L:Day M:[-9999]))


The issue can be reproduced with the following steps:1. Navigate to Supply Chain Planning -> Supply Planning
2. Open right task pane and select Manage Planning Measures
3. Select Actions -> Create
4. Provide required details -> select expression tab as use Archive function
5. Select Save and Close
6. Enable the Custom Measure in the Planning Analytics
7. Run the Plan
8. Add the Custom Measure to the Custom Table

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