ITPub博客

AutoInvoice in Oracle Apps R12 AutoInvoice is a powerful, flexible tool you can use to import and validate transaction data from other financial systems and create invoices, debit memos, credit memos, and on–account credits in Oracle Receivables. You use a custom feeder program to transfers transaction data from an external system into the AutoInvoice interface tables. AutoInvoice then selects data from the interface tables and creates transaction in Receivables. Receivables rejec

正常情况下，Oracle EBS里修改用户密码，可以在System administrator> Define user form里更改，但有的时候，开发或者实施需要更快速的更改密码，可以使用下边的这个脚本 DECLARE l_success boolean; BEGIN l_success := FND_USER_PKG.ChangePassword(\'OPERATIONS\',\'welcome123\'); IF l_success THEN DBMS_OUTPUT.PUT_LINE(\'Password Changed\'); ELSE DBMS_OUTPUT.PUT_LINE(\'Somethin

前提：你有apps的数据库账户，想知道某个用户的密码，因为fnd_user中的密码为加密的，所以无法看懂，你可以尝试用下边的方式来查看用户密码。 SQL> desc fnd_user; Name Null? Type ----------------------------------------- -------- ---------------- USER_ID NOT NULL NUMBER(15) USER_NAME NOT NULL VARCHAR2(100) LAST_UPDAT

之前每个模块记录日志的方式都不同，都会把日志写到不同的文件中，对于User来说很麻烦，需要记住很多的配置，现在越来越多的模块使用FND Logging来存储日志，比如WIP，RCV,OAF...FND Debug Log会把Apps的日志输出到FND_LOG_MESSAGES表里。 怎样收集FND的日志 Step 1 profile设置(user级) FND: Debug Log Level,这个level，可以设置为Unexpected，Error，Exception，Event，Procedure或者Statement，一般情况下

Background 公司总部美国，系统时间为美国时间。中国的业务操作人员在EBS中做业务的时候，希望能按照北京时间来展示，而不是美国时间。 Solution 切换到系统管理员职责 > System Profile设置 Server Timezone: 这个仍为美国时区 Enable Timezone Conversions: site级设置为 "YES". Client Timezone: 设置为中国时区，GMT+8,这个profile可以设置在user level。 设置完之后重启应用（

用tar命令（tar -cvfz src.tar.gz src）去压缩一个目录，遇到错误"Error exit delayed from previous errors" 原因选项"f" 表示The archive file name is given on the command line (required whenever the tar output is going to a file)，f后边需要跟压缩文件的名字。 所以把tar命令从"tar -cvfz src.tar.gz src"改成"tar -czvf src.tar.gz src"后，就不会遇到那个错误了。

MSCA Debug Log1. 找到mwa.cfg配置文件In 11i: $MWA_TOP/secure/In R12: $INST_TOP/admin/install/2. 设置mwa.cfg trace level: mwa.LogLevel=TRACE\'mwa.logdir\' 为日志输出路径,R12下，mobile日志会写到$INST_TOP/logs下注：mwa.LogLevel可以设置为: Fatal, Error, Warning, Debug, and Trace.Fatal只有在出现错误的情况才会记录日志. Trace会打出所有日志。因为性能原因，一般情况下不要设置logLevel到TRACE3. 重启mobile Server4. 业务处理, 在日志

How to generate WIP debug log files in ONLINE cases? For 11.5.10 and above, the WIP debug log files will be created if     1. FND: Debug Log Filename = (Make sure this is null)     2. FND: Debug Log Enabled = Yes     3. FND: Debug Log Level = Statement     4. FND: Debug Log Module = WIP% To get the log file, run the following SQL script. This will create an output called MoveON.txt        

A. To generate a debug file from the Shipping Transaction or Quick Ship forms Set the following profile options: OM: Debug Level - set to 5 WSH: Debug Enabled - set to Yes WSH: Debug Level - set to Statement WSH: Debug Log Directory - any directory that can be written to by the database To check, run the following SQL statement: Code: select value from v$parameter where name = \'utl_file_dir\' Set profile option WSH: Debug Log Directory at the Site & Application Level.In

遇到Sales Order或者相关业务流程（eg.pending demand, workflow status, etc.)的问题的时候，可以收集OM模块的日志再进行分析。收集方法：ProfileOM: Debug Level = 5(If it is zero then debug is off. All of the debug messages are displayed if this profile is equal to 5)OM: Debug Log Directory =  /usr/tmp/debug.log路径必须为select value from v$parameter where name = \'utl_file_dir\'中的值，并且用户有对于目录的写权限。转载请注明出处：

Inventory模块日志的收集refer:http://blog.csdn.net/pan_tian/article/details/7688395Order Management模块日志收集方法Refer:http://blog.csdn.net/pan_tian/article/details/7688426Shipping(WSH)模块日志收集方法Refer:http://blog.csdn.net/pan_tian/article/details/7688443FND Debug Log(FND_LOG_MESSAGES)及Concurrent Request日志的收集方法refer:http://blog.csdn.net/pan_tian/article/details/7688987WIP模块日志收集方法Refer:http://blog.csdn.net/pan_tian/article/details/768

对我来说Python主要是作为我提升工作效率的脚本语言，所以os模块是必须熟练掌握的。 os.sep 可以取代操作系统特定的路径分割符。 >>> os.sep \'\\\' os.name字符串指示你正在使用的平台。比如对于Windows，它是\'nt\'，而对于Linux/Unix用户，它是\'posix\'。 >>> os.name \'nt\' os.getcwd()函数得到当前工作目录，即当前Python脚本工作的目录路径。 >>> print os.getcwd()

压缩tar -cvf xxx.tar.gz yourdirectory 解压解压tar gz(Gzip)文件 tar -xzvf mystuff.tgz 解压普通的tar文件 tar -xvf mystuff.tar参数的意义c Create a new archive.t List the contents of an archive.x Extract the contents of an archive.f The archive file name is given on the command line (required whenever the tar output is going to a file)M The archive can span multiple floppies.v Print verbose output (list file names as they are processed).u Add files to the archive if they

grep 语法 grep \'word\' filename grep \'string1 string2\' filename cat otherfile | grep \'something\' command | grep \'something\' command option1 | grep \'data\' grep --color \'data\' fileName 基本的用法 在某个文件里搜索error字符串 $ grep "error" log.txt 忽略大小写搜索(-i) $ grep -i "ErroR" log.txt 所有子目录下的搜索(-r) $ grep -r "exception" log.txt 全字匹配搜索(-w) 如果你搜

Linux环境下Python的安装过程 前言 一般情况下，Linux都会预装 Python了，但是这个预装的Python版本一般都非常低，很多 Python的新特性都没有，必须重新安装新一点的版本，从下边的截图，可以看到我的 linux下，预装Python 的版本非常低，古老的 2.4.3版本。这里我准备安装现阶段稍微主流点的版本 2.7.3。 下载 官网下载地址：http://www.python.org/do

Symptom: APP-FND-00756: Cannot find combination CCID=-1 CODE=GL# SET=50362 Cause: 遇到这种错误，很多时候时候是因为你的科目是无效科目。 CODE=GL#，表示这个在查找Accounting Flexfield CCID=-1，表示选择的科目ID 执行下边的SQL, SELECT * FROM gl_code_combinations_kfv WHERE concatenated_segments LIKE \'01.203010.30102400.00%\'; 如果返回没有值，说明你的科目在系统中不存在 转载请注明出处:http://blog.csdn.ne

Refer:http://tkyte.blogspot.com/2007/04/when-explanation-doesn-sound-quite.html I was asked recently Under what conditions, autotrace & explain plan can not give the correct execution plan of a sql? The question came in email - not via asktom.  But I found it of enough general interest to write about it here.  As an aside, I rarely, if ever, answer questions emailed to me directly.  It just isn\'t a scalable solution.  This is my attempt to make this

TKPROF命令之前我们收集的trace日志仍为Raw Trace，如果要做性能分析的话，往往要转换为TKPROF，TKPROF可以把Raw Trace转换为更易读的形式。TKPROF Command $tkprof tracefile outputfile [explain= ] [table= ] [print= ] [insert= ] [sys= ] [sort= ] ... Sample: TKPROF raw_trace.trc OUTPUTA.TKPROF EXPLAIN=scott/tiger SYS=NO SORT=(EXECPU,FCHCPU) tracefile：你要分析的trace文件outputfile：格式化后的文件explain=user/password@connectstring（

Raw Trace的收集方法 1. 打开Trace，Help > Diagnostics > Trace > Trace > Trace with Binds and Waits Trace项代表的意思 No Trace – turns trace off. Regular Trace – generates a regular SQL trace by performing the following statement:                                ALTER SESSION SET SQL_TRACE = TRUE; Tr

Multi-Org Access Control (MOAC) is used to allow access to multiple operating units from a single application responsibility. Prior to Release 12, Oracle users would have to login to difference responsibilities to enter or process data within an operating unit.A new feature for Release 12, MOAC, allows the creation of a Security Profile and assign as many operating units as required.A video about MOAC.EBS R12 MOAC(Multi-Org Access Control)原理探索 这篇文档从技术的角度很好的讲