Skip to Main Content
Forums

Database Software

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.

Explain trigerring of mail from Event alert till it is recieved by user

985714Jan 18 2013 — edited Jan 22 2013
Product ebs R12.0.6
I am facing issue with event alert.the query is fetching the records but mails are not received by user. Some of the mails are received but some are not for the same user. Please explain the flow from triggering the alert to receiving the mail by recipient or provide some query to get the details from back end. I have checked the alert definition everything is fine in the setup. Please share query for wf_notification_out and wf_deffered table how we can query in this table based on the alert or the mail content in order to verify User are getting the mails from alert.

Thanks,
Prem

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.

1 person found this helpful
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
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 19 2013
Added on Jan 18 2013
#database-key-features, #event, #not, #query, #sql, #workflow
1 comment
362 views