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

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.14 BEGIN App_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' proj_lu_name, pt.activity_seq keyref1, pt.company_id keyref2, pt.currency_code keyref3, to_char

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 azure Below 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 issue Please suggest Regards Pankaj

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 Function CREATE 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'') || ''-'' || to_char(t.due_date, ''MM'') vade FROM ifsapp.table_name t WHERE t.odendi_bilgisi = ''-'' AND t.is_ad

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', http_method_ => 'GET', query_parameters_ => NULL, key_ref_ => key_ref_);END;

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, I have implemented a REST call and in general it works or fails as expected. However, when it fails (e.g. POST request) it triggers the "failed callback function”: Plsql_Rest_Sender_API.Call_Rest_EndPoint2(rest_service_ => rest_service_, xml_ => json_, url_params_ => url_, callback_func_ => callback_func_, http_method_ => http_method_.action, --http_req_headers_ => , --query_parameters_ => , --header_params_ => , incld_resp_info_ => true, --fnd_user_ => Fnd_Session_API.Get_Fnd_User, --key_ref_ => key_ref_, sender_ => rest_sender_, --http_req_headers_ =>'Content-Type:application/json', --receiver_ => , --message_type_ => , subject_ => subject_, --in_order_ => , fail_notify_ => TRUE, failed_callback_fun_ => 'C_Webshop_Utility_Api.Rest_Fail_Callback' --accepted_res_codes_ => , --auth_params_ => null ); The receiving function: PROCEDURE Rest_Fail_Callback(error_text_ IN VARCHAR2, app_msg_id_ IN VARCHAR2)IS BEGIN Dbms_Output.Put_Line('App msg id is : ' || app_msg_id_ ); INSERT INTO f

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?

After activating the Aurena agent extension and attempting to send a file by email, the file is downloaded to the local PC, but nothing happens. Please reffer to the attached screenshots below. User Settings Send Document File By E-Mail Document Downloaded Locally Any idea what causes this issue? Thanks & Best Regards, Nimesh

Hello, I am trying to create a Custom Event using a Custom Field that has a Custom Enumeration in Apps10. Freight Supplier is the custom field with the custom enumeration. I want the custom event to trigger and be a hard stop if Charge Cost > 0 and Freight Supplier is blank and require the User to enter a value for Freight Supplier if a Charge Cost value is entered: So I have been able to get the Custom Event to work as an Information Message and trigger when the Freight Supplier is blank however, when I click OK it saves the record without a value in the Freight Supplier field. I can also enter the Charge Line with all the required information for Charge Cost and Freight Supplier, but it gives this message as well. I have created the Custom Attribute for custom field Freight Supplier with ROWKEY at it was the only reference I coulld find: I created the Event Action with following Conditions and used the Client_SYS.Add_Info in the SQL, as when trying to use error_sys.system_general opt

In IEE you start debugger and press Get the result here How do one do this in IFS Cloud/Aurena?

Hi Experts, What are the criteria IFS uses to decide if it opens on the same page and which opens on a new page? Thanks & RegardsShan