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

We’re in IFS APP10 and a quick report (SQL) of which the source is an IAL (i.eSELECT … FROM IFSINFO.C_SOME_IALWHERE ...) fails to export to excel. When clicked on the function, it shows the quick report execution dialog to enter parameters and then shows the error when pressed ok  This quick reportThis does not happen to another standard quick report for example with permission to “IFS_ALL” but even if “IFS_ALL” is granted to this report, it still gives the same error.Our other quick reports done without using IALs do not give this error, therefore I believe the IAL is not readable to the Export to Excel function.Questions:Is this a permission issue ( with the quick report or IAL or Both?) If so, which exact permissions need to be granted to make the stream readable?Thanks in advance!

Is it possible to have a BPA user task to enter values (i.e Cancel Reason ) from a drop down (i.e OrderCancelReason). Appreciate you inputs Thanks and Best Regards/Kithsiri

Hi,Is there a way to use  "copy data link" function with Excel or Power BI desktop to manage a dynamic list from IFS? (Product Version: 22.2.5)

Hi,Trying to create a WO using the projection SimpleWorkReportingAssistantHandling in 22R2. As the first step, the necessary information is inserted into an virtual and it is successful. Final step is to invoke POST https://carrix-stg.ifs.cloud/main/ifsapplications/projection/v1/SimpleWorkReportingAssistantHandling.svc/SimpleWorkReportingSet(Objkey='{Objkey}')/IfsApp.SimpleWorkReportingAssistantHandling.SimpleWorkReportingVirtual_Finish.Here, the objkey is needed from the previous step as a Path Parameter and it does not accept a request payload. I was able to extract the objkey using the below method.But unable to connect the objkey as a Path Parameter to the URL.Any ideas?Thank You!

Hi All,  Is anyone currently doing a brand new install of 23r1 remote?  Looking to see if anyone is also having issues along with missing files from the build place?  Currently we are missing the ifscloud-values.yaml file (have a ticket with support currently)

I am trying to create a Custom Field on the Purchase Order that pulls the Lead Engineer from a WO into the PO as the Order Contact. I am trying to get this to work and having problems doing so, it is not showing an error but I am not seeing the Lead Engineer. Just the first assigned Engr. What would my SQL be for this, I have tried:Select RESOURCE_ID from JT_EXECUTION_INSTANCE_UIV WHERE WO = :WO AND TASK_LEADER_DB IS NOT NULLand I have also tried:Select RESOURCE_ID from JT_EXECUTION_INSTANCE_UIV WHERE WO = :WO AND TASK_LEADER_DB = TRUECan anyone help with the SQL? Thanks,   

Entity association is created between Sales Part and Sales Price List Part. Then the Custom tab is added in the Sales Part and the binding is added. But when populating the page, this gives an error saying missing right parenthesis. IFS Web Version: 22.2.5.20230201103053.0Date: 2023-06-14T14:55:27.248Z--------------------------------------------------------------------------------------------------------Database error occurred. Contact administrator.Error details: [{"code":907,"message":"ORA-00907: missing right parenthesis"}]Request Id: 9640c277-ac93-45c6-9a57-641026111b4fUrl: main/ifsapplications/projection/v1/SalesPartHandling.svc/SalesPartSet(CatalogNo='S10362-11-025P',Contract='TEST')/SalesPriceListEntity?$select=CatalogNo,BasePriceSite,PriceListNo,CPurchasePrice,Objgrants,luname,keyref&$skip=0&$top=25  When investigating the SELECT statement generated from the Entity Association, it was noted that a single quotation was missing, when the valid_from_date value is converted

Hi,Is it possible to override same part of the assistant in Customization layer in IFS Cloud?For example init command. Best regardsMarcin Ciurla 

Hi,this morning I have executed an import of an Application Configuration Package (ACP).Does this import result in a Dictionary Refresh Server Cache?My name (DXXXX) is listed on the screen, however I did not executed the refresh manually. MfG,Dietmar

Hi expertsI need help for the syntax of an API call to “Invoke action DoCreateVoucher”The Api Doc gives this definition: https://ifstest.mycompany.com/main/ifsapplications/projection/v1/ExternalVoucherLoadInformationHandling.svc/ExtLoadInfoSet(Company='{Company}',LoadId='{LoadId}')/IfsApp.ExternalVoucherLoadInformationHandling.ExtLoadInfo_DoCreateVoucherI retreived the metadata of this API :<Action Name="ExtLoadInfo_DoCreateVoucher" IsBound="true"><Parameter Name="ExtLoadInfo" Type="IfsApp.ExternalVoucherLoadInformationHandling.ExtLoadInfo" Nullable="false"/></Action> I know the basics of calling an action in Odata but, in this particular case I can’t find how to pass parameters and what must be passed (or not) in the json paylod. The definition says: REQUEST BODY SCHEMA: application/jsonrequest body for action DoCreateVoucherActionobject (DoCreateVoucherAction) If anybody can help or has a similar problem thank you for responding. Janick    

Good day, everyone. Is it possible to obtain the address in IFS by passing the latitude and longitude to an external API?

HiDoes anyone know if there is a way of disabling or blocking the ‘previous’ action in a multi-step assistant in IFS Developer?Thanks! 

Hi In crystal reports its nessasary to have access IFSPRINT user to database views.In APPS10 we do grant permission to IFSPRINT from database grant scripts or we give neccesary permission to IFSPRINT from permission sets.However in IFS cloud as we do not have access to database direclty and also we canot grant database view permission direclty, we have issues running crystal reportsHow do we give access to IFSPRINT user database views?This is actually required to run crystal reports in IFS cloud. Any recommandations to achive this?Regards,

Hi everyone.  Whats the best way to get a list of any invalid objects (including custom items) in IFS?

Can use ASFU license for replication DB & DR site?What are the Database options come with ASFU licenses entitled, such as Tuning pack, diagnostic pack, active data guard, data guard etc. Thanks a lot!

We are integrating some inhouse apps with the API, and I am having a hard time locating the documentation for the following API call.  I got this from dev tools while creating a customer address https://inst.ifs.cloud/main/ifsapplications/projection/v1/CustomerHandling.svc/CustomerInfoSet(CustomerId='######')/CustomerInfoAddresses(CustomerId='######',AddressId='TEST')/AddressTypes(CustomerId='#####',AddressId='TEST',AddressTypeCode=IfsApp.CustomerHandling.AddressTypeCode'Pay') If anyone can point me in a direction to find some info on this API call, it would be very appriciated.

Version : IFSAPP10, Aurena update 16.Customer is  using a group with fieldsets  and when they try to Minimize the individual collapse button for fieldsets, it’s not working to minimize that section. Many thanks for your inputs on this issue.Best regards,Uvini

Some of the custom filed is not showing on test environment after clone data from production database  to test database. 

Hi Everyone,Apologies if I have missed a similar post to my question.We currently operating on IFS Apps 10 update 15.I want to configure a REST API call which is called through a custom menu - I was looking at creating a routing address which will have our API Endpoint. Our API call requires the use of a client ID and Client Secret but we do not have a Token endpoint created as of yet  - just an ID and secret. To call the API I’m using (ifsapp.command_sys.Send_Rest_Message) - which works OK - the only issue is that I do not want to share the ID and Secret in the PLSQL block. Is there a way of hiding the secret which can be called from a PLSQL block - or if there is alternative way which would be better for us to utilize?Many Thanks,Dan 

Hi I had created a custom field CF$_PROJECTNO in ActiveSeparate logical unit, however it wasn’t required anymore so I removed it via the UI, but it is still there in the DB, please see views below - what is the best way to remove this field?this is the UI view - no PROJECTNO field at all Your help very much appreciated as skill set here to alter the database has moved on to pastures new.

Hello,I’ve created a custom entity (STTaskType) and deployed successfully. Trying to reference an Attribute (Task_Type) from this entity to another custom entity (STDispositionCode).Apart from the Referenced attribute (Task_Type_Ref), I’m able to Publish the other attributes in STDispositionCode.While publishing this attribute, I get the below error. What could be the possible issues? Please suggest.Kind RegardsPriyanka Cecilia

Hello Dear Community Members,“A pooled JMS connection is being closed because an error was detected on the connection: weblogic.jms.extensions.ConsumerClosedException: Consumer destination was closed”Has anyone encountered this error before?Who can explain this? Do you have a solution suggestion? ifs 9.4RegardsBarış

Hi All,Assume we have a custom REST API (POST) called by a third party.Is there a way to generate https 4xx error codes  for validations OR is it always 5xx for Business Validations.If IFS Business Logic raises an error using Error_Sys.Record_General, then it will be a 500 error (ORA-20110: ).Third party system who calls IFS Custom API prefers to have 4xx errors for business validations rather then 5xx errors. 

Is there a way to set the system to have the default search settings for all screens  toRun Search to "When Criteria is changed" rather than “Only when Search button pressed” Startup Behaviour to “Use Search” > “Run Latest Serch”

My goal is to have “Execute Online SQL” event action to make a rest request to our API and then use the result of this call to show the warning or error if needed.  I figured that i can show warn/err by using Error_SYS.Appl_general or Client_SYS.Add_WarningI also know there is Plsql_Rest_Sender_API available.  I would appreciate if somebody could post some sample code if they have done something like this. Thank you in advance.  PS: We are using Aurena hosted in IFS cloud, so our access to the database is limited.