SQL Bind is not working in Payroll Flow pattern after 25A upgrade

Summary:

We have Sql Bind for the parameter Start Check Number for Generate Check Payments Task in Payroll Flow pattern. This was working fine for last 4 years and suddenly breaking after 25 A upgrade.

We have found similar issue in other customers as well.

Please let me know if you have any idea about this.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

25A

Code Snippet (add any code snippets that support your topic, if applicable):

Code for references:

SELECT NVL(MAX(TO_NUMBER(pra.serial_number)) + 1, 1)FROM pay_payroll_actions ppa ,pay_payroll_rel_actions praWHERE ppa.legislative_data_group_id IN(SELECT legislative_data_group_idFROM per_legislative_data_groups_vlWHERE legislation_code = 'US')and PPA.ACTION_TYPE = 'H'AND pra.payroll_Action_id = ppa.payroll_Action_id