Sunday, May 21, 2017

Oracle WIP JOBs Migration Approach

This is Data conversion task and often give some challenge while implementation. This is critical to Business.

Per Business scenarios, its needed to capture Data conversion approach in CV200 documents and get it reviewed with Business prior to actual conversion. So that Business is well aware how each data element is being migrated from Legacy system to New ERP system.

Following types of Jobs conversion scenario might exist in every Business

         1. Jobs created but not released for Mfg.
·       Convert or Let oracle to create new Job once after Plan runs
·     This Approach needs to be explained to Business upfront to take out any ambiguity

2. Jobs released but not moved from 1st Operation
·        Convert or Let oracle to create new job once after Plan runs
·     This Approach needs to be explained to Business upfront to take out any ambiguity

3. Jobs released & moved and at some operation (in this case Few resources, Parts might have been issued and cost incurred on job until that operation)

  • Create Dummy Items for Resource Conversion Cost & Item conversion cost & etc.
  • WIP-CNV-MTL-DMY (WORK IN PROCESS DUMMY ITEM FOR CONVERSION OF MATERIAL COSTS)
  • WIP-CNV-RES-DMY (WORK IN PROCESS DUMMY ITEM FOR CONVERSION OF RESOURCE COSTS)
  • WIP-CNV-OSP-DMY (WORK IN PROCESS DUMMY ITEM FOR CONVERSION OF OUTSIDE SERVICE PROVIDER COSTS)
  • WIP-CNV-MOH-DMY (WORK IN PROCESS DUMMY ITEM FOR CONVERSION OF MATERIAL OVERHEAD COSTS)
  • Add these Items to capture cost incurred on the job
  • Convert jobs and keep qty where it was on Operations in legacy system
4.  Jobs released, moved and at OSP operation (in this case, OSP requisition already been created and Parts were out for Processing)
  •           Convert OSP POR & POs
  •        Keep OSP jobs in Run status at OSP operation, so that system will not trigger any OSP POR again. (Assume OSP Requisition creation is in WIP Parameters is At Operation)

·       Note: Don’t keep job at Queue at OSP operation


   Pls check applicability and always ensure Business specific criterias   before jumps to conclusion. Hope these points may help, wish you good luck.