cancel
Showing results for 
Search instead for 
Did you mean: 

Serialize a SFC

Former Member
0 Kudos

Hello experts,

I am facing an issue that when I try to serialize a SFC(material lot size is 200 and SFC quantity is 200 too).However, each time after I hit the OK button on PR500(the numbers shown were exactly the ones that are supposed to be), it keeps on running and lots of insert scripts in the logs.  I attached the setup of the next number maintenance and the screenshot of the log view.

Can you please help me identify if there is anything wrong with the setups?

Thanks so much in advance.

Johnny

Accepted Solutions (0)

Answers (1)

Answers (1)

sergiy_katerinich
Active Contributor
0 Kudos

Hi!

Here it looks as if the system is generating routing steps for each of the new SFCs. It is hard to say more specific, provided just a part of queries on a screen shot.

Regards,

Sergiy

Former Member
0 Kudos

Hi Sergiy,

This is part of the log:

16 INSERT ALL  INTO SFC_STEP ( USE_AS_REWORK, OPERATION_BO, QTY_COMPLETE_PENDING, QTY_COMPLETED, QTY_IN_QUEUE, QTY_IN_WORK, SFC_ROUTER_BO, STEP_ID, BYPASSED, STEP_SEQUENCE, DATE_QUEUED, PREVIOUSLY_STARTED, QTY_REJECTED, PARTITION_DATE, MAX_LOOP, REPORTING_CENTER_BO, STATE, DONE, HANDLE, TIMES_PROCESSED ) values ( 'false' ,'OperationBO:ME 110,ICSX033,#' ,'0' ,'0' ,'0' ,'0' ,'SFCRouterBO:SFCRoutingBO:SFCBO:ME 110,B260LV31TRHF1625007,RouterBO:ME 110,B260LV31TRHF,U,A,1' ,'590' ,'false' ,'59' ,NULL ,'false' ,'0' ,TO_DATE( '2016-07-07 02:02:26', 'yyyy-mm-dd hh24:mi:ss') ,'0' ,NULL ,'N' ,'false' ,'SFCStepBO:SFCRouterBO:SFCRoutingBO:SFCBO:ME 110,B260LV31TRHF1625007,RouterBO:ME 110,B260LV31TRHF,U,A,1,590' ,'0'  )  INTO SFC_STEP ( USE_AS_REWORK, OPERATION_BO, QTY_COMPLETE_PENDING, QTY_COMPLETED, QTY_IN_QUEUE, QTY_IN_WORK, SFC_ROUTER_BO, STEP_ID, BYPASSED, STEP_SEQUENCE, DATE_QUEUED, PREVIOUSLY_STARTED, QTY_REJECTED, PARTITION_DATE, MAX_LOOP, REPORTING_CENTER_BO, STATE, DONE, HANDLE, TIMES_PROCESSED ) values ( 'false' ,'OperationBO:ME 110,ICSX034,#' ,'0' ,'0' ,'0' ,'0' ,'SFCRouterBO:SFCRoutingBO:SFCBO:ME 110,B260LV31TRHF1625007,RouterBO:ME 110,B260LV31TRHF,U,A,1' ,'600' ,'false' ,'60' ,NULL ,'false' ,'0' ,TO_DATE( '2016-07-07 02:02:26', 'yyyy-mm-dd hh24:mi:ss') ,'0' ,NULL ,'N' ,'false' ,'SFCStepBO:SFCRouterBO:SFCRoutingBO:SFCBO:ME 110,B260LV31TRHF1625007,RouterBO:ME 110,B260LV31TRHF,U,A,1,600' ,'0'  )  INTO SFC_STEP ( USE_AS_REWORK, OPERATION_BO, QTY_COMPLETE_PENDING, QTY_COMPLETED, QTY_IN_QUEUE, QTY_IN_WORK, SFC_ROUTER_BO, STEP_ID, BYPASSED, STEP_SEQUENCE, DATE_QUEUED, PREVIOUSLY_STARTED, QTY_REJECTED, PARTITION_DATE, MAX_LOOP, REPORTING_CENTER_BO, STATE, DONE, HANDLE, TIMES_PROCESSED ) values ( 'false' ,'OperationBO:ME 110,ICSX035,#' ,'0' ,'0' ,'0' ,'0' ,'SFCRouterBO:SFCRoutingBO:SFCBO:ME 110,B260LV31TRHF1625007,RouterBO:ME 110,B260LV31TRHF,U,A,1' ,'610' ,'false' ,'61' ,NULL ,'false' ,'0' ,TO_DATE( '2016-07-07 02:02:26', 'yyyy-mm-dd hh24:mi:ss') ,'0' ,NULL ,'N' ,'false' ,'SFCStepBO:SFCRouterBO:SFCRoutingBO:SFCBO:ME 110,B260LV31TRHF1625007,RouterBO:ME 110,B260LV31TRHF,U,A,1,610' ,'0'  )  INTO SFC_STEP ( USE_AS_REWORK, OPERATION_BO, QTY_COMPLETE_PENDING, QTY_COMPLETED, QTY_IN_QUEUE, QTY_IN_WORK, SFC_ROUTER_BO, STEP_ID, BYPASSED, STEP_SEQUENCE, DATE_QUEUED, PREVIOUSLY_STARTED, QTY_REJECTED, PARTITION_DATE, MAX_LOOP, REPORTING_CENTER_BO, STATE, DONE, HANDLE, TIMES_PROCESSED ) values ( 'false' ,'OperationBO:ME 110,ICZP003,#' ,'0' ,'0' ,'0' ,'0' ,'SFCRouterBO:SFCRoutingBO:SFCBO:ME 110,B260LV31TRHF1625008,RouterBO:ME 110,B260LV31TRHF,U,A,1' ,'010' ,'false' ,'1' ,TO_DATE( '2016-07-07 00:00:00', 'yyyy-mm-dd hh24:mi:ss') ,'false' ,'0' ,TO_DATE( '2016-07-07 02:02:26', 'yyyy-mm-dd hh24:mi:ss') ,'0' ,'WorkCenterBO:ME 110,ZPQ' ,'N' ,'false' ,'SFCStepBO:SFCRouterBO:SFCRoutingBO:SFCBO:ME 110,B260LV31TRHF1625008,RouterBO:ME 110,B260LV31TRHF,U,A,1,010' ,'0'  )  INTO SFC_STEP ( USE_AS_REWORK, OPERATION_BO, QTY_COMPLETE_PENDING, QTY_COMPLETED, QTY_IN_QUEUE, QTY_IN_WORK, SFC_ROUTER_BO, STEP_ID, BYPASSED, STEP_SEQUENCE, DATE_QUEUED, PREVIOUSLY_STARTED, QTY_REJECTED, PARTITION_DATE, MAX_LOOP, REPORTING_CENTER_BO, STATE, DONE, HANDLE, TIMES_PROCESSED ) values ( 'false' ,'OperationBO:ME 110,ICZP004,#' ,'0' ,'0' ,'0' ,'0' ,'SFCRouterBO:SFCRoutingBO:SFCBO:ME 110,B260LV31TRHF1625008,RouterBO:ME 110,B260LV31TRHF,U,A,1' ,'020' ,'false' ,'2' ,NULL ,'false' ,'0' ,TO_DATE( '2016-07-07 02:02:26', 'yyyy-mm-dd hh24:mi:ss') ,'0' ,'WorkCenterBO:ME 110,ZPQ' ,'N' ,'false' ,'SFCStepBO:SFCRouterBO:SFCRoutingBO:SFCBO:ME 110,B260LV31TRHF1625008,RouterBO:ME 110,B260LV31TRHF,U,A,1,020' ,'0'  )  INTO SFC_STEP ( USE_AS_REWORK, OPERATION_BO, QTY_COMPLETE_PENDING, QTY_COMPLETED, QTY_IN_QUEUE, QTY_IN_WORK, SFC_ROUTER_BO, STEP_ID, BYPASSED, STEP_SEQUENCE, DATE_QUEUED, PREVIOUSLY_STARTED, QTY_REJECTED, PARTITION_DATE, MAX_LOOP, REPORTING_CENTER_BO, STATE, DONE, HANDLE, TIMES_PROCESSED ) values ( 'false' ,'OperationBO:ME 110,ICZP006,#' ,'0' ,'0' ,'0' ,'0' ,'SFCRouterBO:SFCRoutingBO:SFCBO:ME 110,B260LV31TRHF1625008,RouterBO:ME 110,B260LV31TRHF,U,A,1' ,'030' ,'false' ,'3' ,NULL ,'false' ,'0' ,TO_DATE( '2016-07-07 02:02:26', 'yyyy-mm-dd hh24:mi:ss') ,'0' ,'WorkCenterBO:ME 110,ZPQ' ,'N' ,'false' ,'SFCStepBO:SFCRouterBO:SFCRoutingBO:SFCBO:ME 110,B260LV31TRHF1625008,RouterBO:ME 110,B260LV31TRHF,U,A,1,030' ,'0'  )  INTO SFC_STEP ( USE_AS_REWORK, OPERATION_BO, QTY_COMPLETE_PENDING, QTY_COMPLETED, QTY_IN_QUEUE, QTY_IN_WORK, SFC_ROUTER_BO, STEP_ID, BYPASSED, STEP_SEQUENCE, DATE_QUEUED, PREVIOUSLY_STARTED, QTY_REJECTED, PARTITION_DATE, MAX_LOOP, REPORTING_CENTER_BO, STATE, DONE, HANDLE, TIMES_PROCESSED ) values ( 'false' ,'OperationBO:ME 110,ICZP007,#' ,'0' ,'0' ,'0' ,'0' ,'SFCRouterBO:SFCRoutingBO:SFCBO:ME 110,B260LV31TRHF1625008,RouterBO:ME 110,B260LV31TRHF,U,A,1' ,'040' ,'false' ,'4' ,NULL ,'false' ,'0' ,TO_DATE( '2016-07-07 02:02:26', 'yyyy-mm-dd hh24:mi:ss') ,'0' ,'WorkCenterBO:ME 110,ZPQ' ,'N' ,'false' ,'SFCStepBO:SFCRouterBO:SFCRoutingBO:SFCBO:ME 110,B260LV31TRHF1625008,RouterBO:ME 110,B260LV31TRHF,U,A,1,040' ,'0'  )

sergiy_katerinich
Active Contributor
0 Kudos

This query created routing steps for SFCs B260LV31TRHF1625007 and B260LV31TRHF1625008. I guess these are new SFCs generated by SFC Serialize.