RPAS Size Profile Optimization: fixedpacktypeprepackopt Special Expression Seems to Hang (Doc ID 2087747.1)

Last updated on DECEMBER 21, 2015

Applies to:

Oracle Retail Size Profile Optimization - Version 13.4.3 and later
Information in this document applies to any platform.

Symptoms

Using RPAS/SPO version 13.4.3, when trying to execute the SPO batch the rule group "Opt_BatchL03" is taking enormous time. After more than more than 12 hours still the log showed no progress at all.  The batch is hanging at this expression:

"totpacknumL01,prepackdefL01,prepackcalL01,eachcalL01,errstrL01<-fixedpacktypeprepackopt(optimizeL01,delIDmskL01,skup2msrn.level([PROD].[skup]).or,demandL01,minpacksizeL01,maxpacksizeL01,validpcksizeL01,eachesenableL01,reqflatpackL01,minuntskusL01,maxuntskusL01,fixprepackL01,assfixpackL01,tmpunalloccost.level([PROD].[skup]).average_pop,tmpovralloccost.level([PROD].[skup]).average_pop,defhandlecost,defcomplexcost,endidxL01,fringsize,maxpacknumL01,defminpacksize,defmaxpacksize,defvali

 

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