You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

in Payroll and Global Payroll Interface (GPI) 3 comments

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!