PRP032 Error - Gross to Net Processing

Issue/Symptom/Question

User encountered an error while in the Gross to Net Processing window (screenshot below).

PRP032 -1422 ORA-01422: exact fetch returns more than requested number of rows.
ORA-06512: at "PENTA.PK_LCLTAXAUTH", line 54
ORA-06512: at "PENTA.PK_LCLTAXAUTH", line 504
process_lcl_recip - open C_LCL_RECIP

Please let me know how to resolve.

Applies to

Penta for Windows

Payroll Processing:

  • Payroll
  • Payroll Check Processing
  • Gross to Net Processing

Local Taxing Authority Setup:

  • Payroll
  • Setup
  • Taxes
  • Local Taxing Authorities

Resolution/Fix/Answer

When this error is received, please contact your Penta representative to help identify which Local Taxing Authority is creating the error. Once the error is identified, a user with rights to update this information can change/delete the incorrect record.

Cause 

This error is received because there are more than one Operation # in the Calculation tab of the Local Taxing Authorities window.Â