PRICE LIST的设置的地方的ROUND TO
今天OM中PRICE_LIST为BP_RMB的订单的单价一直是0.85000而不能够在页面中将其修改为0.8547.但是,其他PRICE_LIST却可以的.修改的方法就是在PRICE LIST的设置的地方ROUND TO要修改位数.[@more@]
查看PO中客制的报表过程
根据需要修改PO的客制报表,所以,首先需要把相关的客制报表先查找出来.下面是查找PO客制报表的过程:SELECT APPLICATION_ID FROM FND_APPLICATION_TL where APPLICATION_NAME = 'Purchasing'select * from FND_CONCURRENT_PROGRAMS_TLWHERE APPLICATION_ID = 201AND LAST_UPDATE_LOGIN NOT IN (0)ORDER BY LAST_UPDATE_DATE DESCSELECT * FROM FND_CONCURRENT_PROGRAMSWHERE APPLICATION_ID = 201AND LAST_UPDATE_LOGIN NOT IN (0)ORDER BY LAST_UPDATE_DATE DESC最后使用的语句:SELECT a.user_concurrent_program_name program_name,b.conc
PICK完成,但是状态依然为BACKORDER
PICK完成,但是状态依然为BACKORDER提示:Pick selection is completed with warning解决方法:MAST ITEMàRESERVE和SHIPPABLE要选择 symptom: Pick Release completes but the order remains in backorder release rligible. cause: The Item attributes Reservable and Shippable are not checked and profile option OE:Reservations is not set to Yes fix:Set the Item attributes Reservable and Shippable to checked and profile option O
Backordered even the inventory is sufficient在库存量满足的情况下PICK却BACKORDER
在库存量满足的情况下PICK却BACKORDER,以下是查看METALINK上的资料.Oracle Order Entry Technical Forum Displayed below are the messages of the selected thread. Thread Status: Active From: Michelle Martin 21-Jun-06 06:30 Subject: Backordered even the inventory is sufficient. Backordered even the inventory is sufficient.We cannot understand the behavior of oracle because as we launch pick requested quantity it gets backordered even the inventory is enough. eg. there is available 20 mt under item k65s j
How To Run MSRFWOR - Refresh Collections Snapshots Concurrent Request From The Application
In this DocumentGoalSolutionReferencesApplies to: Oracle Advanced Supply Chain Planning - Version: 11.5.2 to 12.0Information in this document applies to any platform.EXECUTABLE:MSRFWOR - Refresh Collection Snapshots GoalThe Refresh Collection Snapshots can be run as a standalone concurrent request using the following steps This is recommended as a first step when launching Data Collections for the first time on a new or cloned instance.SolutionThe request is available under the Material Planner
立帳科目明細表抓会计科目出错
立帳科目明細表在抓科目的时间抓错,立账的时间的会计科目是11410100但是却抓出来的是11910400.开始以为是应收账款(TYPE:INVOICE, CLASS:INVOICE)所立的会计科目出错,因为应收账款现在的业务包括:应收账款(11410100),其他应收账款(11910400).所以,以为需要新加一个应收账款的会计科目.但是后来通过查看程序,却发现不是这样的问题.测试过程如下:(1) 查出会计科目为11410100看其于11910400的不同(2) 找出不同点,然后查看页面中哪里出问题(3) 经过比较是立账的时间CLASS选择错了,因为同样是应收账欵(TYPE:INVOICE,CLASS却有好多种)A:应收账款(
“0x671e7af5”指令参考的”0x00000101”记忆体,该记忆体不能为”read”.错误提示
Oracle Report Builder在进行Layout Model的过程中提示如下错误:“0x671e7af5”指令参考的”0x00000101”记忆体,该记忆体不能为”read”.但是,在进行Data Modle 和Parameter Form的时间却没有相关的提示.解决办法:打PATCH:p4183804_600_WINNT.同时,在安装Form Builder和Report Builder及PATCH的时间语言均应该选择为ENGLISH.详见:http://www.itpub.net/showthread.php?s=&threadid=737995&perpage=10&pagenumber=2[@more@]
一订单已经出货,状态为CLOSED,但是却发现salesperson写错了
一订单已经出货,状态为CLOSED,但是却发现salesperson写错了,改成正确的过程如下:(1)从数据库中找到正确的SALESPERSON的IDselect SALESREP_ID from oe_order_headers_allwhere order_number = 2907000301 /*2907000301为该SALESPERSON的ID */(2)修改IDupdate oe_order_headers_allset salesrep_id = 100000041where order_number = 2907000147[@more@]一订单已经出货,状态为CLOSED,但是却发现salesperson写错了,改成正确的过程如下:(1)从数据库中找到正确的SALESPERSON的ID
Rain ditty 雨中小调
Rain ditty It is raining heavily outside, the rain knock on the window so silvery that how I want to go back home without working here at office.So long a time that I haven’t go close to the nature and take exercise that how I wish one day I can lay on the green grass, and dautted by the sunshine and the breeze, or dance in the largo garden. Though such easy thing to me before, now this all maybe become only a wish or a dream.We all grow old, but life changes, or the habit of life changes, mayb
gl_code_combinations的设置位置
gl_code_combinations是从如下画面进去设置的: 总账-->设置 -->账户(GL-->SET UP --> ACCOUNTS-->COMBINATIONS)经常使用该表来抓会计科目,AR中是可以引用的(AR -->SET UP -->TRANSACTIONS --> TRANSACTION TYPES -->ACCOUNTS)[@more@]想请教一下gl_code_combinations是从哪个画面进去设置的?经常使用该表来抓会计科目,AR中是可以引用的,但是,却不是最原始的设置位置,我想知道该表的最原始的设定位置在哪里?谢谢大家:rose: :rose: :rose:
Woefulness in the wind 风中的遗憾
as the singing is so beautiful and the lyric is so soulful that i can't help myself translate it into english.wish you can love it :)风中的遗憾Woefulness in the wind 我在风里呼喊你的声音可曾听见Can you hear me call you in the wind 风里喊你千百遍的声音能传多远How far can it spread你能撕碎我的情撕毁我的意撕裂我身体You can rend my love and my body 可是我呐喊的声音你不应该装听不见But why you pretend not to hear my battle cry 我在风里呼喊你的声音可曾听见Can you hear me call you in the wind成千上万的思