Best Of
Re: Ms Teams/Direct Routing integration issue.
Hi, yes, the issue is resolved.
Was applied a NAT IP manipulation in th esip trunk with nice and it was replacing the FQDN by an IP.
After remove the NAT IP manipulation has started to work fine.
Re: PO approval workflow status is Deferred
Thank you, Nirmal. I will schedule the workflow background process.
Query output email shows "No Matching Rows were found"
Recently we upgraded the People Tools to version 8.61 from 8.59. When a scheduled PSQuery runs and the query does not return any rows the report output shows " No matching rows were found: Report Name". In the lower version when the query did not fetch any row the output just contained the report name and blank attachment.
Is there a way to suppress the message " No matching rows were found" from being displayed/sent to the user?
Please let me know.
Expense Report - Expense Close Commitment Control Errors
We have identified that the KK Workcenter shows Commitment Control Expense close errors. However, there is not a page in expenses or in commitment control that can be used to see these errors.
Navigations that do not contain expense close errors.
- Main–>Travel and Expenses --> Manage Accounting --> Review EXP Rpt Budget Exceptions
- Main --> Commitment Control --> Review Budget Check Exceptions --> Travel and Expenses --> Review Expense Reports
Is there an explanation why these have not been updated to contain the expense close transactions.
Thanks
Todd
Re: PO approval workflow status is Deferred
Hi Jinghua @User_93G3P
- Yes this activity "Purchasing Manager did approve through default worklist/full list or homepage"
- This will move workflow to deferred
- fnd_user_preferences and noticed this user's MAILTYPE is "DISABLED". Do you think it may cause the Activity "Set Forward-To/From For Approval Action" deferred?
- this is only for email many cases email will get deferred like workflow mailer is down or lot of pending etc..
you can consider scheduling the workflow background process this will not impact anything
Thanks,
Nirmal Kumar N
Re: Dealinc long-running
Hi User_KN69G,
In dealinc.pc, the query matches the logic defined in the cursor c_get_turnover_cur in dealinclib.pc, which is used within the actual_income_calc function. This cursor is executed each time actual_income_calc is called and the is_turnover_cur variable is empty.
Thanks.
Atanu
Re: Dealinc long-running
This should be called once for deal_Id, Deal_detail_Id and reporting period; however currently it's being called at deal_id, deal_detail_id, item, loc and reporting period level in 19.0.1 version that is why you see so many executions. This requires a fix to call it only once for a deal_id, deal_detail_id and reporting period level to avoid unnecessary loops.

