ITPub博客

For Interface Transactions,INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS DOES below things:1)validate_group (Validate a group of MTI records in a batch together)2)validate_lines(Validate each record of a batch in MTI)3)tempinsert(insert records from MTI into MMTT)4)calling inventory transaction Manager(insert records from MMTT into MMT)For Pending Transactions,INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS DOES below things:calling inventory transaction Manager(insert records from MMTT into MMT)

MTL_TRANSACTIONS_INTERFACE和MTL_MATERIAL_TRANSACTIONS_TEMP有三个类似的字段：TRANSACTION_HEADER_ID & TRANSACTION_BATCH_ID & TRANSACTION_BATCH_SEQ以下为eTRM里关于这三个字段的解释：TRANSACTION_HEADER_ID:Transaction group identifier and Workers, only user-specified values will be ignored.TRANSACTION_BATCH_ID:Batch id for transactionTRANSACTION_BATCH_SEQ:Batch sequence for transaction从字面上看，三个字段意思似乎是一样的，但其实三个字段有

Dual UOM是随着Process Manufacturing（流程制造）的加入，在Oracle EBS R12中新加的特性。对于Dual UOM的物料，查库存时，Workbench不仅会显示主计量单位(Primary UOM)，同时也会显示次计量单位（Secondary UOM）。Dual UOM适用于特定的行业，比如化工，食品...，具体的例子，以牛肉为例，在欧美常常以磅(Pounds)作为牛肉主计量单位，但中国更习惯使用公斤来作为主计量单位。对于这样的物料就有

Min-max planning is a method of determining  when and how much to order based on userdefined minimum and maximum inventory levels.Reorder Qty=  (Max quantity) - [(onhand qty)+(qty on order)] = 1000 - [50 + 0]When to Order?Typically, you should order when: On-hand quantity + supply ? demand < minimum Min-Max Planing:How Much to Order?Order Quantity = (Max quantity) - [(onhand qty)+(qty on order)]Restock：Enter Yes or No to indicate whet

Transaction Historical Summary Report Use the Transaction Historical Summary Report to report past item quantities, past item value, or past inventory balances. The report calculates historical balances based on a rollback date. The report rolls back all of the transactions for the item to the date you specify and prints the quantity, value, or balance as of that date. In addition, the value and quantity versions let you specify the source type. The report sums the transactions for the item an

ORG_ACCT_PERIODS holds the open and closed financial periods for organizations. When a period is opened, the period open form (INVTTGPO) pulls in the next available period from the GL table GL_PERIODS. ORG_ACCT_PERIODS holds the relevant data, such as period start, end and close dates. Note that only postable periods will be brought over. You may create non-postable periods in Oracle General Ledger or in the GL forms provided with Oracle Inventory. If data exists in the PERIOD_CLOSE_DATE c

UOM Tables RelationshipUnits Of Measure FormForm: INVSDUOM.fmbTable: MTL_UNITS_OF_MEASUREMTL_UNITS_OF_MEASURE is the definition table for both the 25-character and the 3-character units of measure.The base_uom_flag indicates if the unit of measure is the primary unit of measure for the uom_class.Oracle Inventory uses this tabl

Locator Level是一个自上而下控制的，Order:Org locator Control  > Subinv  locator Control > Item  locator Control   Org Level Locator Control None: Inventorytransactions within this organization do not require locator information. Prespecified only: Inventory transactions within this organization require a valid, predefinedlocator for each item. Dynamic entry allowed: Inventory transactions within this organization require a locator for eachitem. Yo

1. Source org and destination org both are non-onhand status tracking organizations (Item is lot controlled) 1.1 If Lot is NEW one for Receiving org. Allow Different material Status = Y Intransit/Direct: Default Status from the organization item setup. See Bug 10257769 & 11688000 Allow Different material Status = No Intransit: Copy lot status from source org to destination org. Direct: Copy lot status from source org to destination org. See Bug 14404578 forms/US/INVTTELT

TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG in MTI(MTL_TRANSACTIONS_INTERFACE) or MMTT(MTL_MATERIAL_TRANSACTIONS_TEMP)* For transactions stuck in MMTTupdate mtl_material_transactions_tempset process_flag = \'Y\',lock_flag = NULL ,Transaction_mode = 3  ,Error_code = NULL ,Error_explanation = NULLwhere transaction_header_id = &transaction_header_idand error_code is not NULL; *For transactions stuck in MTIupdate mtl_transactions_interfaceset process_flag =  1,lock_flag = NULL ,Tran

Material Workbench Form，Inbound选项用于查询，“在途数量”，“采购订单数量”，“ASN数量” x01为Inter Org的shipment编号 6245为采购订单编号

使用脚本生成批次，并把这个批次关联到的Item和Org 1.使用API，INV_LOT_API_PUB.AUTO_GEN_LOT生成Next Lot Number 2.关联这个批次到一个Item和Org上 DECLARE v_object_id NUMBER; v_return_status VARCHAR2(1) := NULL; v_msg_count NUMBER := 0; v_msg_data VARCHAR2 (2000); v_lot_number VARCHAR2 (50); v_expire_date DATE := SYSDATE+180; v_organization_id

1、当请购单创建、审批后，mtl_supply的变化 a.当创建完请购单,MTL_SUPPLY为空 b.当审批后,mtl_supply中产生一条数据，supply_type_code=REQ c.当请购单审批后，请购头与请购行存入MS.REQ_HEADER_ID, MS.REQ_LINE_ID，此时MS.SUPPLY_TYPE_CODE=REQ 2、当PO创建、审批后，mtl_supply的变化 a.当请购单转换成po后，在未审批时，MTL_SUPPLY为空 b.当审批后,mtl_supply中原有的supply_type_code=REQ被更改为supply_type_code=PO

Material Workbench Form查询界面里，有一个Detailed选项 这个Detailed选项如果被勾选上，在不用点击左树的情况下，就可以从查询结果清楚的知道物料的位置信息和库存信息; 这个Detailed选项如果没有被勾选上，那么如果想看详细的库存信息，需要逐级点击左边的SKU树，才能看到具体库存信息。 一个例子，Item:pt_a01,Subinventory:PTSUB, Locator:2.4.3,quantity:20, Locator:2.4.8,quantity:10 如果De

基于Item Template,导入Item数据1.查找到TEMPLATE_IDSELECT * FROM MTL_ITEM_TEMPLATES_B b,MTL_ITEM_TEMPLATES_TL tl WHERE b.TEMPLATE_ID = tl.TEMPLATE_ID AND tl.TEMPLATE_NAME LIKE \'Purchased Item%\';2.基于模板插入ItemINSERT INTO MTL_SYSTEM_ITEMS_INTERFACE ( process_flag, set_process_id, transaction_type, organization_id, segment1, description, TEMPLATE_ID ) VALUES ( 1, --process_flag 1, --set_process_id \'CREATE\', --transaction_ty

Step 1:创建两个目录C:\mwagui\lib和C:\mwagui\log，下载patch:4205328(Mobile Wireless Applications (MWA) J2ME Telnet GUI Client 11.5.10)到C:\mwagui\lib。(patch:4205328有一个包含Mobile手持模拟所需要的java class的zip文件，j4205328.zip)Step 2:下载jdk1.5Step 3:创建一个bat文件，内容:set MWA_GUI_TOP=C:\mwagui\set JAVA_TOP=C:\Program Files\Java\jre1.5.0_08%JAVA_TOP%\bin\java -classpath %JAVA_TOP%\lib\classes.zip;%MWA_GUI_TOP%\lib\j4205328.zip oracle.apps.mwa.awt.c

<Incoming material>                          <<Inventory>>                 <Outgoing Material> PO/PR                                                Intra-Org Transfer              SO(OM/Shipping) JOB(Wip Comple

What\'s main code logic while performing query in material workbench form(INVMWBIV.fmb).   Key File: INVMWBIV.fmb INVMWQMB.pls - INV_MWB_QUERY_MANAGER INVMWCTB.pls - INV_MWB_CONTROLLER Key Table: MTL_MWB_GTMP mtl_onhand_quantities_detail ===================== First Delete All records from MTL_MWB_GTMP. DELETE FROM MTL_MWB_GTMP(Happen at INV_MWB_CONTROLLER.initialize) INV_MWB_CONTROLLER.Event |-INV_MWB_CONTROLLER.initialize ===================== INV_MWB_CONTROLLER.initia

The MTL_CC_ENTRIES_INTERFACE table serves as the interface between users and Oracle Inventory\'s Enter/Approve Cycle Count Request functionality. Users populate the interface table, and a PL/SQLconcurrent program, launched by the user, processes the information in this table, inserts/updates the MTL_CYCLE_COUNT_ENTRIES table, and spawns adjustment material transactions, if necessary. Expected behavior ----------------------- Cycle count open interface brings the counts in the count

Account Receipt      Account Alias Receipt Cycle Count Adjust     Intransit Receipt      ISO(Direct)     ISO(Intransit)   PO Receipt RMA Receipt Requisition Move Order Sales Order Pick Sales Order Issue Sales Order Issue(DropShip) WIP Component Issue WIP Move Transaction(Completion Return) WIP Move Transaction(Completion)   转载请注明出处: http://b