Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Application Builder link/page results in ORA-01422: exact fetch returns more than requested number o

whenothersthenDec 19 2014 — edited Dec 19 2014

Hello everyone!

Running APEX 4.2.1.00.08

As of this morning, when I login into APEX as a developer and click on the application builder button, I am taken to the page where it normally lists the applications in our workspace.  However, now it is giving the ORA error:

ORA-01422: exact fetch returns more than requested number of rows

so instead of seeing our list of applications in the interactive report, i am seeing just the error. this seems to be on the internal app/page 4000:1500.

This is in our dev environment.  Everything is working fine in prod.

To my knowledge, nothing APEX related was done on the dev server last night (i know our DBA disabled the following which do not seem specifically APEX related: [1] table partitioning, [2] data mining, [3] olap, [4] real application testing).

Thoughts on what might be causing this?  Is 1 of the 4 things disabled somehow used by APEX?

Thanks!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 16 2015
Added on Dec 19 2014
2 comments
751 views