Base profiles can be identified using following query select * from CLIENT_PROFILE where owner is null Base profile values: select p.profile_id, p.profile_name, pv.profile_id, pv.profile_section, pv.profile_entry, pv.profile_value, pv.profile_binary_value from CLIENT_PROFILE p, CLIENT_PROFILE_VALUE pvwhere p.owner is nulland p.profile_id = pv.profile_id Cheers! Damith Base profiles can be identified using following query select * from CLIENT_PROFILE where owner is null Base profile values: select p.profile_id, p.profile_name, pv.profile_id, pv.profile_section, pv.profile_entry, pv.profile_value, pv.profile_binary_value from CLIENT_PROFILE p, CLIENT_PROFILE_VALUE pvwhere p.owner is nulland p.profile_id = pv.profile_id Cheers! Damith Thank you so much ..
Hi @proharikg, You can use following tables. FNDRR_USER_CLIENT_PROFILE_TAB FNDRR_CLIENT_PROFILE_TAB FNDRR_CLIENT_PROFILE_VALUE_TAB In FNDRR_USER_CLIENT_PROFILE_TAB, you would ideally see 3 profiles per user and you can identify which is which using the value in ‘ORDINAL’ column. Ordinal 0 - current personal profile Ordinal 1 - current base profile Ordinal 9 - IFS Standard profile, which is assigned by the system the first time a user logs into the application. Hope this helps! Hi Charith,I can only find Profile ID in this table , could you please help me to find the base profile name which is associated with these id’s Thanks in advance
A query is taking more than 1 minute to execute.as a result lobby element is showing a timeout error(as shown below), is there any possibility to increase the refresh timing of IFS lobby page? If yes.. please guide me.. Thanks in advance. note: IFS 9 -lobby The setting is in Ifs.Fnd.Explorer.appsettings file. Look for Ifs.Fnd.Explorer.appsettings_sample in the installation directory and modify its content and then rename it to Ifs.Fnd.Explorer.appsettings. We have lobbies that run complex calculations, and with many optimizations and offline data tables, it still can clock closer to 60 seconds, but in your case it might be possible to tweak a few things and get the results to display in a shorter amount time. This is always the best option than increasing the timeout delay. Check if you can use IAL views with snapshot data, and using more efficient joins instead of PL/SQL functions. Thank you ...
Hi @proharikg, To increase the refresh interval of a lobby page, you can do following: Go to Lobby Overview page in IEE. Click on the padlock icon on top right. This will enable a cogwheel icon. Click on the cogwheel icon. This will open a dialog box. In the dialog box you can set the refresh interval as below from the Data section. Although this probably might not help your case as your data source might need some optimization if it is taking over a minute to fetch data. 1 minute is too long for a lobby element as far as I know. The OP is asking about a query taking longer than 1 minute, not about auto refresh interval. If you think about the question “is there any possibility to increase the refresh timing of IFS lobby page?” the more suitable answer would be what’s noted above. However, the setting in the Ifs.Fnd.Explorer.appsettings can be used to resolve the problem with the query timing out after 1 minute (Default setting fo
Hi @proharikg , As it is there in the search naming (SQL where expression), we can use whatever it matches with where clauses Thank you ..
Sort of, but only in the context of looking up values of fields or in the retrieval of a single sub-query parameter. Here is an example from the Part Costs overview: CONTRACT IN ('410','510','582') and COST_SET = 1 and (&AO.INVENTORY_PART_API.Get_Type_Code(contract,PART_NO) = 'Purchased' or &AO.INVENTORY_PART_API.Get_Type_Code(contract,PART_NO) = 'Purchased (raw)') and COST_SET_LATEST_PUR_PRICE <> TOTAL_ACCUM_COST and TOTAL_ACCUM_COST <> 0.0001 and COST_SET_LATEST_PUR_PRICE > 0 Or here is one from Purchase Order Lines: EXISTS(SELECT 1 FROM &AO.purchase_order_line_comp A WHERE A.ORDER_NO = PURCHASE_ORDER_LINE_PART.ORDER_NO AND A.LINE_NO = PURCHASE_ORDER_LINE_PART.LINE_NO AND A.release_no = PURCHASE_ORDER_LINE_PART.RELEASE_NO AND NVL(A.QTY_REQUIRED,0) <> NVL(A.QTY_ISSUED,0) AND STATE <> 'Arrived' AND &AO.inventory_part_in_stock_api..Get_Inventory_Qty_Onhand(CONTRACT, COMPONENT_PART, NULL) > 0 ) Thank you .. I have checked
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.