Best Of
Re: PSPPFUND constraint error
It's been a few weeks but as I recall after we applied all the patches, including the 38678079 Penny mentioned above, we saw the select statement had been changed to include a "NOT EXISTS" so it will not attempt to insert a duplicate value into the staging table:
SELECT DISTINCT C.TAX_CLASS FROM PS_PY_PFF_PGID_CHD C WHERE C.EFFDT = (SELECT MAX(C1.EFFDT) FROM PS_PY_PFF_PGID_CHD C1 WHERE C1.EFFDT <= :1 AND C1.PY_PFF_PROGID = C.PY_PFF_PROGID) AND C.EFFSEQ = (SELECT MAX(C2.EFFSEQ) FROM PS_PY_PFF_PGID_CHD C2 WHERE C2.PY_PFF_PROGID = C.PY_PFF_PROGID AND C2.EFFDT = C.EFFDT) AND C.PY_PFF_TAX_CAT = 'R' AND NOT EXISTS (SELECT 'X' FROM PS_PY_PFFTXCLS_STG S WHERE S.TAX_CLASS = C.TAX_CLASS AND S.PY_PFF_TAX_CAT = C.PY_PFF_TAX_CAT AND S.PROCESSINSTANCE = :2 AND S.COMPANY = :3 AND S.PAYGROUP = :4)
Re: When is the Affordable Care Act for 2025 patch going to be released?
Happy New Year! The patch is targeted for release sometime this week.
Re: How Oracle is going to adjust the W2 to be in line with the One Big Beautiful Bill.
Thanks Justine! Happy New Year! :-)
Gennifer
Re: What happened to My Oracle Support?
Shame, Shame, Shame on Oracle!!!
This new MOS for the Oracle Database is a complete disaster !!!
Oracle must bring back the classic MOS interface immediately !!!
Oracle must listen to customers !!!
This should have been rollout in phases, and the classic MOS still available for a long time till all glitches were sorted out in the new MOS. !!!
I am really upset !!! : (
I cannot find anything in MOS anymore !!!
Re: My Oracle Support, are you really happy with what you've delivered ?
Shame, Shame, Shame on Oracle!!!
This new MOS for the Oracle Database is a complete disaster !!!
Oracle must bring back the classic MOS interface immediately !!!
Oracle must listen to customers !!!
This should have been rollout in phases, and the classic MOS still available for a long time till all glitches were sorted out in the new MOS. !!!
I am really upset !!! : (
I cannot find anything in MOS anymore !!!
Re: My Oracle Support, are you really happy with what you've delivered ?
!!! message to Oracle support !!!
Please stop with this
No one seems happy with your new versions of Oracle support. there is nothing improved, I don't understand how you can be pleased with that
Please, rollback to the previous one
