Deploy Compensation Plans Warning Currency code not found Unexpected Exception in CN_SRP_COMP_PLANS_PVT.create_srp_comp_plan_role 100-ORA-01403: no data found

(Doc ID 2400756.1)

Last updated on MAY 22, 2018

Applies to:

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

Symptoms

Deploy Compensation Plans Job ended in Warning status.

REQUEST TXT OUTPUT

***********************************
Deploy Incentive Plans - Summary
************************************
Request ID: 372397
******************************************************************************
Total Events Picked = 11
Deployer Completed Events = 0
Deployer Incomplete Events = 11
Pending Notify Log for Calc Events = 11
******************************************************************************
----------------------------------------------------------------------------------------------------------------------------
No.| Event Log ID|Event Type |Event Name | Object Id|Deploy Status |Event Log Status
----------------------------------------------------------------------------------------------------------------------------
1| 244003|PLAN_ADMIN |CN_ROLE_PLANS_CRE | 300002264516486|INCOMPLETE |INCOMPLETE
2| 283001|PLAN_ADMIN |CN_ROLE_PLANS_CRE | 300002287439121|INCOMPLETE |INCOMPLETE
3| 284017|PLAN_ADMIN |CN_ROLE_PLANS_CRE | 300002287439186|INCOMPLETE |INCOMPLETE
4| 274001|PLAN_ADMIN |CN_ROLE_PLANS_CRE | 300002287438738|INCOMPLETE |INCOMPLETE
5| 274003|PLAN_ADMIN |CN_ROLE_PLANS_CRE | 300002287438745|INCOMPLETE |INCOMPLETE
6| 267045|PLAN_ADMIN |CN_ROLE_PLANS_CRE | 300002287438746|INCOMPLETE |INCOMPLETE
7| 267222|PLAN_ADMIN |CN_ROLE_PLANS_CRE | 300002287439185|INCOMPLETE |INCOMPLETE
8| 333356|PLAN_ADMIN |CN_ROLE_PLANS_CRE | 300002300400295|INCOMPLETE |INCOMPLETE
9| 331280|PLAN_ADMIN |CN_ROLE_PLANS_CRE | 300002293067037|INCOMPLETE |INCOMPLETE
10| 329827|PLAN_ADMIN |CN_ROLE_PLANS_CRE | 300002293067032|INCOMPLETE |INCOMPLETE
11| 331308|PLAN_ADMIN |CN_ROLE_PLANS_CRE | 300002293067057|INCOMPLETE |INCOMPLETE
----------------------------------------------------------------------------------------------------------------------------

 

REQUEST LOG OUTPUT
Currency code not found
SQLCODE : 100
SQLERRM : ORA-01403: no data found
Exception in CN_SRP_COMP_PLANS_PKG.insert_record
Unexpected Exception in CN_SRP_COMP_PLANS_PVT.create_srp_comp_plan_role 100-ORA-01403: no data found
Call to create_srp_comp_plan_role : FAILED for participant_role_id : 300000721026900
Creating Srp Compplan records for Role-Plan assignment changes => FAILED for Role Plan ID : 300002264516486 and Role ID: 300000714393348
Deploy Incentive Plans has not completed successfully as there are a few Comp Plan changes with Incomplete Status in the Event Log. No Call will be made to Populate Payment Tables or to Populate Notify Log Table for Calc events.


STEPS
Navigator > Participant Assignments > Deploy Compensation Plan

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