|
1
|
-----------> ConnectionPool.abandon: Connection has been abandoned PooledConnection[org.postgresql.jdbc.PgConnection@57d1fe34]:java.lang.Exception
|
|
2
|
at org.apache.tomcat.jdbc.pool.ConnectionPool.getThreadDump(ConnectionPool.java:1104)
|
|
3
|
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:808)
|
|
4
|
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:652)
|
|
5
|
at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198)
|
|
6
|
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:132)
|
|
7
|
at org.compiere.db.DB_PostgreSQL.getCachedConnection(DB_PostgreSQL.java:579)
|
|
8
|
at org.compiere.db.CConnection.getConnection(CConnection.java:1321)
|
|
9
|
at org.compiere.util.DB.createConnection(DB.java:435)
|
|
10
|
at org.compiere.util.Trx.getConnection(Trx.java:284)
|
|
11
|
at org.compiere.util.Trx.getConnection(Trx.java:263)
|
|
12
|
at org.compiere.db.PreparedStatementProxy.init(PreparedStatementProxy.java:61)
|
|
13
|
at org.compiere.db.PreparedStatementProxy.<init>(PreparedStatementProxy.java:44)
|
|
14
|
at org.compiere.db.ProxyFactory.newCPreparedStatement(ProxyFactory.java:54)
|
|
15
|
at org.compiere.util.DB.executeUpdate(DB.java:1063)
|
|
16
|
at org.compiere.util.DB.executeUpdate(DB.java:933)
|
|
17
|
at org.compiere.util.DB.executeUpdate(DB.java:920)
|
|
18
|
at org.compiere.report.FinReport.doIt(FinReport.java:336)
|
|
19
|
at org.compiere.process.SvrProcess.process(SvrProcess.java:362)
|
|
20
|
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:131)
|
|
21
|
at org.posterita.struts.pos.DocumentAction.viewFinancialReport(DocumentAction.java:859)
|
|
22
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
|
23
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
|
24
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
25
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
26
|
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
|
|
27
|
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
|
|
28
|
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
|
|
29
|
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
|
|
30
|
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
|
|
31
|
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
|
|
32
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
|
|
33
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
|
|
34
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
|
|
35
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
36
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
|
|
37
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
|
|
38
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
39
|
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
|
|
40
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
|
|
41
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
42
|
at org.posterita.struts.filter.RoleFilter.doFilter(RoleFilter.java:102)
|
|
43
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
|
|
44
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
45
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
|
|
46
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
|
|
47
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
|
|
48
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
|
|
49
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
|
|
50
|
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
|
|
51
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
|
|
52
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
|
|
53
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
|
|
54
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
|
|
55
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
|
|
56
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
|
|
57
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
58
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
|
|
59
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
|
|
60
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
61
|
at java.lang.Thread.run(Thread.java:748)
|
|
62
|
[22]
|
|
63
|
Sep 19, 2021 9:32:57 PM org.compiere.model.PO set_ValueNoCheck
|
|
64
|
WARNING: ReleaseNo - Value too long - truncated to length=4
|
|
65
|
===========> 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]
|
|
66
|
org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.; State=08006; ErrorCode=0
|
|
67
|
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:339)
|
|
68
|
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
|
|
69
|
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
|
|
70
|
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153)
|
|
71
|
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:119)
|
|
72
|
at sun.reflect.GeneratedMethodAccessor111.invoke(Unknown Source)
|
|
73
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
74
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
75
|
at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:210)
|
|
76
|
at com.sun.proxy.$Proxy6.executeUpdate(Unknown Source)
|
|
77
|
at sun.reflect.GeneratedMethodAccessor111.invoke(Unknown Source)
|
|
78
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
79
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
80
|
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
|
|
81
|
at com.sun.proxy.$Proxy6.executeUpdate(Unknown Source)
|
|
82
|
at sun.reflect.GeneratedMethodAccessor89436.invoke(Unknown Source)
|
|
83
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
84
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
85
|
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:101)
|
|
86
|
at com.sun.proxy.$Proxy7.executeUpdate(Unknown Source)
|
|
87
|
at org.compiere.util.DB.executeUpdate(DB.java:1071)
|
|
88
|
at org.compiere.util.DB.executeUpdate(DB.java:933)
|
|
89
|
at org.compiere.util.DB.executeUpdate(DB.java:920)
|
|
90
|
at org.compiere.report.FinReport.insertLine(FinReport.java:539)
|
|
91
|
at org.compiere.report.FinReport.doIt(FinReport.java:352)
|
|
92
|
at org.compiere.process.SvrProcess.process(SvrProcess.java:362)
|
|
93
|
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:131)
|
|
94
|
caused by: java.net.SocketException: Socket closed
|
|
95
|
at java.net.SocketInputStream.socketRead0(Native Method)
|
|
96
|
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
|
|
97
|
at java.net.SocketInputStream.read(SocketInputStream.java:171)
|
|
98
|
at java.net.SocketInputStream.read(SocketInputStream.java:141)
|
|
99
|
at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:161)
|
|
100
|
at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:128)
|
|
101
|
at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:113)
|
|
102
|
at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73)
|
|
103
|
at org.postgresql.core.PGStream.receiveChar(PGStream.java:370)
|
|
104
|
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2043)
|
|
105
|
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)
|
|
106
|
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
|
|
107
|
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
|
|
108
|
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153)
|
|
109
|
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:119)
|
|
110
|
at sun.reflect.GeneratedMethodAccessor111.invoke(Unknown Source)
|
|
111
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
112
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
113
|
at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:210)
|
|
114
|
at com.sun.proxy.$Proxy6.executeUpdate(Unknown Source)
|
|
115
|
at sun.reflect.GeneratedMethodAccessor111.invoke(Unknown Source)
|
|
116
|
|
|
117
|
===========> DB.saveError: DBExecuteError - An I/O error occurred while sending to the backend. [76089]
|
|
118
|
Sep 19, 2021 9:32:57 PM org.compiere.report.FinReport insertLine
|
|
119
|
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
|
|
120
|
Sep 19, 2021 9:32:57 PM org.compiere.db.PreparedStatementProxy init
|
|
121
|
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
|
|
122
|
java.sql.SQLException: Connection has already been closed.
|
|
123
|
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:117)
|
|
124
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
125
|
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75)
|
|
126
|
at org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer.invoke(ResetAbandonedTimer.java:75)
|
|
127
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
128
|
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75)
|
|
129
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
130
|
at org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:152)
|
|
131
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
132
|
at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:40)
|
|
133
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
134
|
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75)
|
|
135
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
136
|
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
|
|
137
|
at com.sun.proxy.$Proxy5.prepareStatement(Unknown Source)
|
|
138
|
at org.compiere.db.PreparedStatementProxy.init(PreparedStatementProxy.java:71)
|
|
139
|
at org.compiere.db.PreparedStatementProxy.<init>(PreparedStatementProxy.java:44)
|
|
140
|
at org.compiere.db.ProxyFactory.newCPreparedStatement(ProxyFactory.java:54)
|
|
141
|
at org.compiere.util.DB.executeUpdate(DB.java:1063)
|
|
142
|
at org.compiere.util.DB.executeUpdate(DB.java:933)
|
|
143
|
at org.compiere.util.DB.executeUpdate(DB.java:920)
|
|
144
|
at org.compiere.report.FinReport.insertLineSource(FinReport.java:1076)
|
|
145
|
at org.compiere.report.FinReport.insertLineDetail(FinReport.java:899)
|
|
146
|
at org.compiere.report.FinReport.doIt(FinReport.java:355)
|
|
147
|
at org.compiere.process.SvrProcess.process(SvrProcess.java:362)
|
|
148
|
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:131)
|
|
149
|
at org.posterita.struts.pos.DocumentAction.viewFinancialReport(DocumentAction.java:859)
|
|
150
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
|
151
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
|
152
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
153
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
154
|
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
|
|
155
|
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
|
|
156
|
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
|
|
157
|
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
|
|
158
|
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
|
|
159
|
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
|
|
160
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
|
|
161
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
|
|
162
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
|
|
163
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
164
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
|
|
165
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
|
|
166
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
167
|
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
|
|
168
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
|
|
169
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
170
|
at org.posterita.struts.filter.RoleFilter.doFilter(RoleFilter.java:102)
|
|
171
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
|
|
172
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
173
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
|
|
174
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
|
|
175
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
|
|
176
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
|
|
177
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
|
|
178
|
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
|
|
179
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
|
|
180
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
|
|
181
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
|
|
182
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
|
|
183
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
|
|
184
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
|
|
185
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
186
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
|
|
187
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
|
|
188
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
189
|
at java.lang.Thread.run(Thread.java:748)
|
|
190
|
|
|
191
|
Sep 19, 2021 9:32:57 PM org.compiere.process.SvrProcess process
|
|
192
|
WARNING: java.sql.SQLException: Connection has already been closed.
|
|
193
|
java.sql.SQLException: Connection has already been closed.
|
|
194
|
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:117)
|
|
195
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
196
|
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75)
|
|
197
|
at org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer.invoke(ResetAbandonedTimer.java:75)
|
|
198
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
199
|
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75)
|
|
200
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
201
|
at org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:152)
|
|
202
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
203
|
at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:40)
|
|
204
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
205
|
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75)
|
|
206
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
207
|
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
|
|
208
|
at com.sun.proxy.$Proxy5.prepareStatement(Unknown Source)
|
|
209
|
at org.compiere.db.PreparedStatementProxy.init(PreparedStatementProxy.java:71)
|
|
210
|
at org.compiere.db.PreparedStatementProxy.<init>(PreparedStatementProxy.java:44)
|
|
211
|
at org.compiere.db.ProxyFactory.newCPreparedStatement(ProxyFactory.java:54)
|
|
212
|
at org.compiere.util.DB.executeUpdate(DB.java:1063)
|
|
213
|
at org.compiere.util.DB.executeUpdate(DB.java:933)
|
|
214
|
at org.compiere.util.DB.executeUpdate(DB.java:920)
|
|
215
|
at org.compiere.report.FinReport.insertLineSource(FinReport.java:1076)
|
|
216
|
at org.compiere.report.FinReport.insertLineDetail(FinReport.java:899)
|
|
217
|
at org.compiere.report.FinReport.doIt(FinReport.java:355)
|
|
218
|
at org.compiere.process.SvrProcess.process(SvrProcess.java:362)
|
|
219
|
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:131)
|
|
220
|
at org.posterita.struts.pos.DocumentAction.viewFinancialReport(DocumentAction.java:859)
|
|
221
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
|
222
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
|
223
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
224
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
225
|
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
|
|
226
|
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
|
|
227
|
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
|
|
228
|
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
|
|
229
|
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
|
|
230
|
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
|
|
231
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
|
|
232
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
|
|
233
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
|
|
234
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
235
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
|
|
236
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
|
|
237
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
238
|
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
|
|
239
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
|
|
240
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
241
|
at org.posterita.struts.filter.RoleFilter.doFilter(RoleFilter.java:102)
|
|
242
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
|
|
243
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
244
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
|
|
245
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
|
|
246
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
|
|
247
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
|
|
248
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
|
|
249
|
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
|
|
250
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
|
|
251
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
|
|
252
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
|
|
253
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
|
|
254
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
|
|
255
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
|
|
256
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
257
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
|
|
258
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
|
|
259
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
260
|
at java.lang.Thread.run(Thread.java:748)
|
|
261
|
|
|
262
|
Sep 19, 2021 9:32:57 PM org.compiere.util.Trx rollback
|
|
263
|
SEVERE: SvrProcess_76089_6bc45ab2-1191-4a8f-a25c-5a91eddfef23
|
|
264
|
java.sql.SQLException: Connection has already been closed.
|
|
265
|
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:117)
|
|
266
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
267
|
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:79)
|
|
268
|
at org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer.invoke(ResetAbandonedTimer.java:75)
|
|
269
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
270
|
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:79)
|
|
271
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
272
|
at org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:152)
|
|
273
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
274
|
at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:40)
|
|
275
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
276
|
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:79)
|
|
277
|
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
|
|
278
|
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
|
|
279
|
at com.sun.proxy.$Proxy5.rollback(Unknown Source)
|
|
280
|
at org.compiere.util.Trx.rollback(Trx.java:384)
|
|
281
|
at org.compiere.util.Trx.rollback(Trx.java:423)
|
|
282
|
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:148)
|
|
283
|
at org.posterita.struts.pos.DocumentAction.viewFinancialReport(DocumentAction.java:859)
|
|
284
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
|
285
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
|
286
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
287
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
288
|
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
|
|
289
|
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
|
|
290
|
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
|
|
291
|
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
|
|
292
|
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
|
|
293
|
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
|
|
294
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
|
|
295
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
|
|
296
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
|
|
297
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
298
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
|
|
299
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
|
|
300
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
301
|
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
|
|
302
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
|
|
303
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
304
|
at org.posterita.struts.filter.RoleFilter.doFilter(RoleFilter.java:102)
|
|
305
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
|
|
306
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
307
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
|
|
308
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
|
|
309
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
|
|
310
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
|
|
311
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
|
|
312
|
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
|
|
313
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
|
|
314
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
|
|
315
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
|
|
316
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
|
|
317
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
|
|
318
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
|
|
319
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
320
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
|
|
321
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
|
|
322
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
323
|
at java.lang.Thread.run(Thread.java:748)
|
|
324
|
|
|
325
|
|
