Error Submitting Plan Document Approval Request ORA-01403: No Data Found
(Doc ID 2046645.1)
Last updated on MAY 26, 2023
Applies to:
Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.9.2.0 and laterOracle 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
Changes
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 |
Changes |
Cause |
Solution |
References |