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 22.214.171.124 and later
Information in this document applies to any platform.
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.
Cause: FDPSTP failed due to ORA-01086: savepoint 'POPULATE_SRP_TABLES_RUNNER'
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
The Status remains In Progress and does not changed to Clean
Running the following SQL script
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;
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