ITPub博客

OverviewInventory Transaction Manager用于处理库存接口表(MTL_TRANSACTION_INTERFACE或者MTL_MATERIAL_TRANSACTIONS_TEMP)中的记录，处理之后最终产生库存事务(MTL_MATERIAL_TRANSACTIONS)。(补：MTL_MATERIAL_TRANSACTIONS里记录了所有库存事务的历史，是Inventory的最核心的表)Oracle R12 Inventory有两套接口表：1.MTL_TRANSACTIONS_INTERFACE (MTI) :主要用于第三方模块（产品）数据的导入，如Order Management, WIP。对应的Form为Transact

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文件中)And you are all set, the list of Orgs appearing will be from the Organization Access defined for the current responsibility.------------------------------------------------------------------------------------------------------FND_ORG.CHOOSE_ORGVariableDescription Summaryprocedure FND_O

自动生成物料编码的客户化代码，觉得代码写的挺好的，留着备用吧source:https://forums.oracle.com/thread/411343代码需加入到CUSTOM.pll------------------------------------------------------------------------------------------------------------------------------------ /*********************************************************************/ /* Begin Master Item Form */ /* 1. Make sure the Item Field on the Master Item Form */ /* is NOT editable by the END USER */ /* 2

计量单位转换APIset serveroutput on; Declare v_Rate Number(30,23); v_itemid  number default  2036; Begin v_rate := INV_CONVERT.INV_UM_CONVERT (                                    ITEM_ID         => v_itemid,          &

开库存期间，但期间的里最新的期间离现在都有段时间了，并且库存期间内无法新增期间。解决方法：需要给Accounting Calendar中增加期间，然后才能在库存期间里开启新增的期间。首先找到你的Accounting Calender的名字，GL > Setup > Ledger Sets（11i里这个叫SOB，Set of books，在12R下面, SOB 已经由一个新的名词 ledger 所取代）You can define multiple calendars and assign a different calendar to each set of

QUANTITY_DETAILED:Allocated Quantity.QUANTITY_DELIVERED:Final Transacted Quantity.1. Create move order:Quantity: 10Quantity Delivered: NULLQuantity Detailed: NULLQuantity Required: NULLLine Status: 1 (Incomplete)2. Approve move order:Quantity: 10Quantity Delivered: NULLQuantity Detailed: NULLQuantity Required: NULLLine Status: 3 (Approved)3. Allocate move order for full quantity:Quantity: 10Quantity Delivered: NULLQuantity Detailed: 10Quantity Required: NULLLine Status: 3 (Approved)4. Transact

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 Inventory Module as ExampleORDER BY APPLICATION_TABLE_NAME;List:CONCATENATED_SEGS_VIEW_NAMEAPPLICATION_TABLE_NAMEDESCRIPTIVE_FLEXFIELD_NAMETITLECONTEXT_COLUMN_NAMEDESCRIPTIONMTL_ABC_ASSIGNMENT_GROUPS_DFVMTL_ABC_ASSIGNMENT_GROUPSMTL_ABC_ASSIGNMENT_GROUPSABC groupsATTRIBUTE_CATEGORY MTL_ABC_COMP

Category是把具有相似特性的物料分配到一个类别里。Category set是一组Category的合集。The complete set up of item categories is done in below 5 steps in sequence.Tables RelationshipRelated TablesMTL_CATEGORIES_B is the code combinations table for item categories. Items are grouped into categories within the context of a category set to provide flexible grouping schemes.The item category is a key flexfield with a flex code of MCAT. The flexfield structure identifier is a

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: Validate Returned SerialThis profile option determines whether component serials that are returned from WIP should be validated against serials that are issued to thesame job. The available options are Yes and No. This profile option is updateable only at site level.‘Validate Serial Numbers on RMA

今天和同事分享了我在EBS R12.2.2做的一个新功能-Optional Lot Allocation. Optional Lot Allocation的引入，可以让客户在挑库的时候，可以选择是否自动挑入批次。在以前，挑库后，批次一定会根据挑库规则被选择上，客户可能会不满意挑库规则所挑选的批次，那么就需要手动的删除批次，再更改批次，如果批次很多就会增加很多工作量。新功能之后，客户可以选择不挑批次，未来一个合

Consignment Inventory:即寄售库存，在货物没有被购买商使用之前，货物的所有权仍归供应商所有，购买商只有在使用货物时才支付费用。“寄售库存”是处理积压库存产品，腾出其占用空间，增加现金流的一种库存处理方式。委托方将积压的库存产品委托给受委托方代为销售，委托方一般需将库存产品交给受委托方代为保管，授权其代为销售，产品出售后，由受委托方向委托方结

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 I modify this interval time?Anser1:You can schedule the program related to the manager on an interval based on the business requirement,Click on Tools -> Launch manager and schedule the program accordingly.Question2: Tools > Launch Manager,It will Run request "Process transa

Inventory-> Setup-> Organizations->OrganizationsFocus on Inventory Organization,And Click \'Others\'Accounting Information,Enter Account Information.Enter Inventory Information. Associate this new org to a responsibility.  Inventory-> Setup-> Organizations-> Organization Access

Navigation:Inventory > Transaction INVTTMTX.fmx - Misc Transaction/Inter-Org Transfer/SubInv Transfer/Consigned TransactionINVTVTXN.fmx - Material TransactionINVTVTUS.fmx - Transaction SummariesCSTFQITD.fmx - Material DistributionsINVTVTMP.fmx - Pending TransactionINVTVPTX.fmx - Transaction Open InterfaceNavigation:Inventory > Transaction > ReceivingRCVRCERC.fmx - ReceiptsRCVTXERT.fmx - Receiving TransactionsRCVTXECO.fmx - Receiving CorrectionsRCVTXERE.fmx - ReturnNavigation:Inventory

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. Subinventories areassigned to items (in a many to one relationship), indicating a list of valid places where this item will physically exist in inventory.Other attributes include general ledger accounts, demand picking order, locator type, availability type, and reservabletype.You can also specify whether

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_HEADERS, sales orders are not assumed to originate in any particular application. MTL_SALES_ORDERS exists for the purpose of mapping sales orders between other applications and Inventory.MTL_SALES_ORDERS is a key flexfield table with no structure defining column or set defining column. The flexfield c

--需要输入set_of_books_id，set_of_books_id可以从GL_SETS_OF_BOOKS查,Demo环境中的Vision Operations (USA)的set_of_books_id是1 SELECT a.period_name, a.period_num, a.gl_status, b.po_status, c.ap_status, d.inv_status FROM (SELECT period_name, period_num, DECODE (closing_status, \'O\', \'Open\', \'C\', \'Closed\',

Answer is \'Maybe\'.One subinventory xfer creates 2 inventory transactions. (mmt records)Those inventory transactions do NOT create a/c entries if both subinventories are tied to the same accounts.However, if the 2 subinventories are tied to different accounts, then both inventory transactions create accounting records.Check if your subinventories are tied to same accounts. If they are same, you should not see any a/c records.source:https://forums.oracle.com/forums/thread.jspa?messageID=441801

Why Quantity Tree?Why go for such a complex structure just to get the quantity of an Item?Why not just query the tables and get it every time?Why not Just do the computation at each and every code where it is required?This is why:Centralized structure to do anything will reduce much of the hassles. Not only Quantity Computation, but also anything done at a single place will lead to lesser number of bugs and easier maintenance.E.g. where Quantity Tree goes handy:Misc. Receipt Form when you tab

What\'s Expense items Expense items are items that we are using for internal usage and we are not selling them(can be Purchasable). they have no cost. they can be Inventory items!For example, if you purchased staples, paper and pens during the same transaction, these purchases could be entered as one expense item rather than entering them separately. Expense ItemA - Expense Items   a - Purchasable = YES   b - Purchased = YES   c - inventory item = NO(stockable = N