Solved

Hello All, Looking for some guidance on database size and overall data cleardown in some of the tables.   We have been in the system for 20months now and the database is at 2Tb, not massive in the grand scheme of things but need to know potential size moving forwards as well as ways of managing the size of the database so it doesnt continue to grow uncontrolably.   As far as I can see we can clear some old data in a select number of tables but this doesnt have much of a substancial impact on the overall size. These tables being shop order clocking and lines.   Assistance and experience is appreciated   Thanks Mike

Hello,We’ve recently enable AAD authentication for our test environment in IFS 10 UPD9. Is it possible to use Oracle accounts in IFS still with AAD enabled? If so, how do we authenticate the Oracle accounts with SSO?

Right now if you select multiple parts and move to TT, it creates different TT for each part. We would like to have all selected lines under one TT. We usually do not have our parts ‘Serialized’ but if there is a Serialized part maybe it can create a different TT for the serialize part and one TT for the non-serialized part. Has anyone come up with a way of doing the above request?

I have created a counter element for one of my Aurena Lobbies. This element works in IEE but not in Aurena. The counter populates the correct number in Aurena but when I click on the element, I get a Server Error when it is trying to filter out using my data source condition on the Business Opportunities screen. Something to note, I am including a custom lu table in my query. This is the query I am using in the data source. The lobby takes 3 parameters (Sales_0, Sales_1, Sales_2). The query is supposed to be help default the salesperson ID - if the user that is logged in has a salesperson ID (to prevent sales from needing to add their salesperson code into the parameters):View: &AO.BUSINESS_OPPORTUNITYCondition:-- open BO statusSTATE = 'Confirmed'-- If the first parameter is empty then match on the salesperson code that is connected to the person logged inAND (&AO.CUST_ORD_CUSTOMER_API.GET_SALESMAN_CODE(CUSTOMER_ID) = NVL(UPPER('$Sales_0$'),UPPER((SELECT

Hi Experts,I have setup a new PSO application, but the gateway authentication is not working. Even if I provide gateway authentication url, it is taking me to Azure SSO Page. Can you guys please suggest a solution to not allow Azure authentication when gateway url is used? (/IFSPSOWorkbench/Default/login?authGateway=true)

Hello,I’m wondering if it’s possible to adjust the future due dates on a PM action with Performed Date Based set to Yes without a new work task being created/completed? Every time I try to manually change the due date on a line in the maintenance plan, the system won’t change any future suggestions. We’re running apps 10 update 13.A little background on the specific scenario:The PM generated a work order for 10/5/22, but because it falls during a major outage at the plant, it was decided to skip this instance and perform the maintenance when the unit is back online. The WO for 10/5/22 ended up being cancelled. The major outage will be completed by 12/12/22, so we want to adjust the next due date for this PM to line up with that date. I can manually adjust the due date for the next maintenance plan line and save, but the rest of the due dates don’t adjust. The Earliest Start, Latest Finish, and Remaining to Due fields also remain the same for the original due date. I’ve also tried chang

Hi all,As i said in the title i am looking for a way to find this in db level.For example which users have permission to see frmProductStructure?I am finding this as manuel in solution manager/Permission Sets etc. But maybe there is a easiest way in db level with a simple query.Best Regards.

The Repair Order Price Type field needs to retain the type selected by the Component Repair Analyst and not change to “Confirmed” when the order is received.  Once the CRA validates the service with the vendor that matches the price paid these should remain on the order and not automatically be changed by the system.  The field currently changes to confirmed on receipt. Need to validate the Price Type field is a text field Need to expand the Price Type field to include all services: Test, Inspect, Calibration, Minor Repair, Std Repair, Major Repair, Overhaul, Modification, RAI  

Hello Community,I was trying to add a ✓ symbol in the report designer. For this I inserted the character like this in a column in RDF file -Xml_Record_Writer_SYS.Add_Element(xml$_, 'CHECKMARK', 'RK ' || TO_CHAR(UNISTR('\2713')));I also tried simply with UNISTR(‘\2713’) , TO_CHAR(UNISTR(‘\2713’) but none worked.When I printed the report, the character wasn’t showing. When I tried concatenating ‘RK ‘ string before it, only the first string printed -No Checkmark SymbolIs it limitation of report designer not able to print unicode characters? Or is there another way to print such characters? (without using images) Thanks in advance.Rohit.

hello every one,in some users the Attachment does not appear, but in some other appear for the same logic unit , the problem maybe in Permission Set.can anybody help.thank you.     

Hi All, Can anyone please show an example of using NVL2 function parameter in a BR report?  I tried to use NVL but could not get what I wanted. And trying to use NVL2 function parameter, but  not sure what should I enter for the first argument (ValueIfNull). please see the image.&CodeB is a standard parameter for DIM_CODE_B.CODEThe requirement is to get all CodeB values including NULL when the &CodeB leaves blank and the selected CodeB values when &CodeB has a value.Example:when &CodeB = say '45' , the report will only show the records with code_b = 45when &CodeB leaves blank (NULL) then the report will show the records where the code_b of any value plus the code_b IS NULL  Thank you!

Hi All, I’m struggeling to create a list via a Mobile Client Script.I succesfully recieve a Object with data via getDBValues, but I only need one item from that object. So I created a for loop, to go trough the object and store the value in a String, Array or Object (doesn’t matter). Creating a new Array or a Object seems not to work for mobile Als simply extending a var via the += method also not working.Example:var data = getDBValues(stringFormat("SELECT id FROM database_table WHERE type = 'placeholder'"));var arr = new Array();var list = ‘’;for(var i=0; i < data.length; i++) {       arr.push(data[i]['ID']);   list+= data[i]['ID'];} 

We are using IFS 10 UPD7 wherein the Inherit Measurement functionality is not available.Since there are some serial objects which are being moved between equipment's and running hours of the serial object is tracked for maintenance, repair and replacement, it is needed to auto update the measurement readings from the parent object. Would like to know is there any patch available to get this functionality in IFS 10 UPD7 version. Thanks in advance,Siva Ganesh M  

I have problems with an advance invoice that is bigger than the connected Customer Order Invoice. This happened when Customer order was created, Advanced invoice was created and sent to the customer.Thereafter the price for an item on that order was decreased. Order released, shipped. When the invoice is to be created, a posting error is displayed:“ORA-20105: Invoice.ACCERROR1: Error (Sum of offset amounts 10000 cannot exceed gross amount of customer invoice 9500!) occurred while booking Invoice CD 220000074.” According to help text, “Advance invoices can only be prepared for up to one hundred percent of the total value of the order”, in this case the advance invoice is about 105%.I cannot post invoice. Any option to get these posted are of interest, preferably with the difference as POA.Best RegardsDenny

Hi  I am trying to setup an employee schedule for our casual staff where they are scheduled to work a Total 40hrs per week, (5days a week for 10hrs per day), with any additional hrs works they receive as overtimeI.e. if an employee works 43hours, they should receive 3hrs as overtime  Mon Tue Wed Thur Fri Wk Total Normal 9 12 12 7 - Overtime - - - 3 - Total 9 12 12 10 - 43  When trying to set this up as a Day type schedule, I can’t seem to get the overtime to calculate correctly, as it is calculating based on the 10hr per day not the total 40hrs per weekI.e. with the above it is calculating 4hrs as overtime I can’t seem to get the Flexible schedule to achieve this either Any help would be hugely appreciatedCheers 

 Dear All,would you help ? I’ve an issued when tried to create shop order the message was shown “Supply for shop order part not allowed”, would you kindly suggest ? Thank you.

hi sirIn app10 upd15 and upd16 aurena.in the supplier address window,  there is no address detail is it a bug ？ 

Hi All, I’m raising this IFS community post on behalf of a customer. The customer has raised an issue regarding the unavailability of the RMB option, “Electronic Payment Addresses” for the payment method CHK. Customer was already informed the following explanations through the case. CHK payment method doesn’t have an electronic payment address in the IFS application.  This is the reason why this option is not available with the CHK payment method.  For payment methods such as, SEPA, BACS, ISO22000, or ACH, this option is available.Customer needs to know the reason why some of the payment methods like CHK are not enabled for “Electronic Payment Addresses” option.  Thank you! Best Regards,Geeth 

IFS Cloud 22.1.4, Case CS0087287ObjectProperty property_value cannot be longer then 24-67 characters in Aurena. Because ETAG exceed 100 characters. etag_ VARCHAR2(100) := 'W/"'||objid_||':'||objversion_||'"';objid length = 18other characters = 5100chars is exceeded whenvalue length > 67 charswhen validation is enabled => max. value length = 67 – (length of validation method aprox. 43 ch) = 24 charactersSELECT avg(length(validation_method)) FROM object_property where validation_method is not null; = validatation avg length = 43chI want to use 250 characters long string, column is defined as 2000 chars long.This BUG is system wide, etag creation or long objversions must be redesigned at least for specific logical units. rtrim(rpad(property_value||chr(31)||validation_enabled||chr(31)||validation_method,2000)) objversion,  

Hello,I hope someone can help me 😊.This is the scenario :When a CO is for the customer XXX, I would like to create a “Purchase Order Direct” , and when it’s a YYY or ZZZ customer i would like to create an “Invent Order” . ( It’s the same sales part )Can we drive the Sourcing rules automatically du to the customer ?These are the setting I made :Create a sourcing rule : With highest rank as Sourcing Objective.Create a sourcing rules per Customer and Sales Part   And this is the error when I create a line on CO : There is also the set up “Sales Part” Sourcing Option, but i’m not interested because it will always give the same choice for every customer. Did someone  know how to setting this properly ?Regards,Nicolas.

I have created a persistent filed of data type number and would like to limit it to 2 digits.  Does anyone know how to limit the field to 2 digits?

Hello all,I would like to ask for your help to navigate me where to set the background color for gant chart in APB. Unfortunately, it is set to the orange and I would like to reset it back to white/transparent. Can you navigate me to the appropriate register key?With kind regards,Zdenek Baumelt  

Hi Community, does anybody know if it’s possible to customize the .html layout of the service report in Aurena Native Apps (Service Engineer App)? thanks and BR,Sven

Morning All,  I am following the documentation to Configure IFS Database Identity Provider:Configuring the IFS Database Identity Provider Our Apps 10 environment is running on a local server,  is it possible to have Logo URL and the Background Image URL local files stored on the server and not web addresses?  I have attempted to have the URL as \\T:\IMAGES\BACKGROUND.jpg but this does not seem to work, the images are stored on the middleware server and the path is correct. 

To extract data from IFS, Is the use of ETL like Boomi prevent the use of other mode of Extraction( flat files extraction ) ? that is to say, if i use Boomi to extract data from IFS i cannot do so using flat file in the same time ?