My Oracle Support Banner

When Adding A New Grade Getting Error Procedure per_pps_shd.constraint_error at Step 15. (Doc ID 2600802.1)

Last updated on SEPTEMBER 29, 2020

Applies to:

Oracle Human Resources - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

When adding a new grade Ladder receiving the following errors.

ERROR
-----------------------
System Error: Procedure per_pps_shd.constraint_error at Step 15 Cause: The procedure per_pps_shd.constraint_error has created an error at Step 15. Action: Contact your system administrator quoting the procedure per_pps_shd.constraint_error and Step 15.

This sequence already exists for this pay scale. Enter a new sequence


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Total Compensation Wizard
2. Grade/Step Progression
3. Create a ladder.
4. complete 7 steps and submit them.
5. first error is reported, System Error: Procedure per_pps_shd.constraint_error at Step 15 Cause: The procedure per_pps_shd.constraint_error has created an error at Step 15.
6. Cancel the process and try to submit the next ladder.
7. The second error is reported, This sequence already exists for this pay scale. Enter a new sequence

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the setup of the new grade ladders.

Changes

 

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
Changes
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.