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

Good Morning, I have a Crystal Report which utilizes an IAL I created. When I run the report as IFSPRINT or IFSAPP in PLSQL or CRYSTAL Reports the data is returning correctly. However, when I attempt to run the report in IFS Quick Reports no data is returned. I thought it may have been permissions however, I thought if that was so, when I ran it as IFSPRINT in Crystal Reports it would also have thrown the same error message? I’ve also checked the views within the IAL and the accessibility seems to be correct.Example below, this is a report that just displays a company ID while logged in as IFSPRINT.Crystal ReportsIFS Quick Reports Permissions for IAL and view: 

Hi, is there anyone who know how to secure this IFS URL login in middelware server?We want only access for users from a specific IP range to access this url. 

Hi all,We have some lobbies that postback with parameters. Like the one below. You click on shop order element and the filter is used on the shop order operation element.It is working in IEE when we use the filters in the query string:Questions is. How should the “Web Access URL Address” look like to get the same functionality in Aurena?

Hello,As i said is there any way for auto optimize columns for all tables of the system, like default setting?Thanks. 

Hi all,After executing of any Quick Report in Aurena I got the following error.The list: QuickReportInnerList does not exist in dictionary! Refreshing all server caches doesn`t help. I hope someone can help.BGEric 

Hey all the sql experts out there...I am trying to pivot 2 fields using the IFS budget_period_amount1_cfv  view (custom view created with one extra field).  I keep getting an oracle error: ORA-00198: column ambiguously defined on the first line.  It works fine when pivoting one field, but when adding another field in the same table (custom field), I get the error.  Here is the statement:select * from(select account as "Account", account_desc as "Account Desc", budget_period,amount,cf$_sp_actual_costs,budget_year as "Year", code_d as "Dept" from budget_period_amount1_cfv where code_d like nvl(upper('&Dept'),'%')and budget_year like nvl(upper('&Year'),'%') and budget_version = 2)pivot(sum(amount),sum(cf$_sp_actual_costs) for budget_period in (1,2,3,4,5,6,7,8,9,10,11,12)) Any ideas on the problem?Thanks!     

Hi Is it any easy way to identify UPD version in IFS Applications 9?IFS10 contains information about UPD in Menu\Help but not IFS9.I know how to query module_tab but another option is required for enduser with limited access.BSPiotr

I would like to schedule a quick report to run daily.  Can this be done in Apps8?Most of the examples I am finding are for 9 or 10. 

On a custom LU, I’d like to create a read-only reference field to expose MY_CLT.ROWVERSION in the client presentation. Expressions or SQL statements against t.rowversion or v.objversion don’t appear to work. Is there a way to show this field to the users, short of creating another persistent field?(My preference would be a solution that exposes the field without intermediate functions so the database can honor an index on it.)

Hello, I have created an object connection on my Inventory Part screen for Change Request. I am able to see it with full IFS permissions, however, my users cannot see the CR attachment object. I’ve granted Permission Set access to Change Management, and those users can navigate and use the features. The issue is only impacting the connected object. I believe there is some level of access I’m missing. Any help would be greatly appreciated. Full Access: User’s View: 

IFS Apps 8We are successfully sending out Payment Advices using the PDF_Report_Created event and action.HOWEVER, for Payment Advice PDF_Parameter2 is not Supplier ID as in other reports…We need to include the Supplier ID because when an email fails, we need to identify the supplier so that we can fix the email address.Ideally I would like to include the Supplier ID in the Destination Address Address which is the PDF file and which actually shows up on in the application message view in the options field.  Does anyone know how to change the name of the outgoing PDF File or have a simpler/easier solution? 

 Hello  Does anybody know how to change the default values in “Filtered by “  section ?   

Hello, I am attempting to disable Find and Replace in IFS for certain users to prevent accidental bulk changes. I have run debug console, but that hasn’t pointed to any direct items I can disable on a given Permission Set to prevent access. Any help would be greatly appreciated. Thank you.

We are on IFS Apps9.Using SSRS to replace some IFS operational reports.We intermittently have SSRS operational reports fail in the IFS Print Manager.  I have a saved search that I use to find them and restart them, to get them to print. Is there anyway to troubleshoot why the print jobs are failing and resolve the issue?

Hi All How can I access to admin console with SSL Proxy option?In stanard way I use https://myappserver:48080/admin, but in SSL Proxy we got following address: https://mypage.mydomain.com.https://myappserver:48080/admin does not work and also https://mypage.mydomain.com/admin.Does IFS Admin console works only with No Load Balancer option?BSPiotr

Hello, does someone know how to pass multiple values to a single column while generating external link to aplication form? Example: I want to generate link to operation statistic form passing 2 order numbers 101344564 and 101522291 Generating a link with just one order number works (folowing the instructions in Development guide) but i cant add the second one. So first link in below screenshot works but i have been experimenting with finding OR operand and the others dont work: Does anybody know how to pass multiple values (what is the syntax(symbol) for OR)?   B R Ivan  

Hi,When I click Crtstal Runtime Files link on Add-ons, then I’m getting this{"error":{"code":"SE_UNAUTHORIZED","message":"Insufficient privileges."}}It seems I need to add permissions to my profile, what permissions do I have to add to install crystal runtime file? thanks,Narsi.

Hi,I’m new to IFS, I do not know where we can add a new catagory in Catogories of Quick Report.  Please let me know if anyone knows  Thanks,Narsi.

Hello,I want to learn how to “Extract Data” processes works.For example when i try peg to part lines from “Available Source Lines” to “Part Lines” at “Incoming Dispatch Advice” screen, i see two different ways for extract data on debug.The first one from i_hWndFrame.tbwDispatchAdviceAvailableSourceLines.colsSourceRef1etc (source by receipt_info i think). The second one from i_hWndParent.frmIncomingDispatchAdvice.dfnMessageId etc (source by ext_dispatch_advice i think).In this case i have no message_id and delnote_no parameters at RECEIPT_INFO_ALT view but those are requirement for parameters of the peg procedure. So need to extract that parameters from the screen, how can i do that?You can check the pictures. I need to just a way for pegging from RECEIPT_INFO_ALT on SQL somehow (Normally p0_ and p1_ are null at RECEIPT_INFO_ALT view, but if i extract from screen or forms like debug i can peg easily).Best Regards.A SAMPLE BEFORE THE PEGGING-- Context: tbwDispatchAdviceAvailableSourceLin

Hello Everyone, How to capture transport task creator’s username on transport task screen ? I tried using history log report but it is not efficient. I want to capture username on the transport task screen so that I can query the data by username. Thank you for your help.

Has anyone ever changed the Max String Size parameter in Oracle to Extended?  I know the standard VARCHAR2 limitation in Oracle is 4000 bytes.  I have had a few customers ask for Custom Fields and standard fields to be larger such as the external notes on the service quotation and Long Description for PM Work Orders.  Apparently in Oracle, if you change this parameter to extended it gives you a new max size of 32767 bytes.  I was curious if anyone in the community has done this successfully?  If so, was there any special items you might want to mention?  Did this also work when adding new custom fields after changing the parameter? https://dbaclass.com/article/max_string_size-parameter-oracle-12c/

Hi,I’m working on displaying budget numbers to Department Managers in a lobby.Is there any standard way to limit who can access the budget like in Authorization Combination Rules or Authority Combinations ?Any ideas?

If user have worked in company authorizing invoices it’s not possible to remove access to this company. The connection to  invoice posting authorizer is preventing the removal of company access.The invoice posting authorizer cannot be removed once user have authorized invoices, here you can only phase use out by adding a valid until date.Is there a way around this to block access to this company for the user?In our system we have mulitple companies and as users move around between the companies this becomes an issue. 

We use permissions sets to specify whether users have none, query or full access to screens, but if for example 10 users in a permission set have full access to a screen, whats the easiest way to only allow 1 of them to update a specific field on that screen?   Thanks, Chris.

 Hello;  I want to change the password warning message. Could you help?