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.
Re: Temp folder
Hello,
The files in the temporary folder which is defined in JDE.INI can safely deleted. They will not be reused after JDE services are started.
Thank you!
Best regards,
Cezar
Re: XML kernel doesn't enable debug level log
Hello,
First, it looks like the XMLP Kernel accumulates outstanding requests in their message queues. When enabling the debug logging from Server Manager, the SAW kernel sends a message to the respective kernel to start logging the debug information. If the respective kernel has its message queue full, or has some outstanding requests, then the debug logging message is not received by the receiver kernel.
Secondly, it is also recommended to start all the XMLP kernels when the services are started so that the laning (large/small job kernels ratio) to be applied from the very beginning as David already mentioned. Not doing so, you may end up with a wrong small/large job kernels ratio.
Thank you!
Best regards,
Cezar