Solved

We have created many Business Analytics reports and need to modify hard-coded filter criteria in many of the reports.  Is there a table that stores the filter criteria for repeaters that have been defined in the report template?  I’ve tried searching the XML files that are generated by unzipping the XLST file.  But have not been able to find anything related to the repeaters.   I also found the table that stores the report parameters (XLR_TEMPLATE_PARAMETER_TAB) ; those the user of the report is prompted for, but can’t locate where the row, column and cell repeaters are stored.  

Hi I am interested to know when you create new users, what is the default permission set you grant them to allow them to login to the application? I have compared FND_ENDUSER, FND_RUNTIME and FND_CONNECT and either they have too much access or not enough… FND_ENDUSER gives users the ability to create new database task schedules which we wouldnt want to grant whereas FND_CONNECT gives users access to Schedule Application Server Tasks. Both these functions I would only allow the IFS Administrator to have access.  Functional permission sets would supplement this initial permission set; so i wouldn’t expect it to have access to any of the functional screens.  Please provide your thoughts and recommendations  Regards Shaun

All, does anyone auto input web orders into an IFS PO? We have to order our PPE, so non production orders, via the suppliers website, so that we can match invoices the PO is then again entered into IFS, was hoping someone might have a better way of work that could help ourselves.   Thanks for reading, Sarah

I have a created a Lobby element which is timing out.  I am logged on as user IFSAPP.  The result is the same for two other users.  The PL/SQL query behind the element returns the FIVE records in FOUR seconds select contract, part_no, ifsapp.inventory_part_cfp.Get_Cf$_Qty_Demand (contract,part_no) qty_demand from inventory_part ip where ip.PART_STATUS = 'C' and ip.CONTRACT = 'PCT' and ifsapp.inventory_part_cfp.Get_Cf$_Qty_Demand (contract,part_no) >0   The Lobby Data source I have created with the same query takes 90 seconds to populate with either “&AO” or “ifsapp” prefix   The Lobby element times out and doesn’t return any data after 2 minutes. The Custom Field referred to is using a select statement: select ipa.qty_demand from ifsapp.INV_PART_CONFIG_PROJECT_ALT ipa where ipa.contract = :contract and ipa.part_no = :part_no Does anyone have any suggestions why the disparity or how to resolve? Many thanks!  

Hello, Is it possible to display a tab on a screen depending on a value in a custom field? For example, on the Supplier screen, hide the Invoice tab if a fiels is ticked on the General tab?   Many thanks and Regards,   Anne-Sophie

Currently for our users to transfer parts to our mobile devices, they have to create a request, fill in the part needs, print picks, ship it etc. Then the tech will receive it on his screen under the receiving tab. this is a lengthy process for our shippers, especially in the summer. Logistics manager lets the user transfer a part in only a few clicks. takes 20 seconds to do. However the part wont immediately show up in the mobile users stock. They have to initialize before the data come into their phone We’re on v5.7. Is this a version issue or is there a way around this?

I am trying to capture the time of a maintenance WO between Fault Reported and Workdone status. Basically down time for the previous 7 days displayed on a lobby. I have built the lobby and i can record the downtime/ breakdown time for last week but not the last 7 days.

The page you loaded could not be activated due to errors.  Please contact your support representative.   The type initialized for ‘CyrstalDecisions.Shared.SharedUtils’ threw an exception

Hi, I am new to IFS ERP. I would like to know how to analyze a GL account history for a particular account in system ? So far i can see the balances, but how to check transaction history ?  

Why would Copy Voucher in Hold Table RMB option be greyed out when on checking the permission set this has been granted?   Thank you.

We have 4 middleware servers, 1 came back up without any errors. but the other three fail with the following:    

Hi All,   We noticed that the minus sign for currency figures in IFS reports is different based on language. Eg: Seems that English is used short minus (U+002D) and for the Swedish uses long minus (U+2212). Pagero OCR does not recognise the long minus so it causes trouble for customer. Has anyone had this problem and found a solution? Example in Apps10 UPD 5: Invoice Left: English Right: Swedish 

Is it possible to make Digital Signature integrate to attached documents through third party application?    

In IFS Apps 9, how does IFS runtime client store “caching” the username and password that is used on the IFS login screen?   Our client is running into an issue where no matter if they tell it to save the password it keeps changing what user is logging in. Only exception is IFS is launched through a shared ClickOnce  (ifs.fnd.runtime) application using RDS, not via URL. Other option is to figure out a way to suppress or grey out the Extended logon options: Please advise.

Hi, Are there any plans for creating hotkeys for Aurena interface? BR Karolina  

Hello everyone, I am not able to join part_catalog and technical_class_reference as the key_value in technical class reference includes after the part_no this character ‘^’. select a.part_no, b.technical_class from Part_catalog a INNER JOIN TECHNICAL_OBJECT_REFERENCE b ON a.part_no = b.key_value I tried to get rid of the last character of key_value which did not work: select pc.part_no, tor.technical_class from  Part_catalog pc  INNER JOIN  TECHNICAL_OBJECT_REFERENCE tor ON pc.part_no = (select SUBSTR(tor.key_value, 0, LENGTH(tor.key_value) -1))   I never had such an issue in IFS.    Any idea how to link these views?   Thanks a lot! !--[endif]-->!--[if>![endif]-->!--[if>

Hi    In Project Management Demand TAB , How can I make the FUNCTIONAL AREA and QA Class a mandatory field before the users can save?

Hello Has someone experiance running IFS enterprise explorer client with Mac?

In IEE on an LOV, you can set a default saved search. Is there a way to do something similar in Aurena? For example, we built a saved search on expense sheets so that the only work orders a person will see are those that are assigned to them.  Otherwise the LOV has way too much to navigate. How do you do that in Aurena?

We just refreshed our test environment from live. Now used stop_all_servers.bat to stop all servers. All servers successfully stopped.   However upon restarting servers the script is stuck at Starting server ManagedServer1….   Any idea what could be the reason. Looking at the logs it shows  The server 'ManagedServer1' with process id 21880 is no longer alive; waiting for the process to die.

Is it possible to translate text in EE client? Shouldn´t this also be in database like all other translations?   For example, change a text in a EE form from “Create Disposition Data” to another text on NCR form.

Hi All, We are using IFS 9 and we have the following problem with reports:   In much description-fields the text will be formatted by the user using tab key. These descriptions are "unreadable" in reports designed with IFS Report Designer or Crystal Reports:     The C#-forms shows us probably more spaces for a char(9) as the database? How can I show a "nice" formatted text in the report? Can anybody help me?   Best regards Lucie

Hi, I am trying to take info from API to lobby. I face that problem. It is working on my user but It doesn't work on the other users. I permitted the user. What should I do ?    

Hi, I have created a custom LU and one of fields requires LOV. LOV view is a standard view and I want to pass a WHERE clause. In this case, view is DISCRETE_CHARAC_VALUE and I always want to get records in LOV WHERE CHARACTERISTIC_CODE = ‘ABC’. How can I get this done?   Appreciate your response. Thank you.  

Hi, I would like to know if Enterprise Explorer would handle rolling updates in this scenario: Cluster of 2+ nodes NGINX load balancer   The process for applying updates would be: Take down 1 node Does Enterprise Explorer switch over to a new node seamlessly without crashing and kicking the user out? Apply the client delivery to that node Bring the node back up Repeat the process for all nodes… Profit? Is this scenario possible without EE crashing?   NOTE: We only deliver client updates using the installer. Database changes are done manually to prevent downtime. This also cuts the delivery process to a couple of minutes, instead of hours.