EBS備忘錄

Path: 客戶/Standard/關係
將子公司的編號放入母公司的「相關客戶」列表即可

 
1. Commit
針對Form操作和代碼進行Commit，若Form上的異動和代碼中的資料異動有衝突，以介面上的為主。
2. Commit_form
針對Form上的資料異動做Commit，對於代碼中的類似update、insert語句也進行提交，如果Form上的資料異動和代碼中的異動有衝突，以介面上的為主。

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

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

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

設定：
responsibility:系統管理員
path:設定檔/系統
%登入稽核% 層級：Form

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

語法：
  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.

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

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