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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Return to Oracle eBS from APEX

Javier GualdaDec 16 2019 — edited Dec 17 2019

Hi there,

I'm trying to get a way to come back to eBS menu from APEX without having to login again. Any idea how to handle?

Thanks in advance.

Comments

Alex Keh-Oracle

It could be a bug. Do you have test case to help us better understand the problem with TimeOfDay that you experience?

mariohik

Sorry for the delay.
I can't use TimeOfDay as in the example below:

var ts1 = new TimeSpan(6, 10, 0);
var ts2 = new TimeSpan(6, 50, 0);


var x = from t in TestTable
where t.DtColumn.Value.TimeOfDay >= ts1
&& t.DtColumn.Value.TimeOfDay <= ts2
select t;


x.Dump();

Instead, I have to run the query separately (hours and minutes):

from t in TestTable
where (t.DtColumn.Value.Hour >= 6 && t.DtColumn.Value.Minute >= 10 )
&& (t.DtColumn.Value.Hour <= 6 && t.DtColumn.Value.Minute <= 50 )
select t

I am attaching a sample table and you can use LinqPad to test the query.
export.txt (130.51 KB)

Alex Keh-Oracle

Thanks for reporting. I filed bug 32388939 to track this issue. We'll take a look at it.

Alex Keh-Oracle
Answer

This bug was fixed, but missed making it into the first Oracle EF Core 5 release. The fix will be part of the next Oracle EF Core 5 release.

Marked as Answer by mariohik · Feb 12 2021
mariohik

Thank you!

1 - 5

Post Details

Added on Dec 16 2019
2 comments
346 views