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

anyone meeting below type of error? same Sql, no issue in IFS10 UPD12 but with error in IFS10 UPD19. no issue run the sql within pl/sql developer. Error details:Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-56900: bind variable is not supported inside pivot|unpivot operation ORA-56900: bind variable is not supported inside pivot|unpivot operationORA-06512: at line 12ORA-06512: at "IFSAPP.QUICK_REPORT_API", line 2075ORA-06512: at "SYS.DBMS_SQL", line 1134ORA-06512: at "IFSAPP.QUICK_REPORT_API", line 2031ORA-06512: at "IFSAPP.QUICK_REPORT_API", line 2080ORA-06512: at line 6   at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)   at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection dec

Hi,I am unable to create a new project using IFS developer studio installed in the IFS remote desktop.when creating new project in IFS developer studio (screenshot 1) This is the window that appears (screenshot 2) next database selection option is not available (screenshot 3).Please assist me on this issue.screenshot 1:screenshot 2:screenshot 3: Thanks & Regards,Sowmya. 

Earlier today we had a windows defender firewall issue on our test Oracle database server.  We got that resolved but prior to finding the cause we did mws-svr stops/restarts and now one of the instances is hung up with this error: 10/5/23 4:08:43 PM <ERROR  > SSLHandshakeException - Message : sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target (Alert.java:131)10/5/23 4:08:43 PM <ERROR  >  ..caused by: ValidatorException - Message : PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target (PKIXValidator.java:439)10/5/23 4:08:43 PM <ERROR  >  ..caused by: SunCertPathBuilderException - Message : unable to find valid certification path to requested target (SunCertPathBuilder.java:141) I get this when I run mws-svr.cmd as

Hello , I have created a custom field but I need it to be an integer>0 .Does anyone have an idea how to achieve it. Thank you in advance,Hanane

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) :APPS10

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 PrintPass

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'

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

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 th

  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

In window Server Alert Log there are many logs that weren't deleted by Server Log Cleanup task. Logs weren't deleted because they hadn't been marked as Checked. When user manually marks the log as Checked, the Cleanup task delete this log, but in the environment there are more than 12 millon of logs, so there is no possibility to mark manually all of them. So, is there any possibility to delete these logs and verify if there is any possibility to delete logs automatically without marking them manually as Checked? Server Alert Logs Categories 

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 orde

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 (

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!