Hello,
I have created an Account hierarchy and then performed the step to Publish account hierarchy. The schedule process that this step submitted has completed with ERROR. I have set the hierarchy status to Active and then validated the hierarchy before publishing. I am not sure why this has Errored out and did not get any clue in the log this process has generated. Please, help me to find the solution to this problem.
Log:isCubeInMaintenanceMode() :: is cube in maintenance mode ? false
isDimMaintenanceFromPostingDisable():: is dim maintenance from posting disabled ? false
Request for cubeCreation running with request ID: 1493003
Parameters for this request are:
Parameter Name: numberOfArgs Parameter value: 9
Parameter Name: jobDefinitionName Parameter value: PublishHierarchies
Parameter Name: SYS_preProcess
Parameter value: oracle.apps.fnd.applcp.request.exec.CPPreProcessHandler
Parameter Name: submit.argument3 Parameter value: ,
Parameter Name: jobPackageName
Parameter value: /oracle/apps/ess/financials/generalLedger/ledgers/ledgerDefinitions
Parameter Name: currentSubRequestId Parameter value: 0
Parameter Name: cpAsynchJobWrapper Parameter value: oracle.apps.fnd.applcp.request.exec.AsyncExecutableWrapper
Parameter Name: shadowClassName
Parameter value: oracle.apps.financials.generalLedger.ledgers.ledgerDefinitions.ess.program.PublishHierarchies
Parameter Name: SYS_className
Parameter value: oracle.apps.fnd.applcp.request.exec.ExecutableWrapper
Parameter Name: SYS_workDirectoryRoot Parameter value: /u01/APPLTOP/instance/ess/rfd/1493003
Parameter Name: SYS_request_timeout Parameter value: 0
Parameter Name: SYS_groupName Parameter value: ESS_DefaultIsolationGroup
Parameter Name: SYS_inputWorkDirectory
Parameter value: /u01/APPLTOP/instance/ess/rfd/1493003/input
Parameter Name: SYS_submittingApplication Parameter value: FscmEss
Parameter Name: parentRequest
Parameter value: 0
Parameter Name: SYS_product Parameter value: GL
Parameter Name: SYS_extensionListener Parameter value: oracle.apps.fnd.applcp.request.postprocess.CPEventListener
Parameter Name: SYS_redirectedOutputFile Parameter value: /u01/APPLTOP/instance/ess/rfd/1493003/log/1493003.log
Parameter Name: logLevel Parameter value: 1
Parameter Name: oracle.apps.fnd.applcp.invokeIncrementProcIfPresent Parameter value: true
Parameter Name: SYS_application Parameter value: FscmEss
Parameter Name: SYS_logWorkDirectory
Parameter value: /u01/APPLTOP/instance/ess/rfd/1493003/log
Parameter Name: jobExecutesVirusScanOnLogFiles Parameter value: false
Parameter Name: srsFlag Parameter value: N
For request
parameter name: completionText, Value was null
Parameter Name: completionText Parameter value:
Parameter Name: SYS_executePast Parameter value: true
Parameter Name: SYS_priority
Parameter value: 4
Parameter Name: SYS_postProcess Parameter value: oracle.apps.fnd.applcp.request.exec.CPPostProcessHandler
Parameter Name: SYS_effectiveApplication
Parameter value: FscmEss
Parameter Name: cpSqlFileFlag Parameter value: F
Parameter Name: EXT_PortletContainerWebModule Parameter value: ORA_FSCM_UI
Parameter Name: SYS_userName
Parameter value: admin_user
Parameter Name: jobDefinitionApplication Parameter value: GL
Parameter Name: SYS_retries Parameter value: 0
Parameter Name: SYS_outputWorkDirectory
Parameter value: /u01/APPLTOP/instance/ess/rfd/1493003/out
Parameter Name: filePersistenceMode Parameter value: file
Parameter Name: submit.argument1 Parameter value: 85900
Parameter Name: submit.argument2 Parameter value: ,831FAB858E4A814AE0535161DD0AD8C9,
Parameter Name: jobExecutesVirusScanOnOutputFiles Parameter value: false
Parameter Name: SYS_requestExpiration Parameter value: 0
Parameter Name: aflogLevel Parameter value: N
Parameter Name: SYS_userFileDir Parameter value: /u01/APPLTOP/instance/ess/rfd
Parameter Name: SYS_reprocessDelay Parameter value: 5
For request parameter name: requestStepPath, Value was null
Parameter Name: requestStepPath Parameter value:
Parameter Name: cpJavaJobWrapper
Parameter value: oracle.apps.fnd.applcp.request.exec.ExecutableWrapper
------------------------------------------
isPrallelCOADimBuildEnabled():: parallel processing setup is missing....
getNoOfParallelAllowedCubeProcessing:: degree of parallel processing is missing hence defaulting it to 4
creating am with: Name: oracle.apps.financials.generalLedger.ledgers.essbase.publicModel.
applicationModule.LedgerEssbaseAM Config: LedgerEssbaseAMLocal
Created Application module instance
PublishHierarchies: started at ->Sat Mar 02 19:47:00 UTC 2019
creating am with:
Name: oracle.apps.financials.generalLedger.ledgers.essbase.publicModel.applicationModule.LedgerEssbaseAM Config: LedgerEssbaseAMLocal
Created
Application module instance
PublishHierarchies: Independent request for Publishing tree versions through UI....
getParameterValue: Start
Trying to retrieve param key submit.argument1
Retrieved value for param submit.argument1 as: 85900
getParameterValue: End
getParameterValue: Start
Trying to retrieve param key submit.argument2
Retrieved value for param submit.argument2 as: ,
831FAB858E4A814AE0535161DD0AD8C9,
getParameterValue: End
getParameterValue: Start
Trying to retrieve param key submit.argument3
Retrieved value for param submit.argument3 as: ,
getParameterValue:
End
getParameterValue: Start
Trying to retrieve param key listOfProcessedCube
request parameters does not contain key: listOfProcessedCube
getParameterValue: End
PublishHierarchies: List of Valuesets
passed: 85900
Dimension Member Alias validation returned failure status for all the COA for Value set Id list 85900
Releasing Root AM...