/ Oracle EBS

如何在 oracle form 上掛入圖片

Notice: 圖片統一放在 OA_MEDIA , 跟 icon 的圖片放一起比較好找

DECLARE
  v_img_path VARCHAR2(500); -- 圖片檔存放路徑
BEGIN
  -- 讀取圖檔路徑, ex./test/AP/testcomn/java/oracle/apps/media
  BEGIN
 
    SELECT VALUE
      INTO v_img_path
      FROM fnd_env_context
     WHERE variable_name = 'OA_MEDIA'
           AND concurrent_process_id =
           (SELECT MAX(concurrent_process_id) FROM fnd_env_context);
 
    -- 把圖片放到圖片物件內
read_image_file(v_img_path || '/cp_map.jpg', 'jpg', 'CP_MAP.MAP_IMG');
  EXCEPTION
    WHEN OTHERS THEN
      fnd_message.debug('無法讀取 CP Map 解說圖檔!!');
  END;
END;
/ Oracle EBS

從 form 上透過呼叫 concurrent 並指定參數

為了澳洲來的使用者, 在標準form上增加一個快速按鈕, 直接從 menu 上執行 concurrent 程式

使用 persionalize 設定步驟如下:

step1. when new form instance, 新增 menu1,

step2. 替 menu1 新增 action, type 選為 builtin

builtin type 選為 execute procedure

argument 設定如下 (使用 fnd_request.submit_request )

='DECLARE 
x_conc_id NUMBER;
BEGIN
 x_conc_id := fnd_request.submit_request(application => ''XX'',
 program  => ''XXOMP002'',
 description => NULL, 
 start_time => NULL, 
 sub_request => FALSE,
 argument1 => ' || 54794 || ',
 argument2 => chr (0),
 argument3 => NULL,
 argument4 => NULL,
 argument5 => NULL,
 argument6 => NULL,
 argument7 => NULL,
 argument8 => NULL,
 argument9 => NULL,
 argument10 => NULL);
 commit;
END'
/ Oracle EBS

比對 Oracle Forms 程式碼

方法1. Convert the fmb in txt and compare using any file comparing tool.

  • File -> Administration -> Object List Report (It will create a txt file in the same directory)
  • Then Compare using any text comparing tool.

or

方法2. Another solution is to convert FMB(binary file) to FMT(Text file).

  • Open your forms, then choose menu File:Administration:Convert:Binary_to_text
  • This optin generate a Source Code in text format, do it with your files, then compare the files with a command like “diff” on linux, that list all differences line by line if exists
/ Oracle EBS

從 menu 開啟 webpage

How to call an HTML webpage from 11i Navigator menu

資料來源：metalink [Doc ID 332500.1]

1. Create new Form Function.

2. Go to Properties Tab -> Type –> SSWA plsql function that opens a new window (Kiosk Mode).

3. Go to Web Host Tab -> Host Name –> http://www.oracle.com

4. Go to Web HTML Tab -> HTML Call –> products/index.html (you need to start at a page under oracle.com, like products , solutions, etc. It will not start at the oracle.com home page).

Note: 332500.1 – How To Call An HTML Webpage From 11i Navigator Menu
Note: 883404.1 – How To Access External Url When Using SSWA PLSQL Function