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

Trying to use the following statement inside an event IF  EXPENSE_RULE_VALUE in ('STD') and  #USER_ID# not in ('7889','013588') THEN  Raise_application_error(-20199,'Select the expense t  : ' ||   EXPENSE_RULE_VALUE  || ' can not be used any more' );END IF; But we encounter the below error [ORA-06550]: line 27, column 74:PLS-00201: identifier 'IFSAPP' must be declaredORA-06550: line 27, column 2: any way to use the #USER_ID#  properly ? 

Hi all,  I am new to creating custom events and a novice when it comes to PL/SQL. I am trying to achieve when a Purchase Requisition is turned into a Request for Order Quotation that the Supplier on the Purchase Requisition Line is transferred to the Supplier tab in the Request for Order Quotation LU. My code isn’t erroring out but I feel I am missing something as the supplier is not transferring over. As always, thank you for your help and time.  -EliCode: DECLAREINQUIRY_NO_ VARCHAR2(32000) := '&NEW:INQUIRY_NO';VENDOR_NO_ VARCHAR2(32000);attr_ VARCHAR2(32000);CURSOR get_vendor_no ISSELECT VENDOR_NOFROM PURCHASE_REQ_LINE_PARTWHERE vendor_no = vendor_no_; BEGINOPEN get_vendor_no;FETCH get_vendor_no INTO vendor_no_;CLOSE get_vendor_no;Client_SYS.clear_attr(attr_);Client_SYS.add_to_attr('VENDOR_NO', vendor_no_, attr_);END;

Hello IFS community,Is there a table that hold all the messages sent via IFS notification?Or any particular place where I could see all the messages sent? IFS9 Thanks,JL

Hello,One of our customers have reported that their ifsdump.cmd does not work correctly as it does not pick the needed log files when creating the .zip. I have compared the .cmd file with a file in a core environment and both look identical. Any idea on what could be the reason behind this? 

Hi,I have installed the IFS Developer Studio 10.82.0, once we right click on any entity file generate code and deploy getting this error.java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to [Ljava.lang.String;Please provide solution to overcome this error. 

Hi We using IFS 10 upd 6, installed 2013 Visual studio, installed Toolkit also, while opening IFS form getting this dll error.  

Hi Community,When we use Output> Excel option is IFS, the dates after 2029 appear as 19## is excel.For example is date is 03-Jun-30 This is exported as 03-06-1930 in excel.If I change my Regional Setting in PC to DD/MM/YYYY, this issue does not occur.This is very strange - Why it only occurs for dates 2029?Is this something to be reported to IFS?ThanksGayan

Hi All, We have setup email notification for absence requests and receive below error message for some requests and it shows in application messages as failed.Error Text:Fatal error while sending data... Caused by: javax.mail.AuthenticationFailedException: 535 5.7.139 Authentication unsuccessful, user password has expired. Which user password has expired? IFS login user account is active. 

Hi,I am using Bulk Save and Republish Reports option in Business Reporter tool. When File Path is given (for the reports downloaded), I am getting below error. Location is entered to Trusted Location and folder structure was created manually as well. Still getting the above error.When I open individual report from Open menu in destination environment, it executes without an issue.Any idea about the error? Thank you.Best regards,Sureka

HelloWe have a problem with printing labels from the printer Citizen cl-s521. When the print is started via the print agent, the label is physically printed on the printer without any problem. The printer is mapped to the server and the process takes place over the network (the printer has an IP address). When we print via USB on the same printer, the printout appears in the print queue locally on the workstation, but the printer does not actually print it. Any ideas? 

I am wondering if there is any companies out there that offer training material for IFS specifically. I am not looking for one on one training. I am looking for actual material in IFS similar to the old eLearning. I found out that they took that out to boost profits for the academy which isn’t that useful.  Thanks!

Hello all,  Is it possible to add a custom button to the Shop Floor Workbench? I have IFS Developer and some developing experience in Java, .Net and the like. I am just curious if this can be done as I was not able to find anything in the technical documentation on whether or not this was possible.  As always, thanks for the help! Eli  

Hi Everyone, is it possible to add a LOV to standard free entry field ?I suppose the answer is no and that we need to use a custom field instead but just need to make sure that I am not missing something . Much appreciate.

Hello, Since March 10, 2022 our IFS 8 Prod environment has been crashing about every hour.We have not been able to identify any changes to our database, firewalls, servers, scheduled tasks, integrations, IFS front end configurations, hostingTo get it back up, we log onto middleware server > instance > bin > stop all services then start all services. It stays online for a bit, then crashes again.Best guess is that it seems to be connected to the # of users that login.  Relevant details:The Database does not go down during the crash During/after a crash before we start all servers again, the ‘check server status’ script shows severs are up even though no one can access It stays up over the weekend or during night shifts significantly fewer users doing less types of tasks during these times only confirming production, moving inventory, and quality control plans Integrations & major functionality Radley EDI, Radley data collection, TrueCommerce EDI CBS, demand planner  What

Hello All one of the IFS9 Customer want to change the Authentication ( LDAP) from AD Server 2012 to 2016 , ( using SSL, on Port 636) , the connection working fine with non SSL ( on port 389) . But even with correct security certificate imported to java key stores, when it using SSL port 636, it result an error when users trying to login, The managed server logs shows “####<Mar 28, 2022 3:33:00,871 PM CEST> <Warning> <Security> <IFS9APPTEST> <ManagedServer1> <[STANDBY] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <3e72f314-9066-464c-8bdf-1e050e44d802-00000002> <1648474380871> <[severity-value: 16] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-099117> <The LDAP authentication provider named "ADAuthenticator" failed to make a connection to LDAP server at ldaps://nlXXX-ldap001.XXXXXXXXX.local:636, the error cause is: Unsupported curveId: 29.>” Upon ch

Hello,I would like the documents attached to the product structure header : ...appear on the revision of the relevant material:So I wanted to create a transformation object connection: Only, I am missing a key for the "BOM_TYPE" field : Are there any solutions to recover the documents attached to the product structure?Thanks in advance!   

Hi Community, Is there a possibility to monitor/track who has exported which data via IFS Client?  Thanks in Advance!Best regards,Thakshila

not able to create a sales quotation for following opp because of this error message. We already deleted some notes but this doesn´t help. the error is: Server error messages:86c77f28-8f36-489a-b91c-eb8531d13707Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-06502: PL/SQL: numeric or value error: character string buffer too smallFailed executing statement (ORA-06502: PL/SQL: numeric or value error: character string buffer too smallORA-06512: at line 20) Any ideas/suggestions on the cause and how to resolve please

Hi All Does any one using IFS 10 oil and gas extension, using these two schedule tasks, - Reclaim Lob Space from deleted Data Synchronization Messages, - Reorganize Data Synchronization Messages tablesIf someone using at Production environments ( HUB and SATs), what is your experiences and recommendation about it, sometime a back, I head from Oil and Gas technical expert on the product not to use these two tasks as it can cause some troubles at Database. Any experience, recommendation would be highly appreciated.  PS: I’m asking this question related to, IFS 10 with Oracle 12R2 Kind RegardsAmila  

Our APP10 UPD12 customer  raised this below question. Please give your input: “One of our devision are officially using ProCore now who looks to have an integration with IFS via NovaCura Flow.  I am also being told that the team has heard that due to ProCore’s increase in customers using IFS with them, they are trying (or already have?) a direct integration with IFS w/o needing a NovaCura Flow license? Are you able to confirm one way or the other for the ProCore direct or indirect connection with IFS? “ Thanks

Hi Team,During delivery deployment of non-GET related code we have received the following error. We have noticed that this error occurring when delivery includes the files of ORDER moduleError message:               !!!Error deploying file SHPMNT.module at 11-AUG-21 11:55:02               !!!Error occurred while executing Plsql Block               BEGIN                  Dbms_Output.Put_Line('Start running Delivery_Note_API.Post_Installation_View at ' || TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'));                  Delivery_Note_API.Post_Installation_View;                  COMMIT;               END;               ORA-04063: package body "IFSAPP.DELIVERY_NOTE_API" has errors               ORA-06508: PL/SQL: could not find program unit being called: "IFSAPP.DELIVERY_NOTE_API"               ORA-06512: at line 3 Do you have any idea to overcome this error?Best Regards,Bhagya

How to create Project Root

Hello to all,In Aurena B2B, I have this standard IFS lobby:  When I create a user and assign the permission set "B2B_PROCUREMENT_LTU", I get this error message when I go to the lobby: However, the lobby is checked in the permission set configuration:Should I make an additional setting?Thanks in advance! 

Hi,It looks like lov and datepickers are not getting enabled for SQL quick report parameters in IFS Cloud. Is there anyone who has tried this successfully? Best Regards,/Methshika 

Hi All, A certain Test environment has over 1 million records in transaction_sys_local_tab.This table is being accessed through Transaction_SYS.Get_Posted_Job_Arguments to obtain jobs of a particular procedure_name_ where the state is posted.  Obtaining results from this query takes over 1 second. Where are in the Core environment, it takes only 0.1 seconds. The Test environments ‘System Parameters’ have been set as below. As there is a large amount of records in the mentioned table, are there recommended values that need to be put in the above parameters to improve the performance of retrieving data from the mentioned table?Or is there anything else that needs to be done to improve the performance?  Any help is much appreciated. Best regards,Devni