2012/8/31

[IIS] Integration Windows Authorization not Enable


DotNET Open IIS Site Fail – Integration Windows Authorization not Enable
Date: 2012/05/08
Author: Willie Chou
Reference: Error: Debugging Failed Because Integrated Windows Authentication Is Not Enabled  http://msdn.microsoft.com/en-us/library/x8a5axew.aspx


Try to Open Web Site in .NET( Visual Studio), and execute Stat Debugging(F5)





Then following error is occurred !

Solution:
Solution is to enable the Integrated Windows Authorization

[Script] BAT 批次檔連線網路磁碟機

[Script] BAT 批次檔連線網路磁碟機
Author: Willie
Date:2012/08031

此範例包含了寫入log檔
Step:
1. 刪除網路磁碟機,代號 S
2. 設定Log 路徑c:\WintekRunScript\RemoteDisk_log.log
3. 處理要印到Log檔的內容
4. 連線網路磁碟機,代號 S


@ECHO OFF
REM 設定電腦閒置網路磁碟機不中斷

NET CONFIG SERVER /AUTODISCONNECT:-1
net use s: /delete
set log_file="c:\WintekRunScript\RemoteDisk_log.log"

echo Remote Disk Connect Begin > %log_file%
echo Current date is: >> %log_file%
date /t < NUL >> %log_file%
echo Current time is: >> %log_file%
time /t < NUL >> %log_file%

net use s: \\edi\transfer /user:scan
echo Remote Disk Connect End >> %log_file%

[Script] VBA 檔案搬移

[Script] VBA 檔案搬移 
Author: Willie
Date:2012/2/7

目的:利用寫VBA程式讓檔案移動到另一個資料夾,再加上windows排程就可以定時的搬移檔案。


'範例 - 利用 VBA Script搬移附檔名 .bak
'2012/2/7 Willie Chou

On Error Resume Next
Err.Clear

   Set objFSO = CreateObject("Scripting.FileSystemObject")  
   objFSO.MoveFile "D:\a\*.bak" , "d:\b\"
   Set objFSO = Nothing



If Err.Number <> 0 Then

  MsgBox Err.Description
Else
   MsgBox "OK"
End If

[ERP R12] OM Order Line Flow Status Code

OM Order Line Flow Status Code
Date:2011/10/24
Author: Titus, Willie

前言,因為R12OM模組底下多了個Customer Acceptance的設定,這個關系到了OM的Line Flow Status的Code, 因此顧問 Titus 以下的問題:



Q1 .Flow Status Code 不同 Type 下的狀態之意義
CLOSED: Line 完全Closed.
FULFILLED : 指客戶按下 Fulfillment Acceptance 後的狀態嗎?
INVOICE_DELIVERY : Background Process 拋到 AR Interface 的狀態嗎?
PRE-BILLING_ACCEPTANCE : 指等待 Acceptance ?

Titus:
Flow Status Code中,FULFILLED是指已經出貨、尚未到Invoice Interface
INVOICE_DELIVERY 狀態,在form上查看時,是 Awaiting Invoice Interface - Pending Complete Delivery,很可能是它的Delivery還包了其他的Order Line,而其他Order Line尚無法產生AR Interface的資料,導致此Order Line也無法產生(因為同一個Delivery所包的Order Line要一起產生AR Interface資料)

我剛才有發現Wintek SO 111030546 1.2行,停留在INVOICE_DELIVERY status,原因是同張訂單1.3行也是包在同一個Delivery中,但是1.3行的workflow error了,所以1.21.3行都無法關閉。後來利用Worlflow AdminStatus Monitor,將有問題的order line rewind,然後重新執行workflow background process,就正常了。我建議要review有卡住的order line workflow,否則會一直卡住無法走到AR
使用此功能必須使用 System Administrator  才有權限看到所有的 Flow Status





Q2. 流程圖上 Pick & Ship Material ,在R12 上的操作是按下 Ship Confirm 後才開始跑 Acceptance 流程嗎?

Titus:
Customer Acceptance就是指我們出貨後(或提供服務後)在什麼條件下承認應收、承認收入,所以無論是pre-billing acceptancepost-billing acceptance,都是要ship confirm(fulfill)後才依據系統設定有不同的判斷與行為發生。






2012/8/29

[IT] PhoneGap v.s Apache Cordova Cross Platform Solution

PhoneGap v.s Apache Cordova Cross Platform Solution
Author: Willie
Date: 2012/08/29
= = = =




PhoneGap 號稱用它們的語法可以 Build Apps on Both Apple and Android.等7種不同的Mobile Platform,不論成果如何,有這樣的Idea真的很棒,而且重點它也是免費的平台可以供大家使用。另外它也介紹了幾種 Tool for cross platform 的工具給大家使用,看起來都能解決一些平常若是靠自已開發要曠日費時的好用工具(請參考第二個連結)。

URL: http://www.phonegap.com/
            http://www.phonegap.com/tool


上述的PhoneGap是由這個 Apache Project : Apache Cordova 而來,個人認為The Apache Software Foundation 這個非營利組織真的很偉大,許多對IT重要的技術平台都是由它們提供,比如Hadoop ( OpenSource雲端平台) ,等等超過100個案子以上,詳情請見它們的官網嚕!

ASF:http://www.apache.org/ 

   
  PhoneGap: http://incubator.apache.org/cordova/#contribute


Apps Created with PhoneGap:http://www.phonegap.com/app/feature

2012/8/27

[3C家電] 開箱文 - Dirt Devil VS8 Turbo 吸塵器

開箱文 - Dirt Devil VS8 Turbo 吸塵器
Author: Willie Chou
Date: 2012/08/27

-------------
因為家裡缺了一台吸塵器,所以準備要來買進新的,個人最希望買的是Dyson的吸塵器,無奈價格實在不親民,所以另外找到了這台跟Dyson一樣號稱吸力永不衰退的Dirt Devil !!
於是鎖定這台後,在網路拍賣上選了一個八字合的賣家(其實是價格導向的選擇啦~哈),最後購入的價格是 NT 3290 + 100(運費) 。

其實,網路上的價格大同小異,差別會是在配件上,以及PX牌推出可分期的線上刷卡,我買的少了一個配件,算是Devil的一個特色配件"微型渦輪滾",依照賣方的說法是升級成了"紫外線塵蹣吸頭",若是另外再加購台製品(非原廠)要再加 NT 500元,而且不能互換配件。幾經考慮後,還是放棄了加購直接選擇 NT 3,290的All Set 價格。附件如下:

附件:
吸塵器主機*1,集塵杯*1,延伸軟管*1,延伸硬管*1
地板吸頭*1,平板+鬃毛二合一刷頭*1,尖嘴吸頭*1
配件收納袋*1,使用說明書(含保固卡)*1

(原說明書內贈送的氣動渦輪吸頭,直接加碼升級為抑菌除蹣吸頭,故不再附贈氣動渦輪吸頭)

※贈品:紫外線塵蹣吸頭*1(市價NT 1,800元)

用後心得:
使用抑菌除蹣吸頭的時候會感覺吸力不足,除此之外其他的接頭吸力都很足夠,能不用集塵袋的集塵筒清潔很方便,以這個價位來看 C/P值個人覺得蠻高的。以下是我拍攝的圖片可以供大家參考看看。

Dirt Devil 廣告:
很有創意的廣告,是以大法師的背景故事作為開端,看過之後就知道為什麼會有Devil 字眼了,十分搞笑


商品到貨先來一張

拆封時封箱的備註

開箱啦啦啦
配件擺粗來~


側拍寫實照

吸氣口與軟管的銜接

集塵筒的分離式的設計


可以用把灰塵倒出來的 設計



集塵筒還可以拆下來清潔


抑菌除蹣吸頭,須要另外裝上電池,按下把手上方的鈕後會振動,
這樣的設計可能是讓你在吸棉被的時候可以把棉絮拍出來吸走。



紫外線的殺菌光源在吸口的下方

收納方式可以將軟管接合起來


 可以將收納完的軟管掛在主機上


另外一種收納可以將延伸管扣在主機後方

來一張收合起來的整體圖

這就是 Dirt Devil !!





2012/8/23

[ERP R12] OM -Shipping Instruction Attachment Setting


OM -Shipping Instruction Attachment Setting
Date: 2011/08/11
Author: Willie

----------

設定Attachment
Order > Setup > Attachments > Documents




設定Addition Rules, 指定Ship 某客戶時就Attachment 上去,

Rules 也可設定Bill to Address, Customer etc...

[ERPR12] OM -How to Set Up Manual Adjustments

Oracle 原始文件
Willie Chou
2012/08/23




可以定義Modifier,讓UserSO上面直接修改價格(Manual Adjustment):

Doc ID:  Note:134323.1
Subject:  How to Set Up Manual Adjustments?
Type:  PROBLEM
Status:  PUBLISHED
 Content Type:  TEXT/PLAIN
Creation Date:  04-FEB-2001
Last Revision Date:  12-FEB-2001


Problem Description
-------------------

How to set up Manual Adjustments and how to apply them on orders in Order
Management?


Solution Description
--------------------

In order to override the selling price directly on the order line, a manual
discount (to decrease the price) or a manual surcharge (to increase the price)
has to be defined.

The price on the Line can be overtyped, up and down or equal to the original
selling price, if both eligible, manual, overridable surcharges and discounts
have been defined on the line level.  The manual discount will take the original
price and create a discount for the difference in the amount of the new price
and original price.

Setup steps for Manual Adjustments:

1. Automatic Checkbox is unchecked at the modifier list and at line level.
2. Modifier Line is Overrideable.
3. Bucket must be Null.
4. The Pricing Phase will determine when you will be able to override the
   Selling Price:

   A. For lines in the pricing phase 'List Line Adjustment', you CANNOT
      override the selling price without moving to another line or saving the
      order.

   B. For Order Level Adjustment, you CANNOT override the selling price without
      saving the order.

Applying Manual Adjustments:

To manually override the selling price, verify the profile option
OM: Discounting Privileges is set to UNLIMITED.  This allows you to apply all
eligible manual adjustments.  If it is set to Non-Overridable Only then only
non-overridable manual adjustments can be applied. 

You should also make sure that the Enforce Price checkbox for the Transaction
Type is unchecked, so the order allows manual override of the selling price.

On the Sales Order Pad, press the Action button, then View Adjustments. 
In the Modifier Name field, Select the LOV to view the unapplied manual
adjustments for the line.  You can change the rate, amount or enter a
new price for order level or line level adjustments.

On the Sales Order Pad, Line Items Tab, Choose Selling Price LOV to apply
line level manual adjustments.  If there is more than one unapplied manual
adjustment, a list of values will appear.  You can type over the Unit Selling
Price field to apply manual overridable adjustments for the line.
.

--------------------------------------------------------------------------------
Special Notes:

"Product Attribute" must be set to Null; if set to "All Items" the manual adjustment
  will not work.
 
 If can not manually override the selling price, modify the 'Calculate Price Flag' to "Calculate Price"
That will back the pricing phase to "List Line Adjustment".



Setting Sample

Step 1. Enable Discounting Privileges
Path: System Administrator > Profile>System
Application: Order Management
Responsibility: Winnovation - Order Management Super User (可選欲設定的Rep.)
Profile: OM: Discounting Privileges
VALUE Unlimited


Step 2. Define Modifiler for USD
Path: Oracle Pricing Manager > Modifiers > Modifier Setup

Advanced Pricing – Define Modifier


Name
WILLIE-20120113

Number
WILLIE-20120113
Start Date

Currency
USD
Active
Yes
Automatic
No
Modifiers Summary
Modifier No
Level
Modifier Type
Print On Invoice
Automatic
Override
Pricing Phase
Bucket
Automatic
Line
Discount
Yes
No
Yes
List Line Adjustment

Discounts/Charges
Include On Returns
Application Method
Value






New Price
0








Pricing Revise Sample

以下是我在R12 Test環境做的設定,提供給您參考:

1. System Profile OM: Discounting Privileges Responsibility Level 改成 Unlimited





 2. Oracle Pricing Manager職責之下的Modifier Setup,新增一個Modifier,設定內容如之前提供的說明(注意每一個幣別都要設定一組Modifier,才能對各種幣別的訂單都能夠手動改價格)


3. 您可以在 Responsibility Wintek - Order Management Super User 之下任意找一張USD的訂單(訂單行尚未關閉),測試修改價格。(我測試的是112010275這張)

4. 可以在訂單行上按下Actions按鈕,選擇 View Adjustments,查看價格由9.3改成93的效果。


[ERP]OM Workflow 權限


OM Workflow 權限
Date: 2011/07/15
Willie Chou


OM底下若是沒有View workflow 的權限請記得在Menu裡掛上以下功能:

Submenu: Workflow Guest Monitor Application
Function: Workflow Guest Status Diagram
Function:Workflow Activity History

註..EBS版本 R12




2012/8/20

[DotNet]C# Remove HTML Tags

C# Remove HTML Tags

突然要用到去除HTML Tag 的Function 進而Reference 到這篇文章,這文章裡還比較了不同的方式Remove Tag的Performance,可以供大家做參考。令人不意外的的是使用regular expression 的方式會較慢。文章連結如 Link 請大家參照嚕! 

http://www.dotnetperls.com/remove-html-tags

2012/8/7

[ERP R12] WIP - COMPONENT YIELD Vs. COMPONENT SHRINKAGE




COMPONENT YIELD Vs. COMPONENT SHRINKAGE

---------------------------------------
1. Component Yield.
A component yield factor can be entered on the BOM. The navigation path
to do this is Bill of Materials -> Bills -> Bills -> Component Details
alternate region. The default is 1, indicating 100% yield (no loss or
gain).

The gross requirements are divided by the yield factor to generate a
higher component requirement.

New Component usage = usage / yield factor

If 10% of raw material is scrapped in production, then the yield factor is
90%. Component usage for a demand of 100 would be 100 / .90 = 111 (rounded).

Note: You cannot enter component yield for an option class item or for
any components of a planning bill.

2. Component Shrinkage.

In MRP/MPS the shrinkage rate attribute can be used. The navigation path
to do this is Inventory -> Items -> Master Items -> MPS/MRP Planning
alternate region.

Note that a shrinkage rate must be less than 1 (<1).

For a particular inventory item, you can define a shrinkage rate to
describe expected scrap or other loss. Using this factor, the planning
process creates additional demand to cover shrinkage requirements for an
item in order to compensate for loss and maintain supply.

For example, if there is a demand for 100 and a discrete job for 60, then
a planned order would be generated for 40 units to meet the net
requirements, assuming that there is no shrinkage.

If a shrinkage rate of 20% is applied, you assume that you will lose 20%
(or yield 80%) of the current discrete job quantities. For the discrete
job of 60, the net supply is 48 (60 * .80). Since you have a total demand
of 100 and a supply of 48, from the discrete job, the net requirement is 52.
In order to meet the total demand of 100, a suggested planned order of 65
will be recommended to account for the 20% shrinkage ( 52 / (1 - .2) = 65).

Inflated planned order = demand / (1 - shrinkage rate)
Shrinkage demand = [demand / (1 - shrinkage rate)] * shrinkage rate
=> 上述的算式表示依據Shrinkage換算回Shrinkage Demand
Total demand = original demand + discrete job shrinkage + planned order
shrinkage
Using the above example, we have a total demand = 125 (100 + 12 + 13)
=> 也可用 Total 100 Demand / ( 1- 0.2 ) = 125 來計算
Total supply = discrete job + planned order (125 = 60 + 65)

3. Difference.

The difference between shrinkage rate and component yield is:
a) for shrinkage rate, Oracle Master Scheduling/MRP applies the same shrinkage rate to every item on the bill, and
b) for component yield, you can vary the component yield factor for each occurrence of an item on a bill.

-----------------------------------
Reference :Oracle Metalink Document No 102881.1 

2012/8/1

[遊記] 2012.06.30 高雄遊

地點:高雄 MRT 車廂
時間:2012.06.30 

這張是2012.06.30 高雄遊所拍攝的相片,照片的是我的朋友抱著他的女兒,
我是在MRT上拍攝的,當時我們正從瑞豐夜市回來,剛好記錄下這張回憶!

照片中的意外露點為相片增添了幾分趣味,但重點仍是朋友抱著女兒時的爽朗笑容,親情永遠不是金錢能取代的!