目前分類:未分類文章 (30)
- Mar 18 Mon 2013 11:18
FND_MESSAGE
- Mar 04 Fri 2011 09:15
{AR} When update the post code of customer address display APP-AR-42301 Error
- Sep 08 Wed 2010 17:55
{Issue} Material Account Lose
- Aug 03 Tue 2010 22:52
{Issue} 無法同時開啟兩個Oracle Forms
- Jul 08 Thu 2010 14:13
Study : Order Header Workflow
OM Order Header Processes
我們在新增OM Order Type時,會需要設定一組”Fulfillment Flow”,選單如下:
而每個Flow代表的流程是什麼呢?
這邊整理〔Order Flow - Generic〕的Flow Chart,供大家查閱..
- May 21 Fri 2010 19:29
{Form} Date Field Setting
- Apr 09 Fri 2010 17:02
{OM} Order type is Ship. Schedule Arrival Date can not be manually change.
<說明> 敝公司教育Order key-in人員訂單都維護Schedule Arrival Date(SAD).,但常常有User會反應有時候會出現以下的錯誤訊息。
Error :
The order type is “Ship”. Schedule Arrival Date can’t be manually change.
Schedule arrival date can be recalculated if you change request date or schedule ship date.
<問題原因>
- Mar 31 Wed 2010 17:02
Navigate Menu does not show all responsibility
- Mar 31 Wed 2010 13:05
{Profile} AP: Show Finally Closed POs
- Mar 15 Mon 2010 11:24
{Form} How to create Select all checkbox
How to create Select all “checkbox”
<Sample>
go_block('RECEIPT_MATCH');
first_recor;
LOOP
:RECEIPT_MATCH.SELECTION_CHECKBOX:='Y';--OR THE VALUE YOU WANT TO PASS
EXIT WHEN :SYSTEM.LAST_RECORD='TRUE';
NEXT_RECORD;
END LOOP;
FIRST_RECORD;
- Jan 12 Tue 2010 18:57
{API} Move Order Backorder
This job is doing backorder all open move order .(ps. it’s not work for WMS move order)
Below is what I do.
For you all reference.
- Dec 27 Sun 2009 15:06
{Form} Install Oracle Form Developer
以下是我安裝Oracle Form Developer 6i 工具紀錄
(Oracle 目前Developer 版本已經出到11g了,但因為我公司的application server,還是舊版的,所以依然還是使用R6做為開發的工具,故僅供有需要的人參考使用)
Software Prerequisition
- Oracle Form 6i
- Oracle Form Patch 16
- Dec 23 Wed 2009 22:51
{Form} Query from View , DML to Table
我們一般在建立一個簡單的Tabular Form的做法如下:
首先我先建立一個View for Query(F11)使用
In general, complex blocks are based on views while simple setup
blocks are based on tables.
透過View來呈現資料是比較簡單的方式:(節錄於Oracle Applications Developer’s Guide)
- 1.Network traffic is minimized because all foreign keys are denormalized on the server
- 2.You do not need to code any POST–QUERY logic to populate non–database fields
3.You do not need to code PRE–QUERY logic to implement query–by–example for non–database fields
[Query Data Souce Name] : View Name
[DML Data Target ]
Column 上的設定
DML Table Column - 要設定一個Primiary Key Column
Non DML Table Column Setting
ps. 此Column 要能夠讓User 從 LOV選擇,並儲存 ID 值到DML table中
注意:如果Column是要Query by view, 但寫入時不寫入DML Table的,其property中”Query Only”要設定成”Yes”(如下圖)
- Dec 18 Fri 2009 10:36
{Memo} 常用的Profile Value
Profile |
Variable |
PO: MFG Organization ID | :$PROFILES$.MFG_ORGANIZATION_ID |
- Dec 01 Tue 2009 18:28
Building a Report with a Barcode 實作
Prerequisites for this example
- 1.Oracle9i database
- 2.Oracle9i Report
Start ==>
1.Download and install the example files
1.1 Go to the Oracle Technology NetworkWeb site(http://otn.oracle.com/product/reports/).Download the files BarcodePaper.zip and BarCodeWeb.zip into a temporary directory on your machine (e.g., d:\temp).
Download Information:
- BarcodePaper.zip download from http://www.oracle.com/technology/products/reports/htdocs/getstart/examples/BarcodeBeanPaper/index.html
BarCodeWeb.zip download from http://www.oracle.com/technology/products/reports/htdocs/getstart/examples/BarcodeBeanWeb/index.html
1.2 Unzip the contents of the file, maintaining the directory structure, into an examples directory on your machine
2. Update the REPORTS_CLASSPATH environment variable
oraclebarcode.jar folder path to your client regedit “REPORTS_CLASSPATH”
ex. ORACLE_HOME/Examples/BarCodeBeanPaper/Scripts/oraclebarcode.jar;
- Dec 01 Tue 2009 13:30
{INV} MTL_SYSTEM_ITEMS_INTERFACE
Updating Item Attributes to NULL
The method to update these columns to NULL is to use the following values:
· for Numeric fields: insert -999999
· for Character fields: insert '!'
· for Date fields: the above list does not include any updateable date fields.
- Nov 03 Tue 2009 15:10
{Form Personalize} New Global Parameter
About Global Parameter or Form Personalize you shall know.
- GLOBAL variables are dynamically created at runtime
- They can hold up to 255 bytes
- They are visible across all forms that are currently running
2 Properties affect them:
- VALUE:
–Creates it if it does not exist
–Always sets the value
- INITIAL VALUE:
–Creates it if it does not exist, setting it to null
–Only sets the value if it is currently null
- Oct 14 Wed 2009 14:20
{Issue} SECURITY ERROR:WFA_HTML.DETAIL
問題:使用Personal Framework 開Workflow List 出現此錯誤
Solution: Reference Doc ID: 296470.1
Starting with Oracle Applications 11.5.10, all PL/SQL web cartridge UI has been obsoleted. As a result, please use the Framework version of Portal. Make sure that the profile option Self Service Personal Home Page is set to FRAMEWORK ONLY at the SITE level and that the Workflow Administrator Web(NEW) responsibility
- Oct 05 Mon 2009 13:23
{HowTo} Cope Cost Type Across Organization
Responsibility : Inventory Super User
1. Choose Organization to Destination Organization
2. Create Cost Type
Path : Setup > Costs > Cost Types
Multi-Org : Share this cost type with other org.
3. Run "Copy Item Information" Concurrent
Path : Costs > Cost Mass Edits > Copy Cost Information
Choose Program Name = "Copy Item Costs Across Organizations"
Parameters
- Copy Option : Remove and replace all cost information
- Sep 25 Fri 2009 15:24
{AR} AR_DISTRIBUTIONS_ALL : Receipt 交易分錄
The AR_DISTRIBUTIONS_ALL table stores the accounting distributions for cash receipts, miscellaneous receipts, adjustments, credit memo applications, cash receipt applications, and bills receivable transactions. The records are joined to the AR_CASH_RECEIPT_HISTORY_ALL, AR_MISC_CASH_DISTRIBUTIONS_ALL, AR_ADJUSTMENTS, AR_RECEIVABLE_APPLICATIONS_ALL, and AR_TRANSACTION_HISTORY_ALL tables.