Oracle EBS R12 WIP Component Issue.docx
- 文档编号:10440018
- 上传时间:2023-02-11
- 格式:DOCX
- 页数:16
- 大小:518.22KB
Oracle EBS R12 WIP Component Issue.docx
《Oracle EBS R12 WIP Component Issue.docx》由会员分享,可在线阅读,更多相关《Oracle EBS R12 WIP Component Issue.docx(16页珍藏版)》请在冰豆网上搜索。
OracleEBSR12WIPComponentIssue
OracleEBSR12WIPComponentIssue&ReturnProcess
1.定义BOM
BOM(物料清单)是WIP的基础,BOM定义了产品的组成结构图,定义了生产特定物料所需的零件及数量。
每一个零件也可能有他们的BOM结构,由此产生多层的产品结构树。
比如:
一台电脑=1CPU+1内存+1硬盘+1显示器 +1个鼠标+1个键盘+30根数据线+50个螺丝,这个电脑的构成就是一个BOM。
另外一个硬盘可能又是一个BOM,比如1硬盘=4组磁盘+1个磁盘指针+1个硬盘壳,同样的道理,显示器,内存...都有自己的BOM定义,这样对电脑这个BOM来说,实际上构成了一个庞大的BOM树。
这里有有一张关于黄建华文档里的自行车BOM树的截图,比较有代表性。
EBS里如何定义BOM,路径:
BillOfMaterials>Bills>Bills
这里定义一个简单的BOM,1*pt_assembly01=2*pt_component01
BOM的信息保存在BOM_STRUCTURES_B和BOM_COMPONENTS_B表中,BOM_STRUCTURES_B用于保存BOMHeader信息,BOM_COMPONENTS_B是BOM_STRUCTURES_B的childtable,用于保存BOMComponent信息,两个表通过BILL_SEQUENCE_ID字段来关联。
SELECT*FROMBOM_STRUCTURES_BWHEREASSEMBLY_ITEM_ID= 242956;
SELECT*FROMBOM_COMPONENTS_B
WHEREBILL_SEQUENCE_IDin(SELECTBILL_SEQUENCE_IDFROMbom_structures_bWHEREASSEMBLY_ITEM_ID= 242956);
关于发料方式(BOM界面,MaterialControl中的SupplyType)
Push推式发料,必须手工通过界面做发料需严格控制数量或者波动比较大的物料
AssemblyPull拉式发料,装配件完工或报废时自动按标准消耗量触发消耗比较稳定的物料
OperationPull拉式发料,工序移动至ToMove时自动按标准消耗量触发消耗比较稳定的物料
BOM_COMPONENTS_B.WIP_SUPPLY_TYPE存储发料方式
Value
Meaning
1
Push
2
AssemblyPull
3
OperationPull
4
Bulk
5
Supplier
6
Phantom
7
BasedonBill
2.定义Routing路径:
BillOfMaterials>Routings>Routings
Routings(工艺路线)最终解决的问题是生产过程中加工顺序、资源和用量的标准化。
Routing是产品/半成品的生产步骤图,定义了生产特定物料所要经历的工序、加工部门(工作中心)、提前期、耗用的资源及其额定数量。
Routing头信息存储在表BOM_OPERATIONAL_ROUTINGS中,Routing的Operations信息存储在BOM_OPERATION_SEQUENCES表中,两个表通过字段ROUTING_SEQUENCE_ID字段关联。
查询方法,
SELECT*FROMBOM_OPERATIONAL_ROUTINGSWHEREASSEMBLY_ITEM_ID= 242956;
SELECT*FROMBOM_OPERATION_SEQUENCES
WHEREROUTING_SEQUENCE_IDIN(SELECTROUTING_SEQUENCE_IDFROMBOM_OPERATIONAL_ROUTINGSWHEREASSEMBLY_ITEM_ID= 242956);
3.定义WIPDiscreteJob
路径:
WIP>Discrete>DiscreteJobs
Discrete,离散式,一种制造方法,用于装配件的分组或成批制造。
制定标准离散任务,输入核心内容:
任务名称(工单号)、生产类型、装配件、工单类型、生产数量、开工时间或完工时间。
这里在DiscreteJob里定义job,保存,并release这个job。
这一步会涉及到几张表WIP_ENTITIES,WIP_DISCRETE_JOBS,WIP_REQUIREMENT_OPERATIONS和WIP_OPERATIONS,这几张表都是通过WIP_ENTITY_ID相互关联.
<
WIP_ENTITIESstoresinformationaboutjobs,repetitiveassemblies,andflowschedules.Eachrowincludesauniqueentityname,theentitytype,andtheassemblybeingbuilt.OracleWorkinProcessusesthisinformationtocontrolproductionactivitiesandtoensurethatentitieswithduplicatenamesarenotcreated.
KeyFields:
WIP_ENTITY_ID:
JoborscheduleIdentifier
ORGANIZATION_ID:
OrganizationIdentifier
WIP_ENTITY_NAME:
WIPjoborrepetitiveassemblynameorflowschedulereferencecode
ENTITY_TYPE:
WIPentitytypecode
1
Discretejob
2
Repetitiveassembly
3
Closeddiscretejob
4
Flowschedule
PRIMARY_ITEM_ID:
AssemblyItemItem
<
WIP_DISCRETE_JOBSstoresdiscretejobinformation.Eachrowrepresentsadiscretejob,andcontainsinformationabouttheassemblybeingbuilt,therevisionoftheassembly,thejobquantity,thestatusofthejob,thematerialcontrolmethod,accountinginformation,andjobscheduledates.OracleWorkinProcessusesthisinformationtocontroldiscreteproduction.
KeyFields:
WIP_ENTITY_ID:
JoborscheduleIdentifier
ORGANIZATION_ID:
OrganizationIdentifier
PRIMARY_ITEM_ID:
AssemblyItemItem
STATUS_TYPE:
Statusofjob
可以通过下边的SQL查得code的意义
SELECTlookup_code,meaningFROMFND_LOOKUP_VALUES
whereLANGUAGE='US'ANDUpper(lookup_type)LIKEUpper('WIP_JOB_STATUS')
Value
Meaning
7
Cancelled
8
PendingBillLoad
9
FailedBillLoad
10
PendingRoutingLoad
11
FailedRoutingLoad
12
Closed
13
Pending-MassLoaded
14
PendingClose
15
FailedClose
1
Unreleased
3
Released
4
Complete
5
Complete-NoCharges
6
OnHold
JOB_TYPE:
Typeofdiscretejob
Value
Meaning
1
Standard
3
Non-standard
WIP_SUPPLY_TYPE:
MethodofmaterialconsumptionwithinWIP
Value
Meaning
1
Push
2
AssemblyPull
3
OperationPull
4
Bulk
5
Supplier
6
Phantom
7
BasedonBill
START_QUANTITY:
Jobstartquantity
QUANTITY_COMPLETED:
Currentjobquantitycompleted
COMMON_BOM_SEQUENCE_ID:
-->BOM_COMPONENTS_B.BILL_SEQUENCE_IDCOMMON_ROUTING_SEQUENCE_ID:
-->BOM_OPERATIONAL_ROUTINGS.ROUTING_SEQUENCE_ID
<
任务领料需求发放表,记录了工单的制程中每个站点需要投料信息,我们根据这张表生成MMTT,进而生成MaterialTransaction.
WIP_REQUIREMENT_OPERATIONSstoresinformationaboutthematerialrequirementsofjobsandschedules.Eachrowrepresentsamaterialrequirementandcontainsinformationaboutthecomponentitem,itsusagequantities,theusingdepartment,requirementdate,andthematerialcontrolmethod.OracleWorkinProcessusesthisinformationtotrackthematerialusageofjobsandschedules.
KeyFields:
WIP_ENTITY_ID:
JoborscheduleIdentifier
ORGANIZATION_ID:
OrganizationIdentifier
INVENTORY_ITEM_ID:
ComponentItemIdCOMPONENT_SEQUENCE_ID:
-->BOM_COMPONENTS_B.COMPONENT_SEQUENCE_ID
WIP_SUPPLY_TYPE:
MethodofmaterialconsumptionwithinWIP
Value
Meaning
1
Push
2
AssemblyPull
3
OperationPull
4
Bulk
5
Supplier
6
Phantom
7
BasedonBill
REQUIRED_QUANTITY:
ComponentquantityrequiredQUANTITY_ISSUED:
Componentquantityissued
SUPPLY_SUBINVENTORY:
SubinventoryusedtosupplycomponenttoWIP
SUPPLY_LOCATOR_ID:
LocatorusedtosupplycomponenttoWIP
SEGMENT1:
ComponentItemsegment
QUANTITY_ALLOCATED:
Quantityallocated
QUANTITY_BACKORDERED:
Quantitybackordered
<
离散作业工序(操作)表,主要记录工单工序的信息,这张表主要是和RoutingOperationSequences相对应的(表:
BOM_OPERATION_SEQUENCES),Routing里有多少步,那么这个表就有多少个记录。
WIP_OPERATIONSstoresinformationaboutjobandrepetitivescheduleoperations.Eachrowrepresentsaspecificoperationandincludesanoperationsequencenumber,whichorderstheoperationsforthejoborrepetitiveschedule.Eachrowalsoincludestheassemblyquantitycompletedatanoperation,thequantityateachintraoperationstep,
thedepartmentassociatedwithanoperation,thescheduledstartandcompletiondatesforanoperation,theoperation'scountpointandbackflushtypesandotheroperationattributes.Ingeneral,OracleWorkinProcessusesthisinformationtocontrolandmonitorassemblyproductionontheshopfloor.
KeyFields:
WIP_ENTITY_ID:
JoborscheduleIdentifier
OPERATION_SEQ_NUM:
Operationsequencenumberwithinarouting,值一般为:
10,20,30...ORGANIZATION_ID:
OrganizationIdentifier
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:
Numberofunitsscheduledfortheoperation
QUANTITY_IN_QUEUE:
NumberofunitsinQueueoftheoperation
QUANTITY_RUNNING:
NumberofunitsinToRunoftheoperation
QUANTITY_WAITING_TO_MOVE:
NumberofunitswaitingToMoveintheoperation
QUANTITY_REJECTED:
Numberofunitsrejectedfromtheoperation
QUANTITY_SCRAPPED:
Numberofunitsscrappedfromtheoperation
QUANTITY_COMPLETED:
Numberofunitscompletedbytheoperation
FIRST_UNIT_START_DATE:
Firstunitscheduledreceiptdate
FIRST_UNIT_COMPLETION_DATE:
Firstunitscheduledcompletiondate
<
WIP_OPERATION_RESOURCESstoresinformationabouttheresourcerequirementsassociatedwithjobandrepetitivescheduleoperations.Eachrowrepresentsaresourcerequirementandcontainsasequencenumber,theresource'sunitofmeasure,itsusagerateoramount,andseveralotherattributesthatcontrolhowitisscheduledandcosted.
OracleWorkinProcessusesthisinformationtoschedulejobsandrepetitiveschedulesandtochargeresourcestojobsandschedules.
SQL Queries
SELECT*FROMWIP_ENTITIESWHEREWIP_ENTITY_NAME='pt_job01';
SELECT*FROMWIP_DISCRETE_JOBSWHEREWIP_ENTITY_ID=(SELECTWIP_ENTITY_IDFROMWIP_ENTITIESWHEREWIP_ENTITY_NAME='pt_job01');
SELECT*FROMWIP_REQUIREMENT_OPERATIONSWHEREWIP_ENTITY_ID=(SELECTWIP_ENTITY_IDFROMWIP_ENTITIESWHEREWIP_ENTITY_NAME='pt_job01');
select*fromWIP_OPERATIONSWHEREWIP_ENTITY_ID=(SELECTWIP_ENTITY_IDFROMWIP_ENTITIESWHEREWIP_ENTITY_NAME='pt_job01');
4.发料
接下来我们就要从库存中给工单发货,这里有两种方法发料到工单
方法1:
WIP>MaterialTransactions>WIPMaterialTransactions
这种方式比较简单,直接指定库存并发料
方法2:
WIP>Discrete>ComponentPickRelease>ComponentPickReleas(Form)/(SRS)
当BOM的组件很多,使用方法一发料的话,一个个指定库存会很麻烦,OracleEBS提供了PickRelease的方式来发料,这样用户只要指定合适的PickingRule,那么系统会自动帮你挑库。
系统会产生一个MoveOrder(MoveOrderType:
ManufacturingPick),这一步实际上非常类似于订单的PickRelease。
接下来去TransactMoveOrder界面,Transact这个MoveOrder就完成发料动作了。
注意使用方式一发料的话,后台是不会产生MoveOrder的,只有方式二才会有MoveOrder产生。
5.MaterialTransaction这个时候可以去MaterialTransactionform里查看,组件已经从库存中扣减,TransactionType=WIPIssue(Transaction_Type_id:
35,WIPcomponentissue)
这个时候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.WIPComponentReturn
物料发到工单后,有可能因为各种原因要把料退回到仓库,可以使用WIPReturn
路径:
WIP>MaterialTransactions>WIPMaterialTransactions,Type选择WIPReturn
查看MaterialTransaction,就可以看到一条WIPReturn的Transaction发生了,并且组件库存数量又恢复到发料前的数量。
Transaction_TYPE_ID:
43(WIPComponentReturn)
ps:
不管是上边所说的WIPIssue还是WIPReturn,在WIP_TRANSACTIONS表中是没有数据产生的。
WIP_TRANSACTIONSstoresinformationaboutWIPresourcetransactions.EachrowrepresentsasingleresourcetransactionandincludesauniquetransactionIdentifier,atransactiondate,thejoborrepetitiveschedulecharged,theWIPoperationandresourcecharges,andthenumberofunitsofmeasureappl
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle EBS R12 WIP Component Issue