Insights (Business Reporter and Analysis Models, EOI)

APPS9We have been advised that XLR_REPORT_RESULT_TAB is consuming a large amount of disk space on our database.It looks like this is added to when a BA report is scheduled or manually run.How can we flush out/delete records from this table? We can see records going back to 2020 which we don’t need. Thanks

We have existing Event Builders at Product Level. Everything looks good in Database, but on Support Portal it is showing wrong information.Instead of Product Level, it is showing Item Level and next field is blank:  We are having this issue with a large number of Event Builders. Is there is a quick fix? Updating these manually is very time consuming.

Hi,    I have the below two tables with the mentioned fields and sample rows. Table GL_Ledger X has got a lot of actual details down to GL rows while table Budget Y has got budget amounts by Activity_Seq. I need to come up with one report where I have all fields of table X and one additional field for “AMT” coming from budget using the common filed Activity_seq. Two issues in my result:Duplication of budget amounts (in A1 rows). Missing budget for A3 and A5In other words, want to keep all details and rows of table X and pick up all records from table Y with no duplicates.Any clues on how to solve this issue? Also if I will use union all, is there an easy way to copy all table X columns properties to table Y and how to do it if that is the only solution. 

Hello community,Please I want to modify RDF PLSQL in IFS Developer Studio, but I can’t find in Cloud 22R2 any report files for *.RDF and *.Report: Thank you for your help.Best Regards.

Hello ,i have a report that is automatically printed by the system. and I want to disable automatic printing but I don't know where I should go in the set up .Report name : inventory order report Report ID : INV_PART_ORDER_PNT_REP_REPI think  the report is printed when the Mrp is started by a scheduled task . but im not sure Report archive :  Thank you in advance .

HiWhat is the view of posting proposal history? need to retrieve some columns in SQL query. Any clues??RegardsHousseiny

Hello everyone,I’m trying to change translation for customer order report fields, but I can’t find it:I think it’s a problem of permission sets, do you know please what permission I need to work on reports ?Thank you,Regards.

Do we know when IFS will support SQL 2022? Thank you!

The problem is described in the attached doc file.Please find the problem description in that doc file.

Hello, I am working on creating the ability to insert a new row in Business Reporter and have it wrote back to IFS.I am given the normal pop up to insert a new row, I enter the information and press ‘OK’ and occasionally the new line will not be created. There is no error message that is given and nothing happens.Insert New Values ScreenAny advice on why this may happen or how to trouble shoot would be appreciated.

Hello, I am currently trying to use the writeback functionality in Business Reporter.When I am working on creating the Procedure for the the writeback, if I update the API package and try to use the writeback functionality again, I am returned with this error: ‘Existing state of has been invalidated’. I have refreshed my cache, logged out and back in, and nothing changes it. The API works normally from inside SQL Developer.  I am unsure of how to solve this error, any advice is appreciated.

Hi,  I have a customer who wants to schedule job to send customer statement of account (New report created using BR). Is it possible to send BR reports via schedule batch job?  Sadeepa

Refer to following “Quick Report” query which is taking 10+ minutes or even timing out on some occasions. Any ideas on increasing performance of this SQL query? SELECT DISTINCT sp.activeind, sp.catalog_desc, sp.catalog_no, sp.cf$_last_modified, sp.contract, sp.gtin_no, sp.List_price, sp.List_price_incl_tax, sp.sales_price_group_id, sp.sales_unit_meas, spc.cf$_last_modified AS char_lastmodified, spl.last_updated AS SalesPrice_LastUpdated FROM Sales_part_cfv sp LEFT JOIN Sales_Part_Characteristic_cfv spc ON sp.contract = spc.contract AND sp.catalog_no = spc.catalog_no LEFT JOIN SALES_PRICE_LIST_PART_PRICE spl ON sp.catalog_no = spl.catalog_no WHERE sp.contract = '201' AND (sp.cf$_last_modified >= '&datestring' OR spc.cf$_l

Hi All,Requirement:In ‘Receipt’ screen ‘Receipt reference’ is an IFS standard field and ‘Gate Entry Reference’ field is a custom field (persistent type). (Please check image1, fields highlighted in red boxes, ignore the blue boxes 😊 )image1 I need to create an event when user enters value(add/change/delete) to ‘Gate Entry Reference’ custom field. then the same value should be updated to ‘Gate Entry Reference’ field of other records having same ‘Receipt reference’ field value.Please help me to create this event (the event action) Thanks in advance.Best Regards,Hari

We have a report in IFS Apps 10 under IFS Business Reporter that was designed and and implemented over a year ago and up until the beginning of the month work correctly. Now, no matter whether you “Order” the report from within IFS, or launch IFS Business Reporter through Excel, as soon as the report is “run”, the “Conditional Formatting” rules within the Excel worksheet move from “This worksheet” into “Hidden:sheet_1”, even though there are no “hidden” sheets. This only happens when pulling the data from our production system. If we run the same worksheet through BR against any other environment (DEV, TEST etc.), the “Conditional Formatting” rules remain and the selected data that matches the conditions are highlighted as designed. This does not appear to be related to any IFS UPD levels, as we have had it succeed in both UPD8 (TEST1) and UPD12 (TEST2), but fail consistently in UPD8 (PROD).

Please could response for my query, i.e If it is in IFS 10 Apps Report Layout no Multi uncheck and what kind of Favours and un-Favours. Kind regards,Chandra Sekhar 

We use Aurena only, Apps10 Upd13 (soon to be 14) and on a regular basis one or more or all of our SQL order reports start giving errors to all users. But only sql reports, crystals and operational reports are fineThe report in EE works fine, even when in Aurena failsapart from a server restart, this seems to continue for a few hours, then resolves itselfIt feels like were running out of some cache or disk but no one has been able to adviseRunning a refresh server cache sometimes fixes the issue, but not alwayserror:An internal server error occurred. Contact administrator.Url: https://----/main/ifsapplications/projection/v1/QuickReports.svc/QuickReport_844567()?$skip=0&$top=25Request Id = 46e2c0fe-2ce6-4e79-8e0b-09cdeb2b7c37Date = 2022-01-13T12:15:14.661ZClient version = 10.14.123.0

We have recently started having issues opening excel files saved on to the server, which are based on a IFS BA Report. (See error message attached).> If we save the file onto our PC’s desktop, we’re able to open it.> Only affecting users on Windows 11 (and only recently), Windows 10 users can open the file> If IFS BA Add-in is uninstalled completely, the file can be opened   

Hi All, How can I get SQL code behind this order report. (Please find screenshot below)Thanks in advance.IFS apps 10. Best Regards,Hari

Can I hide a field in a header with a visible condition in the report designer?e.g. I want to hide discount in the header when the value is 0,00% Thank you in advance!

I am trying to build a quick report that will pull all of our rework operations that we label with an “R” in our operation description. I cannot get this report to match shopfloor_clockings. It does not pull all of the same shop orders and operations. I started trying to test the database tables individually, but I need a left join in order to filter the content in the operations_history down to the operations with the operation_description found in the shop_order_operations so that I can see that they are working. I get the error that you can see in the screenshot and cannot find a way around it.

We are trying to install the Bi solution. In the tech documentaion it is refered to a Main.cmd that you should request from and IFS Consultant.https://docs.ifs.com/techdocs/23r1/050_reporting/450_self_hosted_bi_int/010_create_azure_resources/#upload_odac_installation_files_to_the_blob_storageAnyone that know where to get the Main.cmd. We have tried a support ticket without any luck. Have now been waiting for 14 days….

Dear Community,I have a quick report (sql statement) the report retrieve many columns but the report is very slow take time to load data when user open it from order reportcan I do something for that ? 

It is needed to add dynamic images into the report for each part. The image is not store in the database or an an attachment, it needs to be fetched from an external image URL.

Is there any recommendation to select the SQL server version for IFS AM?. I needed to install IFS AM for APP10. Can we go with Standard edition without Enterprise?