随笔分类 -  Oracle EBS INV

1 2 3 下一页
总账库存科目明细追溯
摘要：/* Formatted on 2018/3/15 10:04:03 (QP5 v5.256.13226.35538) */ SELECT xel.subinventory_code 子库 , DECODE (xel.lot_number, '', '来源,非库存') 批次 -- , cux_public_pkg.get_item_segment1 (8... 阅读全文
posted @ 2018-03-15 10:06 全威儒 阅读(730) 评论(0) 推荐(0)
查询 EBS 系统物料净重、毛重
摘要：/* Formatted on 2018/3/14 23:40:47 (QP5 v5.256.13226.35538) */ SELECT DISTINCT MSI.SEGMENT1 || ',' 物料编码 , MSI.DESCRIPTION 物料名称 , MSI.UNIT_WEIGHT 毛重 , MSI.WEIG... 阅读全文
posted @ 2018-03-14 23:42 全威儒 阅读(451) 评论(0) 推荐(0)
PROFILE - 库存：物料状态支持 控制【物料状态定义】禁止的事务处理
摘要：PROFILE 库存：物料状态支持 阅读全文
posted @ 2016-12-20 08:34 全威儒 阅读(809) 评论(0) 推荐(0)
MMT事务处理来源类型-INV_OBJECT_GENEALOGY.GETSOURCE
摘要：INV_OBJECT_GENEALOGY.GETSOURCE (MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID, MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID, MTL_MATER... 阅读全文
posted @ 2016-01-09 23:01 全威儒 阅读(810) 评论(0) 推荐(0)
Oracle INV - SO line backorder API
摘要：--Sales Order Lines to backorder API--===================================--SET serveroutput on size 1000000DECLARE l_return_status VARCHAR2(100);l_msg_count NUMBER;l_msg_data VARCHAR2(2000);l_msg_inde... 阅读全文
posted @ 2015-12-11 11:19 全威儒 阅读(961) 评论(0) 推荐(0)
不同组织物料类别差异列表
摘要：--不同组织物料类别差异列表 SELECT MSI1.SEGMENT1 ITEM_NUMBER, MSI1.DESCRIPTION, MC1.DESCRIPTION MASTER_LEVEL, FU1.DESCRIPTION USER_NAME, MIC1.LAST_UPDATE_DATE, MC2.DESCRIPT... 阅读全文
posted @ 2015-07-31 13:46 全威儒 阅读(535) 评论(0) 推荐(0)
The Material Sourcing Process Failed To Create Picking Suggestions in INVTOTRX (文档 ID 2003806.1)
摘要：In this Document Symptoms Cause Solution References Applies to: Oracle Inventory Management - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]Information in this document applies to any platform. Sym... 阅读全文
posted @ 2015-07-13 14:45 全威儒 阅读(2685) 评论(0) 推荐(0)
APP-PAY-06153 When Trying To Open Organization Definition Form (文档 ID 1323165.1)
摘要：In this Document Symptoms Cause Solution Applies to: Oracle Inventory Management - Version 11.5.10.2 and laterInformation in this document applies to any platform.Form:PERWSDOR.FMB - F4 Define Orga... 阅读全文
posted @ 2015-07-06 16:46 全威儒 阅读(1236) 评论(0) 推荐(0)
Item Import: What Does "Sync" Items Do? (Doc ID 417887.1)
摘要：In this Document APPLIES TO: Oracle Item Master - Version 11.5.10.0 to 11.5.10.0 [Release 11.5] Information in this document applies to any platform. 阅读全文
posted @ 2014-11-30 19:38 全威儒 阅读(793) 评论(0) 推荐(0)
Understanding Item Import and Debugging Problems with Item Import (Doc ID 268968.1)
摘要：In this Document APPLIES TO: Oracle Item Master - Version 11.5.8 to 12.1.3 [Release 11.5 to 12.1] Information in this document applies to any platform 阅读全文
posted @ 2014-11-30 19:32 全威儒 阅读(11200) 评论(0) 推荐(0)
INCOIN Importing Multilingual Items (Doc ID 278126.1)
摘要：APPLIES TO: Oracle Inventory Management - Version: 11.5.9 to 11.5.10.CU2 - Release: 11.5 to 11.5 GOAL What is the supported approach for using the Imp 阅读全文
posted @ 2014-11-30 18:25 全威儒 阅读(1055) 评论(0) 推荐(0)
Import Items – Validation Multiple Languages Description
摘要：ð 提交标准请求创建和更新物料，因语言环境与处理次序方式等因素，造成物料中英（更多语言）描述和长描述混乱刷新。 症状: >>> Submit Standard Open Interface Request: Import Items Language: American English (US) / 阅读全文
posted @ 2014-11-30 18:16 全威儒 阅读(687) 评论(0) 推荐(0)
Receiving Transaction Processor Conundrum
摘要：what would we do if we are faced with a situation to execute a receiving transaction in oracle ebusiness suite from a BPEL process in Oracle Fusion Mi 阅读全文
posted @ 2014-11-09 12:25 全威儒 阅读(1184) 评论(0) 推荐(0)
Oracle - Unprocessed Material
摘要：create table kol.MTL_MATERIAL_TRANS_TMP_140325 as select * from MTL_MATERIAL_TRANSACTIONS_TEMP ; update MTL_MATERIAL_TRANSACTIONS_TEMP mmtt Set mmtt.P 阅读全文
posted @ 2014-03-25 15:33 全威儒 阅读(482) 评论(0) 推荐(0)
Receving Transactions > No data found IQC无法接收PO采购物料
摘要：Receving Transactions > No data found IQC无法接收PO采购物料 APP-PO-14094: No records meet your search criteria. Question： Path: Inventory > Transactions > Rec 阅读全文
posted @ 2013-10-21 12:38 全威儒 阅读(643) 评论(0) 推荐(0)
INV Close Period & GL Import Journal > DML tables
摘要：1. (N) Inventory > Accounting Close Cycle > Inventory Accounting Periods Insert data: CST_PERIOD_CLOSE_SUMMARY WIP_TRANSACTIONS WIP_TXN_ALLOCATIONS Up 阅读全文
posted @ 2013-09-08 18:10 全威儒 阅读(863) 评论(0) 推荐(0)
Inventory > INV.MTL_MATERIAL_TRANSACTIONS Show Error Msg: ORA-20100: File lxxx.tmp creation for FND_FILE failed.
摘要：Fixed Step. 1. Backup error data CREATE TABLE MMT_BACKUP_0805 AS SELECT * FROM INV.MTL_MATERIAL_TRANSACTIONS MMT WHERE MMT.TRANSACTION_ID IN ( 1288363 阅读全文
posted @ 2013-08-05 10:33 全威儒 阅读(812) 评论(0) 推荐(0)
同一客户代码下一个CPN对应多个FG会出现CPN描述一样的问题
摘要：Q&A : D2E01客户下已经存在CPN: TP1062/A 对应FG: P5M2812512AFHHF0 直接在客户代码下无法新建,只能在交叉信息新建CPN: TP1062/A， 但无法修改CPN显示内容, 都为旧CPN描述的内容,如果重新进CPN: TP1062/A 更改为对应C9M28125 阅读全文
posted @ 2013-08-01 15:49 全威儒 阅读(347) 评论(0) 推荐(0)
Oracle EBS PO 收接事处理状态待定或错误
摘要：PO接收后,发现在没有接收成功.在"事务处理状态汇总"查找到不是"待定"就是"错误",如下图: 对于事务处理状态"待定"的记录,直接删除记录就可以重新接收. 对于事务处理状态"错误"的记录,需求根据"错误"中的说明修改相关设置,如图中错误是没有维护分类间单位换算,除了直接删除记录外,还要维护相关设置 阅读全文
posted @ 2013-08-01 10:53 全威儒 阅读(1277) 评论(0) 推荐(0)
关闭库存会计期
摘要：结账时，各模块的关帐顺序大致为PO-INV-AP/AR/FA-GL，为了避免库存事务无法产生当期的应付/应收信息，因此一般库存会计期的关闭应在AP/AR之前。关闭库存会计期，一个动作，其实涉及到两个步骤: 1、关闭库存会计期→此时，状态变为“已关闭但未汇总”； 2、运行“期间关闭调节报表”，将库存的 阅读全文
posted @ 2013-07-26 14:50 全威儒 阅读(2402) 评论(0) 推荐(0)

1 2 3 下一页