Projects - EBS (MOSC)

MOSC Banner

Error in Workflow PAWFPPWP/94790 ORA-01722: invalid numberORA-06510: PL/SQL:

edited Feb 20, 2013 10:16PM in Projects - EBS (MOSC) 1 commentAnswered
When we publish some project worjplans, i'm getting workflow error

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 !!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center