Fusion Global Payroll: QuickPay error - A system error ORA-01455: converting column overflows integer datatype occurred in table pay_action_parameters at location 3073. (Doc ID 3011888.1)

Last updated on APRIL 08, 2024

Applies to:

Symptoms

Global Payroll

When attempting to run quickpay,
the following error occurs.

ERROR
-----------------------
SQL_NO 3073
TABLE_NAME pay_action_parameters
AFDICT_APP_PREFIX-PAY-1635870: A system error ORA-01455: converting column overflows integer datatype
 occurred in table pay_action_parameters at location 3073. Contact your help desk.
In { pyxipmt
message text = A system error ORA-01455: converting column overflows integer dat
atype
 occurred in table pay_action_parameters at location 3073. Contact your help des
k.
message level = F,F
payroll_id text = 300000xxxxx
source_id text = 6xxxxxx
line_text = 153, A system error ORA-01455: converting column overflows integer d
atatype
 occurred in table pay_action_parameters at location 3073. Contact your help des
k.
Message Encoded as = 138, PAY


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run quick pay.
2. Error returned.

Cause

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