PAYUSCHK Ran but no bank info was on the paychecks
Our last on-cycle payroll experienced an issue I've never encountered before. (We did apply Tax Update 24D and many other patches before this cycle.)
When the PAYUSCHK ran (pay003), the paychecks file was produced but no bank info was pulled on the checks. In pay003 I see the sql where it utilizes the PS_SRC_BANK_STG (along with a couple other tables) to get the info. I understand this staging table is loaded and then records deleted for the process instance, during the PAYUSCHK unmask/mask app engine process.
My only theory (and no way to prove this) is that maybe this staging table did not get the inserts during that run (and so remained empty?), or somehow did not have the current process instance (perhaps past data never got deleted?) (Nothing about the job errored).