Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
This will include the questions related to Foundation1 and Technology, Infrastructure, Cloud, Integration, Developer Tools, Data and IOT, and Platform.
- 5,197 Topics
- 16,959 Replies
mwo time booking different time zones
Hello all,We are have issues when our engineers in in other time zones book time on Mwo, our service is set to UK time zone.Doing below test, it was 13.00 DK time (12.00 UK time)Work Order created (UK time is shown under “Journal”).Changed to Released, still under UK time zone.Transferred to Mobile Work Order, still under UK time zone.I changed my computer time to Singapore (20.02 when change was done)Default “Start” time on the mobile work order shows the time I set it to.When I go to the “Actual Finish” box and say, job completed 19.30 local SG time, it jumps to “21/3 02.30”And when I try and save, I get “Actual Finish date cannot be in the future” error, but for “me” in Singapore it was completed 40 mins ago.Thanks,Michael
Mutating trigger on VOUCHER_TAB
Hello, I have the following code that works with no issues in Apps8, however in Apps 10 gives a mutating trigger on VOUCHER_TAB. How can I overcome this please ? Declare account_ number;count_ number;BEGINselect count(*),LISTAGG(account, '; ')WITHIN GROUP (ORDER BY account) into count_, account_FROM ifsapp.voucher_row where company = '&NEW:COMPANY' and accounting_year = '&NEW:ACCOUNTING_YEAR' and voucher_type = '&NEW:VOUCHER_TYPE' and voucher_no = '&NEW:VOUCHER_NO' and (substr(account, 0, 4) = '9000' or account = '13009000')and '&NEW:APPROVED_BY_USERID' not in (select pia.user_id from IFSAPP.company_pers_assign cpaleft outer join ifsapp.PERSON_INFO_ALL pia on cpa.emp_no = pia.person_idwhere cpa.valid_to >= sysdateand cpa.pos_code in (select cpp.pos_code from COMPANY_POS_PROPERTY_ALL cpp where cpp.property_code = 'VOUCH_APP' and cpp.PROPERTY_VALUE = 'TRUE'))and '&NEW:APPROVED_BY_USERID' <> 'IFSAPP';if count_ > 0 then error_sy
Data Matrix 2D barcode doesn't display when viewing or previewing the layout
I created a report label using IFS Report Designer and added a custom field and convert the custom field to a 2D Data Matrix. When i preview the layout the 2D Data Matrix does not display instead it display the custom field values.I try adding the custom field to a blank page and try displaying the 2D Data Matrix thinking it’s and issue with space but still it does not display but when converting it to 2D QR Code it display. Could you please advice what am I missing? why it does not display? Kind Regards,Ruby
How to create a defered job to execute .modify__() ?
Hi, If I want to change a customer order line I use this function: Customer_Order_Line_API.Modify__() Some times I need to do it it in a background job. Then I would create a new procedure that executes Customer_Order_Line_API.Modify__() and then start that new procedure with Transaction_SYS.Deferred_Call() from an event. Is there any way to perform this directly without the custom procedure? Best regards Kresten
Cloud - Calling SOAP webservice from BPA workflow - possible?
Hi All, Can it be done? Internet search gives somewhat promising results, like:https://github.com/camunda/camunda-bpm-examples/tree/master/servicetask/soap-service But some of the requirements for that to work is having Camunda extensions:‘Connect’ and ‘Spin’. Are these ones available in this IFS-embedded version of Camunda? Or should it be done some other way?
Long running call: GetCountAttachments
Hi, does anyone face issues related to long running calls slowing down IFS?It was working fine for a while but since several weeks, we start noticing some long running calls related to the Method GetCountAttachments from the package ObjectConnectionServices.We are on APP10 upd 13 and did not move our UPD for more than a year.We are on full standard and only do change on the customization layer.We only use the following modules: Finance, Project, HR, Procurement, Sales, Document Management.I do not know where to search for this method and or to what it’s related.Any help will be welcome, Thanks.
Apps10 IE Custom URL in lobby element not going to external webpage
Hello,I am trying to create an external link that will take our users to an external website. The address is https:\\inet.example.com (example was used to hide the real value). The link works in a browser such as Google.This is the screen after the link is clicked on. I have tried https:\\www.ebay.com and am able to get to the Ebay page.Does this have anything to do with the URL address not being ‘https:\\www’?Thank you in advance!
Quick report and Unpublish option
When a quick report is published, it grants the Projection to all available permission sets.THere is no easy way to “Unpublish” the quick report.I cannot find any option to select a Projection, and then remove access for this projection for several permission sets at the same time. This would be a most helpful feature.My customer (currently 21R2) has hundreds of permission sets, to go in to every single permission set to remove the grant, would take a very long time.
22R2 Aurena Dark Theme and View SSRS Reports Page
I have a customer where some employees are using the Dark Theme in their 22R2 Aurena Use Places. The customer is also using SSRS for MS type Quick Reports. In the Quick Reports/View SSRS Report window, the Quick Report becomes virtually invisible due to using the standard black font for the report data. Is there a way for users using the Dark Theme to show the background of the View SSRS Report window in white rather than black so the black text shows up?
job_queue_processes, CDB vs PDB
Do you know about any limitations with regards to job_queue_processes in CDB.I read, when it is 0 (zero), then jobs execution will be stopped in CDB and PDBs. Non zero value in CDB will allow job execution in CDB and PDBs, unless a given PDB itself is not set to 0, so that PDB will not run any jobs.But, why do we have this arbitrary number 10 for job_queue_processes in CDB, when using IFS database creation template? Can I make it less and how much less?
IFS Cloud Remote Deployment HA Sizing
Hi all, our Customer is planning to have a 3 Node IFS Cloud Middle Tier Cluster and has asked for the Sizing of the three nodes. The available sizing for the Remote Deployment is based on a single Node Installation, and seems a bit high, when having 3 Nodes. The Customer has round about 300 concurrent Users. Do you have any Sizing, and also a recommendation how to scale the IFS Cloud Pods along the Cluster? Thank you in advance. Best RegardsMarion
All, We are on APPS10 UPD15. ‘’Received error message from Node Manager Server: [Server start command for WebLogic server 'MainServer1' failed due to: [Server failed to start up but Node Manager was not aware of the reason]. Please check Node Manager log and/or server 'MainServer1' log for detailed information.]. Please check Node Manager log for details. “ When examining the nodemanger.log there appear multiple errors for jobs that no longer exist. <Server output log file is 'D:\ifs\mws\ifsstage\wls_domain\IFSSTAGE\servers\MainServer1\logs\MainServer1.out'><The server 'MainServer1' with process id 8388 is no longer alive; waiting for the process to die.><Rotated server output log to "D:\ifs\mws\ifsstage\wls_domain\IFSSTAGE\servers\MainServer1\logs\MainServer1.out00069"><Server error log also redirected to server log><Server failed during startup. It may be retried according to the auto restart configuration.><Server failed so attempting to restart (r
My Time Registration window not available in TEST and PREPROD
Hi Community,We have a Aurena customer facing below issue when trying to view My Time Registration window but a message saying “Could not load metadata for TimeRegistrationEmployee” appears.Here is the problem summary: Re-creatable only in Test and re-creatable in pre-prod as informed by the customer. Managed to re-create for both My Time Registration and Time Registration.There are two user who is facing the issue and the other is viewing it without any issue.Current findings summary:* No issues appeared to be there with data related to Time Registration in “fnd_model_design_data_tab”* No issues appear to be existing in dba_context view * Page Configurations: Unpublished and re-published page configurations relating to time registration. Caches / Meta caches refreshed. Didn't resolve the issue.* Disabled base profile and person profile and cache refreshed. Still not resolved.* No issues with permission sets. Even after setting up identical permission sets for both of the users, the is
How can I resolve an error on Creating IFS Home
I have just carried out an Apps9 to Apps10 upgrade and inadvertently not specified the instance folder, setting the IFS Home folder to be F:\IFS\IFSMWS instead of F:\IFS\IFSMWS\IFSL. Is there an easy way to amend this. Unfortunately, it would cause a lot of upheaval if I went back and removed it then re-created IFS Home again as many steps/processes have been carried out since. I think this could be handled by create_backup.cmd but haven’t used this in years.Please advise.Thank you in advance.
Case Statement in Lobby Data Source Designer is not working
Hi all,This following case statement is executing successfully in quick reports but it will not work in data source designer. When I preview the data source, it loads for awhile like it wants to run but then it fails.Any ideas? (SELECT CASE WHEN INVENTORY_TRANSACTION_HIST.TRANSACTION_CODE='OESHIP' AND PART_CATALOG_CFV.PART_MAIN_GROUP='DOMESTIC FG' THEN INVENTORY_TRANSACTION_HIST.QUANTITY * PART_CATALOG_CFV.CF$_PROOF_GALLONS WHEN INVENTORY_TRANSACTION_HIST.TRANSACTION_CODE='OESHIP' AND PART_CATALOG_CFV.PART_MAIN_GROUP='EXPORT FG' THEN INVENTORY_TRANSACTION_HIST.QUANTITY * PART_CATALOG_CFV.CF$_PROOF_GALLONS WHEN INVENTORY_TRANSACTION_HIST.TRANSACTION_CODE='SHIPTRAN' AND PART_CATALOG_CFV.PART_MAIN_GROUP='DOMESTIC FG' THEN INVENTORY_TRANSACTION_HIST.QUANTITY * PART_CATALOG_CFV.CF$_PROOF_GALLONS WHEN INVENTORY_TRANSACTION_HIST.TRANSACTION_CODE='SHIPTRAN' AND PART_CATALOG_CFV.PART_MAIN_GROUP='EXPORT FG' THEN 0 END FROM INVENTORY_TRANSACTION_HIST, PART_CATALOG_CFV WHERE INVENTORY_TRANSACTION
Already have an account? Login
Login to the community
No account yet? Create an account
Login as an IFS Employee
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.