Best Of
Re: Is there a global way to set "grace days" for the Team Time Direct Reports?
Hello User,
Thank you for visiting My Oracle Support Community and posting your question here! I want to let you know I have moved your thread to our Human Capital Management subcategory for those subject-matter experts to engage.
Thanks,
Akash
Re: How to get the min max report output in email oracle ebs r12.1.3
Thank you for your post. I have entered a request to have this post moved to the Logistics community so that the correct subject matter experts can assist you.
Re: Why Orch doesn't wait for UBE to finish with Fire and Forget disabled
Please check the "Launch Report Maximum Synchronous Wait Time" (UBEMaxSynchronousWaitTime in rest.ini) for the AIS instance. Also, refer:
E1: ORCH: Report Step Does Not Fail When UBE Is Not Complete After UBEMaxSynchronousWaitTime (After "not complete within Max Wait Time setting" Appears in AIS Server Log) (Doc ID 2920340.1)
Re: Current query estimated time / History query time
You need to launch the query first. If the query runs already, you can query V$SESSION_LONGOPS to get an idea how long it might take to complete.
There is no way to estimate the run time in advance without runnig the query.
Re: Current query estimated time / History query time
Hi
Please find the answers inline
1.is there a way to figure out estimated time for a data warehouse running query?
Ans - can query V$SESSION_LONGOPS.
This view shows work completed, work total, and elapsed time for long operations.
In OEM, the SQL Monitoring feature graphically shows running queries and estimated completion based on current progress.
2.is there a history view to find completion time for a query?
Ans -DBA_HIST_SQLSTAT,DBA_HIST_ACTIVE_SESS_HISTORY should help .
Thanks
Swati A
Re: How to Add Fluid TA Links to Fluid Expenses Workcenter?
Hi Pere,
When I click Select Menu Item link, then go to the path you provided there is nothing that returns under Employee Self Service. What's strange is I see 3 Employee Self Service folders under that path and nothing returns under them.
All three folders are expanded below. Do you know what would cause it to not show up there?
Re: How to Add Fluid TA Links to Fluid Expenses Workcenter?
Oh, nevermind! I found it. We have a fourth Employee Self Service folder and it was higher up in the list that I didn't notice.