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

Does anyone know where can we change the configuration fields below directly on the database (Oracle)? We need to setup our database copy script so we don’t need to reconfigure it every time we restore a database in another environment (what we do a lot).    

Have we gone through a process of certification of IFS Applications against some of the Security Standards like ISO/IEC 27034

I have a user that never receives the numerical notification in his Streams when he is sent something. If he clicks on the Streams button, he does see the task/notice, however there is not red alert to indicate it is there. He appears to be the only user this is happening to, and I do not see anywhere in Streams that there is a config to turn the notice on or off. Any help or guidance on this would be greatly appreciated. Thank you.

Hi, I have configured my Apps9 middleware server to user LDAP (on-prem) Active Directory. The AD password works fine and users can login using their AD account. However, the issue arises when oracle accounts get locked and expire, users cannot then login with their AD credentials.   Is the recommended practise to change oracle profiles so passwords never expire and accounts never lock, or should I be doing something different.

We are experiencing issues where users have been created using a user account as opposed to IFSAPP.    This morning we had an error relating not having access to user proxy.   Could this be due to the user creating the user not having the rights to grant CONNECT?   Should users only be created by IFSAPP?

We are in an IFS Apps 10 managed environment and would like to interface into IFS by calling existing Oracle API's from an external application. We run into limititations with the Excell add-in and Migration Jobs. Any Idea's ?  

Hello I am wondering if anyone of you have documented some How To document on IFS Securities and Permission sets, profiling etc.  Looking for some initial document to compiling one for our company. any ideas, tips, existing document will be highly appreciated.   Thanks

I have created a custom field in Sales price list part. I am trying to migrate data into Sales Price list Part to insert and Update the data incl. the custom field. I have followed the Guides available for the Custom field migration job but it seems i am missing something. The migration job is able to insert but does not allow for Update and prompts the error (ORA-20112: SalesPriceListPart.EXIST2: The Sales Price List Part object already exists.) Any help would be appreciated.

Hi All Is it possible to hide/inactive below highlighted fields for some users in system without any customization ?   Window - Customer Order    

Hi,   I have tried to insert multiple data using IFS API. after debug insert process in Aurena, i got Request Header & Request Body below: Request header :   Request Body :   But the process unsuccessful   Please advice thanks.

list of operating systems that can be used for application server i.e windows server 2008 R2 .

We’ve created a new context/scope in Aurena and want to roll it out to users. The only way I can find to do that is by default company. We have several business units and would like some users to see one style screen, and other users to see a different one. They are all users with the same default company. Is there any other way to do this other than company?      

When entering text fields (like Part numbers) using the numeric keypad, the dot is shown as a comma. The regional and keyboard settings in Windows are set to keyboard layout en-US, which in every other application results in a dot.  Changing regional settings or numeric format in the IFS options gives no result.  Is there a way to influence the behavior of this? 

In IFS9, we were able to log in to weblogic console using the following URL. <http://host_name:7001/console>   However, the page of weblogic console is not displayed even if the following URL is accessed with IFS10. <http://host_name:7001/console> <https://host_name:7001/console>   Can you tell me how to login to Weblogic Console in IFS10?

I sent this topic to IFS Support in March, but have not received an answer. Hoping someone maybe can give me a “yes”/”no”:   We use IFS V9. We updated in the Application Base Setup > Enterprise > Site, under the Inventory > General tab, the Picking Lead Time to be 10 days for all sites in Prod. However, if we have to key a short-lead order, we get an "INFORMATION MESSAGE: THE DUE DATE IS EARLIER THAN TODAY'S DATE. EARLIER POSSIBLE DELIVERY DATE IS YYYY-MM-DD" for every line item. We can press OK and bypass the message, and it will let you continue keying, but again - it occurs with every line item, which makes keying more of a task. We are looking for a possible way to disable this message?    

In IFS 75 version Reference_sys package during refresh active list has validation that CASCADE option is only valid for P - primary key. Since IFS 8 version there is no that validation. I want to ask whether CASCADE option for A - attribute column or K - key are proper AQS behaviour? It make sens to use it? Check following query which shows many examples from standard code  SELECT DVC.LU_NAME,        DVC.VIEW_NAME,        DVC.COLUMN_NAME,        DVC.COLUMN_REFERENCE,        DVC.TYPE_FLAG   FROM DICTIONARY_SYS_VIEW_COLUMN DVC  WHERE DVC.COLUMN_REFERENCE IS NOT NULL    AND DVC.COLUMN_NAME NOT IN        ('OBJID', 'OBJVERSION', 'OBJEVENTS', 'OBJSTATE')    AND SUBSTR(DVC.VIEW_NAME, -4) <> '_REP'    AND COLUMN_REFERENCE LIKE '%CASCADE%'    AND TYPE_FLAG  NOT in ('P'/*,'K'*/)  order by lu_name

Does IFS 10 (Aurena) provide Out the box functionality to receive documents (.pdf) from an external source via web service?    looking at the list of BizApi’s available i can not see any related to receiving inbound documents, if there is can anybody point me to the correct service / documentation.   Thank you.

I am editing an existing Lobby we created and added a Description element. It’s on the page but when I view the Lobby Page in another session as a User, it doesn’t appear. If I then leave the Lobby Element Designer and reenter my Element is gone. How do I “save it” so it shows to the user? (plus I get an error- perhaps that’s why it doesn’t show?)    

Hi, We configured CWS for IFS Apps 10, as per IFS documentation but running into the following error trying to View a Crystal Quick Report in IFS: Here are the error details captured by the CWS logs: 6/18/2020 11:23:18 AM[IFSCRWebSetup]-[LoadReport] Loading report : C:\ifs\test10_reports\WC Load.rpt 6/18/2020 11:23:18 AM[IFSCRWebSetup]-[LoadReport] DBUser = ifssys ,DBPassword : ******* ,DBServerName : TEST10 ,AppOwner : IFSAPP 6/18/2020 11:23:18 AM[IFSCRWebSetup]-[ReadLogonInfo] ssss 6/18/2020 11:23:18 AM[IFSCRWebSetup]-[LoadReport] Processing 2 parameters. 6/18/2020 11:23:18 AM[IFSCRWebSetup]-[SetTableLocation] Set appropriate post-fixes for REI_WORK_CENTER_LOAD\ 6/18/2020 11:23:18 AM[IFSCRWebSetup]-[SetDatabaseLocation] Generating fully qualified database object name for ABC_WORK_CENTER_LOAD\ 6/18/2020 11:23:18 AM[IFSCRWebSetup]-ERROR in [ExportReportWithParametersAndlogonInfo] Error in exporting the report in rpt format. 6/18/2020 11:23:18 AM[IFSCRWebSetup]-Failed to load databas

Has anyone else ever had Apps10 (UPD5 in our case) completely lock up and require stop and restart of the server services using mws-svr? In the most recent instance last week, after a successful STOP using mws-svr, the entire VM actually locked up during the START and required a ‘hard’ reboot from the VM console.  No errors were seen in the logs at all; they just have no entries from after the time of the freeze showing a happy system doing normal processing until then.  Unfortunately after the VM rebooted we had some file corruption and missing files that required a recovery from backup.  I can’t tell for sure if the files were damaged or missing before the stop/start or if that happened from the forced VM reboot. So: Are we the only ones seeing anything like this?  Has anyone else experienced issues with IFS Applications Server just stopping, or with files becoming corrupted or missing during normal operation? Thanks, Nick

Does anyone know of any IFS Documentation on how to map IAL columns to the Designer ? Here’s what we’re trying and we get an error:         IAL: select col.COMPANY as Company, col.CONTRACT as Site, col.customer_no || ' - ' || max(rega1app.CUST_ORD_CUSTOMER_API.Get_Name(col.CUSTOMER_NO)) as Customer_Name, pm.Part_Main_Group "Trademark", ROUND(SUM( col.revised_qty_due * col.sale_unit_price), 2) "Total_Revenue", ROUND(SUM( col.revised_qty_due * col.cost ), 2) "Total_Sales_Cost", ROUND( SUM( ((col.revised_qty_due * col.sale_unit_price) - (col. revised_qty_due * col.cost))), 2) "Margin", ROUND(AVG( case when col.sale_unit_price <> 0 then (((col.revised_qty_due *  col.sale_unit_price) - (col.revised_qty_due * col.cost)) / (col.revised_qty_due * col.sale_unit_price)) * 100 else 0 end ) , 2) "Margin_%" from REGA1APP.CUSTOMER_ORDER_LINE col left join REGA1APP.CUSTOMER_ORDER co on col.ORDER_NO = co.ORDER_NO left join REGA1APP.PART_CATALOG pm on col.part_no = pm.part_no left j

Hi Team,   we have four managed server , in each managed server log, getting below error: could anyone suggest what could be the issue ? ####<Jun 23, 2020 9:56:01 AM CEST> <Info> <JDBC>  <ManagedServer1> <[ACTIVE] ExecuteThread: '23' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1592898961605> <BEA-001128> <Connection for pool "fndbas" has been closed.>   we  have IFS 8 environment .   Please suggest.      

Hi, I am installing IFS Application 9  in Windows Server 2012 and facing error and its seem like Java related issue. “build\server\install_fndmws.xml:546: The following error occurred while executing this line:” “build\server\install_fndmws.xml:590: Java returned: 1” Please help. Thanks  

We have a quick report with no parameters, but we want the Parameters window to pop up to show Comments in which we’ve documented each column on the report.   Can this be done? How do you document your quick reports for users since there’s not other place to put user info?  

We are trying to add a barcode for the work order number to print on the embedded work order copy.  They look fine in the crystal report designer, but when viewing them in IFS, the barcode either shrinks to a size that is too small to scan or it disappears entirely, all depending on the font size used for the barcode in the crystal report. We tried a different barcode font to try and installed it on the Windows server. We restarted the server to ensure the font installed properly. We tried different things in the crystal report to try to make it work, but nothing worked. We have tested and we can successfully print and scan barcodes on a Quick Report. Therefore there is something about the process that IFS uses when exporting the embedded reports to PDF that is causing the barcode formatting problem Anyone have a similar issue?   Apps 9