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 laterInformation 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
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 |