kikiwhq的专栏

摘自：In this Document Goal Solution 1. Inventory Destination 2. Expense Destination: 3. Expense Account Rules 4. iProcurement - Favorite Charge Account 5. Account Generator - Requisition & Purchase Order AP.

摘自：Document 1067139.1 (oracle.com)In this Document Goal Solution Account Build Timing and Logistics References APPLIES TO:Oracle Purchasing - Version 11.5.10 to 12.2.4 [Release 11.5 to 12.2]Information in this document appli

摘自：POAccountSource_二子_新浪博客 (sina.com.cn)PO Account consists of charge account and accrual account Source mainly depends on following:a Item type(Expense item, Inventory asset item and Inventory expense item)b Distribution Type(Inventory or Expense)..

摘自：[ID 243641.1]Applies to:Oracle Purchasing - Version: 11.5.6 to 11.5.10 - Release: 11.5 to 11.5Information in this document applies to any platform.GoalHow does theCHARGE ACCOUNT default on PO DISTRIBUTIONS?SolutionCharge account..

摘自：(82条消息) PO接收产生分录总结_oldbalck的博客-优快云博客1,发运行的接收应计(PO_LINE_LOCATIONS_ALL.ACCRUE_ON_RECEIPT_FLAG)控制接收时是否产生分录.2,分配行的接收应计(PO_DISTRIBUTION_ALL.ACCRUE_ON_RECEIPT_FLAG)控制发票匹配PO时,分配行的科目取PO charge account,还是取暂估科目.3,强制接收时产生分录: 3.1,update PO_LINE_LOCATIONS_AL

Note: Standard Costing: Transaction_cost 与Actual_cost基本上是一致的，印象中标准成本更新好象是不样的； Average Costing: 平均成本更新应该不一样，其它的成本方法没留意过， Transaction_cost 事务处理的金额, 这个是事务处理有关系的，比如采购，可能就是采购价格。 Actual_cost 是成本计入的金额, 跟你的成本方法有关系。 ...

摘自：INV*物料接收子库存更新 - 旺仔丶小馒头 - 博客园 (cnblogs.com)INV*物料接收子库存更新DECLAREx_return_statusVARCHAR2(30);l_error_tbl inv_item_grp.error_tbl_type;CURSORcur_itemIS SELECT t.organization_name,...

摘自：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=245901104141807&id=280131.1&_adf.ctrl-state=3met3uf4_52APPLIES TO:Oracle Inventory Management - Version 11.5.9 and laterInformation in this document applies to any platform.FO

摘自：https://blog.youkuaiyun.com/gsairon/article/details/8770377mtl_supply表的作用，是当初培训时的一个知识点，现在我整理了一下，贴出来1、当请购单创建、审批后，mtl_supply的变化a.当创建完请购单,MTL_SUPPLY为空b.当审批后,mtl_supply中产生一条数据，supply_type_code=REQc.当请购单审批后，请购头与请购行存入MS.REQ_HEADER_ID, MS.REQ_LINE_ID，此时M...

转自：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=424746486989148&id=262979.1&displayIndex=5&_afrWindowMode=0&_adf.ctrl-state=1c8kev1z9c_278#q1In this Document Purpose Troubleshooting Steps Co...

摘自：https://blog.youkuaiyun.com/chenxianping/article/details/78935942系统版本:RDBMS : 9.2.0.6.0Oracle应用产品 : 11.5.10.2研发用户找我反映公司软件基线版要批量升级了，比如某软件版4.4.12批量升级到4.5.0.0，涉及到软件物料编码数...

摘自：https://www.cnblogs.com/benio/archive/2011/06/13/2079469.html根据API创建项目/****************************************************************************************CreatedBy:COOLERLEECreationD...

摘自：https://blog.51cto.com/baser/2164792使用标准API Inv_Item_Grp更新物料属性，可以修改大部分字段，包括物料编码、物料描述等属性。不可修改字段:PRIMARY_UNIT_OF_MEASURE, TRACKING_QUANTITY_IND, ONT_PRICING_QTY_SOURCE, SECONDARY_UOM_CODE, SE...

转：https://blog.youkuaiyun.com/cai_xingyun/article/details/39778551create_item inv_item_grp.create_item(p_commit => fnd_api.g_true, -- p_item_rec => l_item_rec, x_item_rec ...

mtl_system_items_b表中的栏位与界面栏位对应摘自：https://blog.youkuaiyun.com/huangwenkangz/article/details/50378637IntroductionThe basic table mtl_system_items_b is the basic table of item in ERP system and there are ...

摘自：http://blog.youkuaiyun.com/gsairon/article/details/8433693mtl_material_transactions的COST字段定义分类： EBS INV2012-12-25 15:35 908人阅读 评论(0) 收藏 举报事务处理表的成本核算：mtl_material_transactions

摘自：http://nagagechou.blogspot.tw/2012/07/erpinv-material-sourcing-process-failed.html[ERP R12]INV -The material sourcing Process failed to create picking suggestionsINV - The material sourcing

摘自：http://www.cnblogs.com/quanweiru/p/4642878.htmlThe Material Sourcing Process Failed To Create Picking Suggestions in INVTOTRX (文档 ID 2003806.1)In this DocumentSymptomsCauseS

转载请注明出处:http://blog.youkuaiyun.com/pan_tian/article/details/7899178TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG in MTI(MTL_TRANSACTIONS_INTERFACE) or MMTT(MTL_MATERIAL_TRANSACTIONS_TEMP)* For tra

查询INV期间关闭后的状态为Closed not Summarized报错：CSTRPCRE module: Period Close Reconciliation ReportMSG-00000: Run to date is unspecified. Defaulting to 30-APR-16MSG-00000: calling summarization pa

转载:http://blog.youkuaiyun.com/pan_tian/article/details/7899178TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG in MTI(MTL_TRANSACTIONS_INTERFACE) or MMTT(MTL_MATERIAL_TRANSACTIONS_TEMP)* For transactions s

摘自：http://blog.sina.com.cn/s/blog_3edcf3ea0101i91k.htmlAPP-PO-14142 rcv_receipts_eh.event-000: ORA-000 (2010-01-28 10:27:04)解决办法如图在划圈位置选接收方式然后保存即可（路径为 Items>master Items)

转摘自：http://blog.youkuaiyun.com/gh320/article/details/43969891ERP系统中，接收有时候未能及时生成相应的接收事务处理，多半原因是相关接收事务（接收，交货，退货）数据异常堵在接口表里，未能正确形成接收事务处理。此时在库存超级用户职责下的“事务处理状态汇总”可以看到相应的记录。常见接口表的错误：1. 接收处理处理器的异常，相应

摘自：http://blog.youkuaiyun.com/cai_xingyun/article/details/17533505除了可以用详解EBS接口开发之库存事务处理采购接收的方法还可以用一下方法，不同之处在于带有批次和序列控制的时候实现方式不同The script will load records into the tables           RC

摘自：https://www.cnblogs.com/benio/archive/2011/02/25/1964734.htmlmtl_transactions_interface接口表错误代码错误信息1：mtl_transactions_interface,货位段无效原因：mtl_transactions_interface.locator_id值不正确或为空，或其他异常情况 错误信息2：mtl...

转：https://blog.youkuaiyun.com/pan_tian/article/details/7785821在定义BOM的时候，我们需要设定，工单供货的方式(Supply Type).Push 推式发料，必须手工通过界面做发料，价格昂贵的，需严格控制数量，或者波动比较大的物料。推式组件根据需要可被直接发放至离散任务和重复性计划。虽然在制品管理系统会默认与组件关联的供应子库存，但您仍可以指定从中...

转自：http://overloving.iteye.com/blog/1661118CREATE OR REPLACE PACKAGE PkgImportItems IS          -- Created : 7/27/2012 11:40:03 AM       -- Auther  : Wang Lin       -- Purpose : Import Items   ...

INV-INVIDITM-Updating Item Attributes-Error:There are pending cycle count entries or physical inventory adjustments for this item. Error MessageThere are pending cycle count entries or physical...

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 Requ