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

Can someone explain what is the “new” recommended process to deploy a delivery in IFS cloud using managed services?

Hello, After creating a new customer, and populating the Invoice>General tab with company data, the customer is unable to be removed. There are no transactions of any kind associated with this customer. The following error message comes up: Reference design error when executing “SELECT COUNT(*) FROM INVOICE_TAB WHERE company = :value1_ AND identity = :value2_ AND PARTY_TYPE = :value3_ AND (CREATOR = ‘’Project_Invoice_API’’)” When copying the error out of the debugger, I notice that Project_Invoice_API is encapsulated in two sets of single quotes, which throws the error. I can attach the PL/SQL trace if it would be of any use. Any thoughts on this mystery? Many thanks, Marty

Hi, We have a report rule to force a certain layout to be used for specific site. This works well when printing one shoporder at a time. When printing multiple shop order by selecting many from the overview the report rule is ignored. My guess is that when printing mulitple system does not look in the files to check for the site. Also tried to add to the report rule current user and printed by but still the rule does not kick in. Is there a way to force specific layout in this case when printing multiple shop orders in one go? The other issue that some users do not get the print dialogue up at all when shop orders are printed and have no change to select the layout from there. Tried with full access and with clear profile but it still does not appear, not sure what could effect to this. Regards, Anna

Hi, There is an issue in regards to an element that works fine in EE Client but will error in Aurena. It references Invalid data source definition. Note - Lobby Element is of type Aurena. Steps Tried - Alias with ifsinfo for IAL view along side &IAL Refresh Aurena Page Cache and EE Caches Element and Data source are granted to permission set. Aurena - EE - Data source element - Any advice would be appreciated or please let me know if you need more detail. Many Thanks,

I can’t open any layout in Report Designer, nothing happens when I try to open RDL. //Tobias

Greetings, fndbas/UserTasks.projection uses Client Value filter for MyTodo entity: As FNDBAS is not customizable, we cannot currently translate “Todo” to client language. P. S. I’m not sure if this is the place to report bugs, so if I’m misdirected, please let me know. :)

Is there global variable in aurena client model .I just find variable in command.

I have just started to explore on the topic of field/row level security in IFS Aurena. Wanted to get more info on the same.

We are currently running IFS 10 release 6 on our Azure environment. This setup is using Azure AD Proxy. But in our test environment we have IFS10 release 8 which is using a different setup that causes an issue with websockets on that Azure AD Proxy software. According to IFS we should use Azure Application Gateway, but we have no clue how this should be done and our Azure partner is also lost in the recommendation of IFS. IFS itself claims that the installation and setup of this Azure Application Gateway is typically done by the customer, and can’t give us any more information on how to do this. Is there anybody outthere who knows how this should be setup? Or who can share the nesecary information for us to get this going? BR Filiep

DefColVisibility is a Profile Entry for table pages, but I’m not sure what it does. I get that ColVisibility is used to show/hide columns. I figured DefColVisibility would be something like Default Column Visibility so I set the value to false (0) for one of the columns and it didn’t do anything. If the “Def” prefix doesn’t mean default, what does it mean?

Hi, I’m trying to move our SMTP from our on premise exchange to O365… I’m trying to use smtp.outlook365 as the SMTP host, ive tried port 25 and 587 but nothing works.. someone mentioned that they used a mail.protection.outlook.com host and port 25 which sort of works for internal addresses but i still cant send external… has anyone successfully got this working? what settings have you used? Thanks, Mick.

I have an event action to execute online SQL and I’m getting this error on the background job. Any ideas on how to troubleshoot? I will say that all other standard IFS email event actions work fine, only when I attempt to do an email through the method below do I have an issue. Procedure Command_Sys.Mail is overloaded and overloaded procedure is not supported. ORA-20105: Transaction.OVERLOAD Here’s my SQL statement (taken from another post by @durette - thanks for the idea) DECLARE attr_ VARCHAR2(32767);BEGIN client_sys.clear_attr(attr_); client_sys.add_to_attr('FROM_USER_NAME_', fnd_session_api.get_fnd_user, attr_); client_sys.add_to_attr('TO_USER_NAME_', fnd_session_api.get_fnd_user, attr_); client_sys.add_to_attr('SUBJECT_', 'This is your subject line.', attr_); client_sys.add_to_attr('TEXT_', 'This is your message body.', attr_); client_sys.add_to_attr('MAIL_SENDER_', 'MAIL_SENDER1', attr_); -- client_sys.add_to_attr('ERROR_TEXT_', NULL, attr_); -- client_sys.add_to_attr('ATTACH_',

We have a customer on Apps10 UPD7 trying to set up Active Directory User Integration Configuration but have not been successful.When 'Database Authentication not allowed' is unchecked, they receive error"Failed to perform LDAP search: [LDAP: error code 1 - 000020D6: SvcErr: DSID-031007E5, problem 5012 (DIR_ERROR), data 0" When 'Database Authentication not allowed' is 'checked, no users are synchronized. Please see attached screen shot

Hi All, Trying to add the Message class DELSCH in the connectivity section so I can automate intersite transactions. When I try and add this I get the attached error that the procedure does not exist. I believe this to be a PL/SQL package that we are missing, and if that’s the case how would I get it? Thanks in advance!!

Hi I'm trying to setup a media connection from purchase order receipt to the purchase order header. This is so we can scan delivery notes via the camera functionality on the WaDaCo receipt arrival process and the PL team can then see this in attachments. Can anyone possibly help with the transformation method on this? thanks Nick

Hello - looking for any Oracle database experts out there…. We use a database backup tool named Unitrends to backup our instance of IFS. The tool basically leverages RMAN to backup Oracle using the ARC archive files created. We are having an issue when trying to run the process, has anyone ever seen the following error? We are using Windows Server 2012 R2 as our database server: I am struggling to understand how to grant a Windows user account DBA privileges? Any ideas on this? Many thanks!!

This seems like it should be easy but I cannot figure it out. I want to create a custom event for the purchase_order_line_tab using the execute online sql action. The goal is when a PO line is entered, use the value from one field, use that in a function to return a value and insert that value into another field for the same PO line. For a test I can just hard code the value for now. If I was just creating a trigger I would do something like below. Any suggestion on what I need to do to get this to work. declare a_ varchar2(20); begin a_ := 'Test Result'; :NEW.part_revision := a_; end; Thanks Phil

Hi all, Anyone know the substitution variable for this value: This is not working:

Hi, Does anyone have IFS Analysis Models - SSIS Config Utility Help document, Can you please send me? Thank you.

We are currently outputting to CSV from the manual supplier invoices screen. The invoices often have documents attached. I would like the output CSV to contain a hyperlink to the attachment so user can select the link and open a click 2 run session to see the attachment. Is that possible? If so.. how?

I am trying to connect an IAL definition to a Data Source Designer Element, but when I click the preview button I get an “SQL command not properly ended”. Here is a screen shot of my IAL Object Developer, below that is a screen shot of my report designer and below that is a screen shot of the error I am getting. IAL Object Developer Data Source Designer

We need to store some information about serialized parts that stays even if the part is no longer in stock. I have created a custom field on the part serial record to store this information. I would like to be able to go to Part Serials and add the information to a large batch of serial numbers at one time. However, it looks like the Part Serials table is not updateable. Does anyone have any suggestions on how to do this?

We have a customer in Germany that requires .xml reporting for invoices. We tried using a .rdl report from IFS to generate the .xml successfully. However, the report shows our Parent US company name on it and not our subsidiary from Europe. Even though the invoice is for the other Company (FR200)in IFS. How do we update/fix the .rdl to have the Europe company name on the report instead of US?

Have made changes to a data source, then the applicable element, cleared server cache and lobby cache (URL) with no luck. I know I must be missing something simple, but I do not know what it is. Sincerely, VK

Can someone point me to the technical document for creating a custom field in Aurena. I have one created and published in IEE - IFS10 , need to see that in Aurena Page designer… looks like i am missing some small detail of matching projection or LU… Thanks