Solved

Hi Team, We have upgraded FSM DB to 6.9 from 6.5 on the Oracle DB server (system: XX) and trying to upgrade FSM App client and mobile on the App server (system: YY) using this DB server name but the DB connection doesnt get established.When DB connection is tested during Application server installation it always ends up in error ORA-12154: TNS:could not resolve the connect identifier specified   DB upgrade was successful on Db server (system name: XX) Present Status of the Upgrade:FSM Database:prodfsm dbuserVersion: FSM6.9.7746 17-3-2021 10:31:27FSM Client: FSMVersion: 6.5.7417.14159 Please advise how to fix this connection issue. Regards,Jithesh 

Hi.we experienced that ADMIN role can be overridden by other role which is Exaample:person 007 has roles ADMIN and DISPATCHER.Role DISPATCHER has setup like this: Having that setup for DISPATCHER role, the ADMIN role is overridden.  Person 007 cannot modify any other person anymore. Does anybody know whether it is a correct behavior that ADMIN role can be overridden by other role which has Admin menu as READ-ONLY?Can you explain why it is setup like that? Look forward to your feedback.~Juni

Hi All,The application allows you to define an overwriting tax amount or percentage, which can be used to change the tax amount in a manual supplier invoice. Please let me know whether the overwriting tax level can only be used for manual supplier invoice if not what are the other windows this is supported? Best Regards,Vindya.

Hello everyone, One of the customer’s inquired following question,“How do I change the rate charged on Reminder invoices? Now it is set to 18% which is bit steep. We need this rate to be changed 2 times a year also so it would be good if we can do it ourselves. For now, we need it to be 8%. Please advise” Can someone please advise how to change the rate charged on Reminder invoices ?  Thanks and Best Regards,Peshala

Hi Experts,Is there any document available regarding the functions which are not supported for FSM web client ?Following community thread explains some of the functions  Best Regards,Atheeq

Hi All,Do you have any idea how to get the login screen again to enter different username and password.I have mistakenly left the Remember Password ticked, when login with another user for some testing. Please let me know if you have any idea to get that login screen back?Thank you!  

Hi Guys, When we add a sticky note for a record in MRP Part information window, that same sticky note being appeared for a different record with same site information. This can be observed in both Apps 9 & Apps 10 core environments. So my question is, does this behavior a bug or a standard behavior of the application? 

I wish to use IP aliases on my server, and only bind to a specific one.Currently IFS binds to 0.0.0.0:PORT, is there a way to configure binding to IP:Port (ideally from resolving a hostname, but could be static)?  

would like to know if there is a way to migrate pm settings / pm action/work list and resource .

Hi All,We are having an error when try to create an Invoice from Invoice Plan Details.User is selecting 3 lines and select RMB option ‘Create Credit Invoice’ but getting an error ‘Customer has expired. Check expire date.’When this error reported, the customer had a past Inactive Date and then we removed that from the customer. But still we are getting this error.Can I get some advise to fix this, please?Thank you in advance!  

Good morning, I would likie to know if there is a possibility to use two views/tables in Data Soursce Constructor?If yes, how to do this? I need to combine data from two different views and present it on one lobby object. I have alredy tried with adding two views in “View” box (separetad with “ , ” or “ ; ”) but it didn’t work.Second idea was to use SQL construction  JOIN in “Where” boxeg.  &AO.company_person_all.emp_no = &AO.company_person.emp_no   Thanks!

Hi.Our engineering department would like to use outside operation within manufacturing routings which will all have there own individual work centres set to ‘outside work centre’ and have a connected supplier to reduce the number of levels within a structure.This seems to make sense as it can dramatically reduce the time and complexity of engineering required but our procurement department raised two issues Issue :1  limited forward visibility of future purchase requisitions and purchase orders, not visible until the shop order (with the outside operation) has been released, as when they are at planned this doesn't drive any demand.Question: is there a way procurement can have greater visibility of future purchases requisitions or orders?Issue 2: visibility of parts currently out being processed by an outside operation.Question: how do they see what parts are currently at an outside operation?Any help or suggestions would be much appreciated as I don't believe we are currently using th

Hello,I need Advice on how to solve this,I am trying to get this custom field to work. It is a Read Only Custom Field. The syntax is validated successfully. But when I publish I get “ORA-01403: no data found” (see server error message below). The event  looks like this:I need to use part_no and price_catalog_no to join. Price_catalog_no was not available in the lines only in the header. That is why I created this custom field. This cf works as intended.I am using price_catalog_no from here as a join.  Server error messages:1732c290-72d8-4b97-83c9-929e0d69c15bIfs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01403: no data foundFailed executing statement (ORA-01403: no data foundORA-06512: at line 15ORA-06512: at "IFS”removedcompanyname”.CUSTOM_FIELDS_API", line 4788ORA-06512: at "IFS.CUSTOM_OBJ_SYS", line 2893ORA-06512: at "IFS.CUSTOM_OBJ_SYS", line 5098ORA-06512: at "IFS.CUSTOM_OBJ_SYS", line 5035OR

A collegue of mine accidentally placed their favorites folder within another folder, and it doesn’t seem to be a way to move it back outside and be a freestanding folder together with the rest of the folders. Basically the favorites folder has become a “sub-folder” of another folder. Is there a way to move it back outside and make it freestanding again, together with the rest of the folders in the “main” hierarchy?  Possibly I could just make a new folder outside, and drag the content into it, but in this case I would like to keep the “star” icon for favorites. I should probably mention that I haven’t been using the IFS app9 for too long, and are not 100% sure how all the function works yet. I’m adding a picture in hopes it will make the question easier to understand. Just imagine that the green highlighted folder is the “favorites” folder and I want it out of its main folder to be its own without being a subfolder anymore.

Hi, We are running APPS10 UPD9.  Want to implement Kanban and have never used it before.Have been able to create circuits and do replenishments.  My question is, can you look at a forecast for 3 months out to help resize your Kanban?If so, what are the steps.  Any help would be appreciated.

Hi Team,While installing a fix related to reports the following error was encountered.C_RMA_PROFORMA_INVOICE_REP (CRmaProformaInvoiceRep.rdl)  layout failed to importException on importing Layouts : ORA-20111: ReportLayoutDefinition.FND_RECORD_NOT_EXIST: The Report Layout Definition does not exist.But the respective RDL file was available in the delivery folder. Any idea why the above error is thrown?Thanks in advance.Regards,Nimaz

How do you specify a time for a PM WO to be generated?  All are occurring at 12:00AM.  I would like some to occur at a different time, such as 6:00PM. Thank you for your help

I have extended the calendar for another 10 years, however I don’t recall how to update the current maintenance plan in the existing PM Actions. Do I need to generate a new calendar or can I use the existing one? How far out can you set this calendar, 5, 10 or as much as 20 years? Thank you for your assistance.  

Is there a way to see the demand site customer order number line on the supply site customer order line like you can see it thru the supply chain analysis screen?  

Hi,I have a notification email that’s being sent out when a part need is created for certain parts.  I would like the person who created the part need to be CC’ed on this email.The notification message is triggered by a request event and the person I’d like included on the email is the request event creator.  I’m not sure how to use request_event.created_by in the distribution list.Another problem is I’ve been trying to create substitution maps to get the persons emails address with different methods. For some reason the ones I create don’t show up in the “Wild card member” drop down on the distribution list screen. I don’t see any differences it my substitution maps and the ones that do show up in the drop down.Currently I can use request.event.created_by or I’ve also stuffed the part_need.sequence into the request_event.user_def2 to have a link back to the part need where I could use part_need.created_byAny suggestions appreciated.

Where is the manual assignment reason and comments stored in 15.1 database? It’s no longer in the demand table (previous versions) or in the order change log (15.x version)..  

Hi,  In IFS10 we are error while matching invoice with PO Receipt. System is asking for creating of posting control M19 and M20 where as the the PO does not not contain any Inventory part and M20 and M19 should come in to pictures only in case of inventory part.   Regards, Mukesh

Hello Dear Community Users, I have a question regarding the following topic.I need to add the current operation state and the state of the operation before the current operation as parameters. When the parameter popup window is opened, 2 pieces of operation status (Oper Status Code) field are displayed. Which one is present and which previous operation parameter is not understood. SELECT * FROM shop_order_operation o LEFT JOIN shop_order_operation prev_op ON prev_op.order_no = o.order_no AND prev_op.release_no = o.release_no AND prev_op.sequence_no = o.sequence_no AND prev_op.operation_no = shop_order_operation_api.get_previous_operation(o.order_no, o.release_no, o.sequence_no, o.operation_no) WHERE o.work_center_no = '&[MCS-L]Work_Center_No' ANDo.oper_status_code = '&[MCS-L]shop_order_operation.oper_status_code' ANDprev_op.oper_status_code = '&[MCS-L]operation_history.oper_status_code';How do we make special prompt when we use view column which is enumeration? B

We keep getting issues with IFS where the application grinds to almost a stop. Tasks that should take a few seconds take 10minutes and users can no longer log on. When we look in the Oracle alert log we see lots of occurrences of ORA 3136. Episodes like this seem to last about one hour then the application returns to normal use. We noticed that memory utilization on one or other of the extended servers  shoots up to 100% during the onset of these events but we cannot find any reason for this. It tends to happen at about 9am and 4pm when there is more login/logout activity and a bit around lunch time ~noon but can see no real cause. It doesn’t happen everyday. It was very bad last Friday and Monday of this week. Since then it’s performed well . Has anyone seen anything similar please? 

With respect to what parameters Schedule Capacity is defined as  Infinite Capacity or Finite Capacity in Resource Management?