|
给弟弟妹妹指导下怎么操作,不要一个一个的找,做个trace什么都出来了,超级容易,半个小时就搞定了:
一、 配置如下系统文件
以下配置文件均为用户级别的配置文件,如果模块不同,则相应的更改配置即可。
1. All transactions:
a. RCV: Debug Mode=Yes
b. FND: Debug Log Enabled=Yes
c. FND: Debug Log Level=Statement
d. FND: Debug Log Module=po%
2. a. TP:INV Transaction processing mode= On-line
b. INV: Debug Trace=Yes
c. INV ebug Level=11
d. INV: Debug file (Including the complete path)=<valid directory path plus file name>
3. a. OM: Debug Level = 5
b. OM: Debug Log Directory = <valid directory path>
4. a. RCV: Processing Mode=Immediate or Batch:
PO:Enable Sql Trace for Receiving Processor=Yes
b. RCV: Processing Mode= Immediate:
二、 日志追踪
在Transaction processing mode处理模式中的类型要定义为Immediate,这样EBS的并发请求中会提交运行请求,根据请求编号来查找日志文件。需要提供&p_request_id作为日志追踪的条件,运行如下sql即可。在结果中找到对应的报错类型进行相应的操作。
SELECT TO_CHAR (TIMESTAMP,'DD-MON-YY HH24:MI:SS'),
User_Id,
SUBSTR (message_text,1,300),
SUBSTR (module,1,80),
log_sequence
FROM fnd_log_messages
WHERE TRUNC(TIMESTAMP) = TRUNC(sysdate)
AND process_id =
(SELECT os_process_id
FROM fnd_concurrent_requests
WHERE request_id =
&p_request_id
)
AND module NOT LIKE 'fnd%'
ORDER BY Log_Sequence;
|
|