Oracle ERP R12. Material Transaction Control use period control(INV: Transaction Date Validation).

雖然目前Oracle ERP 有 Peroid control的功能,但是每到月初,因上期的帳尚未結完,故無法將Inventroy的period予以關結(Ps : Inventory period一經關結是不能再打開的)
故Oracle在Profile上有定義以下几種選項:
1. Allow date in any open period : 只要該period是open的,其material transaction可以做在該period
2. Do not allow date in past period : material transaction只能做在本期Open period. (但可以是本期Open period內過去的任何一天,只要是Open period,且Oracle似乎不可以輸入未來的日期)
3. Do not allow past date : material transaction只做在今天以後的所有Open period. (但Oracle似乎也不予許輸入未來的交易,故該選項其實就只能輸入現在的日期,及其必需為Open period)
4. Provide warning when date in past period : 當material transaction為過去的Open period,則只顯示警告,但不予卡關!

Oracle R12 E-Business Suite Timeout Parameters and Profiles (Oracle ERP逾時設定)

• ICX Timeout Profile Values (Oracle ERP逾時設定)

Parameter	Default	Recommendation
ICX:Session Timeout	None	30 (minutes)
ICX: Limit Time	4 (hours)	4 (hours)
ICX: Limit Connect	1000	2000

          

·  ICX:Session Timeout  : 使用者閒置多久沒有作動,就自行將其登出之設定,就是所謂的 Idle time.

  (This profile option determines the length of time (in minutes) of inactivity in a user's form session before the session is disabled.  Note that disabled does not mean terminated or killed.  The user is provided the opportunity to re-authenticate and re-enable their timed-out session. If the re-authentication is successful, the disabled session is re-enabled and no work is lost. Otherwise, the session is terminated without saving pending work.  This functionality is available via Patch 2012308 (included in 11.5.7, FND.E).  Note: Setting the profile value to greater than 30 minutes can drain the JVM resources and cause ‘out of memory’ errors.)

·  ICX: Limit time : 最大連線時間.

  (This profile option defines the maximum connection time for a connection – regardless of user activity.  If 'ICX:Session Timeout' is set to NULL, then the session will last only as long as 'ICX: Limit Time', regardless of user activity.  )

· ICX: Limit connect : 最大連線數

  (This profile option defines the maximum number of connection requests a user can make in a single session. Note that other EBS internal checks will generate connection requests during a user session, so it is not just user activity that can increment the count. )

開心農場20110730 - 收成

趁今天週六沒上班,趕快來整理農場,平常可真苦了農友一號 ="=!

百香果又長大一吋了

玉米也長大許多了

一株最有希望的高麗菜 (又包一層了)

 芥藍菜大部分採收(有嚴重蟲害,只留几株),並鬆土

王米已出穗了 ^0^

奇怪,芒果葉怎麼一點一點黑黑的,難道是蟲害,還是螞蟻啃的 ?

收成下來的芥藍菜,.......這次應該沒錯吧.......這應該叫芥藍菜吧.....

開心農場20110723 - 施肥

今天對農場施肥~~
這就是昨天被我誤下毒手的茄子 , 葉子都被當芥菜給摘了 ="=!

百香果正努力的向上長大中. ^_^

農場現況

開心農場20110722 – 農害(Bug)

可惡的bug ~><~

芥菜說 : 我不行了,死給你看 .....

這株高麗菜有希望 - 已在包葉了喔

農場現況 - 王米生長最為明顯

喔~收成給老婆大人炒菜囉,............
結果被笑到不行,因為........
我以為這是芥菜,.....結果這是茄子的葉子.......="=!
所以說........茄子可能來不及長大了.....="=!

Oracle ERP R12. WIP Material Transactions 發料異常

最近因為user一直反應有庫存,但是工單發料時,系統卻顯示庫存不足,但是查了一下庫存,其available和pending的資料,卻都很正常,所以跟user模擬一下操作方式後,發現這可能是Oracle ERP R12的bug.以下是操作步驟

步驟 :
1. WIP Material Transactions
1.1. Input Job (:WIPTXMAT.WIP_ENTITY_NAME)
1.2. Input Subinventory (:WIPTXMAT.SUBINVENTORY)
1.3. Click Open (:CONTROL.OPEN_BUTTON)
1.3.1. Input Locator (:MTL_TRX_LINE.LOCATOR) - <Option , if locator control>
1.3.2. Input Quantity (:MTL_TRX_LINE.TRANSACTION_QUANTITY)
1.3.3. Click Lot/Serial (:CONTROL.LOT_SERIAL_BUTTON)
1.3.3.1. Input Lot Number (:LOT_ENTRY.LOT_NUMBER)
1.3.3.1.1. See the lov's Quantity is enough .
1.3.3.1.2. See the Quantity Available (:LOT_QUANTITY.QAT)
                 ==> LOV's Quantity <>:LOT_QUANTITY.QAT !
                       (例如:LOV是1000,但是在Quantity Available上卻帶出其它lot的數量)
1.3.3.2. Input Quantity (:LOT_ENTRY.TRANSACTION_QUANTITY) - the same lov's Quantity
1.3.3.3. Message show Negative balances is not allowed.
如上步驟,因為1.3.3.1.2.中其Quantity Available (:LOT_QUANTITY.QAT )因為疑似帶錯,所以可能就會誤判可用庫存不足以發料.

故初步分析其大部分只會發生在當可用庫存批號多於一筆時,因為只有多筆才會帶錯資料.

結論 : 若Oracle尚未Release patch前,則只要步驟1.2.不要指定Subinventory即可,改至明細資料內Subinventory (:MTL_TRX_LINE.SUBINVENTORY_CODE)輸入,就可以避開止一Bug.

concurrent program define上傳/下載

1.由來源端 , 用預設路徑

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct MYREPORT.ldt PROGRAM APPLICATION_SHORT_NAME="MYAPPLICATION" CONCURRENT_PROGRAM_NAME=" MYREPORT "

2.FTP, 將   /home/?????/MYREPORT.ldt 由來源端搬出至PC

3.FTP, 將  MYREPORT.ldt 由PC上傳至 目的端  /home/?????

4.登入目的端

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct MYREPORT.ldt CUSTOM_MODE=FORCE

上述動作, 一次搬一支程式, 且只有完成Concurrent中的2個動作.

Oracle ERP R12 查詢WEB畫面上欄位 table

例：欲查詢(NO1.)web上的match approval Level欄位 / 游標置於該畫面

1.     點(NO.2) About this Page

2.     點選(NO.3) Page /(NO.4) Expand All

3.     尋找Name欄：message….Match Approval Level…之View Object欄位 / 並點選Supplier VO

4.     Query處即有該table及欄位可查詢

開心農場-20110706

農場新作物 (香茅)

葉萵苣 & 莧菜 全數陣亡 ="=! 只剩插苗的部分較為頭好狀狀

病蟲害較為嚴重的一株

百香果也長大了點