Oracle EBS R12 WIP Component Issue&Return Process 1.定义BOM BOM（物料清单）是WIP的基础，BOM定义了产品的组成结构图，定义了生产特定物料所需的零件及数量。每一个零件也可能有他们的BOM结构，由此产生多层的产品结构树。 比如：一台电脑 = 1 CPU + 1 内存 + 1 硬盘 + 1 显示器 + 1 个鼠标 + 1个键盘 + 30根 数据线 + 50 个螺丝 ，这个电脑的构成就是一个BOM。另外一个硬盘可能又是一个BOM，比如 1 硬盘 = 4组磁盘 + 1个磁盘指针 + 1 个硬盘壳，同样的道理，显示器，内存...都有自己的BOM定义，这样对电脑这个BOM来说，实际上构成了一个庞大的BOM树。 这里有有一张关于黄建华文档里的自行车BOM树的截图，比较有代表性。 EBS里如何定义BOM，路径：Bill Of Materials > Bills > Bills 这里定义一个简单的BOM，1 * pt_asmbly01 = 2 * pt_component01 BOM的信息保存在BOM_STRUCTURES_B和BOM_COMPONENTS_B表中，BOM_STRUCTURES_B用于保存BOM Header信息，BOM_COMPONENTS_B是BOM_STRUCTURES_B的child table，用于保存BOM Component信息，两个表通过BILL_SEQUENCE_ID字段来关联。 SELECT * FROM BOM_STRUCTURES_B WHERE ASSEMBLY_ITEM_ID = 242956; SELECT * FROM BOM_COMPONENTS_B WHERE BILL_SEQUENCE_ID in (SELECT BILL_SEQUENCE_ID FROM bom_structures_b WHERE ASSEMBLY_ITEM_ID = 242956); 关于发料方式(BOM界面，Material Control中的Supply Type) Push 推式发料，必须手工通过界面做发料 需严格控制数量或者波动比较大的物料 Asmbly Pull 拉式发料，装配件完工或报废时自动按标准消耗量触发 消耗比较稳定的物料 Operation Pull 拉式发料，工序移动至To Move时自动按标准消耗量触发 消耗比较稳定的物料 BOM_COMPONENTS_B.WIP_SUPPLY_TYPE存储发料方式
2.定义Routing路径：Bill Of Materials > Routings > Routings Routings(工艺路线)最终解决的问题是生产过程中加工顺序、资源和用量的标准化。Routing是产品/半成品的生产步骤图，定义了生产特定物料所要经历的工序、加工部门（工作中心）、提前期、耗用的资源及其额定数量。 Routing头信息存储在表BOM_OPERATIONAL_ROUTINGS中，Routing的Operations信息存储在BOM_OPERATION_SEQUENCES表中，两个表通过字段ROUTING_SEQUENCE_ID字段关联。查询方法， SELECT * FROM BOM_OPERATIONAL_ROUTINGS WHERE ASSEMBLY_ITEM_ID = 242956; SELECT * FROM BOM_OPERATION_SEQUENCES WHERE ROUTING_SEQUENCE_ID IN (SELECT ROUTING_SEQUENCE_ID FROM BOM_OPERATIONAL_ROUTINGS WHERE ASSEMBLY_ITEM_ID = 242956); 3.定义WIP Discrete Job 路径：WIP > Discrete > Discrete Jobs Discrete，离散式，一种制造方法，用于装配件的分组或成批制造。制定标准离散任务，输入核心内容：任务名称（工单号）、生产类型、装配件、工单类型、生产数量、开工时间或完工时间。 这里在Discrete Job里定义job，保存，并relea这个job。 这一步会涉及到几张表WIP_ENTITIES,WIP_DISCRETE_JOBS,WIP_REQUIREMENT_OPERATIONS和WIP_OPERATIONS，这几张表都是通过WIP_ENTITY_ID相互关联. <<WIP_ENTITIES>> WIP_ENTITIES stores information about jobs, repetitive asmblies, and flow schedules. Each row includes a unique entity name, the entity type, and the asmbly being built. Oracle Work in Process us this information to control production activities and to ensure that entities with duplicate names are not created. Key Fields: WIP_ENTITY_ID:Job or schedule Identifier ORGANIZATION_ID:Organization Identifier WIP_ENTITY_NAME:WIP job or repetitive asmbly name or flow schedule reference code ENTITY_TYPE:WIP entity type code
PRIMARY_ITEM_ID:Asmbly Item Item <<WIP_DISCRETE_JOBS>> WIP_DISCRETE_JOBS stores discrete job information. Each row reprents a discrete job, and contains information about the asmbly being built, the revision of the asmbly, the job quantity, the status of the job, the material control method, accounting information, and job schedule dates. Oracle Work in Process us this information to control discrete production. Key Fields: WIP_ENTITY_ID:Job or schedule Identifier ORGANIZATION_ID:Organization Identifier PRIMARY_ITEM_ID:Asmbly Item Item STATUS_TYPE :Status of job 可以通过下边的SQL查得code的意义 SELECT lookup_code,meaning FROM FND_LOOKUP_VALUES where LANGUAGE = 'US' AND Upper(lookup_type) LIKE Upper('WIP_JOB_STATUS')
JOB_TYPE ：Type of discrete job
WIP_SUPPLY_TYPE ：Method of material consumption within WIP
START_QUANTITY：Job start quantity QUANTITY_COMPLETED：Current job quantity completed COMMON_BOM_SEQUENCE_ID：--> BOM_COMPONENTS_B.BILL_SEQUENCE_IDCOMMON_ROUTING_SEQUENCE_ID:-->BOM_OPERATIONAL_ROUTINGS.ROUTING_SEQUENCE_ID <<WIP_REQUIREMENT_OPERATIONS>> 任务领料需求发放表，记录了工单的制程中每个站点需要投料信息，我们根据这张表生成MMTT,进而生成Material Transaction. WIP_REQUIREMENT_OPERATIONS stores information about the material requirements of jobs and schedules. Each row reprents a material requirement and contains information about the component item, its usage quantities, the using department, requirement date, and the material control method. Oracle Work in Process us this information to track the material usage of jobs and schedules. Key Fields: WIP_ENTITY_ID:Job or schedule Identifier ORGANIZATION_ID:Organization Identifier INVENTORY_ITEM_ID:Component Item IdCOMPONENT_SEQUENCE_ID: -->BOM_COMPONENTS_BPONENT_SEQUENCE_ID WIP_SUPPLY_TYPE ：Method of material consumption within WIP
REQUIRED_QUANTITY:Component quantity requiredQUANTITY_ISSUED:Component quantity issued SUPPLY_SUBINVENTORY:Subinventory ud to supply component to WIP SUPPLY_LOCATOR_ID:Locator ud to supply component to WIP SEGMENT1:Component Item gment QUANTITY_ALLOCATED:Quantity allocated QUANTITY_BACKORDERED:Quantity backordered <<WIP_OPERATIONS>> 离散作业工序(操作)表，主要记录工单工序的信息,这张表主要是和Routing Operation Sequences相对应的(表：BOM_OPERATION_SEQUENCES)，Routing里有多少步，那么这个表就有多少个记录。 WIP_OPERATIONS stores information about job and repetitive schedule operations. Each row reprents a specific operation and includes an operation quence number, which orders the operations for the job or repetitive schedule. Each row also includes the asmbly quantity completed at an operation, the quantity at each intraoperation step, the department associated with an operation, the scheduled start and completion dates for an operation, the operation's countpoint and backflush types and other operation attributes. In general, Oracle Work in Process us this information to control and monitor asmbly production on the shop floor. Key Fields: WIP_ENTITY_ID:Job or schedule Identifier maximumOPERATION_SEQ_NUM:Operation quence number within a routing,值一般为:10,ORGANIZATION_ID:Organization Identifier OPERATION_SEQUENCE_ID:-->BOM_OPERATION_SEQUENCES.OPERATION_SEQUENCE_ID STANDARD_OPERATION_ID:-->BOM_OPERATION_SEQUENCES.STANDARD_OPERATION_ID DEPARTMENT_ID:-->BOM_OPERATION_SEQUENCES.DEPARTMENT_ID DESCRIPTION-->BOM_OPERATION_SEQUENCES.OPERATION_DESCRIPTION,工序的描述 SCHEDULED_QUANTITY: Number of units scheduled for the operation QUANTITY_IN_QUEUE:Number of units in Queue of the operation QUANTITY_RUNNING:Number of units in To Run of the operation QUANTITY_WAITING_TO_MOVE:Number of units waiting To Move in the operation QUANTITY_REJECTED:Number of units rejected from the operation identifyingQUANTITY_SCRAPPED:Number of units scrapped from the operation QUANTITY_COMPLETED:Number of units completed by the operation FIRST_UNIT_START_DATE:First unit scheduled receipt date FIRST_UNIT_COMPLETION_DATE:First unit scheduled completion date <<WIP_OPERATION_RESOURCES>> WIP_OPERATION_RESOURCES stores information about the resource requirements associated with job and repetitive schedule operations. Each row reprents a resource requirement and contains a quence number,the resource's unit of measure, its usage rate or amount, and veral other attributes that control how it is scheduled and costed. Oracle Work in Process us this information to schedule jobs and repetitive schedules and to charge resources to jobs and schedules. SQL Queries SELECT * FROM WIP_ENTITIES WHERE WIP_ENTITY_NAME = 'pt_job01'; SELECT * FROM WIP_DISCRETE_JOBS WHERE WIP_ENTITY_ID = (SELECT WIP_ENTITY_ID FROM WIP_ENTITIES WHERE WIP_ENTITY_NAME = 'pt_job01') ; SELECT * FROM WIP_REQUIREMENT_OPERATIONS WHERE WIP_ENTITY_ID = (SELECT WIP_ENTITY_ID FROM WIP_ENTITIES WHERE WIP_ENTITY_NAME = 'pt_job01'); lect * from WIP_OPERATIONS WHERE WIP_ENTITY_ID = (SELECT WIP_ENTITY_ID FROM WIP_ENTITIES WHERE WIP_ENTITY_NAME = 'pt_job01'); 4.发料 接下来我们就要从库存中给工单发货，这里有两种方法发料到工单 方法1：WIP > Material Transactions > WIP Material Transactions 这种方式比较简单，直接指定库存并发料 方法2：WIP > Discrete > Component Pick Relea > Component Pick Releas (Form) / (SRS) 当BOM的组件很多，使用方法一发料的话，一个个指定库存会很麻烦，Oracle EBS提供了Pick Relea的方式来发料，这样用户只要指定合适的Picking Rule,那么系统会自动帮你挑库。 系统会产生一个Move Order（Move Order Type：Manufacturing Pick），这一步实际上非常类似于订单的Pick Relea。 接下来去Transact Move Order界面，Transact这个Move Order就完成发料动作了。 注意使用方式一发料的话，后台是不会产生Move Order的，只有方式二才会有Move Order产生。 5.Material Transaction这个时候可以去Material Transaction form里查看，组件已经从库存中扣减，Transaction Type=WIP Issue(Transaction_Type_id:35,WIP component issue) 这个时候MTL_MATERIAL_TRANSACTIONS表中几个JOB相关的字段 MMT.Transaction_Type_id:35 MMT.TRANSACTION_ACTION_ID:1 MMT.TRANSACTION_SOURCE_TYPE_ID:5 MMT.TRANSACTION_SOURCE_ID -->WIP_DISCRETE_JOBS.WIP_ENTITY_ID MMT.TRX_SOURCE_LINE_ID-->WIP_REQUIREMENT_OPERATIONS.OPERATION_SEQ_NUM MMT.SOURCE_LINE_ID -->MTL_TXN_REQUEST_LINES.LINE_ID MMT.Move_Order_line_ID -->MTL_TXN_REQUEST_LINES.LINE_ID 6.WIP Component Return 物料发到工单后，有可能因为各种原因要把料退回到仓库，可以使用WIP Return 路径：WIP > Material Transactions > WIP Material Transactions，Type选择 WIP Return 查看Material Transaction，就可以看到一条WIP Return的Transaction发生了，并且组件库存数量又恢复到发料前的数量。 Transaction_TYPE_ID:43(WIP Component Return) ps:不管是上边所说的WIP Issue还是WIP Return，在WIP_TRANSACTIONS表中是没有数据产生的。 WIP_TRANSACTIONS stores information about WIP resource transactions.Each row reprents a single resource transaction and includes a uniquetransaction Identifier, a transaction date, the job or repetitiveschedule charged, the WIP operation and resource charges, and thenumber of units of measure applied. Oracle Work in Process us thisinformation to track resource charges and to calculate the values stored in WIP_TRANSACTION_ACCOUNTS. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
本文发布于:2023-06-28 07:51:50，感谢您对本站的认可！
本文链接：https://www.wtabcd.cn/fanwen/fan/90/160262.html
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系，我们将在24小时内删除。
| 留言与评论（共有 0 条评论） |
