Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Hello, I want to park an order when a condition in the shop order operation is happening. Execute it directly generates a a mutation issue, so I need to execute the park action n the background. For that, I have created the following code in a custom event: declare p0_ VARCHAR2(32000) := NULL; p1_ VARCHAR2(32000) := NULL; p2_ VARCHAR2(32000) := NULL; p3_ VARCHAR2(32000) := NULL; attr_ VARCHAR2(32000) := NULL; begin p0_ := '&NEW:ORDER_NO';p1_ := '&NEW:RELEASE_NO';p2_ := '&NEW:SEQUENCE_NO'; p3_ := 'PARK_REASON'||chr(31)||'QUALITY'||chr(30)||'PARK_MRB_NO'||chr(31)||''||chr(30)||'PARK_CHANGE_ORD_NO'||chr(31)||''||chr(30)||'PARK_ORG_CODE'||chr(31)||''||chr(30)||'PARK_PERSON_ID'||chr(31)|| '#USER_ID#'||chr(30)||'PARK_LOCATION_NO'||chr(31)||''||chr(30)||'PARK_NOTE'||chr(31)||'Nota'||chr(30); Client_SYS.Clear_Attr(attr_);CLIENT_SYS.ADD_TO_ATTR('ORDER_NO_', p0_, attr_);CLIENT_SYS.ADD_TO_ATTR('RELEASE_NO_', p1_, attr_);CLIENT_SYS.ADD_TO_ATTR('SEQUENCE_NO_', p2_, attr_);CLIENT_SYS.ADD_TO_ATTR('PA

Hi, How do I make a shortcut to a specific tab. E.g. instead of going here: I need to go here (same address):

Hello, The problem is when a user export report to excel 1- lost leading zero’s from Check # 2- Formatting is off: Excel shows 2.0031E+13 while actual value in report is 020031003282756 I tried to_number but it gives me error ‘ORA-01426:Numeric Overlfow’ any work around options here. Thanks

Hi Have read the relased IFS Roadmap for IFS Products, one question that I don´t get a clear answer on is this: Is IFS 2020 R1 a new core release or should we see that as an “update” on IFS 10 ? /Karl

Wondering if it’s possible to display signature image in Crystal report (held under attachment of an particular screen or Document Revision within IFS)? If yes, please share details. Thanks

I have made Custom Enumeration. This can be seen on the Sales Part and on the Overview Sales Parts. Every thing is working and can also be queried. However if I want to select a column in the data Source Designer, I can’t see these custom columns. This also applies when I want to use the Event action field. Question: How to incorporate or transfer these Custom Fields (&AO.W_I_B_R_PERS_CFP) in the Standard View Sales Parts (%AO.SALES_PART)

In Apps8 - there was an option to display SSRS reports in the Analysis pane at the bottom of the screen. In Apps10 - the Analysis pane is now the Lobby pane. Does anyone know if there is a way to use an SSRS report as a Lobby element there? For our purchasing - we get PO status / update information from suppliers in a SQL server. Currently users get that data through an SSRS report in another window. Ideally, I’d like to display the report data in the lobby pane so it’s automatically all there for the current PO. I’m trying to not have to create new tables / LUs in Oracle and then replicate the data from SQL to Oracle.

Hi, How to add Lobby Element Icon as pictured? The example I want it to be

Dear All, Does somebody know how to hide/unhide the screen from Navigator in IFS Aurena. Thanks in advance! BR, HA

i’m really stumped on how to put together this business rule. basically if a piece of equipment has been service more than 3 times within the last 30 days, we want a pop up alert to notify the user of these details. This would be before insert of a request (or after if that works best) It would be similar to how when you create a request for a place that has existing service calls

I am interested in tracking user activity in my IFS8/Oracle 12c system. The type of information I am interested in is: When was a module or transaction last used? Which users are using which modules or executing which programs? What are the most frequently used modules or transactions? What modules have the highest CPU usage? When I query gv$session I can see the current users and what they are executing, but I am looking for historic data. I know this information might be available from Oracle OEM, but due to separation of duties, I do not have access to this tool.

Query regarding the Print Agent log files. Does this file get archived and cleared down? What would you recommend?

Hi.. I’m Looking for recommendations / suggestions, on test automation software... I am working on IFS 10 and am looking to develop an automation framework around the E2E test scenarios. I was thinking of either Selenium or Katolan. If anybody has experience of these id appreciate some guidance and suggestions. How successful has it been, and is it worth the effort involved. Any suggestions helpful.… thanks.. YK

Hi, I’m trying to figure out how to install IFS EE Extension for all users via ConfigMgr. From my testing I can’t get it to work then doing it in SYSTEM context. Has anyone found a solution for this? When I do it manually (starting the ifseeextensioninstall.msi) with a user account that have admin rights on a machine, it works correctly. But there must be a solution where the user doesn't need to be local admin, right? Best regards/ Tobias Sandberg

A customer is considering using the Excel Add-in for creating supplier for purchase part records. We created an Excel migration job for this and during testing we received the following error for the field Supplier Part No:The value "SOOW 16/6 16 Gauge" has incorrect format for [VENDOR_PART_NO] in Purchase Part Supplier. Should be in uppercase. How can the value in the column easily be converted to uppercase without needing any adjustment by the user in Excel? We would like to handle this via setup in the migration job. If the job was of type MIGRATE_SOURCE_DATA we could simply use the Oracle function UPPER when mapping, but we cannot figure out how to handle this for migration type EXCEL_MIGRATION.

We use the object connections quite heavily in Apps 8, especially on Project Navigator, and I was wondering if anyone has been able to add an additional column to these, particularly the Risks object connection. I am looking to include the status column which can be found if you RMB to the Risk Analysis Navigator, however the object connection screens do not give the option to create a custom field. Does anyone know of another way this can be done? TIA

We have recently begun developing reports in BA. We have published several for our end users to run on demand, but when the reports open in Excel they are blank. This only happened for the end users without the BA Excel Add-in installed. No errors are received, they just get a blank excel spreadsheet. It was my understanding that the end users would only require the Execution Server and obviously be granted access through their permission sets to see the reports. Is there another piece to this that we’re missing that would cause everything generated for end users to be blank?

I have one specific user that cannot run a quick report. She has a permission set that was granted access. I confirmed under the Manage Grants that her permission set is there and she is listed under the Users. Other people in her group that have the exact same permission sets she has can run this report. Has anyone else ever ran into this?

Hello, Our users request a custom RMB from “register arrivals” to the related demand source of type “Shop order” (use case outside operations) in IFS 10 Update 6. This was already implemented in IFS 8 SP1. Due to changes in the view, required source columns are only referenced from the client, but don’t exist in view. in Form Register Arrivals, the relevant data is displayed. column Demand Order Ref1 is not a field in the view. it is a referenced value (...api.get...) Custom Menu definition requires a source column in the source view - which does not exist other approach could be: Idea 1: source Key Name could allow to use a bind variable of the column name of the form like: :tbwRegisterArrivals.colsDemandOrderRef1 Idea 2: source Key Name could allow to use a get-function of the format like: &AO.Receipt_Info_Manager_API.Get_Demand_Order_Ref1(SOURCE_REF1,SOURCE_REF2,SOURCE_REF3,SOURCE_REF4,SOURCE_REF_TYPE_DB) There is the same problem when defining a condition for Custom RMB. Is there a

I have created custom menus in several screens, and they are working. But for one custom menu I want it to display only there is a value in a specific field. Therefore, I used conditions. But seems the custom menu is not accepting the condition. I have tried most of the conditions in below site. https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements005.htm Ex: MINIMUM_QTY IS NOT NULL MINIMUM_QTY <> NULL MINIMUM_QTY != NULL MINIMUM_QTY = “” MINIMUM_QTY = ‘’ The custom menu when no value The custom menu with value If you have faced similar, please share your findings.

We have created an event, it will be triggered when the name of the user changes, the mentioned user in the custom field gets an Stream. This works, but we have one issue: What we want is, that the user, who gets the stream, immediately could go to the salespart mentioned in the stream (via the link in the stream). We think we could arrange this in the screen below, but we are not sure. Anyone who knows? At this moment, when we got to the stream, we get an empty salespart field. Thanks in advance

we have just moved to windows 10 for all users (from windows 7) - DP ran just fine on windows7 but on windows10 the screen font is so small you cannot read it and when you move a window around it leaves a trail of windows behind it filling the screen Anyone any experience of this and perhaps a fix? Thanks Steve G

Hi all, Is it possible lookup the local check-out path inside a SQL block?

Hello I want to know how IFS handles down payment. currently we are using IFS 8 and soon will be upgrading to IFS 10. At Present we are handling down payments manually and are not recorded in IFS. I would like to explore this. Please point me to some documents to read and explore this. Any helpful material will be appreciated. Thanks

We are using document classes to categorize files that can be attached to several different LU’s. If there a standard functionality configuration where you can control what document classes can be used for certain screens/LU’s? We run into problems when a user attaches a file using a document class that should not be used for that screen. Example: We might have customer order whereby a user will add a document classified under “Supplier Contract”. We would never want this added to a customer order. Other than creating some kind of event action, is there standard functionality that can control this? We are on IFS Version 9, Update 8. Thanks!