Solved

Does anyone know why I am getting the following error message when I try to export my Quick Report to Excel?Excel Plugin Error: ORA-06550: line 1, column 43:PL/SQL: ORA-01031: insufficient privilegesThe Quick Report runs fine in IFS and, once run, I can output the results to excel, but I can not simply  do the report function “Export to Excel”.  The report is written against a materialized view in IFS.  I can see the view in IFS SQL Query Tool and can preform searches on the view.The report is written using the following SQL statement:select * from c_pol_gl_sales_cogs_union_mvI have tried using &AO., IFSINFO., prefixes to view name with no luck.

We are trying to add a custom field on the page ReportPickingOfPickListLines. The LU in IEE is CustomerOrderReservation. But in Aurena page designer we are not able to add the custom attibute in Content. On other pages it´s no problem. Is there any limitations on what pages/lists we can add custom attributes?

Hello AllLobby help again needed please. I’ve got a date field in the data and in the element I’d like to highlight dates that are passed today’s date. The system doesn’t like me putting in ‘TODAY’ as the value but it works when I add today’s actual date - any ideas on how to get this to work?Working when I added a dateNot working when I add ‘TODAY’ 

Hi, We have non inventory sales part invoice in ‘Printed’ status and when I checked customer invoice posting analysis it is showing me an error for non inventory sales part “Value is missing or has an invalid time interval for posting type M30 control type C49 code part B in company ABCD”  How can  I resolve this error ? Please help.

I am after setting the remember me option, is this the correct place to set it:  

HI All  I got a problem when setting up a SEPA Credit transfer file with from a German company using Nordea in Finland. Is there anyone that can help me understanding what the errors are and were to correct.  

Hi,I’m trying to create a permission set to grant access to create custom menu items.This is how it’s set up, but still the user can’t create menu items.Why is that, and why are the first tree items red?BR Kresten

Question: How are Aurena Global and Custom Contexts affected by IFS Applications 10 Core Updates?Example: Customer creates a Custom Context in IFS Aurena on a baseline installation of IFS Applications 10 UPD7. They subsequently deploy UPD8. Are both the Global Context and Custom Context automatically updated and aligned with UPD8 when it is deployed or do they have to manually update either or both of the Global or Custom Context?Reason for Question: Customer is about to take UPD9 and wants to know the impact on Global and Custom Contexts.If someone could sign-post me to any published information on this topic please I would appreciate it. I have searched the IFS 10 Technical Documentation but couldn’t find anything which specifically addressed this.Many Thanks,Russell

I am trying to access the list data in the ‘task’ list on the ‘My Tasks Today’ page on the Tech Portal.  I have tried:   var listData=getFormDataLists('task');var listLength=listData.length;alert(listLength);   But this just returns 0, when there are tasks there?   What i am trying to do is retrieve the tasks, then cycle through them and then performing a dirty read on a checkbox i have added (user_def2), any that are checked will then be updated.

Hi All,I am trying to integrate the Web service using C#.Net and I am getting below error, Is anyone has a clue to solve this?The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Basic realm="myrealm"'.

I this video  it is shown that you can have different version of a page based on conditions: ​​​​​Is it possible to put the scope ID in a navigation link and override the other conditions?

Hello, I am attempting to create a Streams notification that is sent to users when they are assigned as the Responsible user on a given CO Action. I have the notification created, however, I’m not sure how to get the Streams notice to push to the responsible user. Currently, the only option is the Responsible ID, which appears to be their employee number and Responsible, which is their name. Neither of these allow the Streams notice to be sent to them. Is there anyway to configure this notification? Any help would be greatly appreciated.

Dzień dobry.Jak w tytule.Klikam w Enterprise Explorer…   i nic się nie dzieje. Także bezpośrednio odpalana “Ifs.Fnd.Explorer.application” nie działa.Stało się tak się tak po zawieszeniu komputera w trakcie pracy IFS i zimnym restarcie . Do momentu zawieszenia wszystko było OK. Może trzeba coś wykasować albo w rejestrze coś się “zatrzasnęło”? Bo o ile wiem to instalki w tej wersji niema?Pozdrawiam;Leonard

When I am login to the account, the below error is giving. If that user has the app-owner permission, then the user can avoid that problem. But the error is giving for the other permission sets.  

This regards the IFS Business Reporter add-in for Excel, specifically Excel in Office 2016, 64-bit. There is one specific BR report we run which I’m having these difficulties with, doesn’t seem to occur with any other report and, strangely enough, running this same report works when done on different computers. The error we’re having occurs when trying to “Run Report” once IFS is loaded. We pick the standard parameter values, press OK, then in the Report Execution Progress window, it seems to go through everything (goes through steps 1 - 3 , fetches data) then it crashes Excel, Excel restarts, and it opens to a blank worksheet. I’ve checked the event logs and found the following pop-up at about the same time it crashes, so this should correlate: Event Log Error #1Event Log Error #2I’ve tried many things, like running .net repairs and running as admin. I’ve officially run out of ideas, so I’ve come here, hoping I can be pointed in the right direction if not have the problem solved entir

I’ve a very simple base flow that is also our master flow which contains our current forecast.  I want to take the SKU-level forecasts from the base flow and transfer it to a combined flow that consists of customers demand history effectively allowing forecasting by customer.  I’m using Apps9 and DP Client 4.0.2.22. Using distribute adjustment on a top level does not carry over the seasonal models per product and it doesn’t seem to bring over the sku-level forecast either.  The parameters i’m using are: target: forecast (in the new combined flow) distribution: based on forecast distribute by: part # distribute from: current base flow What am I missing? Is there a way to pull over the aggregate forecast with out doing it per sku? I realize that the granular customer level forecast may render odd but I’m less concerned with that to begin with so long as the aggregate per SKU rolls up to the currently existing forecast.

Hi am new to IFS and I was wondering if any one knew where to find the IFS report designer, when i search for it in the navigations pane nothing comes up

Hello,Does anyone know from where I can print TIME_CARD_REP (Time Card) report?Thank you.  

Hi, Does ‘Planning Alerts - Shop Order’ need to be configured (if so, how) before this page is useful?   I’ve done partial testing by selecting ‘Approve Planning Alert’ for what is deemed as ‘Alert - High’. No changes  occurred to the orders/parts question. At least, not according to the history of said orders.   I’m not sure what to expect with this page, i.e. is this anything like actioning exception messages in other MRP vendors? What is the scope of these alerts?    many thanks, Jay

How could I change time type automatically on a work task  time report based on time of day? I have a service work order with service contact. Customer says you can visit the site M-F 8-4. Anything outside those hours we can bill overtime.  Ideas how i can do that in apps 10?  I know about scheduling preference and scheduling availability but nothing that translates availability into pricing markups. AKA coverage time. 

Hi all,Apps10 has this nice new feature called ‘operation block’ for splitting reported time between multiple shop orders. But it does not seem to be working on the materials. Hence, how do we issue material the same way to multiple shop orders (and unissue afterwards)? 

All application messages are pending in transaction state. No messages could be completed and notifications are not being sent. How can I fix this situation?Also, some background jobs are not completed. 

Hello all!  This question relates to IFS 10, Update 6.I’ve got a little challenge I could use some advice on.  I have a quick report that outputs some dollar amounts (code below):select unique activity_seq,activity_api.Get_Sub_Project_Id(activity_seq) as sub_project_id,activity_api.Get_Sub_Project_Description(activity_seq) as sub_project_description,activity_api.Get_Activity_No(activity_seq) as activity_no,activity_api.Get_Description(activity_seq) as activity_description,nvl(ifsapp.gd_report_utilities_clp.Get_Activity_Labor_Sum(activity_seq),0) as "Labor",nvl(ifsapp.gd_report_utilities_clp.Get_Activity_Material_Sum(activity_seq),0) as "Material",nvl(ifsapp.gd_report_utilities_clp.Get_Activity_Graphics_Sum(activity_seq),0) as "Graphics",nvl(ifsapp.gd_report_utilities_clp.Get_Activity_Expenses_Sum(activity_seq),0) as "Travel/Expenses"from ifsapp.project_connection_detailswhere project_id = '&PROJECT_ID'order by activity_api.Get_Sub_Project_Id(activity_seq),activity_api.Get_Activity_

Hi Can anyone has an idea how can I check the APIs Explorer in IFS 9?Thanks,

Hi,I want to do data masking on user role. We researched Data Redaction, but we use oracle standart edition. I tried editing the views(customer_order_line_tab). I know it’s a very wrong way. Because, it’s inevitable to receive errors due to calculations.I wanted to ask if anyone has any suggestions. Thanks,Best regards.