My Oracle Support Banner

Possible Causes And Solutions For Missing Rows In CN_SRP_INTEL_PERIODS_ALL Table (Doc ID 736307.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Incentive Compensation - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Purpose

Missing rows in the table cn_srp_intel_periods can cause the calculation to fails for some salespeople.
Recalculation for these salespersons is not possible, because the they can't be selected for the calculation process.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 The salesperson batch size is not  populated
 If you use Future Entry as an intermediate status
 If changes made to GL calendar
  <Note.242795.1>  Failed Calculation and Unable to Select a Salesperson for Submit Calculation
 Trigger deactivation
 Unpublished <Bug 1401596> CRM 11.5.2 NOT ABLE TO SUBMIT CALC FOR SUPPLIER CONTACT TYPE RESOURCE:
 Unpublished <Bug 1397510>  PLAN NOT ASSIGNED WHEN A NEW RESOURCE IS ASSIGNED TO THE EXISTING ROLE AND GROUP
References

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