Oracle eBS 登入的大致流程如下:
SQL
User Login
↓
ICX_SESSIONS.CREATION_DATE
↓
OHS access_log
↓
oacore_server1.log
↓
FND_LOGINS
↓
FND_USER_RESP_GROUPS_DIRECT
↓
SYSADMIN Profile Option
↓
Workflow / AME / Menu Cache要把「使用者: 以SYSADMIN 為例，它的登入嘗試時間」對應到 Application Tier 的 OHS access log / oacore log，這個時間點本身通常不是從 SQL 直接取得，而是先由 EBS DB 端找出登入時間，再拿 timestamp 去對照 OS log。
Oracle EBS R12.2 的 OHS access_log 會記錄 HTTP request、timestamp、URL、HTTP status 等資訊；oacore 則是 WebLogic Managed Server。參考:Oracle文檔
登入成功，但停留在登入畫面時
其它帳號都登入成功，唯獨某些帳號登入後仍停留在登入畫面，可以朝 Profile:Self Service Personal Home Page mode 查看是否首頁的值是錯的。
解法: 在 resp: System Administrator/Profile/System 將 SYSADMIN 的 Self Service Personal Home Page mode 改為 Framework only
查 SYSADMIN 最近的登入嘗試時間
SQL
/* ============================================================
SYSADMIN - Login Attempt Timestamp
EBS R12.2.x
============================================================ */
SELECT
fu.user_id,
fu.user_name,
fu.last_logon_date,
fu.last_update_date,
fu.last_update_login,
fu.end_date,
fu.start_date
FROM
fnd_user fu
WHERE
UPPER(fu.user_name) = 'SYSADMIN';注意：FND_USER.LAST_LOGON_DATE 並不一定能完整代表「本次登入 HTTP request 的 timestamp」。
查 SYSADMIN 的 ICX Session
SQL
/* ============================================================
SYSADMIN - ICX Session Login Timestamp
EBS R12.2.13
============================================================ */
SELECT
s.session_id,
fu.user_id,
fu.user_name,
s.creation_date,
s.first_connect,
s.last_connect,
s.disabled_flag
FROM
apps.icx_sessions s
JOIN apps.fnd_user fu
ON fu.user_id = s.user_id
WHERE
UPPER(fu.user_name) = 'SYSADMIN'
ORDER BY
s.creation_date DESC;欄位說明:
CREATION_DATE：Session 建立時間（最接近登入時間）FIRST_CONNECT：第一次連線時間LAST_CONNECT：最後活動時間DISABLED_FLAG：Session 是否停用
拿到 timestamp 後查 OHS access_log
例如 SQL 查到：
SQL
SYSADMIN
creation_date
-------------------------
17-AUG-2026 09:03:23就到 Application Tier 查
Bash
# 切換成 applmgr
su - applmgr
# 查詢登入記錄的 log
grep "17/Aug/2026:09:03" \
$IAS_ORACLE_HOME/instances/*/diagnostics/logs/OHS/*/access_log*Oracle 官方文件說明 OHS access_log 會包含：
- Client IP
- Timestamp
- Request URL
- HTTP Status
- Response Size
例如：
Apache
127.0.0.1 - - [17/Aug/2026:09:03:03 +0800] "HEAD /index.html HTTP/1.1" 200 -
127.0.0.1 - - [17/Aug/2026:09:03:23 +0800] "HEAD /index.html HTTP/1.1" 200 -查 WebLogic 的 oacore log
R12.2 的 oacore 是 WebLogic Managed Server，其常見 log 位於：
Bash
# WebLogic log 目錄
$FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/oacore_server1/logs/
# 查詢登入帳號的資訊
cd $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/oacore_server1/logs
grep -i "SYSADMIN" oacore_server1.logR12.2 常見的 oacore log,out 及 diagnostic log 都位於 oacore Managed Server 的 logs 目錄
Bash
Admin server - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/AdminServer/logs/AdminServer.log
oacore logfile - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/oacore_server1/logs/oacore_server1.log
oacore out file - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/oacore_server1/logs/oacore_server1.out
oacore diagnostic log - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/oacore_server1/logs/oacore_server1-diagnostic.log
oafm logfile - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/oafm_server1/logs/oafm_server1.log
oafm outfile - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/oafm_server1/logs/oafm_server1.out
oafm diagnostic log - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/oafm_server1/logs/oafm_server1-diagnostic.log
form server log - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/forms_server1/logs/forms_server1.log
form server access log - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/forms_server1/logs/access.log
form server out file - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/forms_server1/logs/forms_server1.out
form server diagnostic log - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/forms_server1/logs/forms_server1-diagnostic.log
forms-c4ws_server1 log - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/forms-c4ws_server1/logs/forms-c4ws_server1.log
forms-c4ws_server1 out file - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/forms-c4ws_server1/logs/forms-c4ws_server1.out
forms-c4ws_server1 diagnostic log - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/servers/forms-c4ws_server1/logs/forms-c4ws_server1-diagnostic.log
