EBS備忘錄 | 不設分類分享 | 痞客邦

Oct 28 Wed 2015 16:30
LOV尺寸設定、呼叫

LOV欄位寬度
Column Mapping Property:(單位：inch)
寬度1剛好可顯示8個中文字

(繼續閱讀...)

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

個人分類： FORM

▲top

Dec 01 Wed 2010 17:16
(轉)關於Form中各種commit的說明

(繼續閱讀...)

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

個人分類： FORM

▲top

Sep 06 Mon 2010 11:20
幾個Trigger的觸發時機

case 1: leave the empty field in new record
case 2: retrieve a value from the DB
case 3: leave field unchanged
case 4: leave field with changed value

(繼續閱讀...)

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

個人分類： FORM

▲top

Aug 02 Mon 2010 13:14
Stacked Canvas步驟

1.新增一個Canvas
Name: Can_Stack
Type: Stacked
Subclass: Canvas Stacked

(繼續閱讀...)

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

個人分類： FORM

▲top

Aug 02 Mon 2010 11:13
Query_Find的BUG

frm-40831:欄位長度太長被截斷(TRUNCATION OCCURRED:value too long for field XXXXXXX)
解法：將該欄位的最大長度(Maxium Length)調到125以上
ora-01898:精準度的設定值過多
解法：不明

(繼續閱讀...)

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

個人分類： FORM

▲top

May 26 Wed 2010 09:55
Stacked Canvas常見問題

1.Canvas發生相互覆蓋，選A Canvas會蓋掉B Canvas，反之亦然
A:Canvas間的間距太小，拉寬就可
2.Satcked Canvas出不來
A:調整Object Navigator裡Canvas間的順序，依序為Content Canvas、Stacked Canvas A、Stacked Canvas B

(繼續閱讀...)

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

個人分類： FORM

▲top

May 06 Thu 2010 15:35
FND_PROFILE.VALUE備忘

語法：
var:=FND_PROFILE.VALUE('user_id');

USERNAME

Your user's current Oracle Application Object Library username.

USER_ID

Your user's current Oracle Application Object Library user ID.

RESP_ID

Your user's current responsibility ID.

APPL_SHRT_NAME

The short name of the application connected to your user's current responsibility.

RESP_APPL_ID

The application ID of the application connected to your user's current responsibility.

FORM_NAME

The name of the current form. Not available for concurrent programs.

FORM_ID

The form ID of the current form. Not available for concurrent programs.

FORM_APPL_NAME

The name of the application for which the current form is registered. Not available for concurrent programs.

FORM_APPL_ID

The application ID of the application for which the current form is registered. Not available for concurrent programs.

LOGON_DATE

Your user's logon date for the current session.

LAST_LOGON_DATE

Your user's logon date for the previous session.

LOGIN_ID

Your user's Sign–On Audit login ID in Oracle Application Object Library.

CONC_REQUEST_ID

Instance of your running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the REQUEST_ID Who column.

CONC_PROGRAM_ID

The program ID associated with a running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the PROGRAM_ID Who column.

CONC_PROGRAM_APPLICATION_ID

The application ID associated with a running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the PROGRAM_APPLICATION_ID Who column.

CONC_LOGIN_ID

The login ID associated with a running concurrent program. You can only use this profile option in a concurrent program. You can use this profile option to fill the LAST_UPDATE_LOGIN Who column.

CONC_PRINT_OUTPUT

The value Yes or No that you enter in the Print Output field when you register a concurrent program. You can use the routine afpoput() from your concurrent programs to change the value of this profile option for a particular instance of your running concurrent program. This profile option determines whether the concurrent managers print the concurrent program's output to the printer.

CONC_PRINT_STYLE

The print style of your concurrent program's output that you enter in the Print Style field when you register a concurrent program. You can use the routine afpoput() from your concurrent programs to change the value of this profile option.

(繼續閱讀...)

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

個人分類： FORM

▲top

May 06 Thu 2010 15:33
FND_GLOBAL package

FND_GLOBAL package 可以抓取大多數的環境變數
1.FND_GLOBAL.USERID --Returns userid
2.FND_GLOBAL.APPS_INTIALIZEprocedure APPS_INITIALIZE(user_id in number,resp_id in number,resp_appl_id in number);
This is used to set the values userid and responsibilityid for a session
3.FND_GLOBAL.LOGIN_ID -Gives login id
4.FND_GLOBAL.CONC_LOGIN_ID--Not sure how to use this
5.FND_GLOBAL.PROG_APPL_ID--Concurrent program application id
6.FND_GLOBAL.CONC_PROGRAM_ID--Concurrent program id
7.FND_GLOBAL.CONC_REQUEST_ID (Server)This will give the concurrent request id of the program which is calling the plsql package..

(繼續閱讀...)

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

個人分類： FORM

▲top

May 06 Thu 2010 15:15
Form系統變數

$$DATE$$
$$DATETIME$$
$$DBDATE$$
$$DBDATETIME$$

(繼續閱讀...)

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

個人分類： FORM

▲top

May 04 Tue 2010 15:01
Coalesce函數

Coalesce(A,B,C)
大致是這樣
if A is not null then

(繼續閱讀...)

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

個人分類： FORM

▲top

May 03 Mon 2010 13:40
Query_Find

使用Query_Find可以啟用EBS的手電筒功能，步驟如下：
1、修改QUERY_FIND的BLOCK，CANVAS，WINDOW 名字，沒改也無妨
2、修改 NEW 按扭的TRIGGER

(繼續閱讀...)

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

個人分類： FORM

▲top

Mar 05 Fri 2010 13:17
FORM Trigger正規方式

在FORM開發中不管是FORM級還是BLOCK級或者ITEM級的TRIGGER，不要把代碼直接寫到TRIGGER中，要使用PROGRAM UNIT來創建相應的TRIGGER，舉例如下：
FORM級和BLOCK級可以按照下面格式在PROGRAM UNIT中創建PACKAGE：
PACKAGE BODY FORM_NAME/BLOCK_NAME IS
PROCEDURE EVENT_HANDLER( EVENT IN VARCHAR2) IS
BEGIN
IF EVENT = 'WHEN-NEW-FORM-INSTANCE' THEN
    XXXXXXXX;
ELSIF EVENT = 'PRE-FORM' THEN
    XXXXXXXX;
ELSE
    APP_EXCEPTION.INVALID_ARGUMENT('EVENT_HANDLER', 'EVENT', EVENT);
END IF;
END EVENT_HANDLER;
END FORM_NAME/BLOCK_NAME;
ITEM級的可以按照下面的格式：
PACKAGE BODY BLOCK_NAME IS
PROCEDURE ITEM_NAME( EVENT IN VARCHAR2) IS
BEGIN
IF EVENT = 'WHEN-NEW-ITEM-INSTANCE' THEN
    XXXXXXXX;
ELSE
    APP_EXCEPTION.INVALID_ARGUMENT('ITEM_NAME', 'EVENT', EVENT);
END IF;
END ITEM_NAME;
END BLOCK_NAME;

(繼續閱讀...)

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

個人分類： FORM

▲top

mm

參觀人氣

成人內容提醒