Solved

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?

Hi,I have the below parameter in my quick reportAND  t.tax_code = NVL('&[MC--L]STATUTORY_FEE.FEE_CODE', '%')But it is not showing the relevant LOV dialog for the above parameter  For some fields it’s working fineDid I miss something here ?

Hi all, sales department wants to assign NACE rev 2 code to customers in IFS app 10. Is there standard screen/field where this is stored, or anyone has experience of using alternative way to assign this code? Thank you for your input. 

Pre-requisites• Serial tracked part with product structure and routing a) Create Shop order for Serial tracked part > RMB > tracking > Reserve Serial No. > release the SOb) Shop order> RMB> reports>  barcode labelsc) Observe the Inventory part Barcode analysis window for the corresponding part  & serial number combination- one record availabled) Navigate to shop floor workbench> select the SO created> Create reports>> Create barcode label reporte) Navigate to & Inventory part Barcode analysis window >  Query for the corresponding part  & serial number combination Why there are two barcodes are generated for the same serial part?

When you select a file under Document Object connections in Aurena and click on File Operations > Print Document I get the following error.  Does anyone know why this is?

I’ve already found few KBAs which discuss similar topics but none of them were answered with the exact scenario with migrating personal profiles from one environment to another in bulk, hence this community post.We need to find an alternative way to migrate personal profiles instead of manually exporting and importing one at a time which consumes a lot of time and of course not feasible for our IT department. It’s not practical enough to hand the responsibility over to end-users with the necessary grants, which isn’t again a good solution in many aspects.Do you have any bright ideas where we can migrate personal profiles in bulk across environments?Thank you in advance./Manulak

I am trying to use the Rest API in IFS 10.  Currently I am struggling with the authentication.  I have found various posts which some say you can use basic authentication, others say it must be oAuth.  However using basic I am constantly receiving a 401 Unauthorized, i can’t find any official documentation explaining how to authenticate using oAuth.Can anybody help?Thanks

hi, how to hide some icons in MWO ? which permission or projection do i need to desactivate to remove icons in MWO I don’t need ? Thanks

Hi Team,We’re using IFS Apps 7.5 and having the attached query regarding the ‘Planned Personal Cost’ calculation for the Work order.Have attached our investigation into the same, any suggestions or further inputs for the resolution would be much helpful. Regards,Venkat

Hi, In my shop order, how can I prevent that an operation can be started before  the previous operation was reported? Using date is not enough, as they are to variable in this case. I want that operation N+1 can only be started if operation N has been reported. Thanks!

I am new to configuring Surveys so this may be a simple question.I want a Survey to execute when the status is ‘onsite’.In which Business Rule or screen do I enter the logic to ‘Execute Survey x when the Task Status is onsite’ ?