-----------> ConnectionPool.abandon: Connection has been abandoned PooledConnection[org.postgresql.jdbc.PgConnection@57d1fe34]:java.lang.Exception at org.apache.tomcat.jdbc.pool.ConnectionPool.getThreadDump(ConnectionPool.java:1104) at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:808) at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:652) at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198) at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:132) at org.compiere.db.DB_PostgreSQL.getCachedConnection(DB_PostgreSQL.java:579) at org.compiere.db.CConnection.getConnection(CConnection.java:1321) at org.compiere.util.DB.createConnection(DB.java:435) at org.compiere.util.Trx.getConnection(Trx.java:284) at org.compiere.util.Trx.getConnection(Trx.java:263) at org.compiere.db.PreparedStatementProxy.init(PreparedStatementProxy.java:61) at org.compiere.db.PreparedStatementProxy.(PreparedStatementProxy.java:44) at org.compiere.db.ProxyFactory.newCPreparedStatement(ProxyFactory.java:54) at org.compiere.util.DB.executeUpdate(DB.java:1063) at org.compiere.util.DB.executeUpdate(DB.java:933) at org.compiere.util.DB.executeUpdate(DB.java:920) at org.compiere.report.FinReport.doIt(FinReport.java:336) at org.compiere.process.SvrProcess.process(SvrProcess.java:362) at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:131) at org.posterita.struts.pos.DocumentAction.viewFinancialReport(DocumentAction.java:859) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.posterita.struts.filter.RoleFilter.doFilter(RoleFilter.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) [22] Sep 19, 2021 9:32:57 PM org.compiere.model.PO set_ValueNoCheck WARNING: ReleaseNo - Value too long - truncated to length=4 ===========> DB.executeUpdate: UPDATE T_Report SET Col_0 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-04-30','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_1 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-05-31','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_2 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-06-30','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_3 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-07-31','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_4 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-08-31','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_5 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-09-30','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_6 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-10-31','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_7 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-11-30','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_8 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-12-31','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_9 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2021-01-31','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_10 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2021-02-28','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_11 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2021-03-31','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)) WHERE AD_PInstance_ID=1592882 AND PA_ReportLine_ID=1000142 AND ABS(LevelNo)<2 [SvrProcess_76089_6bc45ab2-1191-4a8f-a25c-5a91eddfef23] [76089] org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.; State=08006; ErrorCode=0 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:339) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153) at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:119) at sun.reflect.GeneratedMethodAccessor111.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:210) at com.sun.proxy.$Proxy6.executeUpdate(Unknown Source) at sun.reflect.GeneratedMethodAccessor111.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) at com.sun.proxy.$Proxy6.executeUpdate(Unknown Source) at sun.reflect.GeneratedMethodAccessor89436.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.compiere.db.StatementProxy.invoke(StatementProxy.java:101) at com.sun.proxy.$Proxy7.executeUpdate(Unknown Source) at org.compiere.util.DB.executeUpdate(DB.java:1071) at org.compiere.util.DB.executeUpdate(DB.java:933) at org.compiere.util.DB.executeUpdate(DB.java:920) at org.compiere.report.FinReport.insertLine(FinReport.java:539) at org.compiere.report.FinReport.doIt(FinReport.java:352) at org.compiere.process.SvrProcess.process(SvrProcess.java:362) at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:131) caused by: java.net.SocketException: Socket closed at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:161) at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:128) at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:113) at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73) at org.postgresql.core.PGStream.receiveChar(PGStream.java:370) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2043) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153) at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:119) at sun.reflect.GeneratedMethodAccessor111.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:210) at com.sun.proxy.$Proxy6.executeUpdate(Unknown Source) at sun.reflect.GeneratedMethodAccessor111.invoke(Unknown Source) ===========> DB.saveError: DBExecuteError - An I/O error occurred while sending to the backend. [76089] Sep 19, 2021 9:32:57 PM org.compiere.report.FinReport insertLine SEVERE: #=-1 for UPDATE T_Report SET Col_0 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_DATE('2009-04-01','YYYY-MM-DD') AND TO_DATE('2020-04-30','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_1 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_DATE('2009-04-01','YYYY-MM-DD') AND TO_DATE('2020-05-31','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_2 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_DATE('2009-04-01','YYYY-MM-DD') AND TO_DATE('2020-06-30','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_3 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_DATE('2009-04-01','YYYY-MM-DD') AND TO_DATE('2020-07-31','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_4 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_DATE('2009-04-01','YYYY-MM-DD') AND TO_DATE('2020-08-31','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_5 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_DATE('2009-04-01','YYYY-MM-DD') AND TO_DATE('2020-09-30','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_6 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_DATE('2009-04-01','YYYY-MM-DD') AND TO_DATE('2020-10-31','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_7 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_DATE('2009-04-01','YYYY-MM-DD') AND TO_DATE('2020-11-30','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_8 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_DATE('2009-04-01','YYYY-MM-DD') AND TO_DATE('2020-12-31','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_9 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_DATE('2009-04-01','YYYY-MM-DD') AND TO_DATE('2021-01-31','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_10 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_DATE('2009-04-01','YYYY-MM-DD') AND TO_DATE('2021-02-28','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), Col_11 = (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_DATE('2009-04-01','YYYY-MM-DD') AND TO_DATE('2021-03-31','YYYY-MM-DD') AND ( Account_ID=1000267 OR Account_ID=1000268 OR Account_ID=1000121 OR Account_ID=1000269 OR Account_ID=1000118 OR Account_ID=1000210 OR Account_ID=1000211 OR Account_ID=1000119 OR Account_ID=1000116 OR Account_ID=1000123 OR Account_ID=1010819 OR Account_ID=1000788 OR Account_ID=1000782 OR Account_ID=1000773 OR Account_ID=1000760 OR Account_ID=1000215 OR Account_ID=1000755 OR Account_ID=1000535 OR Account_ID=1000490 OR Account_ID=1000218 OR Account_ID=1000216 OR Account_ID=1000418 OR Account_ID=1000213 OR Account_ID=1000212 OR Account_ID=1000427 OR Account_ID=1000026 OR Account_ID=1000064 OR Account_ID=1000040 OR Account_ID=1000035 OR Account_ID=1000410 OR Account_ID=1000054 OR Account_ID=1000461 OR Account_ID=1000061 OR Account_ID=1000057 OR Account_ID=1000016 OR Account_ID=1000056 OR Account_ID=1000290 OR Account_ID=1000779 OR Account_ID=1000495 OR Account_ID=1000494 OR Account_ID=1000738 OR Account_ID=1000730 OR Account_ID=1000548 OR Account_ID=1000546 OR Account_ID=1000031 OR Account_ID=1000039 OR Account_ID=1000081 OR Account_ID=1000484 OR Account_ID=1000483 OR Account_ID=1000282 OR Account_ID=1000284 OR Account_ID=1000276 OR Account_ID=1000285 OR Account_ID=1000277 OR Account_ID=1000287 OR Account_ID=1000279 OR Account_ID=1000288 OR Account_ID=1000280 OR Account_ID=1000289 OR Account_ID=1000281 OR Account_ID=1000286 OR Account_ID=1000278 OR Account_ID=1000046 OR Account_ID=1000283 OR Account_ID=1000291 OR Account_ID=1000544 OR Account_ID=1000034 OR Account_ID=1000464 OR Account_ID=1000442 OR Account_ID=1000110 OR Account_ID=1000004 OR Account_ID=1000752 OR Account_ID=1000744 OR Account_ID=1000542 OR Account_ID=1000541 OR Account_ID=1000540 OR Account_ID=1010821 OR Account_ID=1010817 OR Account_ID=1010813 OR Account_ID=1010800 OR Account_ID=1010799 OR Account_ID=1010798 OR Account_ID=1010797 OR Account_ID=1000783 OR Account_ID=1000780 OR Account_ID=1000776 OR Account_ID=1000772 OR Account_ID=1000775 OR Account_ID=1000774 OR Account_ID=1000771 OR Account_ID=1000770 OR Account_ID=1000769 OR Account_ID=1000768 OR Account_ID=1000767 OR Account_ID=1000757 OR Account_ID=1000756 OR Account_ID=1000761 OR Account_ID=1000759 OR Account_ID=1000754 OR Account_ID=1000751 OR Account_ID=1000750 OR Account_ID=1000747 OR Account_ID=1000554 OR Account_ID=1000549 OR Account_ID=1000547 OR Account_ID=1000537 OR Account_ID=1000505 OR Account_ID=1000504 OR Account_ID=1000501 OR Account_ID=1000456 OR Account_ID=1000195 OR Account_ID=1000197 OR Account_ID=1000457 OR Account_ID=1000193 OR Account_ID=1000194 OR Account_ID=1000198 OR Account_ID=1000196 OR Account_ID=1000454 OR Account_ID=1000199 OR Account_ID=1010795 OR Account_ID=1000790 OR Account_ID=1000789 OR Account_ID=1000787 OR Account_ID=1000785 OR Account_ID=1000784 OR Account_ID=1000781 OR Account_ID=1000777 OR Account_ID=1000735 OR Account_ID=1000420 OR Account_ID=1000538 OR Account_ID=1000536 OR Account_ID=1000491 OR Account_ID=1000488 OR Account_ID=1000422 OR Account_ID=1000209 OR Account_ID=1000208 OR Account_ID=1000207 OR Account_ID=1000205 OR Account_ID=1000204 OR Account_ID=1000202 OR Account_ID=1000201 OR Account_ID=1000203 OR Account_ID=1000471 OR Account_ID=1000077 OR Account_ID=1000030 OR Account_ID=1000063 OR Account_ID=1000018 OR Account_ID=1000059 OR Account_ID=1000206 OR Account_ID=1000737 OR Account_ID=1000275 OR Account_ID=1000273 OR Account_ID=1000274 OR Account_ID=1000272 OR Account_ID=1000271 OR Account_ID=1000766 OR Account_ID=1000762 OR Account_ID=1000555 OR Account_ID=1000553 OR Account_ID=1000552 OR Account_ID=1000550 OR Account_ID=1000438 OR Account_ID=1000239 OR Account_ID=1000237 OR Account_ID=1000451 OR Account_ID=1000450 OR Account_ID=1000449 OR Account_ID=1000448 OR Account_ID=1000226 OR Account_ID=1000225 OR Account_ID=1000223 OR Account_ID=1000426 OR Account_ID=1000229 OR Account_ID=1000459 OR Account_ID=1000224 OR Account_ID=1000217 OR Account_ID=1000179 OR Account_ID=1000180 OR Account_ID=1000181 OR Account_ID=1000182 OR Account_ID=1000183 OR Account_ID=1000184 OR Account_ID=1000185 OR Account_ID=1000430 OR Account_ID=1000190 OR Account_ID=1000189 OR Account_ID=1000188 OR Account_ID=1000187 OR Account_ID=1000186 OR Account_ID=1000258 OR Account_ID=1000259 OR Account_ID=1000260 OR Account_ID=1000261 OR Account_ID=1000262 OR Account_ID=1000263 OR Account_ID=1000264 OR Account_ID=1000265 OR Account_ID=1000266 OR Account_ID=1000252 OR Account_ID=1000253 OR Account_ID=1000254 OR Account_ID=1000255 OR Account_ID=1000256 OR Account_ID=1000241 OR Account_ID=1000242 OR Account_ID=1000243 OR Account_ID=1000244 OR Account_ID=1000245 OR Account_ID=1000228 OR Account_ID=1000099 OR Account_ID=1000246 OR Account_ID=1000238 OR Account_ID=1000236 OR Account_ID=1000235 OR Account_ID=1000230 OR Account_ID=1000231 OR Account_ID=1000232 OR Account_ID=1000233 OR Account_ID=1000227 OR Account_ID=1000221 OR Account_ID=1000222 OR Account_ID=1010796 OR Account_ID=1000786 OR Account_ID=1000758 OR Account_ID=1000545 OR Account_ID=1000503 OR Account_ID=1000502 OR Account_ID=1000248 OR Account_ID=1000247 OR Account_ID=1010816 OR Account_ID=1000452 OR Account_ID=1000453 OR Account_ID=1000250 ) AND C_AcctSchema_ID=1000000 AND PostingType='A' AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)) WHERE AD_PInstance_ID=1592882 AND PA_ReportLine_ID=1000142 AND ABS(LevelNo)<2 Sep 19, 2021 9:32:57 PM org.compiere.db.PreparedStatementProxy init SEVERE: INSERT INTO T_Report (AD_PInstance_ID, PA_ReportLine_ID, Record_ID,Fact_Acct_ID,LevelNo ,Col_0,Col_1,Col_2,Col_3,Col_4,Col_5,Col_6,Col_7,Col_8,Col_9,Col_10,Col_11) SELECT 1592882,1000137,Account_ID,0,1 , (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-04-30','YYYY-MM-DD') AND fa.Account_ID=x.Account_ID AND fa.PostingType='A' AND C_AcctSchema_ID=1000000 AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-05-31','YYYY-MM-DD') AND fa.Account_ID=x.Account_ID AND fa.PostingType='A' AND C_AcctSchema_ID=1000000 AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-06-30','YYYY-MM-DD') AND fa.Account_ID=x.Account_ID AND fa.PostingType='A' AND C_AcctSchema_ID=1000000 AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-07-31','YYYY-MM-DD') AND fa.Account_ID=x.Account_ID AND fa.PostingType='A' AND C_AcctSchema_ID=1000000 AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-08-31','YYYY-MM-DD') AND fa.Account_ID=x.Account_ID AND fa.PostingType='A' AND C_AcctSchema_ID=1000000 AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-09-30','YYYY-MM-DD') AND fa.Account_ID=x.Account_ID AND fa.PostingType='A' AND C_AcctSchema_ID=1000000 AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-10-31','YYYY-MM-DD') AND fa.Account_ID=x.Account_ID AND fa.PostingType='A' AND C_AcctSchema_ID=1000000 AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-11-30','YYYY-MM-DD') AND fa.Account_ID=x.Account_ID AND fa.PostingType='A' AND C_AcctSchema_ID=1000000 AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2020-12-31','YYYY-MM-DD') AND fa.Account_ID=x.Account_ID AND fa.PostingType='A' AND C_AcctSchema_ID=1000000 AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2021-01-31','YYYY-MM-DD') AND fa.Account_ID=x.Account_ID AND fa.PostingType='A' AND C_AcctSchema_ID=1000000 AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2021-02-28','YYYY-MM-DD') AND fa.Account_ID=x.Account_ID AND fa.PostingType='A' AND C_AcctSchema_ID=1000000 AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)), (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr,ev.Accounttype,ev.AccountSign)) FROM Fact_Acct fa join c_elementvalue ev on ev.c_elementvalue_id= fa.account_id WHERE TRUNC(DateAcct) BETWEEN TO_TIMESTAMP('2009-04-01','YYYY-MM-DD') AND TO_TIMESTAMP('2021-03-31','YYYY-MM-DD') AND fa.Account_ID=x.Account_ID AND fa.PostingType='A' AND C_AcctSchema_ID=1000000 AND fa.AD_ORG_ID in (0,1000000,1000002,1000001)) FROM Fact_Acct x WHERE ( Account_ID=1000492 OR Account_ID=1000753 OR Account_ID=1000499 OR Account_ID=1000177 OR Account_ID=1000176 OR Account_ID=1000175 OR Account_ID=1000174 OR Account_ID=1000437 OR Account_ID=1000076 OR Account_ID=1010818 OR Account_ID=1000443 OR Account_ID=1000065 OR Account_ID=1000011 OR Account_ID=1000436 OR Account_ID=1000446 OR Account_ID=1000433 OR Account_ID=1000088 OR Account_ID=1000440 OR Account_ID=1000441 OR Account_ID=1000013 OR Account_ID=1000445 OR Account_ID=1000428 OR Account_ID=1000421 OR Account_ID=1000432 OR Account_ID=1000473 OR Account_ID=1000460 OR Account_ID=1000462 OR Account_ID=1000413 OR Account_ID=1000117 OR Account_ID=1000411 OR Account_ID=1000467 OR Account_ID=1010814 OR Account_ID=1000032 OR Account_ID=1000073 OR Account_ID=1000078 OR Account_ID=1000037 OR Account_ID=1000092 OR Account_ID=1000093 OR Account_ID=1000055 OR Account_ID=1000058 OR Account_ID=1000045 OR Account_ID=1000095 ) AND C_AcctSchema_ID=1000000 AND Account_ID IS NOT NULL AND AD_ORG_ID in (0,1000000,1000002,1000001) GROUP BY Account_ID java.sql.SQLException: Connection has already been closed. at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:117) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75) at org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer.invoke(ResetAbandonedTimer.java:75) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:152) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:40) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81) at com.sun.proxy.$Proxy5.prepareStatement(Unknown Source) at org.compiere.db.PreparedStatementProxy.init(PreparedStatementProxy.java:71) at org.compiere.db.PreparedStatementProxy.(PreparedStatementProxy.java:44) at org.compiere.db.ProxyFactory.newCPreparedStatement(ProxyFactory.java:54) at org.compiere.util.DB.executeUpdate(DB.java:1063) at org.compiere.util.DB.executeUpdate(DB.java:933) at org.compiere.util.DB.executeUpdate(DB.java:920) at org.compiere.report.FinReport.insertLineSource(FinReport.java:1076) at org.compiere.report.FinReport.insertLineDetail(FinReport.java:899) at org.compiere.report.FinReport.doIt(FinReport.java:355) at org.compiere.process.SvrProcess.process(SvrProcess.java:362) at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:131) at org.posterita.struts.pos.DocumentAction.viewFinancialReport(DocumentAction.java:859) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.posterita.struts.filter.RoleFilter.doFilter(RoleFilter.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Sep 19, 2021 9:32:57 PM org.compiere.process.SvrProcess process WARNING: java.sql.SQLException: Connection has already been closed. java.sql.SQLException: Connection has already been closed. at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:117) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75) at org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer.invoke(ResetAbandonedTimer.java:75) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:152) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:40) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81) at com.sun.proxy.$Proxy5.prepareStatement(Unknown Source) at org.compiere.db.PreparedStatementProxy.init(PreparedStatementProxy.java:71) at org.compiere.db.PreparedStatementProxy.(PreparedStatementProxy.java:44) at org.compiere.db.ProxyFactory.newCPreparedStatement(ProxyFactory.java:54) at org.compiere.util.DB.executeUpdate(DB.java:1063) at org.compiere.util.DB.executeUpdate(DB.java:933) at org.compiere.util.DB.executeUpdate(DB.java:920) at org.compiere.report.FinReport.insertLineSource(FinReport.java:1076) at org.compiere.report.FinReport.insertLineDetail(FinReport.java:899) at org.compiere.report.FinReport.doIt(FinReport.java:355) at org.compiere.process.SvrProcess.process(SvrProcess.java:362) at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:131) at org.posterita.struts.pos.DocumentAction.viewFinancialReport(DocumentAction.java:859) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.posterita.struts.filter.RoleFilter.doFilter(RoleFilter.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Sep 19, 2021 9:32:57 PM org.compiere.util.Trx rollback SEVERE: SvrProcess_76089_6bc45ab2-1191-4a8f-a25c-5a91eddfef23 java.sql.SQLException: Connection has already been closed. at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:117) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:79) at org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer.invoke(ResetAbandonedTimer.java:75) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:79) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:152) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:40) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:79) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108) at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81) at com.sun.proxy.$Proxy5.rollback(Unknown Source) at org.compiere.util.Trx.rollback(Trx.java:384) at org.compiere.util.Trx.rollback(Trx.java:423) at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:148) at org.posterita.struts.pos.DocumentAction.viewFinancialReport(DocumentAction.java:859) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.posterita.struts.filter.RoleFilter.doFilter(RoleFilter.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)