Period Open Error: SQLERRM : User-Defined Exception (SRP_POP_FAILED) in CN_SRP_OPEN_PERIODS_PVT.populate_srp_tables

(Doc ID 2089754.1)

Last updated on DECEMBER 16, 2015

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.10.0.0 and later
Oracle Fusion Incentive Compensation - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to open period, the job Open Incentive Period: Create Subledger Participant Records completed with error.


ERROR
Error message
SQLCODE : 1
SQLERRM : User-Defined Exception
Exception (SRP_POP_FAILED) in CN_SRP_OPEN_PERIODS_PVT.populate_srp_tables

STEPS
1. Navigator > Participant Assignments > Manage Periods
2. Change period status = Open for period NOV-2015
3. Click on [Apply or Submit]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms