[jira] [Commented] (OFBIZ-9216) report GL Account Trial Balance

2017-02-16 Thread Jacques Le Roux (JIRA)

[ 
https://issues.apache.org/jira/browse/OFBIZ-9216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15869976#comment-15869976
 ] 

Jacques Le Roux commented on OFBIZ-9216:


OK then we could revert, but I think it's not an issue anyway... Bigger fishes 
to fry...

> report GL Account Trial Balance
> ---
>
> Key: OFBIZ-9216
> URL: https://issues.apache.org/jira/browse/OFBIZ-9216
> Project: OFBiz
>  Issue Type: Bug
>  Components: accounting
>Affects Versions: Trunk, Release Branch 16.11
> Environment: database oracle 12c
>Reporter: Moatasim Al Masri
>Assignee: Pierre Smits
> Fix For: Upcoming Release, 16.11.02
>
> Attachments: OFBIZ-9216-GlAccountTrialBalance.groovy.patch
>
>
> go to 
> Accouting --> Organization GL Settings -->Accounting button -- >> reports --> 
> GL Account Trial Balance
> when excute this report the give me error 
> NOTE: we used oracle 12c database
> -
> ERROR rendering error page [/error/error.jsp], but here is the error text: 
> org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering 
> screen 
> [component://accounting/widget/ReportFinancialSummaryScreens.xml#GlAccountTrialBalance]:
>  java.lang.IllegalArgumentException: Error running script at location 
> [component://accounting/groovyScripts/reports/GlAccountTrialBalance.groovy]: 
> org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast 
> object 
> 'com.ibm.icu.util.GregorianCalendar[time=148322160,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=com.ibm.icu.impl.OlsonTimeZone@4ebd0d68[transitionCount=71,typeCount=3,transitionTimes=[-1230776624,108165600,118270800,136591200,149806800,168127200,181342800,199749600,215643600,231285600,244501200,262735200,275950800,481154400,496962000,512949600,528670800,544399200,560120400,575848800,592174800,610581600,623624400,641167200,655074000,671839200,685918800,702856800,717973200,733701600,749422800,765151200,779662800,797205600,86000,828655200,843170400,860104800,87462,891554400,906069600,93078,938124000,954367200,970178400,985816800,1001628000,1017352800,1033077600,1048802400,1066946400,1080252000,1097791200,1112306400,1128031200,1143756000,116190,1175205600,1193349600,1206655200,1225404000,1238104800,1256853600,1269554400,1288303200,1301608800,1319752800,1333058400,1387486800,1395957600,1414706400],typeOffsets=[8624,0,7200,0,7200,3600],typeMapData=[1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,finalStartYear=2015,finalStartMillis=1.4200704E12,finalZone=SimpleTimeZone:
>  
> Asia/Amman],firstDayOfWeek=1,minimalDaysInFirstWeek=1,repeatedWallTime=0,skippedWallTime=0,ERA=0,YEAR=0,MONTH=0,WEEK_OF_YEAR=0,WEEK_OF_MONTH=0,DAY_OF_MONTH=0,DAY_OF_YEAR=0,DAY_OF_WEEK=0,DAY_OF_WEEK_IN_MONTH=0,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0,YEAR_WOY=0,DOW_LOCAL=0,EXTENDED_YEAR=0,JULIAN_DAY=0,MILLISECONDS_IN_DAY=0,Field
>  22=0]' with class 'com.ibm.icu.util.GregorianCalendar' to class 
> 'java.util.Calendar' (Error running script at location 
> [component://accounting/groovyScripts/reports/GlAccountTrialBalance.groovy]: 
> org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast 
> object 
> 'com.ibm.icu.util.GregorianCalendar[time=148322160,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=com.ibm.icu.impl.OlsonTimeZone@4ebd0d68[transitionCount=71,typeCount=3,transitionTimes=[-1230776624,108165600,118270800,136591200,149806800,168127200,181342800,199749600,215643600,231285600,244501200,262735200,275950800,481154400,496962000,512949600,528670800,544399200,560120400,575848800,592174800,610581600,623624400,641167200,655074000,671839200,685918800,702856800,717973200,733701600,749422800,765151200,779662800,797205600,86000,828655200,843170400,860104800,87462,891554400,906069600,93078,938124000,954367200,970178400,985816800,1001628000,1017352800,1033077600,1048802400,1066946400,1080252000,1097791200,1112306400,1128031200,1143756000,116190,1175205600,1193349600,1206655200,1225404000,1238104800,1256853600,1269554400,1288303200,1301608800,1319752800,1333058400,1387486800,1395957600,1414706400],typeOffsets=[8624,0,7200,0,7200,3600],typeMapData=[1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,finalStartYear=2015,finalStartMillis=1.4200704E12,finalZone=SimpleTimeZone:
>  
> 

[jira] [Commented] (OFBIZ-9216) report GL Account Trial Balance

2017-02-16 Thread Pierre Smits (JIRA)

[ 
https://issues.apache.org/jira/browse/OFBIZ-9216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15869970#comment-15869970
 ] 

Pierre Smits commented on OFBIZ-9216:
-

I don't see it happening in 
https://ofbiz-vm2.apache.org:28443/accounting/control/GlAccountTrialBalance

> report GL Account Trial Balance
> ---
>
> Key: OFBIZ-9216
> URL: https://issues.apache.org/jira/browse/OFBIZ-9216
> Project: OFBiz
>  Issue Type: Bug
>  Components: accounting
>Affects Versions: Trunk, Release Branch 16.11
> Environment: database oracle 12c
>Reporter: Moatasim Al Masri
>Assignee: Pierre Smits
> Attachments: OFBIZ-9216-GlAccountTrialBalance.groovy.patch
>
>
> go to 
> Accouting --> Organization GL Settings -->Accounting button -- >> reports --> 
> GL Account Trial Balance
> when excute this report the give me error 
> NOTE: we used oracle 12c database
> -
> ERROR rendering error page [/error/error.jsp], but here is the error text: 
> org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering 
> screen 
> [component://accounting/widget/ReportFinancialSummaryScreens.xml#GlAccountTrialBalance]:
>  java.lang.IllegalArgumentException: Error running script at location 
> [component://accounting/groovyScripts/reports/GlAccountTrialBalance.groovy]: 
> org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast 
> object 
> 'com.ibm.icu.util.GregorianCalendar[time=148322160,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=com.ibm.icu.impl.OlsonTimeZone@4ebd0d68[transitionCount=71,typeCount=3,transitionTimes=[-1230776624,108165600,118270800,136591200,149806800,168127200,181342800,199749600,215643600,231285600,244501200,262735200,275950800,481154400,496962000,512949600,528670800,544399200,560120400,575848800,592174800,610581600,623624400,641167200,655074000,671839200,685918800,702856800,717973200,733701600,749422800,765151200,779662800,797205600,86000,828655200,843170400,860104800,87462,891554400,906069600,93078,938124000,954367200,970178400,985816800,1001628000,1017352800,1033077600,1048802400,1066946400,1080252000,1097791200,1112306400,1128031200,1143756000,116190,1175205600,1193349600,1206655200,1225404000,1238104800,1256853600,1269554400,1288303200,1301608800,1319752800,1333058400,1387486800,1395957600,1414706400],typeOffsets=[8624,0,7200,0,7200,3600],typeMapData=[1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,finalStartYear=2015,finalStartMillis=1.4200704E12,finalZone=SimpleTimeZone:
>  
> Asia/Amman],firstDayOfWeek=1,minimalDaysInFirstWeek=1,repeatedWallTime=0,skippedWallTime=0,ERA=0,YEAR=0,MONTH=0,WEEK_OF_YEAR=0,WEEK_OF_MONTH=0,DAY_OF_MONTH=0,DAY_OF_YEAR=0,DAY_OF_WEEK=0,DAY_OF_WEEK_IN_MONTH=0,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0,YEAR_WOY=0,DOW_LOCAL=0,EXTENDED_YEAR=0,JULIAN_DAY=0,MILLISECONDS_IN_DAY=0,Field
>  22=0]' with class 'com.ibm.icu.util.GregorianCalendar' to class 
> 'java.util.Calendar' (Error running script at location 
> [component://accounting/groovyScripts/reports/GlAccountTrialBalance.groovy]: 
> org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast 
> object 
> 'com.ibm.icu.util.GregorianCalendar[time=148322160,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=com.ibm.icu.impl.OlsonTimeZone@4ebd0d68[transitionCount=71,typeCount=3,transitionTimes=[-1230776624,108165600,118270800,136591200,149806800,168127200,181342800,199749600,215643600,231285600,244501200,262735200,275950800,481154400,496962000,512949600,528670800,544399200,560120400,575848800,592174800,610581600,623624400,641167200,655074000,671839200,685918800,702856800,717973200,733701600,749422800,765151200,779662800,797205600,86000,828655200,843170400,860104800,87462,891554400,906069600,93078,938124000,954367200,970178400,985816800,1001628000,1017352800,1033077600,1048802400,1066946400,1080252000,1097791200,1112306400,1128031200,1143756000,116190,1175205600,1193349600,1206655200,1225404000,1238104800,1256853600,1269554400,1288303200,1301608800,1319752800,1333058400,1387486800,1395957600,1414706400],typeOffsets=[8624,0,7200,0,7200,3600],typeMapData=[1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,finalStartYear=2015,finalStartMillis=1.4200704E12,finalZone=SimpleTimeZone:
>  
> 

[jira] [Commented] (OFBIZ-9216) report GL Account Trial Balance

2017-02-16 Thread Jacques Le Roux (JIRA)

[ 
https://issues.apache.org/jira/browse/OFBIZ-9216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15869947#comment-15869947
 ] 

Jacques Le Roux commented on OFBIZ-9216:


Thanks Moatasim, Ahmad,

Pierre, your patch is in 
trunk r1783202
R16.11 r1783211

Older releases have conflicts, I let that for interested persons...

> report GL Account Trial Balance
> ---
>
> Key: OFBIZ-9216
> URL: https://issues.apache.org/jira/browse/OFBIZ-9216
> Project: OFBiz
>  Issue Type: Bug
>  Components: accounting
>Affects Versions: Trunk, Release Branch 16.11
> Environment: database oracle 12c
>Reporter: Moatasim Al Masri
>Assignee: Pierre Smits
> Attachments: OFBIZ-9216-GlAccountTrialBalance.groovy.patch
>
>
> go to 
> Accouting --> Organization GL Settings -->Accounting button -- >> reports --> 
> GL Account Trial Balance
> when excute this report the give me error 
> NOTE: we used oracle 12c database
> -
> ERROR rendering error page [/error/error.jsp], but here is the error text: 
> org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering 
> screen 
> [component://accounting/widget/ReportFinancialSummaryScreens.xml#GlAccountTrialBalance]:
>  java.lang.IllegalArgumentException: Error running script at location 
> [component://accounting/groovyScripts/reports/GlAccountTrialBalance.groovy]: 
> org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast 
> object 
> 'com.ibm.icu.util.GregorianCalendar[time=148322160,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=com.ibm.icu.impl.OlsonTimeZone@4ebd0d68[transitionCount=71,typeCount=3,transitionTimes=[-1230776624,108165600,118270800,136591200,149806800,168127200,181342800,199749600,215643600,231285600,244501200,262735200,275950800,481154400,496962000,512949600,528670800,544399200,560120400,575848800,592174800,610581600,623624400,641167200,655074000,671839200,685918800,702856800,717973200,733701600,749422800,765151200,779662800,797205600,86000,828655200,843170400,860104800,87462,891554400,906069600,93078,938124000,954367200,970178400,985816800,1001628000,1017352800,1033077600,1048802400,1066946400,1080252000,1097791200,1112306400,1128031200,1143756000,116190,1175205600,1193349600,1206655200,1225404000,1238104800,1256853600,1269554400,1288303200,1301608800,1319752800,1333058400,1387486800,1395957600,1414706400],typeOffsets=[8624,0,7200,0,7200,3600],typeMapData=[1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,finalStartYear=2015,finalStartMillis=1.4200704E12,finalZone=SimpleTimeZone:
>  
> Asia/Amman],firstDayOfWeek=1,minimalDaysInFirstWeek=1,repeatedWallTime=0,skippedWallTime=0,ERA=0,YEAR=0,MONTH=0,WEEK_OF_YEAR=0,WEEK_OF_MONTH=0,DAY_OF_MONTH=0,DAY_OF_YEAR=0,DAY_OF_WEEK=0,DAY_OF_WEEK_IN_MONTH=0,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0,YEAR_WOY=0,DOW_LOCAL=0,EXTENDED_YEAR=0,JULIAN_DAY=0,MILLISECONDS_IN_DAY=0,Field
>  22=0]' with class 'com.ibm.icu.util.GregorianCalendar' to class 
> 'java.util.Calendar' (Error running script at location 
> [component://accounting/groovyScripts/reports/GlAccountTrialBalance.groovy]: 
> org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast 
> object 
> 'com.ibm.icu.util.GregorianCalendar[time=148322160,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=com.ibm.icu.impl.OlsonTimeZone@4ebd0d68[transitionCount=71,typeCount=3,transitionTimes=[-1230776624,108165600,118270800,136591200,149806800,168127200,181342800,199749600,215643600,231285600,244501200,262735200,275950800,481154400,496962000,512949600,528670800,544399200,560120400,575848800,592174800,610581600,623624400,641167200,655074000,671839200,685918800,702856800,717973200,733701600,749422800,765151200,779662800,797205600,86000,828655200,843170400,860104800,87462,891554400,906069600,93078,938124000,954367200,970178400,985816800,1001628000,1017352800,1033077600,1048802400,1066946400,1080252000,1097791200,1112306400,1128031200,1143756000,116190,1175205600,1193349600,1206655200,1225404000,1238104800,1256853600,1269554400,1288303200,1301608800,1319752800,1333058400,1387486800,1395957600,1414706400],typeOffsets=[8624,0,7200,0,7200,3600],typeMapData=[1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,finalStartYear=2015,finalStartMillis=1.4200704E12,finalZone=SimpleTimeZone:
>  
> 

[jira] [Commented] (OFBIZ-9216) report GL Account Trial Balance

2017-02-16 Thread Moatasim Al Masri (JIRA)

[ 
https://issues.apache.org/jira/browse/OFBIZ-9216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15869740#comment-15869740
 ] 

Moatasim Al Masri commented on OFBIZ-9216:
--

thank you Ahmad, this import statement solved my issue 

> report GL Account Trial Balance
> ---
>
> Key: OFBIZ-9216
> URL: https://issues.apache.org/jira/browse/OFBIZ-9216
> Project: OFBiz
>  Issue Type: Bug
>  Components: accounting
>Affects Versions: Release Branch 16.11
> Environment: database oracle 12c
>Reporter: Moatasim Al Masri
>
> go to 
> Accouting --> Organization GL Settings -->Accounting button -- >> reports --> 
> GL Account Trial Balance
> when excute this report the give me error 
> NOTE: we used oracle 12c database
> -
> ERROR rendering error page [/error/error.jsp], but here is the error text: 
> org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering 
> screen 
> [component://accounting/widget/ReportFinancialSummaryScreens.xml#GlAccountTrialBalance]:
>  java.lang.IllegalArgumentException: Error running script at location 
> [component://accounting/groovyScripts/reports/GlAccountTrialBalance.groovy]: 
> org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast 
> object 
> 'com.ibm.icu.util.GregorianCalendar[time=148322160,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=com.ibm.icu.impl.OlsonTimeZone@4ebd0d68[transitionCount=71,typeCount=3,transitionTimes=[-1230776624,108165600,118270800,136591200,149806800,168127200,181342800,199749600,215643600,231285600,244501200,262735200,275950800,481154400,496962000,512949600,528670800,544399200,560120400,575848800,592174800,610581600,623624400,641167200,655074000,671839200,685918800,702856800,717973200,733701600,749422800,765151200,779662800,797205600,86000,828655200,843170400,860104800,87462,891554400,906069600,93078,938124000,954367200,970178400,985816800,1001628000,1017352800,1033077600,1048802400,1066946400,1080252000,1097791200,1112306400,1128031200,1143756000,116190,1175205600,1193349600,1206655200,1225404000,1238104800,1256853600,1269554400,1288303200,1301608800,1319752800,1333058400,1387486800,1395957600,1414706400],typeOffsets=[8624,0,7200,0,7200,3600],typeMapData=[1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,finalStartYear=2015,finalStartMillis=1.4200704E12,finalZone=SimpleTimeZone:
>  
> Asia/Amman],firstDayOfWeek=1,minimalDaysInFirstWeek=1,repeatedWallTime=0,skippedWallTime=0,ERA=0,YEAR=0,MONTH=0,WEEK_OF_YEAR=0,WEEK_OF_MONTH=0,DAY_OF_MONTH=0,DAY_OF_YEAR=0,DAY_OF_WEEK=0,DAY_OF_WEEK_IN_MONTH=0,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0,YEAR_WOY=0,DOW_LOCAL=0,EXTENDED_YEAR=0,JULIAN_DAY=0,MILLISECONDS_IN_DAY=0,Field
>  22=0]' with class 'com.ibm.icu.util.GregorianCalendar' to class 
> 'java.util.Calendar' (Error running script at location 
> [component://accounting/groovyScripts/reports/GlAccountTrialBalance.groovy]: 
> org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast 
> object 
> 'com.ibm.icu.util.GregorianCalendar[time=148322160,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=com.ibm.icu.impl.OlsonTimeZone@4ebd0d68[transitionCount=71,typeCount=3,transitionTimes=[-1230776624,108165600,118270800,136591200,149806800,168127200,181342800,199749600,215643600,231285600,244501200,262735200,275950800,481154400,496962000,512949600,528670800,544399200,560120400,575848800,592174800,610581600,623624400,641167200,655074000,671839200,685918800,702856800,717973200,733701600,749422800,765151200,779662800,797205600,86000,828655200,843170400,860104800,87462,891554400,906069600,93078,938124000,954367200,970178400,985816800,1001628000,1017352800,1033077600,1048802400,1066946400,1080252000,1097791200,1112306400,1128031200,1143756000,116190,1175205600,1193349600,1206655200,1225404000,1238104800,1256853600,1269554400,1288303200,1301608800,1319752800,1333058400,1387486800,1395957600,1414706400],typeOffsets=[8624,0,7200,0,7200,3600],typeMapData=[1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,finalStartYear=2015,finalStartMillis=1.4200704E12,finalZone=SimpleTimeZone:
>  
> Asia/Amman],firstDayOfWeek=1,minimalDaysInFirstWeek=1,repeatedWallTime=0,skippedWallTime=0,ERA=0,YEAR=0,MONTH=0,WEEK_OF_YEAR=0,WEEK_OF_MONTH=0,DAY_OF_MONTH=0,DAY_OF_YEAR=0,DAY_OF_WEEK=0,DAY_OF_WEEK_IN_MONTH=0,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0,YEAR_WOY=0,DOW_LOCAL=0,EXTENDED_YEAR=0,JULIAN_DAY=0,MILLISECONDS_IN_DAY=0,Field
>  22=0]' with class 'com.ibm.icu.util.GregorianCalendar' to class 
> 

[jira] [Commented] (OFBIZ-9216) report GL Account Trial Balance

2017-02-16 Thread ahmad alajarmeh (JIRA)

[ 
https://issues.apache.org/jira/browse/OFBIZ-9216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15869731#comment-15869731
 ] 

ahmad alajarmeh commented on OFBIZ-9216:


you can solve this problem :
go to groovy file with name "GlAccountTrialBalance.groovy" ,
 and insert this line as import statment "import com.ibm.icu.util.Calendar"

> report GL Account Trial Balance
> ---
>
> Key: OFBIZ-9216
> URL: https://issues.apache.org/jira/browse/OFBIZ-9216
> Project: OFBiz
>  Issue Type: Bug
>  Components: accounting
>Affects Versions: Release Branch 16.11
> Environment: database oracle 12c
>Reporter: Moatasim Al Masri
>
> go to 
> Accouting --> Organization GL Settings -->Accounting button -- >> reports --> 
> GL Account Trial Balance
> when excute this report the give me error 
> NOTE: we used oracle 12c database
> -
> ERROR rendering error page [/error/error.jsp], but here is the error text: 
> org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering 
> screen 
> [component://accounting/widget/ReportFinancialSummaryScreens.xml#GlAccountTrialBalance]:
>  java.lang.IllegalArgumentException: Error running script at location 
> [component://accounting/groovyScripts/reports/GlAccountTrialBalance.groovy]: 
> org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast 
> object 
> 'com.ibm.icu.util.GregorianCalendar[time=148322160,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=com.ibm.icu.impl.OlsonTimeZone@4ebd0d68[transitionCount=71,typeCount=3,transitionTimes=[-1230776624,108165600,118270800,136591200,149806800,168127200,181342800,199749600,215643600,231285600,244501200,262735200,275950800,481154400,496962000,512949600,528670800,544399200,560120400,575848800,592174800,610581600,623624400,641167200,655074000,671839200,685918800,702856800,717973200,733701600,749422800,765151200,779662800,797205600,86000,828655200,843170400,860104800,87462,891554400,906069600,93078,938124000,954367200,970178400,985816800,1001628000,1017352800,1033077600,1048802400,1066946400,1080252000,1097791200,1112306400,1128031200,1143756000,116190,1175205600,1193349600,1206655200,1225404000,1238104800,1256853600,1269554400,1288303200,1301608800,1319752800,1333058400,1387486800,1395957600,1414706400],typeOffsets=[8624,0,7200,0,7200,3600],typeMapData=[1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,finalStartYear=2015,finalStartMillis=1.4200704E12,finalZone=SimpleTimeZone:
>  
> Asia/Amman],firstDayOfWeek=1,minimalDaysInFirstWeek=1,repeatedWallTime=0,skippedWallTime=0,ERA=0,YEAR=0,MONTH=0,WEEK_OF_YEAR=0,WEEK_OF_MONTH=0,DAY_OF_MONTH=0,DAY_OF_YEAR=0,DAY_OF_WEEK=0,DAY_OF_WEEK_IN_MONTH=0,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0,YEAR_WOY=0,DOW_LOCAL=0,EXTENDED_YEAR=0,JULIAN_DAY=0,MILLISECONDS_IN_DAY=0,Field
>  22=0]' with class 'com.ibm.icu.util.GregorianCalendar' to class 
> 'java.util.Calendar' (Error running script at location 
> [component://accounting/groovyScripts/reports/GlAccountTrialBalance.groovy]: 
> org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast 
> object 
> 'com.ibm.icu.util.GregorianCalendar[time=148322160,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=com.ibm.icu.impl.OlsonTimeZone@4ebd0d68[transitionCount=71,typeCount=3,transitionTimes=[-1230776624,108165600,118270800,136591200,149806800,168127200,181342800,199749600,215643600,231285600,244501200,262735200,275950800,481154400,496962000,512949600,528670800,544399200,560120400,575848800,592174800,610581600,623624400,641167200,655074000,671839200,685918800,702856800,717973200,733701600,749422800,765151200,779662800,797205600,86000,828655200,843170400,860104800,87462,891554400,906069600,93078,938124000,954367200,970178400,985816800,1001628000,1017352800,1033077600,1048802400,1066946400,1080252000,1097791200,1112306400,1128031200,1143756000,116190,1175205600,1193349600,1206655200,1225404000,1238104800,1256853600,1269554400,1288303200,1301608800,1319752800,1333058400,1387486800,1395957600,1414706400],typeOffsets=[8624,0,7200,0,7200,3600],typeMapData=[1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,finalStartYear=2015,finalStartMillis=1.4200704E12,finalZone=SimpleTimeZone:
>  
>