Thanks @Isuru Wijeratna, that wasn’t the answer I was hoping for, but since there’s only going to be a handful of records per year, I guess that is workable.
Hi @Pilar Franco,Yes you are correct, the Blocked For Use would just tell the system to not pay to that item. I think our team want to use it as a sort of accidental edit protection too.I agree it sounds like only options are to either restrict edit access on this screen more than it currently is, and/or do a custom configuration.
Hi @janise no, “TEMPCAL#” is not used by us to our knowledge. It looks to me to be an internal/behind the scenes calendar in the application? These are the calendars we have.
Hi @jporter, no its still an ongoing problem unfortunately.
Confirmed with Global Support it was a bug introduced in Update 15. We’ve now been provided a patch to fix it, which has resolved the problem.
I’m also interested in finding this out.
Thank you @Chathuri Peiris and @ereslk,I can confirm that option is turned off, so take it that its the bug in Update 15 causing this. I’ll log a case with support.
So for Apps 10 does that mean we’ll get the patch soon, or do we have to wait until after 3 March to get it?
We turned off all internet accessibility to our environments so they are only accessible on the corporate network directly. That way it’s impossible for the module to be called outside our network.They are behind a reverse proxy and firewall etc. but obviously they are unlikely to help with this vuln.By turning off internet access it means that we’ve lost the use of MWO and Aurena in the field for our maintenance team unless they’re on corporate wi-fi, and contractors now will have to use the terminal server.This is all in addition to other network-wide mitigations too of course.
Yes, eagerly awaiting an update. I came across POC on Twitter which suggested WebLogic is vulnerable so we’ve locked things down until IFS provide an update.
Thanks for the info @Nethmini Kosvinna, if we can’t do it that way, I can see on the JT_TASK and JT_EXECUTION_INSTANCE DB rows that it tracks the object version and has an object id.Is there somwhere where previous versions of the row/object are stored which I could query, or does the old version get wiped out on change and the version is only for informational purposes?
Is there a way to do this via an event action or configuration rather than a customisation?
Sorry, correction to solution SQL (above will run in PL/SQL but below is corrected to allow it to work in an IAL), with added bonus inclusion of Full User licenses:-- Get FullSELECT 'Full User' AS NAME , TO_CHAR(TO_NUMBER(fndli.LICENSE_LIMIT) - TO_NUMBER(fndli.USERS_LEFT)) AS NO_OF_USER , TO_CHAR(fndli.LICENSE_LIMIT) AS TOTAL_LIC , TO_CHAR(fndli.USERS_LEFT) AS REMAININGFROM fnd_license_info fndliUNION--- Get LTUSELECT extractvalue(value(lic), '*/PERMISSION_SET', 'xmlns="urn:ifsworld-com:schemas:fndlicensemanagement_ifs_license_file"') "NAME", TO_CHAR(lru.USER_COUNT) as NO_OF_USER, TO_CHAR(extractvalue(value(lic), '*/NUMBER_OF_USERS', 'xmlns="urn:ifsworld-com:schemas:fndlicensemanagement_ifs_license_file"')) TOTAL_LIC, TO_CHAR((extractvalue(value(lic), '*/NUMBER_OF_USERS', 'xmlns="urn:ifsworld-com:schemas:fndlicensemanagement_ifs_license_file"') - lru.USER_COUNT)) AS REMAINING FROM FND_LICENSE, TABLE(xmlsequence(extract(XM
Thank @MiLeNLIt does look pretty messy but it works.It doesn’t work for our Warehouse Data Collection CTU licence as that usage seems to be tracked differently, (i.e. its not tracked in the fnd_licensed_role_user view like LTU and VIRTUAL_MAP/additional licenses are but I’m not too concerned about that one, as I am about the LTU’s which it got nicely.--- Get LTUSELECT extractvalue(value(lic), '*/PERMISSION_SET', 'xmlns="urn:ifsworld-com:schemas:fndlicensemanagement_ifs_license_file"') "NAME", extractvalue(value(lic), '*/NUMBER_OF_USERS', 'xmlns="urn:ifsworld-com:schemas:fndlicensemanagement_ifs_license_file"') NO_OF_USER, lru.USER_COUNT as TOTAL_LIC, (extractvalue(value(lic), '*/NUMBER_OF_USERS', 'xmlns="urn:ifsworld-com:schemas:fndlicensemanagement_ifs_license_file"') - lru.USER_COUNT) AS REMAINING FROM ifsapp.FND_LICENSE, TABLE(xmls
Hi @dsj, no that’s not what i’m after. I can get the Full User license count with no issues:I want to know how many spare LTU and other non-Full User licenses are spare.There’s several ways to get the Full User license information (multiple views and API functions available) but none of them seem to work for LTU’s that I can tell so far.I can get LTU current consumption from the DB, but can’t find either a LICENSE_LIMIT for LTU’s like is available for FU lic’s, or a USERS_LEFT for LTUs which again is available for FU lics, despite the data displaying in on the License Management screen, so it must be stored somewhere.I’m hoping somone knows where that somwhere is.Either one of these fields for LTU’s would be suitable for me.
If there is a view that I can use to either directly pull or extrapolate the available number of licenses that’d be terrific.
Hi @Srikanth yes I found that, but I want to know how many licenses are spare.This is tracked and available for Full, but I haven’t been able to find this or even the total number of licenses in the environment.Even if I could get the total, I could subtract the usage you’ve shown above to give me the number of free licenses.
Thanks @ThushAsanka that ended up being the problem (mostly).There was a line in there with Authorizer ID linked to new/current Person ID, but User ID was linked to the old User to delete.Once I corrected the line to the correct new User, I was able to delete the old User.
No, we never figured out why it happens, and it still happens. We’re about to upgrade the server resource today and hopefully see whether that makes a difference, but I don’t have high hopes.
Can confirm this worked beautifully!
Thanks for the reply Sahan.So to confirm, by default you can only restrict WO access at the Site level, not the Maintenance Org level?
Thanks for the reply. I will do some testing over the coming weeks and attempt to set this up.Cheers
Yes +1 for @MickD’s note about the mailbox delegations. I forgot about that in my post above.
I would suggest from experience a couple GB more RAM on the DB server than the IFS standard recommendations, and then make sure you have a couple GB spare for the OS after assigning RAM to Oracle e.g. if your DB server has 20 GB RAM, allocate 16GB to Oracle, and 4GB to the OS etc.
Our experience is this is not the case.On our Win 10 PC’s, we have Region, Region Format set to English (Australia) and all date formats elsewhere are displaying in correct DD/MM/YYYY format.Also checked the browser (Edge - Chrome-based) to ensure it was set to display in Australian locale which it is, but Aurena still shows in American date format.Also is happening on ALL our staff’s phones which are a combo of iPhones and Android (primarily Samsung) and same thing - all showing American date format instead of Australian.Its causing a fair bit of frustration.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
