ebs log and output file path
来源:互联网 发布:湖广填四川 知乎 编辑:程序博客网 时间:2024/04/25 23:38
select t.logfile_name,t.outfile_name from fnd_concurrent_requests t
where t.request_id = _request_id
4、Oracle EBS Request的Output和Log放置的路径
log 信息是放在
/ora11510/oracle/devcomn/admin/log/DEV_xxxx/
/hcable/prog/xxxcomn/admin/out/xxx_hcl/
下面的,文件命名方式?
l + request id + .req
output 信息是放在
/ora11510/oracle/devcomn/admin/out/DEV_xxxx/
/hcable/prog/xxxcomn/admin/out/xxx_hcl/
下面的,文件命名方式?
o + request id + .out
CREATE OR REPLACE PACKAGE xxwip_test_if001
AS
PROCEDURE main(
errbuf OUT VARCHAR2, -- エラーメッセージ
retcode OUT VARCHAR2); -- リターン・コード(xxfnd_101_md001_pkg.gcv_success : 正常
-- xxfnd_101_md001_pkg.gcv_warning : 警告
-- xxfnd_101_md001_pkg.gcv_error : エラー)
END xxwip_test_if001;
/
CREATE OR REPLACE PACKAGE BODY xxwip_test_if001
AS
PROCEDURE main(
errbuf OUT VARCHAR2, -- エラーメッセージ
retcode OUT VARCHAR2) -- リターン・コード(xxfnd_101_md001_pkg.gcv_success : 正常
-- xxfnd_101_md001_pkg.gcv_warning : 警告
-- xxfnd_101_md001_pkg.gcv_error : エラー)
IS
lvv_msg VARCHAR2(2000);
BEGIN
lvv_msg := 'ファイル名' || CHR(9) ||
'行番号' || CHR(9) ||
'在庫組織コード' || CHR(9) ||
'製造オーダー区分' || CHR(9) ||
'組立品' || CHR(9) ||
'完了日';
fnd_file.PUT_LINE(
WHICH => fnd_file.OUTPUT,
BUFF => lvv_msg);
lvv_msg := 'data.csv' || CHR(9) ||
'100' || CHR(9) ||
'113' || CHR(9) ||
'100' || CHR(9) ||
'電気' || CHR(9) ||
TO_CHAR(SYSDATE,'yyyy-mm-dd');
fnd_file.PUT_LINE(
WHICH => fnd_file.OUTPUT,
BUFF => lvv_msg);
EXCEPTION
WHEN OTHERS THEN
errbuf := SQLERRM;
retcode := xxfnd_101_md001_pkg.gcv_error;
END main;
END xxwip_test_if001;
/
- ebs log and output file path
- Define and output a file
- File Input and Output(1)
- [Language]File Input and Output
- Log file location for Oracle EBS R12
- Log file and logwatch
- Two output file names resolved to the same output path
- log file switch and log file sync
- ORACLE EBS中查看某个Request的Output File
- ORACLE EBS中查看某个Request的Output File
- Path to log file not valid: log/mongrel.log问题
- How to variable path of log output via log4net
- File Input and Output with R
- show log file info and log switches
- EBS log
- EBS log
- EBS log
- Open File and Open Path
- VSS 2005
- Determining the Size of a Class Object
- ebs 新老系统切换消息导入脚本
- 将SQL2000数据库升级到SQL2005
- 8.04版本liveCD安装到94%时出现GRUB致命错误的问题解决
- ebs log and output file path
- 数据流盘高速存储读取技术最新进展
- OSI 模型层以及各层协议
- 一些IBM内部定义的最新 cutting edge role
- 类型转换
- 二叉树
- 更改系统/启动驱动器号
- The "Exec" task needs a command to execute,[小问题,大麻烦,vs2005的貌似BUG的设定]
- 程序员五点建议