We have quick report that takes excessively long to execute and return results. Any ideas on increasing performance?There’s only 5 rows in the result set (see below).select pm.Part_Main_Group as Trademark,l1p.contract,l1p.part_no,ip.description,l1f.ms_set as MS_Set,trunc(l1f.ms_date) as Forecast_Date,extract( MONTH from to_date(l1f.ms_date)) as Month,to_char(l1f.ms_date,'yyyymm') as YearMonth,l1f.forecast_lev0 as Forecast_Qty,NVL((select sum(rega1app.Customer_Order_API.Get_Ord_Gross_Amount(ORDER_NO))from rega1app.customer_info_cfv cicleft join rega1app.cust_ord_invo_stat col on l1p.contract = col.contract and l1p.part_no = col.part_no and cic.customer_id = col.customer_no and ( extract( YEAR from to_date(col.invoice_date)) = extract( YEAR from to_date(l1f.ms_date)) ) and ( extract( MONTH from to_date(col.invoice_date)) = extract( MONTH from to_date(l1f.ms_date)) ) where ( l1p.contract = 'W' and l1f.ms_set = cic.cf$_ms_set or l1p.
Has anyone experience of adding Custom Fields to the DELIVERY_NOTE_REP in Report Designer? I’m struggling to find a presentation object/view that I can use
Hi Everyone,Apologies if this question has been answered - not too sure of the search term to look for within the forum.We are looking to amend the automated functionality within IFS to print an additional document template in IFS9 from the customer order - driven by the status of the order. I believe this is controlled from the following check boxes on the document information tab. (please see screenshot below)We would like to print multiple copies of the customer invoice and we also have another output document template within the same invoice report definition.Order History shown below - invoice and delivery note are created automatically. Is it possible to add another document to the automated output? Please let me know if I need to provide any additional information.Many Thanks,Dan
Hi,We would like to understand if lobby screens are used or not used by users. Is it possible to understand when a user uses a lobby screen last time? Do users use any lobby? Quick Report has a log table. So, we can get this information. However, we need to do this for lobbies.Thanks.
Has anyone experienced the following error?Can't open IFS 9 applications and also IFS 10 applications..net framework has been installed, I have installed and uninstalled .net framework several times but the same error still occurs.error :ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of https://ifs10.sample.co.id:48080/client/runtime/Ifs.Fnd.Explorer.application resulted in exception. Following failure messages were detected: + The type initializer for 'System.Net.ServicePointManager' threw an exception. + The type initializer for 'System.Net.ComNetOS' threw an exception. + Configuration system failed to initialize + Unrecognized configuration section oracle.manageddataaccess.client. (C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config line 275)
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.