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 and later
Oracle Fusion Incentive Compensation - Version and later
Information in this document applies to any platform.


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

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

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


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