Replies posted by proharikg
Hi @chajash ,It is possible through quick report (need to use ‘UNION ALL’ and ‘WITH’ clause). I have done that before and it was working. WITH T AS (SELECT PROD_FAMILY, NO_of_Parts, Total_inv_value from view1) SELECT * FROM T UNION ALL SELECT SUM("Total_inv_value"),'TOTAL','' FROM T Best Regards,Hari
Hi @proharikg, It is most likely that enough heap memory is not allocated to the Integration Server, although this might not be the case all the time. However, if the report is fetching a huge amount of data, heap space errors could be thrown if there isn’t enough memory allocated. The best way to investigate this would be to a obtain a heap dump when the error occurs and analyze it to find out if there really is a problem with the allocated memory or if there is any other problem leading to this. Once that is done, you can increase the heap memory or take any other necessary corrective action. If you need to increase the heap size, you can do it from IFS MWS Admin Console in IFSAPP10 Hope this helps! Thank you Charith
Hi @proharikg, It depend on your environment settings and configurations you use. But in general terms I would recommend below points to check before and after the refresh whether it has the same parameters. batch queue configuration delivery differences (installed Components window) system parameters, plsqlap environment tab & IFS Connect Configurations License Management window information Connect server’s listener port (Setup IFS Connect window) database backup method configuration and archive logs parameters undo tablespace names oracle directory names and paths These are the basic which came to my mind to be verified after the database refresh and this is what we follow as a standard as well. But there's a catch if you are using customized tables and information on the environment those need to be verified as well. Hope this clears your question! If this comment satisfies you please mark it as the best answer so others will also get benefited from this post. Hi Ragav,
Hi @proharikg , As far as I know it is a design limitation but once you synchronize the custom objects, the database will be cleared and redeploy the custom fields. Then when you do the reload configuration, the necessary client caches will changed. Therefore, it won’t be an issue when adding a custom object. Thanks & best Regards, Wimali Thank you Wimali
Hi @proharikg, This is by design. You cannot refresh Custom Objects cache from here. When you do certain operations such as publish or synchronize in custom fields, the caches will be refreshed automatically via application logic and the time is updated here. Ideally, the option to refresh it from here should be disabled to avoid any confusions. However, if you want to explicitly refresh Custom Objects cache due to some reason, you can do it by manually running following PL/SQL Block. BEGIN Install_Tem_SYS.Installation_Support('REFRESH_CUSTOMOBJECTS', NULL); END; This is the method IFS installer uses to refresh Custom Objects cache during delivery installations and reconfigurations. Hope this helps! Thank you so much Charith, regards,Hari
Hi @proharikg Could you please come up with more specific information regarding your issue, like, actions follows when creating a custom fields, what permission were lost, etc. /Shardha Hi, As per my knowledge there is no connection between the privileges had and new custom fields. Can you please elaborate more on what has happened? Hi,It has resolved now, No idea what had happened.. the CFV lost its permission after creating custom field. I have given access to CFV again through new permission set window Thanks and regards,Hari
Hi @proharikg Could you please come up with more specific information regarding your issue, like, actions follows when creating a custom fields, what permission were lost, etc. /Shardha Hi Shardha,It has resolved now, No idea what had happened.. the CFV lost its permission after creating custom field. I have given access to CFV again through new permission set window Thanks and regards,Hari
Hi @proharikg Lets forget the fact that the SQL query is giving the expected output for a moment. If you have a look at the method generated for this custom field, it only accepts one parameter, that is the order no. FUNCTION Get_Cf$_Detailed_Status ( order_no_ IN VARCHAR2 ) RETURN VARCHAR2 IS temp_ VARCHAR2(32000); CURSOR get_attr IS SELECT CASE WHEN c.QTY_ASSIGNED >= c.BUY_QTY_DUE THEN 'Fully Reserved' WHEN c.QTY_ASSIGNED IN (NULL, 0) THEN 'Released' WHEN c.QTY_ASSIGNED < c.BUY_QTY_DUE THEN 'partially Reserved' END Status FROM CUSTOMER_ORDER_LINE c, CUSTOMER_ORDER d WHERE c.order_no = order_no_ AND c.order_no = d.order_no; BEGIN OPEN get_attr; FETCH get_attr INTO temp_; CLOSE get_attr; RETURN temp_; END Get_Cf$_Detailed_Status; So if you pass only the order no and expect different results Customer order line vice, its not correct right. In your PLSQL output screen capture I could
Hi Hari, You can disapprove/unpublish the custom field. Here you can follow more admin guidelines here as well. https://docs.ifs.com/techdocs/foundation1/040_administration/220_user_interface/020_custom_objects/015_manage_cust_objects/default.htm Hi Minoshini,Thank you so much..Regards,Hari
Hi, If there are more than one custom filed, uncheck the Approve check box in line level for the desired custom field, then Save. RMB and Unpublish. Then you have to Synchronize if you have other custom fields for the same Logical Unit. If you still want to delete, you have that option as well. see below. Hope this information helps you. Hi Chamika, Thank you so much. Regards,Harikrishnan G R
Hi @proharikg, I think we have no full user access to get this screen. You could try with IFSADMIN account instead of Application Owner and see if the window is available. I have found that to be the case in some older IFSAPP versions. Could you pls help how to check version of IFS 7.5? That’s not quite straight forward in these older versions of the application I am afraid. The response marked as answer in following post might be of some help to you in this regard: To bottom line, you may have to check with IFS to determine the SP level of your customization project, to my knowledge. Hope this helps! Thank you so much Charith.. Regards,Hari
is create user available in IFS 7.5 ? or is there any other name? please send me screenshot navigation path if possible… Thanks in advance.. Thank you so much Charith… I think we have no full user access to get this screen.Could you pls help how to check version of IFS 7.5? regards/Hari
Custom objects doesn’t exists in App75. However you should be able to create custom menus in App75. To create custom menus you can use Configuration/Custom Menu/Custom Menu window in IFS Admin executable. Hope this helps. Hi Nishadi, Thank you so much for the info. Regards,hari
Hello @proharikg , Glad to hear that the issue has been resolved. Since the issue was resolved after providing required permissions, I think that is not related to a data source issue (user sessions issue) If you get such issue in future, kindly try the steps that I mentioned above as well (If you cannot figure out the exact error). Those steps can be used if there are no known errors with user sessions in the Database end but in the IEE. Hope this is clear with you :) Cheers! Sure Imal, Thank you so much for the help Regards,Hari
Hello @proharikg , If this is APPS10, could you please try below steps? a. Log into the “IFS Middleware Server Admin Console” as “ifs” user. b. Then navigate into Main Cluster -> Data Sources -> Control C. Click on the ‘Plsql-Access’ row and click ‘Restart’ d. After that, restart the application. Impact of performing the restart: This will refresh the connection pool. And there will be no impact for the ongoing users/session. The process will refresh only the available connections. In Apps9, you need to follow the same steps for the data source value. Cheers! Hi Imal,thank you for this new method to me.Current issue is in app 9.I have resolved it by giving access user to the view..Suggest whether is this ok nor not..?now it is working fine
Hi @proharikg As Stephen mentioned, you can make the field read-only in the required base profiles, so that the users attached to that base profile will have that field read-only. It is useful to make the field read-only to particular set of users. If you want the field to make read-only for all the users (even for app owner), you can do that defining it as a conditional field as below. For an example, if you want to make the Receipt Date in PO header read-only, you can do it as below. Thanks, Outstanding, This is a complete new information to me. Thanks a lot
If you use the Preview button in the SQL Data Source section of the Data Dource Designer, does it at least prompt you for a value for MANAGER? For example, here’s what I see when Previewing one where we have it defined as company = ’$COMPANY$’ in the condition. When doing a preview it should prompt you for this for testing purposes. If it doesn’t prompt you it may be a syntactical issue. If it does prompt you does it return results or give an error? If the Preview does give you results, does your Lobby screen actually include MANAGER as a parameter in the drop down list of value(s) at the top of the screen? If so, is that set with a value? Lastly, I don’t know how you would be able to run this as a SQL Query data source that uses that as a condition if the data being pulled doesn’t have that field available to it. So in that sense I have to assume that your view includes a field called MANAGER. Nick Thank you..
Does the query work in SQL Developer, pulling Manager as a field as you would expect? If you remove the Condition, does sample data pull into the data source, and is Manager one of the fields in the sample data? If the answers to both questions above are "yes", then the data looks OK and manager is a valid field in that data. Is there something wrong with the $MANAGER$ field, as in, that is hot what the lobby page parameter is named? I am not sure what the issue would be if the query works fine without the condition and includes "Manager" as one of the fields... Thanks, JoeK Thank you..
Hi @proharikg, 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 If all you need is just the base profile IDs and their names, then following query mentioned in @dsj’s reply is the easiest way to do that. Base profiles can be identified using following query select * from CLIENT_PROFILE where owner is null I should also highlight that a certain profile appears in FNDRR_USER_CLIENT_PROFILE_TAB only if it is assigned to a user. Otherwise it will not show up here. So to list down all base profiles, regardless of whether they are assigned to a user or not, above query is more accurate. You can JOIN these tables as necessary using the Profile_ID column to fetch any other data you need since it is common to them all. Hope this helps! Hi Charith,Thank you so much,This solution helps a lot.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.