關於部落格
  • 24989

    累積人氣

  • 0

    今日人氣

    0

    訂閱人氣

ORACLE 新增簡單的ENTER FORM & 設定

  **修改Form 需注意
Data Blocks
Query Data Source Type =>Table Name
Item => assign Canvases
 
Canvases
Windows
LOV
Column Mapping Properties=>Return item
Trigger
PRE-FORM=>app_window.set_window_position()
Program Units
APP_CUSTOM
if (wnd = 'FORECAST') then
    app_window.close_first_window;
  elsif (wnd = '<another window>') then
 
設定Oracle

1.Create Table in APPS Create Table set unique, 即不會產生重覆資料
 
 
CREATE TABLE ENTER_BUDGET
(
  PERIOD            VARCHAR2(10 BYTE),
  CUSTOMER_NAME     VARCHAR2(200 BYTE),
   unique (PERIOD,CUSTOMER_NAME)
)
 
2. Save the fmb to “$AU_TOP/12.0.0/forms/US/
3. Compile to “$XXPSC_TOP/12.0.0/forms/US/”
 
有些需要呼叫環境變數
bash
bash-3.00$ . APPSPRODUPG_pathfinder.env
 
cd $AU_TOP/forms/US
bash-3.00$ frmcmp_batch module=$AU_TOP/forms/US/XXPSBUGT.fmb userid=apps/pathfind1 output_file=$XXPSC_TOP/forms/US/XXPSBUGT.fmx module_type=form compile_all=special
 
4.Setting Form to Oracle
 
(1). Application Developer->Application->Form

Form XXPSBUGT
Application Custom Applications
User Form Name Customer Budget
Description  Customer Budget
 
(2). Application Developer->Application->Function

   Decription Function CUSTOMER BUDGET
User Function Name Customer Budget
Description Customer Budget
Properties Type Form
Form Form Customer Budget
 
   (3). Application Developer->Application->Menu
   Add to Menu -> MARKETING_MENU

Seq 23
Prompt Enter Customer Budget
Function Customer Budget
Description Marketing Enter Customer Budget
 
相簿設定
標籤設定
相簿狀態