Skip to Main Content

Intelligent Advisor

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!

Empty number or date field in datatable results in error running execute query

RayNLNov 29 2018 — edited Nov 30 2018

@"PamNL"

Anybody already experienced and know how to solve the next problem?

I've got a few entities in my model that execute query directly after the load so the interview is prefilled.

Not every fields contains data. Thats okay when it is a text-field, but when it is a number-field or a date-field the interview falls in error.

As shown below. When I select the "Contact_id" colum the interview falls in error. When I uncheck the colum it doesn't.

I hope this is not intended.

pastedImage_0.png

This post has been answered by Brad Tuckett-Oracle on Nov 29 2018
Jump to Answer
Comments
Post Details
Added on Nov 29 2018
2 comments
146 views