Refresh Payment Batch Error ORA-06502: PL/SQL: numeric or value error: character to number conversion error while executing BEGIN cn_tp_paysheets_pvt.refresh_worksheet_parent (Doc ID 2070695.1)

Last updated on OCTOBER 26, 2015

Applies to:

Oracle Fusion Incentive Compensation - Version 11.1.9.2.0 and later
Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Refresh Payment Batch, the following error occurs.

ERROR
Request 109837 encountered ERROR: ORA-06502: PL/SQL: numeric or value error: character to number conversion error while executing BEGIN cn_tp_paysheets_pvt.refresh_worksheet_parent(:errbuf, :retcode, :at(1), :at(2)); END; at ORA-06512: at line 1 ORA-06512: at "FUSION.FND_EXECUTE", line 214

STEPS
1. Create payment batch for August
2. Recalculate commission for August
3. Run Refresh Payment Batch for August and it errors.
    Navigator > Payments > Manage Payment Batches > Action : Refresh

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms