目前日期文章:200912 (12)

瀏覽方式: 標題列表 簡短摘要

以下是我安裝Oracle Form Developer 6i 工具紀錄

(Oracle 目前Developer 版本已經出到11g了,但因為我公司的application server,還是舊版的,所以依然還是使用R6做為開發的工具,故僅供有需要的人參考使用)

Software Prerequisition

  • Oracle Form 6i
  • Oracle Form Patch 16

基本上Oracle Form 6i Tool 應該可以在OTN下載的到,但是我實在是找不到link..所以無法提供給大家download位置,下次如果我不小心找到連結位置,會再Post上來跟大家分享。

下圖僅是我自己以前的保存的安裝檔

SomebabyTina 發表在 痞客邦 PIXNET 留言(3) 人氣()

我們一般在建立一個簡單的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)

SomebabyTina 發表在 痞客邦 PIXNET 留言(1) 人氣()

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 '!'

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

触发器执行顺序:

1. 当打开FORM时:

(1) PRE-FORM

(2) PRE-BLOCK(BLOCK级)

(3) WHEN-NEW-FORM-INSTANCE

(4) WHEN-NEW-BLOCK-INSTANCE

(5) WHEN-NEW-RECORD-INSTANCE

(6) WHEN-NEW-ITEM-INSTANCE

2. 当填写一行记录完成后,光标移动到下一条记录的时候:

(1) WHEN-VALIDATE-RECORD
(只将填写的记录与数据库中已存在的记录作唯一性的验证,如果只是页面上的数据重复而数据库中没有与其重复的值则不会报错.)

(2) WHEN-NEW-RECORD-INSTANCE

(3) WHEN-NEW-ITEM-INSTANCE

3. 当点击“保存”时

(1) WHEN-VALIDATE-RECORD
(将页面上的所有数据提交到数据库,若页面上有重复的数据,则提交第一次时成功但只是将数据先写到数据库中一类似临时表的地方,在提交第二条重复记录的时候报错,执行事务回滚,原来执行成功的指令也将被撤消)

(2) PRE-INSERT

(3) ON-INSERT

(4) POST-INSERT

(5) POST-FORMS-COMMIT

(6) PRE-BLOCK(BLOCK级)

(7) KEY-COMMIT

(8) WHEN-NEW-ITEM-INSTANCE

4. 当光标移动到当前数据块中已经显示的行上时:

(1) WHEN-REMOVE-RECORD

(2) WHEN-NEW-RECORD-INSTANCE

(3) WHEN-NEW-ITEM-INSTANCE

当在该行上的不同ITEM移动时:

(4)WHEN-NEW-ITEM-INSTANCE

5. 当要进行修改时(在记录中的某个项上进行了修改时):

(1)ON-LOCK

6. 在修改完成后进行保存时:

(1) WHEN-VALIDATE-RECORD

(2) PRE-UPDATE

(3) ON-UPDATE

(4) POST-FORMS-COMMIT

(5) PRE-BLOCK(BLOCK级)

(6) KEY-COMMIT

(7) WHEN-NEW-ITEM-INSTANCE

7. 删除一条记录时:

(1) ON-LOCK

(2) WHEN-REMOVE-RECORD

(3) KEY-DELREC

(4) WHEN-NEW-RECORD-INSTANCE

(5) WHEN-NEW-ITEM-INSTANCE

8. F11查询过程:

(1) WHEN-CLEAR-BLOCK

(2) WHEN-NEW-RECORD-INSTANCE

(3) WHEN-NEW-ITEM-INSTANCE

在输入查询条件后点CTRL+F11:

(4) PRE-QUERY

(5) WHEN-CLEAR-BLOCK

(6) POST-QUERY

(7) WHEN-NEW-RECORD-INSTANCE

(8) WHEN-NEW-ITEM-INSTANCE

9. CRRL+F11:

(1) WHEN-CLEAR-BLOCK

(2) PRE-QUERY

(3) WHEN-CLEAR-BLOCK

(4) POST-QUERY(每查一条记录,触发一次)

(5) WHEN-NEW-RECORD-INSTANCE

(6) WHEN-NEW-ITEM-INSTANCE

10. 从查询状态(F11)转为输入状态(F4)时:

(1) WHEN-CLEAR-BLOCK

(2) KEY-EXIT

(3) WHEN-NEW-RECORD-INSTANCE

(4) WHEN-NEW-ITEM-INSTANCE

11. 手电筒查询过程:

(1) QUERY_FIND(BLOCK级)

输入查询条件后,点击“查询”按钮:

(2) WHEN-CLEAR-BLOCK

(3) PRE-QUERY

(4) WHEN-CLEAR-BLOCK

(5) POST-QUERY

(6) WHEN-NEW-RECORD-INSTANCE

(7) WHEN-NEW-ITEM-INSTANCE

12. 点击“New”时:

(1) WHEN-NEW-RECORD-INSTANCE

(2) WHEN-NEW-ITEM-INSTANCE

13. 点击“Edit Field”时:

(1)KEY-EDIT

14. 点击“Window Help”时:

(1)KEY-HELP

15. 点击“Clear Record”时:

(1) WHEN-REMOVE-RECORD

(2) POST-QUERY

(3) WHEN-NEW-RECORD-INSTANCE

(4) WHEN-NEW-ITEM-INSTANCE

16. 点击F4关闭时:

(1) KEY-EXIT

(2) POST-FORM

17. 点击“Close Form”按钮关闭时:

(1) KEY-EXIT

(2) POST-FORM

18. 点击“Translations”按钮时:

(1)TRANSLATIONS

19. 点击小叉号关闭时:

(1) WHEN-WINDOW-CLOSED

(2) CLOSE-WINDOW

(3) KEY-EXIT

(4) POST-FORM

20. 选中LOV列表:

(1) KEY-LISTVAL

(2) WHEN-NEW-ITEM-INSTANCE

21. 选中记录前面的小条时:

(1) WHEN-NEW-RECORD-INSTANCE

(2) WHEN-NEW-ITEM-INSTANCE(数据项级)

(3) WHEN-NEW-ITEM-INSTANCE

22. 光标上下移动时

(1) WHEN-NEW-RECORD-INSTANCE

(2) WHEN-NEW-ITEM-INSTANCE


SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Profile

Variable

PO: MFG Organization ID :$PROFILES$.MFG_ORGANIZATION_ID
 

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Oracle ERP改成Web Login後造成有些Function無法Launch Form

 

Oracle的建議請參考(Metalink: 149358.1 )

重點Responsibility Key不要用特殊字,中文字,還有 空白

如果採用Data Fix, 需更新下面3個Table

FND_RESPONSIBILITY
WF_LOCAL_ROLES

WF_LOCAL_USER_ROLES

 

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

有一個已經Allocate的Move Order的Sales Order Line被Cancel, 但Move Order Line卻未被Close, 造成Reserve住庫存, 致使新的Move Order無法順利執行Allocate

解決方法,可參考Notes:338740.1,有一設定值可使用

Go into the responsibility: Inventory
Goto Inventory > Setup > Organization > Parameters
Goto the first tab "Inventory Parameters"

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

ERP 中選不到國別

Reference : Notes, 277121.1與404331.1.

新增SQL如下 :

INSERT INTO FND_TERRITORIES (TERRITORY_CODE,
                             LAST_UPDATE_DATE,
                             LAST_UPDATED_BY,
                             CREATION_DATE,
                             CREATED_BY,

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

資料來源

CustomerImport

11i Customer Interface Vs Oracle Base table

Here is summarize information for interface Vs base table. Once Customer Import get completed successfully , the data moved to these tables:

customerinterfaceFlow

SomebabyTina 發表在 痞客邦 PIXNET 留言(2) 人氣()

Prerequisites for this example

  1. 1.Oracle9i database
  2. 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:

  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;

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Bat file

<<test_ftp.bat>>==content==

date /T>>%date:~0,4%%date:~5,2%%date:~8,2%.log
time /T>>%date:~0,4%%date:~5,2%%date:~8,2%.log
ftp -n -s:ftpscript.txt>>%date:~0,4%%date:~5,2%%date:~8,2%.log

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

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 '!'

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

找更多相關文章與討論