Solved

A quick report SQL query runs but does not display the results. The query works fine in SQL Developer. Do not know what issue is. 

I have a user who get a “blank” page when opening Inventory Details and Inventory Management. This worked yesterday. We have cleared the cache and personal settings, and also reinstalled the app to no avail. I assume there may some temp files that needs to be removed manually?  

Al-Salam Alikum I defined BU code string in our company 101.in cash box , this part code is enabled for direct cash payment.but un-enabled for customer and supplier payment .how I can enable this code string for customer and supplier payment ? 

Dear all,I have uploaded a mixed payment through the External Check Upload Functionality. However, I am getting a very strange error and as a result, I can not approve the mixed payment. Can any one of you help me out to resolve this issue? 

Hi,In the Report Designer, we have the option to turn any value field into a barcode. But we need a barcode with information from two fields. Example, the barcode must have both Part No and Part Description. Is it possible to achieve?

 When we create a new Structure Revision, IFS automaticaly asigns a phase-out date (“yesterday”) to the previous revision, while stamping a phase-in date (“today”) to the new revision. This seems practical but has some drawbacks:The new revision is born as “Tentative”, as we plan to make changes on it. That is why we are making a revision ;-)If the new revision is not finished in the same working day and set to “Buildable”, if it remains as work-in-progress for a while (“Tentative”), and MRP is run meanwhile,  the Part we are revising is found to have “Not Buildable” revision. And MRP considers there are no components for that part in the structure and triggers a lot of order cancellations as the materials are no longer required.  In my view, a more logical approach would be to set the Phase-out of the previous revision and Phase-in of the current revision when changing the status of the structure revision from Tentative to Buildable. That is, dates are stamped when there is a new revi

Hi Experts,Please refer the below requirements.Customer is using inbound map to modify/insert records with some additional logics.  Their requirement is to send the json request without any mapping name.Example json message format{    "parameters": {        "mapping_name": "EXT_SYS_TO_FSM",        "xml_import": {            "inbound": {                "part": {                    "part_id": "DP19",                    "description": "Updated by OData API new change"                }            }        }    }} Is there a way to define the json request without “mapping_name”?(I know that we can create the json request without mapping_name. But in this scenario, xml map is not getting triggered and only the baseline logic will execute and the tables are created). For this requirement, json request should execute with the use of xml map even though the xml map is not defined in the json message it self. “Perform_inbound_integration”  is generic for all the types of inbound integrations. Th

for performing mass updates in FSM we need to set up columns according to the screenshot of the error message below:Unfortunately we cant find where to do this in studio. if anyone can assist I would be very grateful

when attempting to cancel the matching of a customer mixed payment then we have this error; Wrong Requirements for account 1900.  Please check code part demands Mixed payment cannot be cancelled as there is a supplier payment included that has been cancelled. How can we rectify this and remove the allocation of this payment from customer account/invoices?  

Dear All,When I enter a mixed payment, I need to change the default currency of the bank account. In my case, I can't change the currency. Ex : I have set AUD for my bank account and I receive the payment in USD. But system doesn't allow to change currency from AUD to USD. Even in mix payment line, it is not allowed to change the currency. Any help for this? 

I get following error message when posting the final invoice which is created from the customer order.ORA-20105: Invoice.ACCERROR1: Error (Voucher date for payment cannot be earlier than voucher date (28-MAY-22) on which payment on account CUPIA 45 was posted.) occurred while booking Invoice CD ****The customer order has one advance invoice  and settled through the mixed payment. But at the preliminary stage the final invoice has back dated the invoice date. Is that a problem? I tested all possible scenarios and at the final invoice level only forward day can be entered. Please suggest me solution. 

Hi everyone, i have this issue i was creating a new custom LU Entity, and in aurena i was create a  page configuration and projection conf.   i also create a relationship with project Entity. Then i try to create a List using this entity in the Project Definition Page but doesnt work, i dont know if i missing something . But i need can use this custom entity for create a list in project definition page, maybe i missing something. Thanks for the Help.Regards. 

Hello, We have the below problem in FSM Mobile: In mobile, some fields are “dropdown” type and we want to display predefined values. For example, the below field “CUSER_DEF221” needs to have some values in its dropdown, but in mobile the dropdown is empty. Screenshots below that show the steps that we have already done. The field of the custom table​​​​​​The ‘Lookups’ of this fieldThe global code table The field properties -1-The field properties -2-​​​​​​The actual field with the empty dropdownThanks a lot !! 😊

we are upgrading from 360 to PSO6 and cant find how to add or delete private activities in the Scheduling Workspace as we can in 360. Are we correct in thinking that this is now something that has to be performed in the Planning Workspace in Planning/Resource/Unavailabilities, or are we still able to add the unavailbilities directly into the Scheduling Workspace?thank you for your help

How All.How could I set up a parameter in Aurena Lobby to understand “Like” where condition with % so I will be able to type a part of the text.In the example bellow, if I use like condition with %, the element in Aurena doesn’t not work, just in IEE. IF I remove the %, it works fine.Is it possible?Tks a lot!this way works without %. In Aurena Lobby does not with %UPPER(ITEM_DESCRIPTION) LIKE NVL(UPPER('%$CPF_NOME$%'),'%')  

Hi , I have an IAL view which use a custom filed view(CFV) in FROM clause. when the topic environment is created IAL deployment failed with error “ ORA-00942: table or view does not exist”. I suspect this is due to configurations are not imported (CFV not there) when the IAL view is deployed as per logs. Anyway to solve the issue?Thu May 26 08:21:30 BST 2022] - INFO: Start executing /opt/ifs/build-home/database/ial.tem[Thu May 26 08:21:34 BST 2022] - INFO: Finished executing /opt/ifs/build-home/database/ial.tem[Thu May 26 08:21:34 BST 2022] - INFO: Connection closed[Thu May 26 08:21:34 BST 2022] - WARNING: DB: 7 errors were detected during deployment of DB objects[Thu May 26 08:21:34 BST 2022] - INFO: Running data import, logs location: /var/log/ifs/cbs/deploy_db[Thu May 26 08:21:34 BST 2022] - INFO: Trying to connect to the database to import data as user ifsapp[Thu May 26 08:21:34 BST 2022] - INFO: Connection successfull[Thu May 26 08:21:34 BST 2022] - INFO: Importing Application Con

Hello!In the ‘Jump to screen’ icon in FSM mobile, we would like to display only the screens that belong to this specific workflow, based on the ‘Workflow Condition’ script of every screen. Is there any way to configure it? (In the screenshot below, all the screens are displayed, OOTB and Customs) Thanks!!   

Hello All, Our customer wishes to use digital signature functionality so they have created a new custom event action for event DOCUMENT_APPROVED. Method:Edm_File_Sign_Util_API.Certify_Pdf_File (‘&DOC_CLASS', '&DOC_NO', '&DOC_SHEET' , '&DOC_REV' , 'Signature from IFS'); They have generated new user certificates in keystores window and when the user try to approve the document, below error “Invalid file name” comes.As you can see there are no special characters in the file name. When I check the application message I can see the same error message there.The message request xml is in correct form and has valid structure. <DOCDIGITALSIGNATURE_CERTIFYPDFFILE_REQUEST><DOC_CLASS>XYZ.01</DOC_CLASS><DOC_NO>COVA-111</DOC_NO><DOC_SHEET>1</DOC_SHEET><DOC_REV>02</DOC_REV><DOC_TYPE>VIEW</DOC_TYPE><FILE_NO>1</FILE_NO><REASON>Signature from IFS</REASON></DOCDIGITALSIGNATURE_CERTIFYPDFFILE_REQUE

Hi Is it a bug that  navigation searching  of aurena does not support fuzzy search with Chinese language1， “采购订单接收” page can be found ， if we  search the “采购“ key words 2，but if we  search the “订单” ，  “采购订单接收” page would not be found. 

Hi All,i am planning to use perform method using metrix xml in map function.  how can we capture response in xml maps.  as per document “Metrix 5 XML Messages” ,  ex: below is the xml message in map function . <create_task result_name="CreateTask01">       <request>          <request_id>{requestId}</request_id>       </request>   </create_task> Response ; <create_task_result result_name="CreateTask01">       <task>          <task_id>6198</task_id>          <accepted>N</accepted>          <plan_start_dttm>05/01/2012 03:19:00 PM</plan_start_dttm>          <plan_travel_to_min>0</plan_travel_to_min>          <plan_travel_return_min>0</plan_travel_return_min>          <plan_travel_start_dttm>05/01/2012 03:19:00 PM</plan_travel_start_dttm>          <fixed_commitment>N</fixed_commitment>          <status>OP</status>          <task_status>OPEN&lt

Hi, Is it possible to control (hide/show) the task’s status change icon on top right corner for different screens for the mobile app?  Thank you,João Oliveira  

Hi everybody,Is it possible in IFS Apps9 to manage the grants like quick reports?Is there something like this screen? Thank you and kind regards.

Is there a place in IFS IEE to see both active and historical work orders in one place? It seems you can only see historical records in one view and active records in another.

Hi All,We are an Alliance v12.5 site.We’re setting up a Customer Support workflow, but have a requirement for different SLA times, depending on what the Problem Code is.As far as I’m aware, the SLA times are pulled through to the Customer Support job, from the active contract that’s assigned to the customer, in which case the same SLA times would be populated regardless of what the problem code is.Is there a way that anyone knows of, where we could populate different SLA times dependent on what the problem code of the job is??cheersMark

I’m trying to move the elements (.rpi, _rpt table and _rep view… is there more?) for a custom operational report (this is an SSRS based report that I did not create) from one test instance of IFS to another.  Is there a way to do this from within the application?