Error in Workflow PAWFPPWP/94790 ORA-01722: invalid numberORA-06510: PL/SQL:
PAWFPPWP : Seeded workflow, no customizaion; the issue is coming from package : .PA_WORKPLAN_WORKFLOW.SELECT_ERROR_RECEIVER
Project -> Workplan Information
When we publish the project changes Plan, workflow PA Workplan workflow giving the error as "ORA-01722: invalid number"
RDBMS : 11.1.0.7.0
Oracle Applications : 11.5.10.2
The error "ORA-01722: invalid number" is coming from database package : PA_WORKPLAN_WORKFLOW.SELECT_ERROR_RECEIVER (called from "PA: Workplan Errors" workflow process)
SQL query to get the list of project members Using --> pa_project_role_types.project_role_type=2008
Since the result dataset has text & number data project_role_type, above condition giving 'Invalid Number' error. (Note : project_role_type is varchar2 ) Then, I modified the code as ---> pa_project_role_types.project_role_type=’2008’ and retriggered workflow for the same project, that fixed the issue !!