Error Submitting Plan Document Approval Request ORA-01403: No Data Found (Doc ID 2046645.1)

Last updated on OCTOBER 07, 2015

Applies to:

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

Symptoms

Submit Plan Document Distribution Request and the request error.

ERROR
ORA-01403: no data found

STEPS
1.  Create a plan document request
     Navigator > Participant Assignments > Manage Plan Document Distribution Request
2.  Review the log file and it shows the no data found error.

LOG MESSAGE

Srp Plan Doc Distribution Process Start
l_srp_plan_appr_job_id = 300000001196426
l_org_id = 300000000976239
Publish Srp Plan Assignment - Start of publish_bulk_srp_cp_appr
CN_SRP_COMP_PLANS_PVT.update_srpcp_appr_batch_status.Updating Status of
300000001196426 to :ORA_PROCESSING
CN_SRP_COMP_PLANS_PVT.update_srpcp_appr_batch_status.Updating Status of
300000001196426 to :ORA_PROCESSING
Publish Srp Plan Assignment - Plan Approval not enabled.
PLAN_APPROVAL_ENABLE_FLAG = Y
Unexpected Error : Party name not found For GUID : MYUSER1
CN_SRP_COMP_PLANS_PVT.update_srpcp_appr_batch_status.Updating Status of
300000001196426 to :ORA_FAILED
CN_SRP_COMP_PLANS_PVT.update_srpcp_appr_batch_status.Updating Status of
300000001196426 to :ORA_FAILED
SQLCODE : 1
SQLCODE : 1
SQLERRM : User-Defined Exception
SQLERRM : User-Defined Exception
Exception in CN_SRP_COMP_PLANS_PVT.publish_bulk_srp_cp_appr
Exception in CN_SRP_COMP_PLANS_PVT.publish_bulk_srp_cp_appr

 

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