You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

ORA-06502: PL/SQL: numeric or value error

edited Oct 25, 2023 4:57PM in Compensation 5 comments

Summary:

Starting a Workforce Compensation Cycle and it's going to an 'Error' status.

Content (please ensure you mask any confidential information):

Start Workforce Compensation Cycle going to 'Error'. All of the sub processes are successful along with the Evaluate Dynamic Columns and Alerts.

The log indicates these two errors:

Refresh_summary_plan_all Errored with error message as :ORA-06502: PL/SQL: numeric or value error

Global_Process resulted in error, Error Message: ORA-06502: PL/SQL: numeric or value error

The Status Details say 'The request has completed and is in a terminal state.'

Any guidance is appreciated on what these errors mean. I have another plan set up and it started fine. The only difference between the two is the eligibility profile, compensation change statement and 4 dynamic calculations in user defined columns.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!