MSCA / WMS Function Keys -[ID 275915.1]
Applies to: Oracle Inventory Management - Version: 11.5.9 and later [Release: 11.5 and later ]Information in this document applies to any platform.This document includes all versions ...
稻盛和夫(INAMORI KAZUO)
在朋友的推荐下看了这一期的对话节目。这一期节目嘉宾是稻盛和夫。在日本被称为“经营之神”的稻盛和夫,50年的职业生涯中创办了两家世界500强企业,并一直保持着从未亏损的奇迹。现在他正在用他的经营哲学来...
packed items
Sometimes we met some items in inventory,but packed. the qty can be avaiable to reserve, and avaiable to transacted.I have no idea how this issue generated. i saw this datafix:update apps.mtl_onhan...
Inventory Asset Value
If you want to make costing enabled attribute at organization level, then set this attribute to organization level. Now you can disable Inventory Asset flag Explanation on this Functionalit...
wrong shipped sales order
Yesterday, we met a issue, the customer told us that one SO was shipped my mistake. As i know that once the SO has shipped, it can't be returned. I just a little worried about the issue. ...
costed error
Check on metalink for this issue. and i gueUncosted Transactions with Error Message CST_MATCH_TXFR_CG_TXFR_ORG [ID 362133.1]6:45:10 PM: Hui Wang: Uncosted transactions with error CST_MATCH_TXFR_CG_OR...
飘着找爱
故事情节:ZZ:http://i.mtime.com/aiqing100/blog/1167078/ 斯嘉丽经历了三次失败的婚姻。她为了赌气嫁给了查尔斯,为了赚钱嫁给了弗兰克,她其实并不爱他们,为此还得罪了原本应该成为新娘的她的两个妹...
ORA-01722 Invalid Number
用户反映系统中的一个克制的报表有问题,只出来了部分数据。检查SQL是没有问题的。但是察看log有:ORA-01722 Invalid Number在重新跑SQL发现加了参数,SQL是没有问题的,去掉特定的参数就会出现那样的错误。网上查...
恋恋风尘
阿远初中毕业之后,因为家境不许,只好放弃学业到台北工作,那年他十五岁,但是他认识阿云已经十四年了。 阿云第二年也到台北来做事,那时候,她才知道像他们这样的人在城市所过的日子并不像阿远回家时...
社交网络(ZT)
http://movie.douban.com/review/3780008/ 我的名字叫Mark Zuckerberg,我是一典型卷发犹太人,我成绩优秀,高中最爱编程,造了几个有点小用的软件后,我考上了哈佛. 在大学我什么都...
update locator
Sometimes, the user found some items have onhand qty, but without locator.The user provide us the locator, we will do the following update:--------1 row will be updated------------update apps.mtl_ma...
Oracle ERP message check
sometimes we may met the error, we don't know if it is the customize error, or oracle stand error. we can check the error defin though Application Developer----Application--message to check the error....
How to list E-Business Suite Profile Option values for all levels using SQLPlus
How to list E-Business Suite Profile Option values for all levels using SQLPlus [ID 201945.1] SELECT distinct SUBSTR(e.profile_option_name, 1, 25) PROFILE, DECODE(...
oracle erp profile notes:
Cycle Count Listing report INV: Dynamic Precision Option for Quantity on Reports: -999,999,990 -999,999,990.00(before you change the profile, please make sure which level will be change)...
query for on hand qty,reserve qty
onhand qty 包括了预留的数量,如果要计算可用量,需要使用onhand qty-reserve qty.select A.organization_code,A.segment1,A.description,A.transaction_quantity,nvl(b.RESERVATION_QUANTITY,0) resqty,A.subinve...
INV_IOI_MASTER_CHILD Errors in Item Import [ID 429924.1]
Troubleshooting DetailsBACKGROUND: When rows fail the Import Items process due to an INV_IOI_MASTER_CHILD_1n error, it means that one or more master controlled attributes do not have the same value i...
SELECT FOR UPDATE Cursors
You use SELECT FOR UPDATE cursors for updating the rows retrieved by a cursor. This is often required when there's a need to modify each row retrieved by a cursor without having to refetch that row. M...
Troubleshooting FRM-40654 [ID 1003629.6]
Troubleshooting FRM-40654 [ID 1003629.6] Modified 02-JAN-2009 Type PROBLEM Status PUBLISHED Checked relevance 13-...
The Base Cause of ” FRM-40654 “
The Base Cause of ” FRM-40654 “http://www.oracleappshub.com/category/ebs-suite/page/2/Very common problem your end user normally reports “FRM-40654: Record has been updated by another user. Re-...
Native Dynamic SQL and Dynamic PL/SQL(6)
Using Bind VariablesBinding refers to the linking of program values to variables at runtime. This is done by means of bind variables. Using bind variables in native dynamic SQL makes the code execute...