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

Hi,I create quick report (SQL statement) based on Purchares Order view. Each row have a order_no. When “view report” click , then i have results and  I need RMB (menu item) to navigate to ifs window "Purchase Order" with this order_no from the row.How can I do this ?

Hello everyone,Does anyone know how to write the URL to properly apply the filter “Cost Invoice” for invoices in the posting proposals window? When I press my lobby element I want to list only invoices with this specific status message. This is the filter I want applied to the lobby element. Current setup:The lobby data source is very basic and only lists invoices in with the above status and their invoice no. The lobby data element url counts the different invoices and lists them as a counter - also very basic.  Currently the Web Access URL looks like this:‘page/PostingProposals/List?searchcontext=MessageId:$MESSAGE_ID$’but it dosen’t filter out the cost invoices, it shows everything in the posting proposals window - its like the filter parameter is not properly triggered. Initially we tried with the “filter” parameter instead of the “searchcontext” one but we had no luck with that one either and now we’ve run out of ideas.Can any of you smart guys help with this? 

Hi, We have special characters in a file (attached in .zip).Dev. Studio cannot deploy it, saying:  First error location is highlighted.On the other hand PL/SQL Developer has no problem with it when deploying.Also standard deployment/delivery procedure gives us no error for this.The file is already in UTF-8, according to for instance, Notepad++.Dev Studio version is in the picture.What should we do to be able to deploy it from Dev., Studio? 

When scheduling an IFS Operational report like the MC Customer Ledger Detailed Age Analysis which has a date parameter that’s typically set to today’s date (Date of Analysis), is it possible to increment the date with each run in Aurena 22R Cloud environments?  In IEE, the use of #TODAY#  in the parameter is allowed.  This allows the parameter to increment with each scheduled run.  In Aurena 22R Cloud, when choosing “Today” on the calendar, the current date is populated and continues to be the date that the scheduled report uses when it runs.  Is there a workaround for this when scheduling Out-of-the-Box IFS Operational reports?

Hi Community,We have a situation where Saved Search are missing in Search dialog, but they are showing in the navigator and under My administration.The related view is a _Cust view.Could this be a permission issue ?We are in Apps9.ThanksGayan

Is there any option to create users automatically by login with SSO user in IFS cloud ?

Hi,We are currently building a high-availability (HA) configuration environment using the Remote-deployment method in the customer project. Could you please provide the following information regarding certificates:1. Which components require certificate application, the load balancer, and/or servers?- Is application to the load balancer unnecessary?2. Regarding the number of certificates needed:- Do we need one certificate per load balancer and per server (3 servers total)? (So, four in total?)Or would it be using a common certificate for both the load balancer and servers?(Since the systemURL in ifscloud-values.yaml points to the LB's FQDN, would one suffice?)3. If there are any configuration diagrams for using a load balancer available in the IFS documentation, we would appreciate it if you could share them.Thank you and best regards!

dear all, We want to create an event if the quantities of materials in the purchase order exceed the quantities specified in the order during the delivery processThe code snippet for the event is provided below, but we're not receiving any emails from the event. Does anyone have any comments on this?  BEGIN  DECLARE    v_emails VARCHAR2(200);    v_subject VARCHAR2(100);    v_message VARCHAR2(4000);    v_buy_qty_due NUMBER;    v_total_qty_arrived NUMBER;  BEGIN    SELECT pola.BUY_QTY_DUE,           SUM(ria.SOURCE_QTY_TO_RECEIVE)     INTO v_buy_qty_due, v_total_qty_arrived    FROM PURCHASE_ORDER_LINE_ALL pola    LEFT JOIN RECEIPT_INFO_ALT ria ON ria.SOURCE_REF1 = pola.ORDER_NO                                     AND pola.LINE_NO = ria.SOURCE_REF2                                     AND pola.RELEASE_NO = ria.SOURCE_REF3                                     AND pola.PART_NO = ria.PART_NO                                     AND pola.CONTRACT = ria.CONTRACT;     IF v_total_qty_arrived > v_

Hello.On an sql treatment, I had to update a custom procedure to return a value, for that, I added a new parameter with the “out” key, so the new signature is :PROCEDURE SFD_EV_SC_053(p_order_no_ varchar2,p_line_no_ varchar2,p_rel_no_ varchar2,p_line_item_no_ varchar2,p_shipment_id out float) On an old event, this same procedure is called but in a deferred way, so the code is : Client_SYS.Clear_Attr(attr_);  Client_SYS.Add_To_Attr('P_ORDER_NO_', '&NEW:ORDER_NO' , attr_);  Client_SYS.Add_To_Attr('P_LINE_NO_', '&NEW:LINE_NO' , attr_);  Client_SYS.Add_To_Attr('P_REL_NO_', '&NEW:REL_NO' , attr_);  Client_SYS.Add_To_Attr('P_LINE_ITEM_NO_', '&NEW:LINE_ITEM_NO' , attr_);  Client_SYS.Add_To_Attr('P_SHIPMENT_ID', v_shipment_id , attr_);  transaction_sys.deferred_call('MYPACKAGE_API.SFD_EV_SC_053','PARAMETER',attr_ ,'#SQL Treatment'); But it seems that PL/SQL doesn’t support the call of such a procedure in a deferred way, or maybe the call must be different. The error code that I

I have troubles finding even base material on how to prepare the security needed to have a 3rd party application using a REST API. First step I want to use is Postman. With that authorization settings are needed. Which should I use? A user with user type: Service User? Where to use OAuth in IFS?All ideas welcome.

Hi all, My questions are related to workflows that are executed asynchronous. In my scenario I have a workflow of type process enrichment that is executed on creating new work orders. When triggered, the workflow will update several fields. The trigger for this workflow is a custom event on ACTIVE_WORK_ORDER_TAB. There are no conditions placed  on the custom event action. The timing is set to 'Asynchronous’ and this causing some strange behavior. For me and a colleague the event and workflow are triggered and the update is performed. For another user the event and workflow are not triggered. All users are having the same permissions and we are all performing the exact same test scenario. We also performed the test in several browsers. I'm having the following questions:How could it be that for some users the trigger does work and for others not? When a workflow is executed asynchronous, can we see that somewhere in IFS? Because the workflow watch doesn't show any information (only when

Hello.I would need your help as I don’t know what IFS screen I have to reach.We have a custom report that we defined on :ifswin:Ifs.Application.ManageReportDefinitions.ReportDefinitionDetail?action=get&key1=UNIFORM_PAYMENT_ADVICE_REPThis report is generated to send an email to suppliers with the report sent at attachment file, but I can’t find how the send is done. We have an error in which we send an email with a total amount of 0, and we need to prevent that.Thanks

Hello,As a fresh SQL user, I'm having trouble implementing a certain functionality in IFSAPP 10. I'm trying to add a PL/SQL block to the user menu (On customer order lines) that will add a record in a table I've created. Currently, I'm using a simple code that works by adding a record with the appropriate key, but I'm struggling to allow the user to input additional data such as comments or planned date. I've also written a version of the code that requires entering all the data manually. Unfortunately, I can't seem to integrate them. In the reports I've created, I use '&' to allow for manual input of values. While running report user gets pop-up window with required fields. However, this method doesn't seem to work here.DECLARE    now_            DATE            := TRUNC(SYSDATE);--    planned_        DATE            := TRUNC(&Data_wykonania);    user_id_        VARCHAR2(30)    := NULL;    note_           VARCHAR2(32000) := '&Additional_Data'; -- Prompt user for additional

In Apps9 we have an IFS Report Designer report that shows within the ‘Reporting’ submenu for Financials, but does not show in Order Report.  We can work around but the user wants it to show in Order Reports.The report is granted to the correct permission set (hence shown in the Reporting menu), and is a standard IFS report.Any ideas why it does not show up in Order Report?

Dear community,I need the name of the views (tables) in the following tabs: Can somebody provide these?Thank you.

Hi Community,is it possible to create a totals field in an LU under custom fields. RegardsAndré

What is the correct syntax for mapping a context to a User Group that has both a special character and spaces? Our firm has many User Groups with both spaces and special characters. For example, User Group = OPS - Maintenance Staff. The instructions on the Context Mapping page say, Values are case sensitive. Values with spaces or special characters must be enclosed with quotation marks. Note: user identifier should be in uppercase.I tried both- USERGROUP = “OPS = Maintenance Staff”  USERGROUP = ‘OPS = Maintenance Staff’Neither syntax work. It does work when I remove the spaces and the special character. 

OverviewEnvironment cloning is the service of replacing data in one of the customer’s environments from the data of another environment of the customer. The service may be referred to as environment/database refresh, environment/database copy, environment/database clone as well. Following are the parameters involved in cloning an existing environment.Data – This refers to the data stored in the database, which includes but is not limited to business data, metadata, and system parameters. In all scenarios, the target environment will get the source environment's data except for environment-specific basic data, integrations, connect configurations, system parameters, etc which is retained in the target environment. This is achieved by exporting those data from the target environment before the clone and importing them back into the environment after the clone. See Why are some items not copied after IFS Cloud Cloning activity? | IFS Community for additional details.Source Environment – T

I have created a new page in IFS EE 10 (screen cap below) and I want to navigate to it via an RMB from another screen. However I want it to open a open a new record on the page automatically when it opens. So that the text field “No. Of Labels” just needs a value to be entered (the plus sign has already been clicked) .“Create Window” action type from the RMB won’t work. Is what I want to do possible?Thank you.  

We had a link set up to another application from the Mobile Integration page in Apps for Page Designer section but when we go to this page, it throws an error message.  Nothing displays in the Mobile Integrations list. An internal server error occurred. Contact administrator.        Url: https://ifscloud.omnibyte.com/main/ifsapplications/projection/v1/ServiceEngApp.svc/HomeIntegrationsSet?$orderby=DisplayOrder&$select=Name,Description,Site,Id,TaskSeq,ExecutionInstanceSeq,DisplayOrder,Screen,FeatureType,MchCode,MchContract,MchName,MchLoc,MchPos,EquipmentMainPosition,GroupId,MchType,SupMchCode,ObjLevel,SerialNo,Type,PartNo,Criticality,ItemClassId,LocationId,ObjectInfo,RoomPosition,CustomerIdentity,ObjTypeDesc,AddressId,AddressInfoId,Address1,Address2,Address3,Address4,Address5,Address6,CustomerNo,LocationName,City,Country,County,State,ZipCode,CountryCode,ZipCity,Contact,EMail,PhoneNo,WoNo,OrganizationSite,OrganizationId,PriorityId,WorkType,TaskDescription,LongDescription,ReportedBy,A

Hi,I wanted to create a simple JSON clob like -{ "attribute1": "value1", "attribute2": "value2", "attribute3": "value3"}I am using PLSQLAP_Document_API to create this type of data. But the problem is, during initialization of the PLSQLAP Document, I have to give a name. And that name becomes a parent attribute for rest of my attributes and the output is like -{ "MAIN_DOC": { "attribute1": "value1", "attribute2": "value2", "attribute3": "value3" }}I can’t get rid of this “MAIN_DOC” attribute. Is there something I am doing wrong?Below is my snippet -DECLARE json_doc_ PLSQLAP_Document_API.Document := PLSQLAP_Document_API.New_Document('MAIN_DOC'); json_ CLOB;BEGIN PLSQLAP_Document_API.Add_Attribute(json_doc_, 'attribute1', "value1"); PLSQLAP_Document_API.Add_Attribute(json_doc_, 'attribute2', "value2"); PLSQLAP_Document_API.Add_Attribute(json_doc_, 'attribute3', "value3"); PLSQLAP_Document_API.To_Json(json_ => json_,

I use plsql_rest_sender_API.Call_Rest_EP_Empty_Body_Sync2 to make a synchronous GET request. Based on the response I am required to take further action.When making sync request IFS always throws an error in the application message and hangs.ifs.fnd.base.SystemException: Unable to get database connection. (javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/jdbc/However an async call is successful. What could be the root cause for this error?

Hello, Currently, we are attempting to rework our Customer PO tracking on customer orders, shipments, and invoices. Right now, we have a read only custom field tied to the invoice that fetches the customer order’s customer PO number field so it can be displayed on the invoice, regardless of if this was an invoice created from a customer order directly, or if it was created from a shipment, that was created from a customer order. The issue is that, if you create an invoice, and then change the customer PO number on the customer order, and you go to reprint modify the invoice (or create a credit or correction invoice from that invoice) the output will pull the custom field value at time of report generation. This PO is incorrect and we aren’t sure on how to go into that report archive and pull this custom field, since it does not live on the CUSTOMER_ORDER_IVC_REP view. It does live somewhere in IFS, as reprint original from archive works, but I’m not sure if that is accessible since it

Hello,I’m trying to add translations to fields and screen label values through the ‘Text Translations’ screen. After updating the text, I’ve Approved the translation and refreshed the language cache by Language option. But I do not see any changes to the field label value in Work Order screen. I’ve validated the same in Build Place and CFG environments.Example: Directive field is renamed as DescriptionIs there any other step I’m missing? Please advice.Kind RegardsPriyanka Cecilia

Hi,I want to get the translation of a commodity group via the REST-API in IFS Apps 10. Ultimately I want to get some product data to provide for another system. Unfortunately the commodity group shows only the code (e.g. 22) and not the actual description which I need.I found the projection “CommodityGroupsHandling.svc” which gives me the commodity group description in default language which is fine but unfortunately it’s english in our environment. Now I want to get the German translation of the basic data which is available in the application.Can anybody help me with that? Thank you and regards,Sören