You Cannot Create Duplicate Paysheet For The Same Salesperson And Role
(Doc ID 756821.1)
Last updated on JULY 03, 2019
Applies to:Oracle Incentive Compensation - Version 12.0.3 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Problems are encountered when creating payruns for two different pay groups containing the same
resource for different periods.
For example, create a resource associated to pay group number 1 until 14-Dec-2008 and associated
to pay group number 2 since 15-Dec-2008. Create a payrun for pay group 1 and pay group 2 on period
December 2008. One of the two payruns creation failed with the following error:
Failed to create worksheet for <salesrep_id>
msg: You cannot create duplicate paysheet for the same salesperson and role.
msg: ORA-06502 : PL/SQL: numeric or value error: character string buffer too small in Package
CN_Payment_Worksheet_PVT Procedure Create_Worksheet
This can be reproduced with the following steps:
(R) Compensation Manager
Maintain Pay Groups
Associate a resource to paygroup number 1 until 14-DEC-2008
Associate a resource to paygroup number 2 from 15-DEC-2008
Maintain Payment Batches
Create a payrun for paygroup 1 on period December 2008
Create a payrun for paygroup 2 on period December 2008
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document