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

Hi Last night we updated our SSL certificate as the old one was due to expire. Today, none of the IFS Scan It apps will connect on our Android devices.We have tried everything we can think of and nothing works.If we open Chrome on the Androids it will log in to browser version of IFS with no issues. As a separate but linked issue, since the SSL was updated, when users go to print, they get dozens of random 1 character printers, which actually all spell out an error message saying: Security Error: Requests from ifs-cloud…… are not trusted – certificate mismatching. Please install the Aurena Agent again for this server. The only fix we have found is to disable the chrome extension and re-enable it on each computer. Surely this can’t be the fix? Any help would be greatly appreciated. Thanks

We have noticed that the links in the header part of screens have stopped working, e.g. on a Customer Order we are unable to ‘zoom’ to the customer record without RMB and opening in a new tab.This affects 23.1 and 22.2.6 and later.Has anyone else noticed and has anyone found a fix?

Hello,we created a new custom page with a lot of custom fields.Everything is fine, but users want to duplicate custom page window, but with only few details.We don’t want to duplicate all details, because in few fields we have autoincerement ID, date of creation field, etc.We want to use custom menu function and write an PLSQL query to copy only few fields to new row in table, but after copying we want to transfer to window with new created row on this custom page window.Is it possible to do it with custom menu PLSQL query?Thank you in advance for any ideas.

Hello everyone,I'm trying to set up signatures on PDF documents in IFS Cloud.I carried out tests on a Cloud base (22R2) and APPS10 base (UPD12) :The configuration is almost identical (apart from the user assigned to the keystore and the doc class used) The certificate :APPS10Cloud Document revision (.PDF file) :APPS10CloudIf I pass the procedure for certifying the "Edm_File_Sign_Util_API.Certify_Pdf_File" documentThe APPS10 PDF is certified Cloud PDF is not certifiedAny ideas?Thank you in advance,Théo

Hello ,  I want to know what’s the right syntax to use the condition in custom event :my condition is : NEW:CUSTOMER like 25% OR 15%.Here what I’ve used , but it doesn’t work , I guess it’s a wrong syntax , Can anyone help me with that ? Thank you in advance ,Hanane

Dear Expert,We are facing issue while trying to Import the OVA file which we downloaded from Life cycle portal for version 22R2 , reported below error by our GCP cloud team when they were   trying to import on GCP Cloud , Any help would be appreciated. below error was reported by Google cloud support team. 1. We reproduced the issue again and confirmed the error " Could not connect to archive.ubuntu.com:80 (91.189.91.81), connection timed out"2. We checked the documentation [1] and realized that your customer has not run the precheck tool to verify that the source VM meets the requirements.3. You will request your customer to run the precheck tool and feedback us to move forward. RegardsSujeeth S    

Trying to set up Crystal Reports Web Service on IFS Cloud 23R1.Print manager is showing error  “No PDF report returned from Crystal Web Service”The report runs in crystal  reports against the instance database using IFSAPP but no other user- The report worked fine in Apps10  Crystal Debug is showing:10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Decrypted.10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Decrypted.10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-testpdb AppOwner-IFSAPP IALOwner-IFSINFO10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Decrypted.10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Decrypted.10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-testpdb AppOwner-IFSAPP IALOwner-IFSINFO10/5/2023

Hello all,I want to send some information with quick report to someone.Configured a simple application server task with quick report, so it is working without parameter, but i need to use spesific parameter. Because i will create an event for trigger mails on database level.This procedure works belong but not include quick report parameter block, can somebody tell me any other way to do this? Vers: 10.14BEGINApp_Message_Processing_API.Run_Application_Server_Task(2081319,'FALSE');END; 

Hello, I’m quite new using IFS Applications, and I wanted to put a custom field at Purchase Order with the Sales Order (which originated the PO). I was able to create a custom field retrievind the Tree_id from the view SUPPLY_ORDER_ANALYSIS and was trying to create anoter custom field usind the customized field above in order to retrives the sales order number, but it’s not working. The code to retrieve the Tree_ID:select Tree_id from SUPPLY_ORDER_ANALYSIS where Order_Ref1 = :ORDER_NO The field at my Purchase Order screen: The code to retrieve de Sales Order number (not working):select Order_Ref1 from SUPPLY_ORDER_ANALYSIS where Tree_id = :CF$_TREE_ID and Node = '0' When I try to synchronize the below error appear (Error: ORA-01403: No Data Found)  Anyone know how to workaround this? Thank you.

Dear Community,  We encounter an issue during the IFS Installation in our upgrade project:We are upgrading from IFS 8 to 10 following steps are followed for the upgrade.- Take backup of PROD (Oracle 11g)- Import this export to the new App10 DB (Oracle 19c)- Complete the DB upgrade and fix any SYS invalids.- Run IFS Upgrade on the upgraded DB.The issue is:The process gets hanged on the step 'Component DOP is ready'. A SELECT Statement as per the screenshot attached keeps on running for more than 15hrs and after this is complete, installer does not continue beyond this point.There are no error logs created as well. If you have any fresh ideas what we can investigate that would be really appreciate it.  Thank you very much for any ideas or thoughts! Kind regards,Balazs This is the stuck query: DECLARE    CURSOR get_prjrep_connections IS    SELECT        *    FROM        (            SELECT                pt.activity_seq                               activity_seq,                'PTR'    

  Is there any way we can maximize the field  without changing the display resolution ?Its not visible for some users those who use >100% Thanks in Advance

Is it possible to add a duration to the date in date fields? For example, for the "Wanted Delivery Date" in the customer order: "TODAY" + 1 month or "TODAY" + 20 days.Comparable logics are also helpful. Many thanks in advance and best regardsRolf

Hello,Can some one suggest setup of Proxy for IFS 9 IEE.the proxy parameter in configuration seems to be only for Webclient.getting following error when we are using it. the environment is hosted on azureBelow is a summary of the errors, details of these errors are listed later in the log.    * Activation of C:\Users\XXX\Desktop\Ifs.Fnd.Explorer.application resulted in exception. Following failure messages were detected:        + The Deployment Provider specified in the manifest cannot be reached. Maybe due to network error and/or the deployment provider is not responding correctly. If we select passthru in azure then it works without any issuePlease suggestRegardsPankaj 

Is it possible to prevent database authentication with Aurena, leaving only the SSO option available to users, at least for external-facing IFS Cloud sites?This is with IFS Cloud.It seems like it should be feasible but I’ve not yet found any clear documentation on how to go about the process if it is.Thanks,Nick

We have done quite a number of code customisations without problems but this time we have got an error during the order delivery even though everything worked fine during the environment and sanity builds. Start running Inventory_Part_API.Post_Installation_View at 2023-10-03 18:58:56!!!Error occurred while executing Plsql Block at 03-OCT-23 18:59:11BEGIN   Dbms_Output.Put_Line('Start running Inventory_Part_In_Stock_API.Post_Installation_View at ' || TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'));   Inventory_Part_In_Stock_API.Post_Installation_View;   COMMIT;END;ORA-04063: view "IFSAPP.SINGLE_MANUAL_RESERVATION" has errorsORA-04063: view "IFSAPP.SINGLE_MANUAL_RESERVATION" has errorsORA-06512: at "IFSAPP.INVENTORY_PART_IN_STOCK_API", line 25618ORA-06512: at line 3 I can’t see a reason for the error.  The view definitions look ok.  Why would an error happen during order delivery which didn’t happen during the previous builds? Any help much appreciated!

The following error occurs after logging in…User can login on any other pc..Tried with another user on the same pc,but no luck..  Thanks

Hi, I need to create a Quick Report for a department. For this requirement, I should use pivot. However, the pivot columns must be dynamic. The columns show years and months.To make the query dynamic, I wrote a function that returns a query text. However, when I query with Dual table. It has been returning query text, not the query result.  The FunctionCREATE OR REPLACE FUNCTION pivot_function RETURN VARCHAR2 AS dates VARCHAR2(32000); pivot_query VARCHAR2(32000);BEGIN SELECT listagg('''' || vade || ''' AS "' || vade || '"', ', ') within GROUP(ORDER BY vade) INTO dates FROM ( SELECT DISTINCT to_char(t.due_date, 'YYYY') || '-' || to_char(t.due_date, 'MM') vade FROM ifsapp.table_name t WHERE t.odendi_bilgisi = '-' AND t.is_advance_peyment_db = '+'); pivot_query := 'SELECT * FROM ( SELECT nvl(t.project_id, ''Projesiz'') "Proje No", t.currency_rate, to_char(t.due_date, ''YYYY'') || '

Does anyone have any ideas/suggestions/handy hints on how to identify those fields in Apps9 we have chosen to make mandatory?  See example in Customer Order below. We are moving to Cloud and could do with a mechanism for ID-ing these.Thanks!  

Hi all,we setup shrink lob segment schedule job and it was running well.but now it goes to warning stage.i can see below error in background jobs.what can i do to solve this error? Shrinking of lob segment FILE_DATA in table EDM_FILE_STORAGE_TAB failed, due to Oracle error ORA-06550: line 1, column 75:PLS-00201: identifier 'DBMS_REDEFINITION' must be declaredORA-06550: line 1, column 7:PL/SQL: Statement ignored ORA-06512: at "IFSAPP.DATABASE_SYS", line 3783 here is schedule job Thank you 

Hello everyone,When I try to run the "Calculate Resource Capacity" processing from the "Resource management > Analysis > Resource Analysis" screen, I get this error message:However, the task does exist as a bd task... it's even scheduled.However, when I connect with IFSAPP, no problem.The user does have rights to the task, could you give me an idea?Thanks a lot! 

Hi, I am practicing about web services. I would like to change the URL with a parameter. It is working while static value. However, I couldn’t do it with a URL parameter. I didn’t set anything about query parameters. But the application message throws “Error while processing query parameters in the request” error. How can I solve it? DECLARE query_params plsqlap_document_api.document; key_ref_ VARCHAR2(1000); username_ VARCHAR2(50);BEGIN key_ref_ := 'Github Test'; username_ := '/' || 'hasanyucel'; url_params := plsqlap_document_api.new_document('url_params'); plsqlap_document_api.add_attribute(url_params, 'parameter1', username_); plsql_rest_sender_api.call_rest_endpoint_empty_body2(rest_service_ => 'GITHUB_PROFIL', url_params_ => url_params, callback_func_ => 'github_rest_api.rest_callback_test',

I want to call an endpoint in another IFS Cloud environment using the custom action REST Call, but an authentication error occurs.Am I missing something? 

Hello,Currently we are facing an issue where out printing is down in IFS Cloud. The strange thing is that this only happens for some printers, which we have verified they are mapped correctly and even remapped them to be sure. The error we are getting is “object reference not set to an instance of an object”. We’ve never encountered this error before in the 8 months that we’ve been using IFS cloud. This issue causes items in the print manager to fail, and when restarted, it seems there is a 50% chance this will complete the print manager job and actually print out.Any and all advise would be greatly appreciated.Thanks,Bryan

Community, This is question is more technical related. IFS assisted to developed the interface with Windchill, Windchill will be the source of truth and sync with IFS at real time. The interface utilize JSON, we are on APP10.We have an issue recently, which ends up failure in IFS engineering part structure change. below is an sample error message. the user is trying to revise current parent part 6408715 in a new revision 3, and remove the component 1070084 in new revision 3.CPdmDataHandling: ORA-20110: CPdmDataHandling.REV: EngPartRevision 6390270 / 2 - ORA-20110: InventoryPart.NEGONHANDNOTALLOWED: Negative On Hand cannot be allowed when the part is Lot or Serial Tracked.Error on reprocessing on 22nd : CPdmDataHandling: ORA-20110: CPdmDataHandling.BOM: EngPartStructure 6408715 / 3, 1070084 / , pos: 10 sort:  - ORA-20110: CPdmDataHandling.NOBOMDEL: Cannot process delete of EngPartStructure for Part 6408715/3 Sub-Part 1070084/. Structure record not found for Sort and Dwg Position.",  be

I’m trying to automate a process involving creating resource groups using workflow. I’ve found the projection NewResourceGroup, but for some reason it doesn’t seem to work inside a workflow. It works fine though Postman.Workflow: The first step creates the resource group. Defined as: And an object seem to be created:  I’ve understood that to use bound actions I need to read the object before and result looks OK after read: I get no errors in the two following call actions:  However, no resource group is created:  I’m able to create a resourcegroup using the same parameters, but doing the same api calls directly from postman. I’m obviously missing something in the workflow, but what? Anyone that has experienced something similar?