My Oracle Support Banner

Error when opening Accumulation Period the Status does not go to Clean (Doc ID 437832.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Incentive Compensation - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When trying to open a new accumulation period, the status remains In progress and the following error is encountered in one of the child requests spawned.

POPULATE_NEW_PERIODS module: Open Periods Runner
.....
Cause: FDPSTP failed due to ORA-01086: savepoint 'POPULATE_SRP_TABLES_RUNNER'
never established
ORA-06512: at "APPS.CN_PERIODS_API", line 1132
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at l


This can be reproduced with the following steps:

(R) Incentive Compensation Super User
(N)Administration -> Incentive -> Accumulation Period
Change the status of a period from Never Opened to Open
Click Update
The Status remains In Progress and does not changed to Clean

Running the following SQL script

select line, text
from dba_source
where name = upper('cn_periods_api')
and line between 1131 and 1133;

 returns the following:

1131 WHEN srp_pop_failed THEN
1132 ROLLBACK TO populate_srp_tables_runner;
1133 retcode := 2;

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
Cause
Solution

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