Replies posted by ThushAsanka
Hi, After taking a quick look at my app9 environment and doing a quick debug, I think the tables used now are comm_method_tab and person_info_tab. There are two views that get referenced from the person screen - person_info_comm_method and person_info_comm_method2 that join these two. Thank you, Hypervox.. Yes, comm_method_tab with Party_type being “PERSON” seems to be the best approach to get the comm methods.
Hi @ThushAsanka Communication methods have been redesigned in later APP7 and during APP75 SP4 by moving data into COMM_METHOD_TAB from various tables including PERSON_INFO_COMM_METHOD_TAB. But the PERSON_INFO_COMM_METHOD_TAB was kept in APP8 as well (seems only with old data) and then permanently removed in APP9. Hope this helps. Hi Randini,Yes, this really helps… Thank you very much. 😊😊Best Regards,
Hi @m.arif ,I think you can get those details from pres_object_dic_security view.You may use the below sql query.select po_id, pres_object_api.Get_description(po_id) po_description, lu, module, module_namefrom pres_object_dic_securitywhere pres_object_sec_sub_type in ('Base View','View') Thanks,
Turn on history logging on the purchase requisition lines - this is typically dangerous in most instances as it can be a lot of data. But in every case like you’ve described, I’ve found it was because someone - who didn’t own up to it - was deleting the requisition lines as they were processing them. Sometimes it was because they delete the lines legitimately and combine the requisitions together, they just didn’t go back and remove the header. Other times, it was intentionally done to hide the lack of work being accomplished. I’ve not found that MRP creates empty requisitions. Thanks Shawn, I’ll try to have the customer to enable the history log. I had the doubt of users deleting the PR lines, because there were like 120 PRs without lines. I was not ready to believe a user deleting that much of PR lines manually .But, there’s a possibility I can see, as you have pointed out. Will keep this thread updated. Thanks,
Hi Tushitha, Do you have any warning in Background Jobs details? Or anything suspicious in MRP Action Proposals? Could it be that we are trying to generate a 0 supply qty for a PO Req Line but it fails. If you have access to the database check if you can run below SQL select * from mrp_part_supply_demand where order_no = ‘your requsition no’. To check if it has written anything there. Keep digging :-) -Mats Thanks Mats,No warnings in the relevant background job. Currently monitoring for another occasion for the same issue to happen, so that I can check whether that sql query return anything.I’ll try with the customer enabling the history logging for the deletion of the PR lines if any users manually deleting them, as Shawn has suggested. Thanks,
Hi @sutekh137 ,I think the problem is with the data type of the last login field, not the schema.I just created a test quick report using the below query, converting the last_login to char, and successfully got the results. (I created and ran the report as app owner)select username,to_char(last_login)from SYS.DBA_USERS Thanks,
Hi @osojans ,See if the below IFS Insider youtube video would work. There are some other videos in IFS Insider for each functional areas. And you can refer the IFS Aurena user guide available in the IFS public documentation site.https://docs.ifs.com/documents/Aurena_User_Guide.pdf Thanks,
Hi @Jayanidu,Do you get any results for the below query when running it in the SQL Plus after connecting to the database.select grantee,granted_role,default_rolefrom dba_role_privswhere default_role = 'NO' I think the default_role is always ‘YES’, but I had one situation that one of our customers had a login issue with one user, and it was found one of the required role has “NO” flag for default role, due to some reason. It was resolved after changing it to YES from database end. Just remembered, so thought to share with you, if the same would have occurred here as well. Thanks,
Hi @KUNGTOM ,I agree with you that, may IFS customers are sharing app owner account with their outside IFS consultants, which is very easy and efficient with their work handling. But, almost all IFS customers have restricted access to their IFS apps from external network. So, external parties are provided with a VPN account/accounts to connect to the IFS application through the internal network. So, I think it is possible to track from which VPN account / IP address, the system has been accessed and what date/time. I don’t know exactly, because I’m not familiar with that process, but I think it should be possible.And, another thing some customers practice is that, they don’t share the app owner account of the production system, but that of the test systems. And I know some customers daily copy the production system to their test systems. So, when an investigation needed for a specific problem, consultants can investigate it in the test system,so the same solution can be applied in the
Hi @K4uLinalM You cannot do it to be fetched automatically on a custom sequence. I don’t think it can be done through even a custom event also.But, the users can manually put a Line number as they desire when entering the order line. If the users forgets to manually enter it, the Line No field can be made mandatory in the users’ base profiles. Thanks,
Hi @hmccabe,This INTORDTR - Move to Internal Order Transit due to issue transaction is posted due to an increase in the qty of the certain part in the Internal Order Transit. As explained above also, this increase of qty in Internal order Transit is happened due to inter-site movements through internal orders.When the qty of part is delivered from the delivering site through the internal customer order, SHIPTRAN - Ship Customer Order Internal Transit transaction is posted. And that qty is delivered to the Internal order Transit, so the qty in the Internal Order Transit is increased by that amount and the INTORDTR - Move to Internal Order Transit due to issue transaction is posted at the same time (Created Date and Created Time is same in the inventory transactions). But, the INTORDTR transaction does not contain an order reference or location because it is just an increase in the transit, not in the inventory stock, and that’s why its direction is also 0.And when that qty is received t
What is the difference between "Object Connection Transformations" and Document Revision => Tab "Object"
Hi @ZTC ZTC JGOTA,In the Objects tab of the Document Revision screen, the object information on where the particular document is attached, is displayed. And also, there you can attach the same document to another object (Customer order, Work order, equipment etc..) as well, by simply clicking + button, and selecting the desired objects. Adding documents by this way, attach the document to the object as real (not a shortcut). It’s not relevant to Object Connection Transformations (OTC).OTC automatically create a transformation (like a shortcut) of the document attached to the source LU (original object) automatically, as defined in the OTC rule. There is no record creating in the Objects tab of the document revision because of this transformation of the attachment. While OTC automatically create a copy/transformation of the document attachment in the target LU object, we have to manually create documents in the Objects tab of the Document revision if it should be connected with addition
Hi Thushitha, Please check the below link for details and hope it helps you. Advanced / Automotive Supply Chain (sharepoint.com) Thank you Devin. Thanks Devin.. But the provided link only works for IFS employees I think. Would you be able to share it as an attachment here ? Thank you in advance,
@Mathias Dahl The link to the documentation described above is broken. Could you please provide the new link? Hi @ZTC ZTC JGOTA ,Use below link.https://docs.ifs.com/ifsclouddocs/21r1/DefineSystemBasics/AboutObjectConnectionTrans.htm?StandAlone=true Thanks,
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.