ITPub博客

===For Applmgr User===APPL_TOP: 11i:<APPS_BASE>/<SID>applR12:<APPS_BASE>/apps/apps_st/applNOTE:Oracle Applicaitons product files,including $INV_TOP,$AU_TOP....COMMON_TOP:11i:<APPS_BASE>/<SID>comnR12:<APPS_BASE>/apps/apps_st/comn(Common files such as Java&HTML)NOTE:$JAVA_TOP is under $COMMON_TOPORACLE_HOME11i:<APPS_BASE>/<SID>ora/8.0.6R12:<APPS_BASE>/apps/tech_st/10.1.2===For Oracle User===ORACLE_HOME11i:<ORACLE_BASE>/<SID>db

Oracle uses three files (listener.ora, tnsnames.ora & sqlnet.ora) for network configuration. Oracle Net is configured by configuration files. These include (but are not limited to): TNSNAMES.ORA - This file contains a list of service names, which translate into the instances the client can connect to. It (tnsnames.ora) is used on outgoing requests.SQLNET.ORA - this file is used to configure Oracle Net on the client. For example, tracing can be turned on.LISTENER.ORA - T

Oracle Product Lines ? Applications Oracle E-Business Suite PeopleSoft Enterprise Siebel JD Edwards EnterpriseOne JD Edwards World Hyperion Primavera Oracle Open Office Oracle Fusion Applications Oracle CRM On Demand More on Oracle applications ? Middleware Java Application Server SOA Content Management Enterprise 2.0 and Portals More on Oracle middleware ? Databases Oracle Database 11g MySQL More on oracle databases ? OS an

Oracle官方下载地址 https://edelivery.oracle.com/，基本上Oracle的所有软件都可以从上边得到 直接下载 2.接受协议 3.选择下载的产品和平台 4.选择“Oracle E-Business Suite Release 12.1.1 Media Pack for Linux x86-64-bit",然后一个一个下载 wget方式下载 http://edelivery.oracle.com/ 其实也可以通过Unix命令行来下载， 具体方法参见http://johanlouwers.blogspot.jp/2010/11/wget-files-from-oracle-ede

Oracle EBS系统安装相关的Metalink Note Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86 [ID 761564.1] Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 [ID 761566.1] Linux下安装最为重要的两篇Note，一个是32位的Linux的安装说明，一个是64位的 MD5 Checksums for R12.1.1 Rapid Install Media (Doc ID 802195.1) 下载解压后，这个Note讲解了怎样判断解压后的

收集了一些Oracle营收方面的数据，也许个别数据不是非常准确，但至少对Oracle的经营规模可以有一个基本的概念 Oracle营收状况 2012年Q3 上图来自：http://www.oracle.com/us/corporate/investor-relations/faq/index.html 数据库和中间件基本占了revenue的2/3,Application比例还很小只占1/3 美国还是Oracle的大头，占据整整半壁江山；亚太接近20%的贡献 2011年 2011年度业绩：全年收入356亿美元

做过一段时间EAS性能测试，好多年过去了，突然发现对这一段时间的所作的东西都有些模糊了，这里大概记录一下，以后好帮助回忆 采用LoadRunnerV8.0的Java Vuser协议进行测试。EAS采用自主产权的ORM-RPC协议，LoadRunner V8.0不支持该自定义协议的脚录制。通过自己开发的测试脚本，调用EAS业务组件的方式进行压力测试。该方式基本可以真实准确的模拟实际用户的行为。EAS性能测

Symptom Change Organization列表中找不到对应的Org Solution 问题一般是\'Organization Access\' Form中当前的Responsibility没有Mapping对应的组织，在Organization Access Form中增加对应的映射关系就应该能解决问题。 关于Organization Access用法，可参见User Guide You can specify which organizations a responsibility can access bymapping responsibilities to organizations. Once this mapping is set up, a user logging into an Oracle Manuf

Symptoms: 创建新的Sales Order Line的时候，填写完数量，切出焦点，报错：Could not find a price list in Ordered UOM xxx and Primary UOM of the item Solution: Order Header上找到所使用Price List 到Order Management > Pricing > Price Lists > Price List Setup，增加新的item到价目表中，问题就解决了

Symptoms: 创建新的Sales Order Line的时候，填写完Item，切出焦点，报错：FRM-40212:Invalid Value For Field Ordered_Item_Dsp Solution: Key Flexfield Segments中重新Compile下System Item这个KFF，问题解决

With the expansion of EBS Shenzhen team,we’re seeking candidates with solid development experience and workable oral English skills in Shenzhen.   Organization Name: OARDC – E-Business Suite Development                                         Job Title:（Senior）Applications Engineer

Symptoms: 打了一个Patch后，但查Diagnostics: Apps Check,发现相关的Java文件版本并没有提升 1.到App Server端检查文件系统中的文件版本 ident $JAVA_TOP/oracle/apps/inv/transaction/server/SerTrxManager.class 2.通过DB客户端执行下边语句来检查文件在数据库里的文件版本 set serverout on begin fnd_aolj_util.getClassVersionfromDB(\'oracle.apps.inv.transaction.server.SerTrxManager\'); end; 然后发现第一步的AppServer中的文件

之前转了一个关于Trigger次序的帖子见（http://blog.csdn.net/pan_tian/article/details/7535875），但是不太全，今天又找到一贴 1．  当打开FORM时： （1）       PRE-FORM （2）       PRE-BLOCK（BLOCK级） （3）       WHEN-NEW-FORM-INSTANCE （4）       WHEN-NEW-BLOCK-INSTANCE （5）     &

Define a KFF step by step Author:                         Pan Tian Creation Date:            04/05/2012 Last Updated:              Version:               &

Introduction This document lists the order in which triggers fire in Oracle Forms o The first column, Action, describes the function to be performed (e.g. deleting a record). o The second column, Trigger Firing Order, describes the order in which triggers fire after a function is performed. o The third column, Level, describes the level (form, block, item) at which the trigger fires. This was accomplished by creating a form with all the triggers invoked. If a trigger could fire

EBS提供了很多标准的KFF，通过下边这个SQL就可以查询（以Applicaiton Code排序）SELECT B.APPLICATION_SHORT_NAME, A.ID_FLEX_CODE, A.ID_FLEX_NAME, A.APPLICATION_TABLE_NAME, A.UNIQUE_ID_COLUMN_NAME, A.DESCRIPTION FROM FND_ID_FLEXS A,FND_APPLICATION B WHERE A.APPLICATION_ID = B.APPLICATION_ID ORDER BY A.APPLICATION_ID;ID_FLEX_CODEID_FLEX_NAMEAPPLICATION_TABLE_NAMEDESCRIPTIONGLATReporting Attributes:AccountinGL_CODE_COMBINATIONSReporting Attributes:General Ledger Accounting Fl

What is AOL? Oracle Applications are constructed and maintained using the Application Object Library (AOL).The Three main areas of AOL areApplications Security Operating Profile Concurrent Processing AOL Stands For “Application Object Library”. AOL is data repositiry for your Oracle Applications. It keeps track of all application objects like users(Apps), Responsibilities, Menus, Applications, Functions etc. AOL is a primary component of the Applications Technology layer. It is a

1.     写作目的   1 2.     利用Toad或其它pl/sql工具在Oracle ERPDatabase中建立Package,源码如下...1 (1).建立Package Header1 (2).建立Package Body. 1 3.     取得APPS密码的步骤   2 4.     通过任何一个User name/password取得APPS密码的方法   2 5.     通过FND_USER:ENCRYPTED_USER_PASSWORD取得明文密码

OM模块的Pick Release用的比较多，里边涉及的分支比较多，总结了一下方便查阅 For pdf version,you can download via "Pick Release Process_v3.pdf" 转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7527908 ======EOF======

zz:http://www.oracleappshub.com/fusion/fusion-application/oracle-fusion-applications-frequently-asked-questions/ Oracle Fusion Applications are currently available under an early adopter program. That means Oracle is not pushing to existing clients to replace their applications with Oracle Fusion Applications, but will instead its trying to build a reference base through their early adopter program.This post is series of Q&A, that everyone wants to know. 1. When Fusion was announce