on 07-11-2016 9:47 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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' )
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.