Insights (Business Reporter and Analysis Models, EOI)

A collegue of mine accidentally placed their favorites folder within another folder, and it doesn’t seem to be a way to move it back outside and be a freestanding folder together with the rest of the folders. Basically the favorites folder has become a “sub-folder” of another folder. Is there a way to move it back outside and make it freestanding again, together with the rest of the folders in the “main” hierarchy?  Possibly I could just make a new folder outside, and drag the content into it, but in this case I would like to keep the “star” icon for favorites. I should probably mention that I haven’t been using the IFS app9 for too long, and are not 100% sure how all the function works yet. I’m adding a picture in hopes it will make the question easier to understand. Just imagine that the green highlighted folder is the “favorites” folder and I want it out of its main folder to be its own without being a subfolder anymore.

Hello Dear Community Users, I have a question regarding the following topic.I need to add the current operation state and the state of the operation before the current operation as parameters. When the parameter popup window is opened, 2 pieces of operation status (Oper Status Code) field are displayed. Which one is present and which previous operation parameter is not understood. SELECT * FROM shop_order_operation o LEFT JOIN shop_order_operation prev_op ON prev_op.order_no = o.order_no AND prev_op.release_no = o.release_no AND prev_op.sequence_no = o.sequence_no AND prev_op.operation_no = shop_order_operation_api.get_previous_operation(o.order_no, o.release_no, o.sequence_no, o.operation_no) WHERE o.work_center_no = '&[MCS-L]Work_Center_No' ANDo.oper_status_code = '&[MCS-L]shop_order_operation.oper_status_code' ANDprev_op.oper_status_code = '&[MCS-L]operation_history.oper_status_code';How do we make special prompt when we use view column which is enumeration? B

Prior an individual was able to open a report without installing IFS Business Reporter.  Now if they open a BR Report it is blank.  Once BR is installed they are able to review the data, so not sure if there is a configuration that I can not seem to find that possibly changed.Thanks so much for your assistance. 

Hello Dear Community Users, I have a question regarding the following topic.I need to add the current operation state and the state of the operation before the current operation as parameters. When the parameter popup window is opened, 2 pieces of operation status (Oper Status Code) field are displayed. Which one is present and which previous operation parameter is not understood. SELECT * FROM shop_order_operation o LEFT JOIN shop_order_operation prev_op ON prev_op.order_no = o.order_no AND prev_op.release_no = o.release_no AND prev_op.sequence_no = o.sequence_no AND prev_op.operation_no = shop_order_operation_api.get_previous_operation(o.order_no, o.release_no, o.sequence_no, o.operation_no) WHERE o.work_center_no = '&[MCS-L]Work_Center_No' ANDo.oper_status_code = '&[MCS-L]shop_order_operation.oper_status_code' ANDprev_op.oper_status_code = '&[MCS-L]operation_history.oper_status_code';How do we make special prompt when we use view column which is enumeration? B

Filter criteria of BR generated different code for different users in same organization. So, it is difficult to share the report among the organization. Is this known bug, limitation or are we use it with wrong settings? Could some one help.Ex User A: In operation request comma separated list  User B:  In operation request semicolon separated list  

Hi, with the following webcast (IFS Internal )https://web.microsoftstream.com/video/87b365f9-8392-4fdc-aa9b-4b2e983b761aI know IFS Businss Report have a new feature called  “Interactive Structures“ from APP10 RTM. while, currently even I’m using APP10 UPD10, I still cannot see such option in my Desing Row: Can anyone tell me how to enable this feature?

Hi all,  I have a issue with the IFS business reporter in IFS10 UPD11. We moved from IFS 9 to IFS 10, When saving or publishing reports i got the error message below about folder patch is missing. How is the folder patch set in IFS business reporter?   

Hi I Is there anyone that can explain the manage report structure view in IFS business reporter? How to move reports, i only manage to move reports from unconnected to the folders but not the other way around. What happen then is that the reports are not accessible from order report function inside IFS. What is this used for?   BR Andreas 

All- In hopes someone has had experience with Paymode payment file/pay advise.   I need to create a pipe separated file that incorporates ACH and CHK supplier pay methods within one file. Any help is greatly appreciated. Best-Christy

Hi all.Which permission set should I give to user to let use Business report in Excel?I Already installed the add-in and give access to the information source needed.But after login, the user has the message: Note: Using my user I can login and run the report. but I have access to all permission sets.  Tks a lot

HiI have made a Profit & Loss report in IFS business reporter, only with actual figures.Now I have created a Budget version with some test budget data, which went OK, but I have problems getting them included in my P&L report. I want to make columns with Actual Data, Budget data, Deviation.But I can’t figure out how to include the budget figures in the P&L report. I can’t find any budget measure, no measure to select budget version etc.Are there no budget figures in Business reporter? ThanksSøren

Hi,I have a published Quick Report, which now needs to be deleted/unpublished. The only options available to me are shown below:Is there a procedure I can follow to delete or unpublish an existing Quick Report? 

Hi all.I have a simle QIS without security filter and as I run the report in excel it fetches just one row.Even running with the owner.How please could I fix this?Tks   

Hello, Is there a way to pass multiple values in a given parameter in report designer (apps 10)?  For example, if we add ‘supplier id’ as a parameter and the user wanted to get three suppliers (2654, 1759, 1953), is there a way to pass all three values in a single parameter that the report could then parse out to get the results?  If yes, is there an out-of-the-box IFS report where I can see it working?Thanks,Tom Bowe

Hi,Did anyone face such error when performing Zoom In function in a BR report?The Oracle error "-1691" occurred when inserting report data into the report table - " unable to extend lob segment IFSAPP.SYS_LOB0000070775C00005$$ by 1024 in tablespace IFSAPP_LOB" That’s a quite simple report that queries the GL Project Transaction aggregating values by Code C for a specific project and specific period. If i try to zoom in it generally produce this errors, however it actually worked a few times with some lines. It seems that it works if only very few data are within the Zoom In (= only few lines).

Hello,does anybody know the table or view name of the company and site?  Thank you

Hi All,Do you know why I do not see the  Export QIS Draft(s) or Export QDIM Draft(s) options in IFS Apps10? Is this something related to user permissions?Can you please send your expert solutions? Thank you!

Is it possible to create an ODBC connection to IFS Application from within Excel?

We want to remind the suppliers of the deliveries on a daily basis and to come to us as an information report on who the reminder was made to.We did this with 3rd party apps. But I know that IFS is capable enough to do this as well. So we don't want to depend on 3rd party apps.But in order to complete this, I have many questions and problems in my mind.How to send the report sent to each supplier to me as information (e.g attachments)? How do I attach the excel report to the sent emails? How do I send email body as html with "Operational Report -> Report Formatter". How do I send the email sender from our email address like supplier@xyz.com. Or how do I make the sender header "Reminder for Pending Purchase Part"? Can I insert graphics such as lobby elements into the email?We are using IFS 9.4. And we couldn't find answers to most of our questions from the community and the help document.Your every information on the subject is very valuable to us. Thanks.  

Hi,I have created BR report with 2 parameter Project ActivityI used 3 data sources and used ‘custom dimension connection and custom dimension LOV’ windows for connect activity dimension to the project employee allocation source and get LOV for activity. But when running report showing all activities in database instead of selected project.  Appreciate your feedback regarding this issue.Thanks,Deepal.  

Hi,I have created a parameter “&Activity” for getting project activity short name. (Figure 1).And also created function parameter “&Activity_2”  because “&Activity” is not mandatory while running the report (Figure 2).After I checked “multi value” checkbox of “&Activity” and also changed operator to “IN” for holding multi values in filter criteria (Figure 3). When running report with multiple values its showing blank pageAnyone can help me to solve this problem? 

We are interested on What BI Reports are Available for Manufacturing customers. Appreciate if you can guide us where we can find BI Solution in each Product in IFS.

HelloI have created a report , clicked on the Save Report Option and filled out the required report information.The report was saved in the ‘Example Reports’ and was visible there after I saved it. I have not yet published it, because it was a work in progress.I have not used any custom IALs and I have full permission to create, save and publish reports.However, when I was looking for the report again the next day, it was no longer showing. No system updates were made overnight, so I don’t understand where my report went.Has anyone else experienced the same issue? 

Hi All, I have logged in as various users and the below fault is intermittent. It generally happens the first time you go to run the Work Order report that has been written in Crystal Reports. I am at a loss of where to look to try to prevent this from happening - any ideas you wonderfully clever individuals? Server error messages:9ec596ec-3c47-4924-a728-5e2aa6d3b44cIfs.Fnd.FndSystemException: Unexpected error while calling server method ExploreReports/NewClientReport ---> Ifs.Fnd.FndServerFaultException: ORA-04068: existing state of packages has been discardedFailed executing statement (ORA-04068: existing state of packages has been discardedORA-04061: existing state of  has been invalidatedORA-06512: at "IFSAPP.REPORT_SYS", line 3294ORA-04061: existing state of package body "IFSAPP.PART_SERIAL_CATALOG_API" has been invalidatedORA-06512: at "IFSAPP.WO_SEP_RPI", line 1199ORA-04065: not executed, altered or dropped package body "IFSAPP.PART_SERIAL_CATALOG_API"ORA-06512: at "IFSAPP.WO

Receive the below error when save. No any error/compilation issue in Database object of writeback interface. Where should I check?