ITPub博客

相信很多人学习Oracle EBS，都是使用Oracle自带的Vision Demo环境，Vision环境组织架构很复杂，chen_7733在ITPUB上传了一个相当棒的文档，详细介绍了Vision环境的组织架构图。文档下载地址：http://www.itpub.net/thread-790530-1-1.html ，除了前面这个，另外再推荐一个Vision Demo组织架构图的好文档：http://www.erp100.com/forum.php?mod=viewthread&tid=97822

拿到一个陌生的Form，想知道某个菜单项到底在Form中对应的是哪个SpecialX Trigger，可以使用这个方法。打开Custom Code中的Show Custom Events然后点的菜单项，然后就可以知道这个菜单项到底是哪个SpecialX Trigger了。

Detail Log for GL programsUsed for concurrent request problems where we need to know what sql was used in key areas or we need  to retain temporary tables. Note: Be aware that temp tables are never dropped so leaving this on will create a build up of many temporary tables throughout GL, like gl_posting_interim_nnnnn1. Set GL: Debug Mode profile option to Yes, run the program and provide the program log.Note: This profile option introduced in GL 11i FP.D initially allowed 5 main GL concurr

1) Check value of  profile option :AR: Enable Debug Message Output, it should be set to Yes 2) Run the following select statement to determine where the log will write to : select value from v$parameter where upper(name) = \'UTL_FILE_DIR\' this returns something like : VALUE -------------------------------------------------------------------------------- /usr/tmp, /usr/tmp, /u01/oracle/mc3yd213/db/tech_st/11.1.0/appsutil/outbound/mc3yd213_bej301441, /usr/tmpThe above is just an examp

一个早上读完了《20个月赚130亿-YouTube创始人陈士骏自传》这本书。这本书的书名实在是太俗了，公开场合下还真不太好意思给别人看到这本书的书名，太露骨了。要不是有人推荐，还以为又是成功学之类的书，不过书的内容还不错，详细讲述了Youtube创始人陈士俊的创业史，文笔也算流畅。看完书后，第一感觉就是这家伙怎么这么很幸运，连作者本人在书中多次提到自己的幸

1.My Oracle Support (MOS), Link:http://support.oracle.com2. Patches & Updates页签下，Patch Name or Number输入6880880 ， 并且选择正确的平台根据你的的Release版本来下载Opatch把旧的$ORACLE_HOME/Opatch目录备份，然后把刚下载的文件拷贝到对应的ORACLE_HOME下，并解压。Example:$ cd $ORACLE_HOME (If an OPatch directory already exist then move it) $ mv Opatch /TEST/OPatch_100057 $cd $ORACLE_HOME $ unzip p6880880_101000_LINUX64.zip Archive: p6880

命令：opatch lsinventory用于查看数据库所打Patch的列表。但运行的时候发现错误：[oracle@bej301441 OPatch]$ opatch lsinventory Invoking OPatch 11.1.0.6.2 Oracle Interim Patch Installer version 11.1.0.6.2 Copyright (c) 2007, Oracle Corporation. All rights reserved. Oracle Home : /u01/oracle/mc3yd213/db/tech_st/11.1.0 Central Inventory : n/a from : OPatch version : 11.1.0.6.2 OUI version : 11.1.0.7.0 OUI location : /u01/oracle/mc3yd213

$AD_TOP/sql 下有许多非常有用的脚本。Script11.0.x10.7NCA10.7SC/16.1Descriptionadcompsc.plsxxxCompile objects in a given schemaadcpresp.sqlx  The script duplicates rows in FND_RESPONSIBILITY in the following way: Find data_group_id dg_id for the given data_group_name.For each row with data_group_id 0 in FND_RESPONSIBILITY, look fora corresponding row with data_group_id dg_id, with the same application_id,and responsibility_name that only differs in the given suffix string s

OPM全称Oracle Process Manufacturing,即Oracle流程制造，和离散制造（Discrete Manufacturing）不同，流程制造主要应用于制药，食品行业。Process Manufacturing vs Discrete Manufacturing流程式制造(Process Manufacturing)是通过一条生产线将原料制成成品，比如集成电路、药品及食品/饮料制造等。流程式制造(Process Manufacturing)特点：生产计划方面，计划制定简单，常以日产量的方式下达计划，计划也相对

Standalone (one-off) Patch:Addresses a single fix or enhancement. Standalone patches are released only when there is an immediate need for a fix or enhancement that cannot wait until an aggregate bundling is available.The One-off patch category was common in the older versions R11 (11.0.x) and early releases of 11i. Typically, they fix single or isolated set of bugs.Rollup Patch (RUP):An aggregation of patches that may be at the functional level, or at a specific product/family release level.

五一假期，和十几个大学同学在广西小聚了几天，算是毕业后聚得人最多的一次了，现在我的这些同学也基本都是拖家带口了，很多都发福了不少，也有头顶开始"地中海"的了。我们这一帮子人一起，少不了胡吃海喝，晚上专找有大通铺的旅店住，通宵斗地主，还在桂林西街的小网吧群殴CS，SC这种古典游戏（热键都忘光了），好像一下子穿越回到了大学那段时光。回

XML Template Example1.Responsibility:XML Publisher Administrator2.Home > Data Definitions3.In \'Search\' area,enter \'Min-max planning report (XML)\' into name field,and query4.click query result - Min-max planning report (XML)5.press \'Update File\' button,upload the new date template file INVISMMX_XML.xmlRTF Template Example1.Responsibility:XML Publisher Administrator2.Home -> Templates,Query with Name:"Min-max planning report (XML)"3.Click query result - Min-max planning rep

打开某一个form报错:FRM-47023: No such parameter named XXX exists in form YYYYYY.SolutionFRM-47023错误，有的时候确实是因为Form中缺少了对应的变量而造成的。也有种情况，就是在Function里注册的时候，加了错误的参数，把这个参数修正或者去掉也可能解决问题（需要重新Login）。

Oracle eDelivery上只提供新版本的EBS下载链接，如果想下载旧版本的EBS，必须提一个SR(Service Request)来申请。比如现在最新版本的EBS是12.1.x，如果想下载11.5.10或者12.0.6就必须提一个SR来申请，最后Oracle Support会提供下载链接或者实体光盘给你。ps:实际上Oracle的其他产品(比如DB)都是一样的,下载旧版本需要单独提SRReference:How to Obtain Media Packs for Older Versions of Oracle Products Requesting Physical

1.Make sure to set the following profile optionsMRP:Debug Mode = yesMRP:Trace Mode = yesCST: Cost update debug level = Full2.Resubmit the error transactions for costing.Uncosted/Failed transactions can be resubmitted through application itself.Costs -> View Transactions -> Material Transactions.From the menu, Tools Select All: Tools Submit AllElse, can use the following script to submit the records in MMT table:update mtl_material_transactionsset costed_flag = \'N\',error_code = NULL,err

Oracle Form里查看Record History，报错：APP-FND-01564: Oracle error 1403 in fdxwho APP-FND-01564: Oracle error 1403 in fdxwhoCause: fdxwho failed due to ORA-01403: no data found.The SQL statement being executed at the time of the errorwas: and was executed from the file &ERRFILE.Solution:这种错多半是因为记录中的Who字段(created_by或last_updated_by)在FND_USER表中不存在造成的，所以重新update一个有效的fnd_user.user_id字段到who字段，错误就可以

Open Oracle Reports with command rwbuilder.sh, encounter error: "REP-3000: Internal error starting Oracle Toolkit."[oracle@bej301441 ~]$ rwbuilder.shReport Builder: Release 10.1.2.3.0 - Production on Fri Apr 26 20:42:08 2013Copyright (c) 1982, 2005, Oracle.  All rights reserved.REP-3000: Internal error starting Oracle Toolkit.Solution:1. Unset the following environment variables which are required by Forms, but in some circumstances can cause problems for Reports. Reset the vari

本文介绍下内部销售订单Internal Sales Order(ISO)在Oracle EBS中的流程，内部销售订单和组织间转移（Inter-Organization Transfer，IOT）的作用是类似的，都是用于在库存组织间实现物料转移。只是使用的场景不尽相同，Inter-Organization Transfer(IOT),一般适用于，操作者同时具有来源组织和目标组织物料控制的权利，那么直接做IOT来实现物料的转移，就可以了；Internal Sales Order(ISO)，一般适用于

MTL_CST_TXN_COST_DETAILS stores the cost of a transaction by element and level.记录每一笔事务处理的成本；对于每笔库存事务的记录，这个表中有可能有记录，也有可能没记录；对于那些可以手工设定成本的事务处理，在这个表中有记录，例如，录入成本的杂项事务处理等===Fields Relationship===MTL_CST_TXN_COST_DETAILS.COST_ELEMENT_ID = CST_COST_ELEMENTS.COST_ELEMENT_IDMTL_CST_TXN_COST_DETAILS.TRANSACTION_ID

一个RDA报表能收集目标模块许多关键数据，比如目标模块的各个文件版本，JDBC版本，索引情况，Profile配置，系统版本，DB版本...一个Report在手，系统的配置信息你也基本就拿全了。使用方法：Start Oracle E-Business SuiteConnect to responsibility Application Diagnostics Select the Diagnose menu optionClick button Select Application and select an appropriate ApplicationScroll down to group "System Sna