My Oracle Support Banner

Error - when holding transactions ORA-01460 (Doc ID 1336032.1)

Last updated on AUGUST 06, 2020

Applies to:

Oracle Incentive Compensation - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to hold more than 50 transactions on the Payment Worksheet the following error occurs

ORA-01460: unimplemented or unreasonable conversion requested in Package CN_Pmt_Trans_PVT Procedure Insert_Reason

Errors have occurred in the update. Please click the Back button on your browser and reenter the values

.
The issue can be reproduced at will with the following steps:

(R) Incentive Compensation Super User
(N) Transaction > Payment
Create a Payrun
(N) Requests > Submit
Create a Payment Worksheet
(N) Transaction > Payment
Query back the Payrun
Select 50 or more transactions
Click on Hold Transaction
Error encountered

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.