Core Workflow - EBS (MOSC)

MOSC Banner

Count query could not be executed - defaulting to max 10.000 rows

edited Feb 27, 2018 4:00AM in Core Workflow - EBS (MOSC) 4 commentsAnswered

Hi

Receiving the error below when running the Workflow Analyzer

using the feb 2018 file

16-FEB-18 14:43:37-Count query could not be executed - defaulting to max 10.000 rows.

Error at step 30 in run_sig_sql running: select P.Process_Item_Type, P.Activity_Name, S.Activity_Status, S.Activity_Result_Code,

Nvl(To_Char(Wi.End_Date,'YYYY'),'OPEN') Wf_Status, To_Char(S.Begin_Date, 'YYYY') Began, '||to_char(count(S.Item_Key),'999,999,999,999')||' "COUNT"

FROM wf_item_activity_statuses s,wf_process_activities p, wf_items wi

WHERE P.Instance_Id = S.Process_Activity

AND Wi.Item_Type = S.Item_Type

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