Skip to main content

We are having an issue on Cloud 24R2 querying GL Voucher Rows Analysis. 

If we use Edge, and input certain criteria (ie often ‘Year and Period’ or ‘Year and Project’), we are given an error when we click Search:
 

GLVoucherRowsAnalysis/List (server error)
Database error occurred. Contact administrator.
Error details: r{"code":1422,"message":"ORA-01422: exact fetch returns more than requested number of rows"}]

Server stack trace error(s):
  Failed to execute the generated database statement
  ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "IFSAPP.GEN_LED_VOUCHER_ROW_API", line 6217

  ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "IFSAPP.GEN_LED_VOUCHER_ROW_API", line 6217


Request Id: 6705792c-18b2-47ae-a151-5a9bacc91057

Method: GET
Url: /main/ifsapplications/projection/v1/GLVoucherRowsAnalysis.svc/GenLedVoucherRows?$filter=((AccountingYear%20eq%202025)%20and%20CodeB%20eq%20'C1005') and (Company eq '620')&use-timezone-filter=false&$skip=0&$top=961
Response Code: 500 - Internal Server Error

**Full error details are attached

But if we do the exact same query using Chrome, we get no error and results are returned correctly.
 


I can use Edge and query just Year=2025 and it will return over 107K records. But if we combine with certain other criteria, we error immediately.

We are at a loss as to what can be happening. Are there required addins for Edge that Chrome does not require?

Thanks to anyone that can provide some hints as to what to look out for?

Lorraine

Be the first to reply!

Reply