Oracle EBS INV
文章平均质量分 77
田攀
tian.pan@qq.com
展开
-
Auto Generate Item Number
自动生成物料编码的客户化代码,觉得代码写的挺好的,留着备用吧source:https://forums.oracle.com/thread/411343代码需加入到CUSTOM.pll------------------------------------------------------------------------------------------------------------原创 2013-10-25 15:21:25 · 2750 阅读 · 0 评论 -
XXX_Mark_ID in MTL_SERIAL_NUMBRS
MTL_SERIAL_NUMBER table has 3 mark_id fields: GROUP_MARK_ID, LINE_MARK_ID, LOT_LINE_MARK_IDGROUP_MARK_ID=TRANSACTION_HEADER_IDLINE_MARK_ID=TRANSACTION_TEMP_IDIf lot controlled, then LOT_LINE_MARK_原创 2013-04-13 15:22:03 · 4757 阅读 · 0 评论 -
New Feature "Optional Lot Allocation" in Oracle EBS R12.2.2
今天和同事分享了我在EBS R12.2.2做的一个新功能-Optional Lot Allocation. Optional Lot Allocation的引入,可以让客户在挑库的时候,可以选择是否自动挑入批次。在以前,挑库后,批次一定会根据挑库规则被选择上,客户可能会不满意挑库规则所挑选的批次,那么就需要手动的删除批次,再更改批次,如果批次很多就会增加很多工作量。新功能之后,客户可以选择不挑批次原创 2013-03-27 23:14:24 · 2802 阅读 · 1 评论 -
MTL_SALES_ORDERS
Once Sales Order get booked, There will be record go into mtl_sales_orders.Unlike account numbers which are stored as flexfields in GL_CODE_COMBINATIONS, or purchase orders which are stored in PO_HEAD原创 2013-02-06 16:41:50 · 4602 阅读 · 0 评论 -
Consignment Inventory in Oracle EBS
Consignment Inventory:即寄售库存,在货物没有被购买商使用之前,货物的所有权仍归供应商所有,购买商只有在使用货物时才支付费用。“寄售库存”是处理积压库存产品,腾出其占用空间,增加现金流的一种库存处理方式。委托方将积压的库存产品委托给受委托方代为销售,委托方一般需将库存产品交给受委托方代为保管,授权其代为销售,产品出售后,由受委托方向委托方结算货款并获取佣金或差额利润。沃尔玛采用原创 2013-03-22 10:21:26 · 4611 阅读 · 0 评论 -
Create an Inventory Organization
Inventory-> Setup-> Organizations->OrganizationsFocus on Inventory Organization,And Click 'Others'Accounting Information,Enter Account Information.Enter Inventory Information. Associate this new org t原创 2013-03-04 18:57:55 · 2583 阅读 · 0 评论 -
Inventory Transactions Manager
OverviewInventory Transaction Manager用于处理库存接口表(MTL_TRANSACTION_INTERFACE或者MTL_MATERIAL_TRANSACTIONS_TEMP)中的记录,处理之后最终产生库存事务(MTL_MATERIAL_TRANSACTIONS)。(补:MTL_MATERIAL_TRANSACTIONS里记录了所有库存事务的历史,是Invento原创 2013-03-30 21:07:54 · 5584 阅读 · 0 评论 -
Using script to submit INV Manager to process MTI/MMTT
1.Using script to submit INV Manager to process MMTT/** When prompted for user_id, resp_id and resp_appl_id, ask ct enter the correct values for * these variables. The values can be obtained by logg原创 2012-07-03 10:46:03 · 5127 阅读 · 0 评论 -
How to invoke Standard Choose Organizations Form From your form
Step1: Create 4 parameters in your custom form,ORG_ID,ORG_CODE,ORG_NAME,CHART_OF_ACCOUNTS_IDAttributes like belowStep2: Pre-Form Trigger, call FND_ORG.CHOOSE_ORG;(FND_ORG.CHOOSE_ORG定义在FNDSQF.pll文件中)An原创 2013-03-29 13:36:52 · 5382 阅读 · 0 评论 -
Oracle Inventory Module Forms(fmx) Name Dictionary
Navigation:Inventory > Transaction INVTTMTX.fmx - Misc Transaction/Inter-Org Transfer/SubInv Transfer/Consigned TransactionINVTVTXN.fmx - Material TransactionINVTVTUS.fmx - Transaction SummariesCSTFQI原创 2013-02-28 12:33:11 · 4025 阅读 · 0 评论 -
TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG,TRANSACTION_STATUS in MTI or MMTT
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原创 2012-08-23 11:41:18 · 19649 阅读 · 1 评论 -
Profile:INV:Transaction Date Validation
There is a profile which is used to controls the date you can enter for transactionsINV:Transaction Date ValidationPROFILE_OPTION_NAME:TRANSACTION_DATE Allow date in any open period:Allows entry of原创 2013-01-19 16:56:15 · 3312 阅读 · 0 评论 -
java.lang.UnsupportedClassVersionError in Oracle Apps
After submitting inventory transaction, Oracle Applications show process error, Check inventory debug log, found out error:java.lang.UnsupportedClassVersionError. From log, The issue seems be related原创 2013-03-07 17:20:49 · 3426 阅读 · 0 评论 -
Serial Number Related Profiles/Options
INV: Restrict Receipt of SerialsThis profile determines if users can receive into stores the serial numbers that have been issued out of inventory and are in status 4 –Issued out of Stores. INV: Valid原创 2013-04-13 15:27:15 · 2804 阅读 · 0 评论 -
Move Order Type
MTL_TXN_REQUEST_HEADERS.MOVE_ORDER_TYPE LOOKUP_TYPELOOKUP_CODEMEANINGDESCRIPTIONMOVE_ORDER_TYPE1RequisitionMove Order RequisitionMOVE_ORDER_TYPE2ReplenishmentMove Order Type created from replenishment原创 2012-08-21 11:22:00 · 5997 阅读 · 0 评论 -
QUANTITY_DETAILED,QUANTITY_DELIVERED in MTL_TXN_REQUEST_LINES
QUANTITY_DETAILED:Allocated Quantity.QUANTITY_DELIVERED:Final Transacted Quantity.1. Create move order:Quantity: 10Quantity Delivered: NULLQuantity Detailed: NULLQuantity Required: NULLLine Status: 1原创 2013-04-22 11:25:23 · 3056 阅读 · 0 评论 -
UOM Convertion Rate API
计量单位转换APIset serveroutput on;Declarev_Rate Number(30,23);v_itemid number default 2036;Beginv_rate := INV_CONVERT.INV_UM_CONVERT ( ITEM_ID => v_i原创 2013-08-27 16:17:44 · 3603 阅读 · 0 评论 -
Item Categories
Category是把具有相似特性的物料分配到一个类别里。Category set是一组Category的合集。The complete set up of item categories is done in below 5 steps in sequence.Related TablesMTL_CATEGORIES_B is the code combinations table for ite原创 2013-04-15 15:32:52 · 4412 阅读 · 0 评论 -
Inventory API Related Nots
Note 729998.1:Oracle Inventory Management Application Program Interface (APIs)Note.729261.1How To Create A Move Order Header Using INV_MOVE_ORDER_PUB.Create_Move_Order_Header APINote.729263.1How To Cr原创 2013-06-19 14:58:45 · 7227 阅读 · 1 评论 -
Navigation to Open/Close INV/GL/AR/AP/PO Period
* Purchasing:Purchasing Responsibility > Setup > Financials > Accounting > Control Purchasing Periods * Inventory:Inventory Responsibility > Accouting Close Cycle > Inventory Accounting Periods * GL原创 2013-02-05 16:22:27 · 5212 阅读 · 0 评论 -
Add accounting periods to your calendar
开库存期间,但期间的里最新的期间离现在都有段时间了,并且库存期间内无法新增期间。解决方法:需要给Accounting Calendar中增加期间,然后才能在库存期间里开启新增的期间。首先找到你的Accounting Calender的名字,GL > Setup > Ledger Sets(11i里这个叫SOB,Set of books,在12R下面, SOB 已经由一个新的名词 ledger 所取原创 2013-05-30 19:26:35 · 2799 阅读 · 0 评论 -
Open Inventory Periods Script
某个库存组织下,发现有很多库存期间都未打开,而一个一个的开期间比较麻烦,可以使用这个脚本来批量打开库存期间-----------------------------------------------------------l_org_id为 organization's Organization_ID--eg. select * from mtl_parameters where organ原创 2013-05-16 15:30:55 · 3971 阅读 · 0 评论 -
Unit Of Measure(UOM) in Oracle Applications Inventory
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原创 2012-10-23 17:12:41 · 14577 阅读 · 0 评论 -
Dual UOM in Oracle EBS
Dual UOM是随着Process Manufacturing(流程制造)的加入,在Oracle EBS R12中新加的特性。对于Dual UOM的物料,查库存时,Workbench不仅会显示主计量单位(Primary UOM),同时也会显示次计量单位(Secondary UOM)。Dual UOM适用于特定的行业,比如化工,食品...,具体的例子,以牛肉为例,在欧美常常以磅(Pounds)作为原创 2012-12-01 23:54:26 · 4149 阅读 · 0 评论 -
Oracle EBS Material Status FAQ
Slideshare:Oracle EBS Material Status FAQ(Pan Tian)Oracle EBS MATERIAL STATUS FAQAuthor: PTIAN (tianpan@gmail.com)Creation Date: 16/04/2012Last Updated:原创 2012-04-23 12:34:47 · 6272 阅读 · 0 评论 -
基于Item Template,导入Item数据
基于Item Template,导入Item数据1.查找到TEMPLATE_IDSELECT * FROM MTL_ITEM_TEMPLATES_B b,MTL_ITEM_TEMPLATES_TL tlWHERE b.TEMPLATE_ID = tl.TEMPLATE_IDAND tl.TEMPLATE_NAME LIKE 'Purchased Item%';2.基于模板插入ItemINSER原创 2012-07-16 14:02:53 · 5448 阅读 · 0 评论 -
Internal Sales Order (ISO) Process Flow
本文介绍下内部销售订单Internal Sales Order(ISO)在Oracle EBS中的流程,内部销售订单和组织间转移(Inter-Organization Transfer,IOT)的作用是类似的,都是用于在库存组织间实现物料转移。只是使用的场景不尽相同,Inter-Organization Transfer(IOT),一般适用于,操作者同时具有来源组织和目标组织物料控制的权利,那么直原创 2013-04-27 00:36:52 · 7593 阅读 · 0 评论 -
Descriptive Flex Field List
Query:SELECT CONCATENATED_SEGS_VIEW_NAME,APPLICATION_TABLE_NAME,DESCRIPTIVE_FLEXFIELD_NAME,TITLE,CONTEXT_COLUMN_NAME,DESCRIPTION FROM FND_DESCRIPTIVE_FLEXS_VL WHERE APPLICATION_ID = 401 --Take Invent原创 2013-04-17 17:45:07 · 6059 阅读 · 0 评论 -
SubInventory & Locator Tables
RelationshipMTL_SECONDARY_INVENTORIESMTL_SECONDARY_INVENTORIES is the definition table for the subinventory. A subinventory is a section of inventory, i.e., raw material, finished goods, etc. Subinven原创 2013-02-22 19:00:38 · 16618 阅读 · 0 评论 -
Interface Managers - Material Transaction - Process Interval - Field Not Updatable
Asked a question in OTNQestion1:In Interface Managers form(Navi:Inventory > Setup > Transactions > Interface Managers), Default interval of concurrent program 'Material transaction' is 5 mins, how can原创 2013-03-05 14:35:03 · 4443 阅读 · 0 评论 -
Material Workbench - Inbound check box
Material Workbench Form,Inbound选项用于查询,“在途数量”,“采购订单数量”,“ASN数量”x01为Inter Org的shipment编号6245为采购订单编号原创 2012-08-20 09:55:27 · 2020 阅读 · 0 评论 -
Generation of a LOT number for an Inventory item via API in R12
使用脚本生成批次,并把这个批次关联到的Item和Org1.使用API,INV_LOT_API_PUB.AUTO_GEN_LOT生成Next Lot Number2.关联这个批次到一个Item和Org上DECLARE v_object_id NUMBER; v_return_status VARCHAR2(1) := NULL; v_m翻译 2012-08-03 17:49:15 · 2385 阅读 · 0 评论 -
ASCP中是要计算mtl_supply的数据
1、当请购单创建、审批后,mtl_supply的变化a.当创建完请购单,MTL_SUPPLY为空b.当审批后,mtl_supply中产生一条数据,supply_type_code=REQc.当请购单审批后,请购头与请购行存入MS.REQ_HEADER_ID, MS.REQ_LINE_ID,此时MS.SUPPLY_TYPE_CODE=REQ2、当PO创建、审批后,mtl_supply转载 2012-08-03 17:27:16 · 2077 阅读 · 0 评论 -
Material Workbench Changes From 11i to R12
For Material Workbench form, the technological framework are different between R12 and 11i,In 11510 Forms grid is used where as from R12 it is upgraded to JTF grid.(You may note Material Workbench原创 2012-08-03 17:15:24 · 6405 阅读 · 3 评论 -
'Detailed' checkbox in Material Workbench
Material Workbench Form查询界面里,有一个Detailed选项这个Detailed选项如果被勾选上,在不用点击左树的情况下,就可以从查询结果清楚的知道物料的位置信息和库存信息;这个Detailed选项如果没有被勾选上,那么如果想看详细的库存信息,需要逐级点击左边的SKU树,才能看到具体库存信息。一个例子,Item:pt_a01,Subinventory:P原创 2012-08-02 11:54:41 · 1907 阅读 · 0 评论 -
INV&WMS Picking Rule
Inventory Picking Rule(Oracle Apps R12)用于在非WMS组织下,给Sales Order, WIP, OPM Manufacturing设置挑库规则路径:Inventory > Setup > Rules > PickingLot: You can sort by lot based on the following criteria原创 2012-07-02 14:48:19 · 6023 阅读 · 2 评论 -
Cycle Count Interface Table - MTL_CC_ENTRIES_INTERFACE
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/SQLconcurr原创 2012-07-02 23:23:52 · 6021 阅读 · 0 评论 -
Inventory Integretion Notes
> PO/PR Intra-Org Transfer SO(OM/Shipping)JOB(Wip Completion) Inter-Org Transfer原创 2012-07-12 13:27:00 · 1685 阅读 · 0 评论 -
Pick Release 代码流程图
OM模块的Pick Release用的比较多,里边涉及的分支比较多,总结了一下方便查阅For pdf version,you can download via "Pick Release Process_v3.pdf"转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7527908======EOF======原创 2012-05-02 14:18:12 · 3552 阅读 · 0 评论 -
Physical Inventory
Physical Inventory Basic Steps1.Define Physical Inventory > Snapshot(The snapshot saves all current item on-hand quantities and costs) > It will raise "Freeze physical inventory" Concurrent Reques原创 2012-04-09 17:16:03 · 4384 阅读 · 0 评论