Skip to Main Content
Forums

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!

Error in tabluar form created by collection after add one more column

Jozef Demovic SVKMay 29 2015 — edited May 29 2015

Hi Experts,

I have a problem.

When i try to add one more column to my tabular form created from collection it throws error - ORA-01403 No Data Found.

It throws error even if i add some dummy column like: 'test' damages. (see screenshots bellow). I created report bellow "TEST" where is the same select like for tabular form. There are correct values.

If i remove the column from source query, everything works fine again. But i have to extend tabular form for one more column. Where should be the problem ?

Real column used screenshot:

2015-05-29_144739.png

source from tablar form and 'TEST' Report:

2015-05-29_144757.png

Dummy 'test' value column used screenshot:

2015-05-29_144910.png

source from tablar form and 'TEST' Report:

2015-05-29_144904.png

APEX 5.0

DB 11g

Apache Tomcat

Thanks

J
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2015
Added on May 29 2015
#apex-discussions
3 comments
143 views