Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Check Report is returning completely Blank

EBDJan 20 2016 — edited Jan 20 2016

Hello All,

I've been having an issue with our check report returning completely blank, including the Category, Period and Location headers. I've downloaded the 11.1.2.4.1 patch which has a GUI to be able to test a check rule, and the rule that I've built is valid and returns a value in this check rule however, the check report is completely blank. My check intersection report is working well as well as all of our out of the box reports in Report Execution, it's only the check report that is not working. Has anyone experienced this?

Rule:

|,,,,,,Balance,[ICP None],,LBOR,[None],[None],,,,,,,,,,,,,,,,| == 0.4 ( output should should equal 0.4)

Log:

[2016-01-20T07:55:49.669-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.file.script.jython.JythonInterpreterUtil] [SRC_METHOD: <init>] Error Initializing the PythonInterpreter:null

[2016-01-20T07:55:49.670-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.validation.model.util.CheckProcessManager] [SRC_METHOD: <init>] Jython Operations Initialization Completed.

[2016-01-20T07:55:49.670-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.webservices.HFMService] [SRC_METHOD: checkData] ***** Check Initialization - END *****

[2016-01-20T07:55:49.674-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.webservices.HFMService] [SRC_METHOD: checkData] ******** Check Execution - BEGIN ********

[2016-01-20T07:55:49.782-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.util.RegistryUtil] [SRC_METHOD: getHfmClusterName] Cluster name:TAIS-HYP-P02

[2016-01-20T07:55:51.073-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.validation.model.util.CheckTargetFactory] [SRC_METHOD: getAppInstance] Connection established to HFM.

[2016-01-20T07:55:51.134-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.validation.model.util.CheckProcessManager] [SRC_METHOD: executeCheckRules] ------------------- Execution for Entity : CZT - BEGIN -------------------

[2016-01-20T07:55:51.140-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.validation.model.util.CheckProcessManager] [SRC_METHOD: executeCheckRules] ------------------- Execution for Entity : CZT - END -------------------

[2016-01-20T07:55:52.911-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.reporting.model.util.ReportManager] [SRC_METHOD: returnValidatedQuery] Query:SELECT CatKey, PeriodKey, rptEntityStatus, rptLocation, rptName, rptDesc, rptMode, rptTitle, rptSubTitle, rptEntName, rptEntCat, rptEntPer, rptRuleSeq, rptRuleTitle, rptRuleDef, rptAcct, rptAcctDesc, rptAcctVal, rptTime, rptRuleStatus, UDVal1, UDVal2, UDText1, UDText2, UDText3 FROM tDataCheck [[

WHERE (CatKey = ? ) AND (PeriodKey = ? ) AND (PartitionKey = ? )

ORDER BY DataKey

]]

[2016-01-20T07:55:53.866-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.reporting.model.util.ReportManager] [SRC_METHOD: generateReport] Generating report for template:Check Report With Warnings.rtf

[2016-01-20T07:55:56.856-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.validation.model.util.CheckProcessManager] [SRC_METHOD: executeCheck] Check Report saved at - \\tais-hyp-p02.na.toshiba-dpg.local\Data\FDMEE\TICHFM\outbox\reports\179.pdf

[2016-01-20T07:55:56.934-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.webservices.HFMService] [SRC_METHOD: checkData] Disconnected from FDMEE database.

[2016-01-20T07:55:57.205-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.validation.model.util.CheckProcessManager] [SRC_METHOD: executeCheck] Disconnected from HFM.

[2016-01-20T07:55:57.205-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.webservices.HFMService] [SRC_METHOD: checkData] ******** Check Execution - END ********

[2016-01-20T07:55:57.240-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.webservices.HFMService] [SRC_METHOD: pd] [HFMService] Info:[checkData:179,APR-15] END (true)

[2016-01-20T07:55:57.257-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.ui] [tid: 26] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.servlet.ODIServlet] [SRC_METHOD: doPost] response msg:true

[2016-01-20T07:56:00.581-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.util.model.applicationModule.GLIntegrationBaseAMImpl] [SRC_METHOD: invoke_odi_process] pid:179, Extract id:117501, status:null

[2016-01-20T07:56:00.863-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.workbench.model.applicationModule.WorkBenchAMImpl] [SRC_METHOD: loadStatus] Executed status VO with params partitionKey:2, period Key:4/30/15 12:00 AM, catKey1rule id:11

[2016-01-20T07:56:00.864-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.workbench.model.applicationModule.WorkBenchAMImpl] [SRC_METHOD: loadStatus] Executed process VO with load id:179

[2016-01-20T07:56:00.881-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.workbench.model.applicationModule.WorkBenchAMImpl] [SRC_METHOD: executeCheckRule] ent load:1,

[2016-01-20T07:56:01.002-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.workbench.model.applicationModule.WorkBenchAMImpl] [SRC_METHOD: executeCheckRule] Generating report for report id:9

[2016-01-20T07:56:02.089-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.reporting.model.util.ReportManager] [SRC_METHOD: returnValidatedQuery] Query:SELECT CatKey, PeriodKey, rptEntityStatus, rptLocation, rptName, rptDesc, rptMode, rptTitle, rptSubTitle, rptEntName, rptEntCat, rptEntPer, rptRuleSeq, rptRuleTitle, rptRuleDef, rptAcct, rptAcctDesc, rptAcctVal, rptTime, rptRuleStatus, UDVal1, UDVal2, UDText1, UDText2, UDText3 FROM tDataCheck [[

WHERE (CatKey = ? ) AND (PERIODKEY= ? ) AND (PartitionKey = ? )

ORDER BY DataKey

]]

[2016-01-20T07:56:02.950-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.reporting.model.util.ReportManager] [SRC_METHOD: generateReport] Generating report for template:Check Report.rtf

[2016-01-20T07:56:03.138-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.ui] [tid: 33] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.workbench.userinterface.backing.WorkBenchBacking] [SRC_METHOD: executeRule] WORK_BENCH_BACKING_DEBUG:::: SIZE OF ITERATOR 25

[2016-01-20T07:56:04.222-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.workbench.model.applicationModule.WorkBenchAMImpl] [SRC_METHOD: loadStatus] Executed status VO with params partitionKey:2, period Key:4/30/15 12:00 AM, catKey1rule id:11

[2016-01-20T07:56:20.487-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 30] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.workbench.userinterface.backing.WorkBenchBacking] [SRC_METHOD: initWorkbench] **** DEPLOYMENT PROFILE IS :

[2016-01-20T07:56:21.181-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 30] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.workbench.model.applicationModule.WorkBenchAMImpl] [SRC_METHOD: loadStatus] Executed status VO with params partitionKey:2, period Key:4/30/15 12:00 AM, catKey1rule id:11

[2016-01-20T07:56:21.182-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 30] [userId: <anonymous>] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.workbench.model.applicationModule.WorkBenchAMImpl] [SRC_METHOD: loadStatus] Executed process VO with load id:179

[2016-01-20T07:57:43.033-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: <anonymous>] [ecid: 00iY5lKJxZvFw00Fzzw0w00002OC0001bP,0:1] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.workbench.model.applicationModule.WorkBenchAMImpl] [SRC_METHOD: loadStatus] Executed status VO with params partitionKey:2, period Key:4/30/15 12:00 AM, catKey1rule id:11

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2016

Added on Jan 20 2016

#business-intelligence-applications, #fdmee, #financial-data-management, #performance-management-applications

10 comments

3,329 views