Field Service - EBS (MOSC)

MOSC Banner

Having trouble creating Mobile Field Queries.

edited Mar 3, 2015 10:04AM in Field Service - EBS (MOSC) 3 commentsAnswered

I am trying to create a Mobile Field Query and keep getting this error. Query is below also. The query works directly from Sequel. Any ideas what this error means?

Error ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'INSERT_QUERY' ORA-06550: line 1, column 7: PL/SQL: Statement ignored  

Select  

    a2.object_id ord_header_id, a2.doc_number, a2.subject_id , a1.incident_number

From  

   CS_INCIDENTS_ALL a1 ,CS_SR_LINKS_EXT_V a2

Where  

    a2.subject_id = a1.incident_id and a2.external_object_code = 'ONT_ORDER_NUMBER' and a2.doc_number = :1

Thanks,

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