Best Of
Re: How are you calculating the premium portion of comp time payouts for OBBBA?
Hi,
I think we are going to spend the last 15 minutes of each Payroll for NA SIG meeting to discuss OBBBA. Please join us next week:
Re: Best Practice for Handling W-4 Tax Changes During Payroll (Preventing Confirm 00020 Errors)
We have been successfully using the delivered Payroll Lockdown functionality since it was first released several year ago. As part of our payroll process, we lock down both the Direct Deposit and W-4 ESS pages on the day of Final Calc and Confirm. It works great for us.
Albina K
Re: Jobs Sched
Hi 2011
What database are you using? The SQL below will run on an Oracle 19c database and convert the Unix Epoch date values into something more user friendly. If your database is non-Oracle then one of the many AI agents out there (ChatGPT, Copilot, etc) should be able to help you convert it.
select jsschjbnm
, to_char(date '1970-01-01' + numtodsinterval(jsschsttime * 60, 'SECOND'), 'DD-MON-YYYY HH24:MI:SS') as jsschsttime
, jsschlncstat
, jsresubct
, to_char(date '1970-01-01' + numtodsinterval(jsschlnctime * 60, 'SECOND'), 'DD-MON-YYYY HH24:MI:SS') as jsschlnctime
, jslncenvh
, jslncdatp
, jsschuser
, jsschrole
, jsjobnbr
, jsprocver
, jsprocist
, jsdonotexpr
, jsuser
, jspid
, jsjobn
, to_char(to_date(to_char(jsupmj + 1900000), 'YYYYDDD'), 'DD/MM/YYYY') as jsupmj
, to_char(to_date(lpad(to_char(jsupmt), 6, '0'), 'HH24MISS'), 'HH24:MI:SS') as jsupmt
from sy920.f91320
where jsupmj > 125212
order by jsschsttime;
Hope it helps
Jonathan
MasonJo
Re: Oracle supplied Oracle Linux AWS AMIs gone
Any ETA on when this will be available again on AWS console
Re: Oracle supplied Oracle Linux AWS AMIs gone
Also importing in AWS images from YUM repository it's not the same in terms of serviceability of the instances: ex. OVA images need to be converted to VMDK to make the import work, the root volume is managed with LVM, cloud-init custom configs are missing, etc..
Oracle Solaris 11.4 Common Build Environment 11.4.90.0.0.212.0 Released
Oracle Solaris Common Build Environment 11.4.90.0.0.212.0 has been released:
The Common Build Environment (CBE) release for Oracle Solaris 11.4 SRU 90 is now available via “pkg update” from the release repository or by downloading the install images from the Oracle Solaris Downloads page.
As with previous 11.4 CBE releases, this is licensed for free/open source developers and non-production personal use, and is not the final, supported version of the 11.4.90 SRU, rather the pre-release version on which the SRU was built.
It contains all of the new features and interfaces, but not all of the final rounds of bug fixes, from the 11.4.90 SRU.
For more information see:
https://blogs.oracle.com/solaris/announcing-a-new-version-of-our-oracle-solaris-environment-for-developers
Re: Jobs Sched
Hello,
The value stored in SJSCHSTTIME is not Julian format.
This is Unix Epoch divided by 60. This means the number of minutes past from 1st of January 1970.
Thank you!
Best regards,
Cezar
Re: Jobs Sched
Hello,
Which scheduler are you referring to?
The AIS Scheduler or the Batch Scheduler?
Thank you!
Best regards,
Cezar
Re: JDE - end of support
Hi
You can review the below document in the support portal
JD Edwards EnterpriseOne Platform Statement of Direction KB694384
This document is typically updated twice a year. It includes new platforms supported as well as deprecated ones
This will help in getting overall idea on the platform support
Regards,
Prabhu
Re: Orch why automatically assigned rol?
Review view security setup for ORCH object type for *ALL UDO name (as seen in the attached screen print) in P00950UO|W00950UOG and then disable or delete those records for the roles which are not required.
