Gopal
Well Known Member
All,
I have a specific Issue. I am trying to Run Cash Requirement report, which inturn Calls Account Balance Businessfunction. Account Balance Business function issues a fetch to f0911.
The fetch to F0911 is taking hours to get a response from our Oracle Database.
The same Fetch executed from SQl Worksheet fetches the data within a minute.
We also have the same issue when we have some custom reports going behind F0911, F0902,F0411 Tables.
Typical Log is like this..
> Cash Requirment Report Log-R04431 Log
>
> Mar 02 17:25:56.185 - 4584/5024 Entering JDB_SelectKeyedPosition
> Mar 02 17:25:56.185 - 4584/5024 ORACLE DBInitReq conn=03021D58 requ=04300A38 BTS01OR02 (DVPSDB)
new [ 9]
> Mar 02 17:25:56.185 - 4584/5024 SELECT GLDGJ, GLPOST, GLCO, GLAID, GLMCU, GLSBL, GLSBLT, GLLT,
GLPN, GLCTRY, GLFY, GLCRCD, GLAA, GLU, GLALT1, GLBCRC, GLCRRM FROM TSIADTA.F0911 WHERE ( GLPOST
>= 'P' AND GLAID >= '03304372' AND GLLT >= 'AA' AND GLCTRY >= 20.000000 AND GLFY >= 5.000000 AND
GLPN >= 3.000000 AND GLDGJ >= 105060 ) ORDER BY GLPOST ASC,GLAID ASC,GLLT ASC,GLCTRY ASC,GLFY
ASC,GLPN ASC,GLDGJ ASC
> Mar 02 21:20:34.831 - 4584/5024 Exiting JDB_SelectKeyedPosition with Success
> Mar 02 21:20:34.831 - 4584/5024 Entering JDB_FetchMatchingKey
> Mar 02 21:20:34.831 - 4584/5024 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 100
-----------
It took 4 hours to retun the value. Any Suggestions on this is Highly Appreciated.
Thanks
Gopal.
I have a specific Issue. I am trying to Run Cash Requirement report, which inturn Calls Account Balance Businessfunction. Account Balance Business function issues a fetch to f0911.
The fetch to F0911 is taking hours to get a response from our Oracle Database.
The same Fetch executed from SQl Worksheet fetches the data within a minute.
We also have the same issue when we have some custom reports going behind F0911, F0902,F0411 Tables.
Typical Log is like this..
> Cash Requirment Report Log-R04431 Log
>
> Mar 02 17:25:56.185 - 4584/5024 Entering JDB_SelectKeyedPosition
> Mar 02 17:25:56.185 - 4584/5024 ORACLE DBInitReq conn=03021D58 requ=04300A38 BTS01OR02 (DVPSDB)
new [ 9]
> Mar 02 17:25:56.185 - 4584/5024 SELECT GLDGJ, GLPOST, GLCO, GLAID, GLMCU, GLSBL, GLSBLT, GLLT,
GLPN, GLCTRY, GLFY, GLCRCD, GLAA, GLU, GLALT1, GLBCRC, GLCRRM FROM TSIADTA.F0911 WHERE ( GLPOST
>= 'P' AND GLAID >= '03304372' AND GLLT >= 'AA' AND GLCTRY >= 20.000000 AND GLFY >= 5.000000 AND
GLPN >= 3.000000 AND GLDGJ >= 105060 ) ORDER BY GLPOST ASC,GLAID ASC,GLLT ASC,GLCTRY ASC,GLFY
ASC,GLPN ASC,GLDGJ ASC
> Mar 02 21:20:34.831 - 4584/5024 Exiting JDB_SelectKeyedPosition with Success
> Mar 02 21:20:34.831 - 4584/5024 Entering JDB_FetchMatchingKey
> Mar 02 21:20:34.831 - 4584/5024 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 100
-----------
It took 4 hours to retun the value. Any Suggestions on this is Highly Appreciated.
Thanks
Gopal.