Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
After RUP13, pay_payroll_actions link to pay_pre_payments has changed
Staff are running the first payroll after RUP13 and End of Year Phase 1 patches were loaded in our 12.2 instance. They did all the regular payroll steps and then went to run a custom report to pull payment totals that uses this query:
SELECT DISTINCT paa.assignment_action_id,
DECODE(ppp.ORG_PAYMENT_METHOD_ID,61,'Check',62,'Deposit',81,'Third Party Check') as C_1,
ppa.EFFECTIVE_DATE as E341281,
COUNT(ppp.PRE_PAYMENT_ID)
OVER(PARTITION BY ppa.EFFECTIVE_DATE,ppp.ORG_PAYMENT_METHOD_ID ) as C_2,
MAX(ppp.PRE_PAYMENT_ID) OVER(PARTITION BY ppa.EFFECTIVE_DATE ) as C_4,
MIN(ppp.PRE_PAYMENT_ID) OVER(PARTITION BY ppa.EFFECTIVE_DATE ) as C_3