My Oracle Support Banner

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.

Symptoms

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:

You cannot create duplicate paysheet for the same salesperson and role.
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
(N) Setup
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

(N) Tasks
Maintain Payment Batches

Create a payrun for paygroup 1 on period December 2008
Create a payrun for paygroup 2 on period December 2008



Cause

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
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.