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

‘Failed to retrieve Report’   Hello Community,    We’ve having an issue on our test environment, receiving the ‘Failed to retrieve Report’  message (Apps 9 UDP7) when running a CR quick report. Everything fine in IFSL The database has been refreshed from Live a few months ago, but to list the numerous things we have tried with no luck. Checked reports work through Crystal. Can confirm yes Checked credentials of all sys, print, ifssys, ifsapp accounts. Can log in to all  Performed a middleware reconfig Report is in the correct <HOME>Layout folder System parameters updated Host where CRWeb is installed Virtual Directory given to CRWeb services Updated logos value Checked Inetpub/wwwroot IFSCRWebSetup XML config files to ensure they are using TNS to correct DB Restarted IIS Restarted ‘All Servers’ bin files  Restarted windows services Restarted Extended server Removed anything other than standard views I am using the CR_WEB_INIT\ with correct linking Using IFSPRINT as the user to c

My brain has apparently stopped working today… can someone remind me what the magic key-press is to open the Debug Console in Apps7 (and prior)? Perhaps I’ll earn an “I’m having a dumb day” badge for this one … :) Nick

We have some custom fields that are truncating at 30 characters after they have been selected and saved.  The enumeration drop down shows the full text value, but once saved and the screen refreshed it will re-display it showing only the first 30 characters.  We are using Apps10 (upd5) on IEE.  I’m opening a case with IFS, seeing if anyone else is seeing the same thing or knows about this and if a solution exists.  

When trying to order a Business reporter report through IFS, and then selecting ‘view executed report’, I receive an error due to the ‘file format or file extension is not valid’. Excel is trying to open an .xlsx file when the report contains macros so its saved as .xlsm.   We are new to using IFS, therefore I hope there is someone more experienced out there to assist us with this error. I tried to attach the screen shots but it is erroring on this page. Thanks  

After getting my quick report (crystal report) to work by suffixing the views with _A I tried adding parameter(s).  Unfortunately, this has provide errors: I have added the parameter IFS_ORDER_NO. So the Crystal Report Select Expert looks like: CUSTOMER_ORDER_A.ORDER_NO  is equal to {?IFS_ORDER_NO}   However, when running the Quick Report I am not prompted for the parameter value. My idea would be to create a custom menu on the Customer Order that runs the Quick Report and uses the current Customer Order No as the parameter value.   Any ideas?

Does anyone try to create a matrix lobby element? Mine are not working, despite using valid data sources. Turning on the debugger, reveals that there’s a sorting in all matrix lobby elements that I create: “order by MAX_PARTICIPANT desc”. That is disregarding the data source used. We’re on IFS10 update 3. 

I have a user that is trying to export query data from IFS, a large amount of query data, and he just needs the flat file (.csv). His Output channel is exporting the .csv file to Excel and trying to auto-open, and the export is taking a very long time - due to the many rows of data being downloaded to Excel. The user does not need to view this info in Excel, so is there a way to create an Output channel where it will just allow you to save the flat file to a local file folder without having to open in an application first?

We have problem on production database that pictures pasted into yellow note are not saved in the database. On test database they are saved. I have figured out that yellow notes are saved in TEXT column of type CLOB in the table FND_NOTE_PAGE_TAB. We are using IFS App 9 UPDATE 7. Any suggestions ?

I have set up a Quick Report to run a Crystal Report and this works fine except that I am being prompted for Login Information each time it is run.   e.g. if the Crystal Report is accessing the CUSTOMER_ORDER_TAB I receive the following:   Login Information for CUSTOMER_ORDER_TAB is requested prompting me to enter: Login: Password: DB Instance:  Schema Owner:   Can anyone please advise what I am missing.

I have created a Custom Logical Unit in order to create a custom page. One of these fields has been setup as a referenced persistent field reading from SHOP_MATERIAL_ALLOC_CFV. There were a couple of custom fields in this view that have since been removed. When I try to bring up a list of values on the reference field I get an ‘invalid identifier’ error on one of the removed fields. Is there a way to ‘refresh’ or re-publish the list of views so the removed fields are excluded?

I have lobby data source pointing to IAL. Is there any other way to pick columns to use than write those manually? Data source ‘preview’ show data and columns even not selected any, but element designer can’t use sata source if not wrote needed columns to data source.

Application messages are not processing in the IN/OUT queue and Struck in Processing. Waht could be main reason and how to troubleshoot the same.

Hi All,   I’m bit confused about how PLSQL method works for inbound messages with binary data (eg: incoming PDF) My interpretation of the documentation is that the IFS framework will encode input binary file to base64, placed in the BIN_DATA attribute of framework generated XML; thus the input of the PLSQL method is an XML.  Both examples in the documentation were also written considering that the input is a XML  However, my experience was that input clob for the PL SQL method is actual file data instead of a XML. Am I confused with the documentation or is is there anything I have missed? Example Function just return the input:   Application Message with Message Response PDF My assumption was the response would be a XML with encoded file data; instead it’s actual input file   Cheers! Damith

Hi,   We are having a issue where Application messages in Out queue has failed due to xml having special character (90°).  Is there any way to edit in application messages.   BR 

We want to create some links to web pages on an App 10 lobby. Is there a way to specify that a link on a lobby page should open in external browser, and not inside IEE?

We will be utilizing the Purchase Requisition System and have potential for multi-level approvals.  An example would be the approver for a department has a limit of $5,000, then it goes to the CFO who has a limit of $15,000, then it goes to the CEO who has an open limit.  If we have a requisition for $20,000 the department would approve it, then the CFO, then CEO.  This is working fine, the problem is the email notification.  We want to notify the department approver first, then once approved it goes to CFO, once approved goes to CEO.  The out of box (OOB) email Event does this excellent, it just gives an email that is not in a usable format.  We have created a custom event, but it is sending to all 3 approvers at the same time.  How do we get the logic from the OOB Event that we can use on our custom event or clone the OOB event to get the step through approver process?  I’m sure someone has the logic and others utilize this the same way.    

We are currently on Apps 9.  We would like to batch print customer invoices but we have multiple templates that are used for this. I am trying to create a report rule that will default the layout template when a specific site is selected so the invoices are printed on the correct layout.  We have tried various iterations of the expression in the report rule but none seem to be working.  One such version is below.  Can anyone offer any insight on what we may be doing wrong?  

Hi All, I started a little project to visualize statpack data and since there were some threads regarding statpack and performance in this forum, hope this will be helpful for anyone who’s not a DBA but had to deal with performance issues like me 😉 You can find it here https://github.com/damithsj/sql-developer-reports   Try this out and let me know your thoughts. Cheers!

Hello, Does anyone know a way of changing the behavior of when you click on a IFS URL link embedded within an email to an IFS screen? If the user is already logged into IFS it will still create a new session (prompting user to login unless using SSO) instead of utilizing the existing IFS session they have open. Any suggestions would be appreciated Regards Shaun  

I’m trying to rebuild a DEV environment from PROD in an automated fashion.   I see the extended server installer script installer.cmd accepts command line options. How do I call this script to rebuild the extended server in a hands-off fashion? Can I pass in things like the SSL certificate name and credentials, etc.?

Hello, We will soon start using doc management with approval templates in Apps 8. Are you aware of anything in IFS that shows the approval status on the document itself? As far as we can see, the doc revision card shows this, but there is nothing to show on the document itself once it is printed / downloaded to your PC. Any suggestions would be welcomed  Regards Shaun

We’re located in Belgium and we have our own Azure cloud servers for IFS in Amsterdam (NL). Apart our from belgian offices we also have offices working with IFS in Czech Republic, Thailand, Malaysia, China and Brazil. But we are struggling since IFS10 with startup times of 90sec. or more in China and Brazil, 60sec. in thailand and Malaysia.  Belgium and Czech republic manage in 20-30 seconds. I find this quite unacceptable, but it’s hard to convince IFS. Anymore people expereincing this? Or is this due to a bad setup ? Should not be, because setup was done by IFS.    

Dear IFS Heroes, I want to automatically send the RMA report via email when the status gets ‘’Released’’ in IFS 9. Usually I’m using the PDF_REPORT_CREATED event, but it’s not working for RMAs because it’s not picking up any PDF_PARAMETERS and this way I can’t send it to the correct email addresses. Is there a way to send RMA pdf reports automatically to the correct email addresses? Thank you, RM

Hi, I am using IFS 9 and there is Application performance issue, when i see the performance details into Task Manger, one java file which is related to Application, it is located as ‘mw_home\java\bin\java’ utilizing 80% CPU Usages and users are getting performance issue. Please help me to solve this issue, Thanks Regards Shekhar

Please suggest me, how can i prepare the delivery of 7.5 Apps