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

Do users have the ability to ceate new tasks in Aurena ? I can’t seem to find a way to create one

Hi community, I’m new to IFS and I’m wondering if there is a way to perform a kind of subscription for REST call from IFS Explorer or IFS Aurena. Basically what I’m trying to achieve now, is a simple task. Let’s say you have a “Purchase Order” and you want to get a kind of notification outside the IFS ecosystem when its status change from e.g. “Planned” to “Released”. To perform this task I need IFS to perform a REST call outside to another service that will receive the information and perform some additional operation. I read many topics but couldn’t find a way to do that for now. I also found that in IFS Explorer you can subscribe to event only for e-mail. I’m not sure how to do that. Do I need to write kind of batch or task in PL/SQL that will perform the REST call to outside and tie it to a custom event? Can someone provide at high level steps need to be done just to know how to move and how this this kind of operation could be performed. Does anyone had the same problem? Thanks

Hi everyone, I have this issue with a column in project Page in IEE i need to know wich is the formula for can retrieve the Total Costs in the project , because not is a custom field, somebody can help me please? Thanks for the Help

Hello, I’m using IFS Cloud. I currently have a custom event and an event action that should send an email every time a Business Opportunity closes. For some reason, even when the mail sender is on, emails aren’t being sent. Does anyone know why this might be the case? Everything looks fine to me. My Custom Event: Custom Attribute defined in the Custom event above My Event action When I close a Business Opportunity with the Reason ID of 40, nothing happens.

Hello, Is there a place IFS Cloud stores the logs of events, custom events, event actions, etc?I have an emailing event action but we aren’t getting any emails sent out, and other than doing an email trace, we have no way to debug to test what’s causing emails to not get sent/emails failing. Any and all advise would be greatly appreciated. Thanks,Bryan

Is it possible to know the log off and log on time for users in IFSAPPS10? We’ve researched articles and reached out to our implementation partners. They do not believe that it is possible. With history logging, we’re able to see user activities, but not logoff / logon times. The objective is to know total time in the system for a given period. We’re using this information to assist with training accountability.

What purpose is served by the index HISTORY_LOG_ATTRIBUTE_RK? Can I drop this index and/or its constraint? What specifically will happen if I do? I’m working on an upgrade from 9 to Cloud that includes a large data migration from Sales and Marketing to Embedded CRM, and I’m writing a lot of history logging when I insert the new records. Our whole business will be down while this runs, so it’s important to make this migration as fast as possible. Most of my experience in tuning Oracle databases has been with read-heavy systems, so it’s a new and interesting problem for me to optimize writes. I set a couple of Oracle parameters to temporarily improve commit performance (COMMIT_LOGGING=BATCH and COMMIT_WAIT=NOWAIT). I plan to change these back before handing the system off to end users. I’m running my migrations in parallel threads, so to avoid transaction contention, I set INITRANS to 4 on the history and history attributes tables and indexes, up from the default of 1 for the tables and

I have an issue with a custom event in the Customer Order screen in IFS APPS10. “Order Category” is a Custom Field on that screen. I want to: Check that “Order Type” contains “INT” and if it has “INT” check that “Order Category” is not empty and prevent the Order being saved if it is empty. But when I set the custom Event to check what is in “Order Category” it tells me there is no value (because it hasn’t been saved yet). It displays the Order Type but does not have a value for Order Category. I get the Order Category by joining the rowkey of the Order Category table (CUSTOMER_ORDER_CFT) on the Objkey of the Order Type table (CUSTOMER_ORDER). How do I get the event to delay until it has saved the Order Category ? Would a Deffered Call do it?

Hello, I currently have a custom event and event action that sends an email out. I would like to have a custom attribute on the custom event that gets the email we need to send to. This is currently what I have Sadly, this ends up in an error, no matter the formatting. I’ve tried just using BusinessOpportunityHandling.GetDefaultsForSendMail and multiple different formats, but nothing works. Can someone please show me how to properly do this? all of the ifs documentation shows are actual API calls like: but when you go to API Explorer in IFS Cloud, there are no actual “APIs” like this, only projections, which as I understand it, are oData API’s. There’s no other documentation for IFS. Any and all advise would be greatly appreciated. Thanks,Bryan

Hello, I’m wondering what the formatting might look like for when you try to call a projection function as an API call? I’d like to call the GetDefaultsForSendMail function from the BusinessOpportunityHandling Projection. I know the API is called Business_Opportunity_API but I have no way of seeing what the method looks like for the GetDefaultsForSendMail function. There is no real API documentation in the API explorer, only the projection (oData API) documentation. I’m trying to execute a PL/SQL server method to call that API function for an event action. Thanks,Bryan

Hello, Actually (we are on IFS V8), after each purchase order, an email is sent to the supplier with the purchase’s PDF. But for a purchase order, the email is not sent. This is the SQL request that we used for check if email is sent or not : SELECT poh.order_no order_no, famt.*, poh.userid, to_char(poh.date_entered,'DD/MM/YYYY HH24:MI:SS') date_entered, substr(poh.message_text,instr(poh.message_text,'(SID:')+5,instr(poh.message_text,')')-instr(poh.message_text,'(SID:')-5) SID, poh.message_text MESSAGE_TEXT, tlsl.state, NVL(famt.state, famt2.state), Client_SYS.Get_Item_Value('PDF_EVENT_PARAM_6',tlsl.arguments_string) order_rev_no, TO_CLOB(tlsl.error_text) error_textFROM PURCHASE_ORDER_HIST pohLEFT OUTER JOIN transaction_sys_local_tab tlsl ON tlsl.schedule_id=substr(poh.MESSAGE_TEXT,instr(poh.MESSAGE_TEXT,'(SID:')+5,instr(poh.MESSAGE_TEXT,')')-instr(poh.MESSAGE_TEXT,'(SID:')-5)LEFT OUTER JOIN fndcn_application_message_tab famt ON (substr(famt.subject,34,10) = Client_SYS.Get_Item_Value('

Hello, is it possible to create an ODBC connection which can be used in EXCEL to access data from IFS Cloud? Our IFS Cloud server runs on premise and I added the TESTPDB IFS instance the same way like APPS9 (see screenshot). Unfortunately, it does not work. Are there any technical limitations? Thanks, Golo

In Aurena Page Designer can you increase the size of the Card element? Can you resize a card to fit the screen or change the Font size? On a tablets the data displayed is too small to read. Any suggestions on how to make a screen bigger and easier to view? Thanks,

Couple of LTU related questions: What is for an IFS implementation the option to have LTU users in place? I mean how can we start using LTU? I noticed the description of what LTU users are in the following thread. Do I have it correctly memorized that we will prepare a permission set and IFS will turn it into a permission set to be used for LTU users? I think that for time registration or TripTracker LTU is needed/best. Is that a correct assumption?

Hello, Is there any documentation on how to create custom APIs and API calls for IFS Cloud? A lot of the documentation on the IFS Cloud technical documentation site either isn’t helpful, or it’s full of broken links. Even the 22r1 and newer links are broken with a 404 missing page error. Thanks,Bryan

Hi all, I am trying excel migration in ifs cloud 22R1 through excel add in but got stuck while clicking in login button in excel. Can you guess what will be the issue and suggest some method to resolve.

What steps are needed to move an FTP document repository? We moved repository to a new server location and new IP address. Should add the new Repository Address and User first? I don’t want to break the document link in IFS. I have read a few community postings but could not find a step by step process to follow. We copied our Document server to a new host and it has a new IP. Can someone provide direction? We use APPS10 UPD#11 Thank you,

Dears - When navigating from Lobby Element to a particular IFS Screen, is there any option to fetch the data sorted on the basis of a field value. Example - Lobby Element -- navigates to Purchase Orders screen. Can we sort the Purchase Orders on the basis of ORDER_NO ?

Hello, How can I send an email using a workflow? The event action type of email is so limiting, I can’t fetch values that I need to send an email, like the contact email for a business opportunity, so I have to use a workflow and use projection actions. How can I achieve this?Thanks,Bryan

Hello, can any one share daigram for push notification in IFS10 Regards Pankaj

Hello, What is the purpose of this database task and how can I call it properly? FND_EVENT_ACTION_API.ACTION_EXECUTEONLINESQL I tried using this and it keeps giving me an error saying SQL is not a valid reference. Is there documentation regarding the formatting of it’s parameters? I also would like to know what the purpose of this other database task is FND_WORKFLOW_CONNECTION_API.START_WORKFLOW and how I can properly call it. I also get an error when I try to invoke this database task. There is no documentation that I could find on the API Explorer or the IFS Cloud technical documentation. Thanks,Bryan

I’m trying to access a field from the scheduling resource. This works for a standard field like this: Resource_API.Get_Description(#RESOURCE_SEQ#) However, I want to retrieve a custom field and cannot figure out the correct syntax. Any pointer appreciated.

Hi All, I am trying to test Push Notifications from the application(ServiceEngApp - Windows) as well as using Mobile_Push_SYS.Send_Notification. I can see Push Notifications from Aurena User Log.However, I cannot see any Push Notifications from the mWO app.Notification Parameters have default values.Any thoughts?Please refer attachments for further info.

Hi All, we are currently having an issue with creating new attachments and getting this error. I saw this post and already re-check with win scp , it can connected This is EDM Basic and I test with WinSCP This is in IFSAPP 08. Really appreciate your valuable opinions and suggestions to sort out this problem. Thank you in advance!

A IFS Cloud 21R2 environment was cloned from PROD to TEST and after the clone, the tasks are not automatically running in TEST env. So far we have checked that oracle batch jobs are running and job_queue_processes is set to a high number. Any other ideas what to check?