Solved

Hi, I understand Apps 10 UPD6 and above is supported to run on Oracle 19c (19.3). Does anyone know if Apps 10 UPD7 is supported on Oracle 19.7, the latest Oracle 19 DB patch bundle for Windows? This is available as Oracle Patch ID - 30901317. TIA, Srikanth

Hi Everyone,   I’m currently updating the shipment handling unit label report which is a built in report and I need to obtain the printer name and number of copies within the pl/sql RDF file for the report.  I wish to use this information in conditional branches in the report.      When a user selects the printer and enters the number of copies on the report format and output dialog box is there any way to extract this extract the information?     Thank you, William Klotz  

I just discovered that on May 26th customer invoices quit creating a pdf archive file.  It appears that other reports such as delivery report, purchase orders etc are still being created.  These pdf files are needed by the report rule process to automatically email invoices to customers.  I cannot figure out why they are not being created.  Can anyone suggest what might be causing the problem.  It is not a user specific problem.  Same person can create a PO arrival pdf archive report.  From the report archive if you RMB on an invoice Show PDF is greyed out. Thanks Phil

I am using Apps 9 and am creating a permissions set for people to be able to report shop order operations. The permission set currently allows the user to go to the “Report Shop Order Operation” screen (Manufacturing → Shop Order → Report Operation → Report Shop Order Operation) and do everything they need to do, but for some reason the RMB menu option for “Report Operations...” is not enabled in the “Shop Order” screen (Manufacturing → Shop Order → Order → Shop Order).   What permissions do I need to enable to enable this RMB option? Is there a good way in general of identifying which permissions need to be set to enable RMB menus?

Morning, I know we can stop different parts being stored in the same location by ticking ‘Mix of Part Numbers Blocked’ on the Warehouse Navigator, but is there a way in Standard Apps 9, to prevent a part being stored in more than one location? i.e Limiting every part in a warehouse / bay to only 1 Pick Location.   Thanks, Chris.  

Is there any way to force a screen refresh after displaying an error message. Currently user has to OK the error, then click refresh and then click no to not save. Error_SYS.Appl_General('INFO',message_);  Thanks,

Hello,  I have custom menus created in Aurena with method calls from custom packages. When logged in as App Owner, these menus work.  But when logged as a different user, the following error is given. The package is granted the correct access. The projection and the actions are granted access to the permission set the user belong to as well.  ErrorMenu DefinitionHas anyone seen this?

Does IFS allow html based email from when handling pdf_report_created event? We are required to include logo in the signature.

if there was a way to only choose certain part categories to copy - Copy Part - from user: Just to clarify. I was.wondering if there can be a default where to ones that never get used can be unlocked when I open copy part, or even removed/hidden. I know they can be clicked off. I'd love to just open one and adjust the two or three changes needed depending on if it's a purchased part or a manufactured part.  

Hi Team, Could any one help with me on how can I use below process in IFS10 UPD3 , Basically “Approve” customer cheque, Regards, Mukesh

I can add substitutes for purchase orders, but cant seem to add for supplier invoices. Normally, when I populate on the purchase order substitutes, the authorisers appear and I can add a valid from/to  - but no functions allowed, even with IFSAPP_ALL - permission sets look good too.   Any ideas what am missing here?    

I have SQL that using multiple views, I therefore created an IAL using the SQL and deployed it.     The IAL appears in the IAL Configuration, however, I am unable to access the IAL within the Data Source Designer OR using Quick Reporter.   Can anyone advise what I am missing?    

We are building flight disruptions, but there are times when the aircraft does not end up taking a mx delay...is there a way to delete those flight disruptions? I hate to see a bunch of meaningless flight disruptions (meaning they have no delay time associated with them) clogging up the system, but I can’t see the simple way of deleting, or removing those Flight Disruptions...any thoughts on that?    Concerns: Does it affect MAA downstream to have a bunch of 0:00 mx delays? Do duplicate Flight Disruptions (with real x:xx delays) cause issues? Thanks! Tim

When using a custom layout of fields (in particular on a Custom Page), is it possible to control the layout (location and field size) in any way either via database or importable/exportable XML code in any way? Having to line up a lot of fields with the little arrow buttons is pretty time consuming to get fields to all line up and space evenly. I’m hoping there’s a way I can just input pixel values for size and location somehow?

Hello, I would like to launch the Print Preview report (accessible from the Resolve page of the Service Order) and the Service Order report (from the "Report" button of the Service Order) to a single pdf containing the two concatenated reports in one action.I have considered several solutions:• Create a single new report using the customizer containing both sub report. Knowing that each report to be concatenated normally has its own structure (header, group, detail with sub report, etc.) : I have not tested how many levels of reporting can accept nested sub reports.• Create an action button in the Service Order UI that will execute java code to run both Pdfs : I don’t know how to group the two Pdfs into one. •Use code in the first report that will launch the second report generation : I do not know which code to use and if it is possible to do so.   Thank you for giving me a solution.

Dear esteemed Members,   Our customer is planning to upgrade OS to Win Server 2016 Std or 2019 Std from 2008 R2 for its IFS App Ver 8 Sp2 instance. Would request IFS recommendation on the OS upgrade with possible impact. Any technical document or whitepaper available to back up the recommendation.   Regards, Sunil Nair

Sometimes we have noticed performance drawbacks due to the value set for the "job queue processes” parameter in the oracle database. What is the correct formula for the set this value correctly and what are the things that need to consider?  

Is there a way in a custom menu to allow a user to be prompted to type in a value that I can subsequently use in the SQL code?

Hi, Can someone shed some light about how to get the server resources downloaded for locally installed Touch apps server (for Demo purposes)? In apps 9 there was an option in the customer portal page to check the “Cloud connection status” and if the system is registered most recent resources could be downloaded  but seems that’s no longer available for Apps10. TIA. Regards, Ruchira

Hi   Wondering, we have a field available to us on screen for ‘Supplier Name’ - but when I look in the search box to configure so users can search by name its not available. Is there anything I can do to make this field searchable?? Is there perhaps an SQL expression I can use that will put the sort by name into order?    

Is there any way to get MRP run date and the user information who run the MRP for a purticular part? Actually i can get these two information from background job but there is no option of part query. please suggest if there is any window or any sql view where i can get these information.

when user create new part revision, i would like to set a CF to “A Value” or “B value” depends on revision number (eng_chgt_level). Actually, i do it by an event and a background job but users have to refresh the screen to see value affected. An another option is to do it by an Oracle Trigger BEFORE INSERT by it is not a IFS “best practice”. What is the best way to set and display default value on screen while you’re typing data of a new record ?

Hello. I am looking into the setup of a Freight Price list for our US customer base. I have setup a Freight Map and Freight Price List for Fedex Priority, with the Zone Defined by Zip Code. This allows for a numeric range of Zip Codes as shown below.   This is working when a 5 digit Zip code is used. The problem i have encountered is when the Customer Address is in the ZIP+4 format (XXXXX-XXXX). In this case the Freight Zone is not found. Is there another way to approach this, or have i missed something in the setup?

Hello, I would like to automatically add the invoice (pdf) as an attachment in the service order as soon as we invoice it. Do you have a solution ? Thanks for your help.

Dear fellow IFS users For our production, we created a lobby which shows the current work orders being done. This is displayed on a big TV. When the PC is turned on, this lobby should be opened automatically and displayed in full screen mode / kiosk mode, as it is only for display purposes and doesnt need any user interaction. Is there any possibility to automatically open IFS in full screen / kiosk mode? The PC has no mouse or keyboard connected so this should be automated as far as possible. Many thanks for your inputs on this issue Best regards N.