1) backup table kcrt_fg_pfm_project prj 2) Run this SQL:
UPDATE kcrt_fg_pfm_project prj SET (prj.prj_financial_summary_id, prj.prj_financial_summary_name) = (SELECT fs.financial_summary_id, fs.NAME FROM pm_projects p, fm_financial_summary fs, pfm_lifecycle_parent_entity pe WHERE p.pfm_request_id = prj.request_id AND pe.lifecycle_id = fs.parent_id AND pe.project_req_id = prj.request_id AND fs.parent_entity_id = 526 AND fs.entity_type = 'FS') WHERE ( prj.prj_financial_summary_id IS NULL OR prj.prj_financial_summary_name IS NULL );
Re: Project has invalid input or the input has more than one match.
if this does not help you, i had this issue cause of an oracle patch and parameter. i dont have notes the exact oracle patch id, but you can google or your dba can check it. the parameter is _projection_pushdown” = FALSE and the oracle patch is related to this issue.