Oracle EBS开发
文章平均质量分 78
Oracle EBS开发、维护等相关技能分享,主要涉及Oracle Form,Oracle Report...
田攀
tian.pan@qq.com
展开
-
Some JDeveloper Concepts and Tips
File Type:jpr jpx jwsjpr - JDeveloper Project Filejws - JDeveloper Workspace Filejpx - The.jpx file contains configuration information that JDeveloper uses in the design time to allow you to create th原创 2013-01-24 17:27:57 · 3079 阅读 · 0 评论 -
JDeveloper Setup for OA Framework
Download JDeveloper 参考下边Note来下载JDev,不同版本的EBS需要下载不同版本的JDevNote 416708.1 - OA Framework - How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x ATG Release 12 Ver原创 2013-01-23 17:49:36 · 6998 阅读 · 2 评论 -
OAF MVC Architecture
MVCM:The Model is the place containing the business logic. V:The View is the presentation layer. C:The Controller manages the flow between pages.OAF MVC Architectureor1] ModelBC4J(Business Components原创 2013-01-29 11:32:46 · 3367 阅读 · 0 评论 -
OAF Sample Code
Get the VO from the AMOAViewObject objAssessmentVO = (OAViewObject)yourAM.findViewObject("yourVO"); MtlLotNumbersVOImpl vo= (MtlLotNumbersVOImpl)findViewObject("MtlLotNumbersVO1"); MtlLotNumbersVOR原创 2013-01-29 17:16:09 · 8618 阅读 · 0 评论 -
How to Generate SQL Trace In OAF
1. Profile 'FND: Diagnostics' = Yes at user level.This will make 'Diagnostics' menu display.2. Login to Personal Home Page as that user and select the 'Diagnostics' icon at the top of the page.3. Sele原创 2013-01-30 11:45:55 · 3847 阅读 · 0 评论 -
How to Check Debug Log on OAF Pages
1. Profile 'FND: Diagnostics' = Yes at user level.This will make 'Diagnostics' menu display.2. Login to Personal Home Page as that user and select the 'Diagnostics' icon at the top of the page.3.In li原创 2013-01-30 12:29:16 · 5681 阅读 · 0 评论 -
How to Deploy a OAF Files
a) Copy all files except page definition from local machine to appropriate directories.The files such as Controllers *CO.class Application modules *AM.class View Objects *VOImpl.class, *VORow原创 2013-02-04 13:01:29 · 3638 阅读 · 0 评论 -
PL/SQL Cursor常见用法模板
1.LoopDECLARE emp_rec emp%rowtype; CURSOR emp_cur IS SELECT * FROM emp;BEGIN OPEN emp_cur; LOOP FETCH emp_cur INTO emp_rec; EXIT WHEN emp_cur%NOTFOUND;--这个必须有,否则bu原创 2013-02-06 12:58:54 · 5339 阅读 · 0 评论 -
Oracle Security API - FND_FUCTION.TEST
FND_FUCTION.TEST(Function_Name)Test if function is accessible under current responsibility.TRUE if function is accessible.This function Only checks static function security, and global object type gra原创 2013-02-20 18:58:59 · 3549 阅读 · 0 评论 -
Send Emails from PL/SQL
1.要想从DB Server发邮件,首先得确保DB Server已经启用了SMTP(Simple Mail Transfer Protocol)服务。检查是否启动SMTP的方法telnet server.domain.com 25(25是SMTP的默认端口)2.PL/SQL to send email sample code:DECLARE lc_from_email_id VARCHA原创 2013-02-27 16:20:47 · 2745 阅读 · 0 评论 -
JDev Run OAF Page Slowly
现象:从JDeveloper中Run OAF页面非常慢。原因:开发环境下,一定硬件配置,OAF页面运行的性能瓶颈主要在于网络。所以理想性能的OAF开发环境是,DB Server里安装JDev来开发OAF,这种最理想情况。一般情况下,想提升性能,最好保证DB Server和本机在同一个局域网络下。Server A是中国的服务器,我的开发环境是美国Linux机器,ping Server A,time大原创 2013-02-26 11:06:44 · 2522 阅读 · 0 评论 -
Region Style in OA Framework
Regions are containers for for different items in a page.In a page there can be any number of regions inside regions and many number of items inside the region.Every region is a java bean acting as a原创 2013-02-25 19:55:02 · 12166 阅读 · 0 评论 -
Cache Pattern
Oracle EBS中,如果获取Item,Organization等基础数据的信息。你可以写SQL来查,这种做法的不好处就是,在不同Procedure或者Function中,你可能需要写多次类似的SQL来取值,造成代码的冗余。EBS标准的做法是,通过Cache模式来时缓存需要的信息。以获取Organization为例,系统中标准的做法是: l_return_value := INV_CACHE.原创 2013-03-04 13:12:46 · 2420 阅读 · 0 评论 -
OPEN_FORM, CALL_FORM, NEW_FORM and FND_FUNCTION.EXECUTE
OPEN_FORMwhen one form invokes another form by executing open_form the first form remains displayed, and operators can navigate between the forms as desired. Example:When we invoke a form from OPEN_FO原创 2013-03-05 12:34:07 · 11017 阅读 · 0 评论 -
Difference between Do_Key('Exit_Form') and Exit_Form
In Oracle Application Developer Guide, It says following...The Oracle Applications forms have special exit processing. Do not call EXIT_FORM directly; always call do_key(’EXIT_FORM’).What's difference原创 2013-03-05 15:15:10 · 4148 阅读 · 0 评论 -
Difference between Commit,COMMIT_FORM and Do_Key('Commit_Form')
COMMIT_FORM and COMMIT do the same thing, they apply any outstanding changes in the form to the DB and issue a DB-COMMIT.DO_KEY('commit_form') executes the code which is written in your KEY-COMMIT tri原创 2013-03-05 15:34:49 · 7844 阅读 · 0 评论 -
odf-File and xdf-File
关于odf文件,写过一篇笔记,见:Oracle Apps ADODFCMP Utility, xdf和odf类似,都是数据库对象的描述文件,用于数据库表,视图,索引等等在不同数据库间的移植。根据NOTE:551325.1的说法,xdf将会逐步取代过去的odf,毕竟xdf的xml格式还是要比文本格式的odf有方便处理些。xdf对应的执行文件是$JAVA_TOP/oracle/apps/fnd/odf原创 2013-03-06 18:37:22 · 3664 阅读 · 0 评论 -
Application ENV parameter:CLASSPATH and AF_CLASSPATH
CLASSPATH=[JDK_TOP]/lib/dt.jar:[JDK_TOP]/lib/tools.jar:[JDK_TOP]/jre/lib/rt.jar:$JAVA_TOP/../lib/appsborg.zip:$JAVA_TOPand some other forms/mid server necessary lib.eg.frmall.jar,ewt3.jar,frmsrv.jar..原创 2013-03-11 17:57:10 · 2999 阅读 · 0 评论 -
Oracle ADF Faces Rich Client Components
Oracle ADF Faces rich client (known also as ADF Faces) is a set of JavaServer Faces (JSF) components that include built-in Asynchronous JavaScript and XML (AJAX) functionality. While AJAX brings rich原创 2013-03-12 19:45:24 · 3286 阅读 · 0 评论 -
Oracle E-Business Suite on Mobile Device
近期看了一些EBS在移动终端的应用案例,大体研究了下,EBS移动终端的实现方法大体有以下几种:1.ADF MobileOracle ADF Mobile是基于Java和HTML5的移动开发框架,基于这个框架构建,扩展企业应用到安卓和iOS。Demo1:http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/adfmobiledem原创 2013-03-12 20:54:22 · 4302 阅读 · 0 评论 -
Personalization Level on Oracle MSCA
Oracle Mobile Supply Chain Applications enables you to personalize the user interface to suit your individual preferences. Personalization can be performed at the following levels:• Responsibility lev原创 2013-03-12 23:55:25 · 3900 阅读 · 0 评论 -
Item Styles in OA Framework
messageStyledText - When you want to display only the text and the user should not be able to edit the text then we use the messageStyledText.messageTextInput - As the name implies it helps the users原创 2013-03-13 16:51:02 · 4529 阅读 · 0 评论 -
几个关于Oracle EBS二次开发的问题
问:论坛里有人问如何给Form添加新的字段?答:通过DFF,Descriptive Flexfield。Descriptive Flexfield会把新加的字段添加到基表中的预留字段。不推荐通过直接修改Form的方式来添加字段,那样的话,如果打了patch后,新加的字段就会被覆盖。关于Flexfield的更多信息,可以查阅Oracle Applications Flexfields Guide问:原创 2013-03-14 11:37:38 · 4607 阅读 · 0 评论 -
Oracle Forms Customizations Technology Stack
A Mind Map Regarding Oracle Form Personalization. Choose proper technology base on your requirements.原创 2013-03-19 19:21:20 · 2573 阅读 · 0 评论 -
FRM-18108,FRM-10102 Error when open form
新装了个XP的虚拟机,拷贝了必要的fmb和pll文件开发目录下,Form Builder(version:10)打开TEMPLATE.fmb,总是报FRM-18108,FRM-10102错误,这种错误多半是FORMS_PATH的问题,但仔细检查过注册表,FORMS_PATH参数设置应该是没有问题,并且报的相关文件都已经在开发目录下了。解决方法:1.重新拷贝了$AU_TOP/forms下TEMPLA原创 2013-03-22 21:42:27 · 3042 阅读 · 0 评论 -
不要为了重构而牺牲代码的阅读性
在性能可以接收的前提下,不要为了重构而牺牲代码的阅读性,这会让后期的维护越来越难。尤其是PL/SQL这样面向过程的语言,宁肯代码存在冗余,也要保证逻辑的清晰。重构是为了让逻辑更简单和清晰,而不是为了抽象让逻辑变得混淆和复杂。为了重构而重构,那是炫技,企业级软件工程需要更多地是稳定,清晰,而不是花架子。-------------------------------------------------原创 2013-03-26 17:00:33 · 2633 阅读 · 4 评论 -
Parameter variables vs Global variables in Oracle Form
Oracle Form里,有两种全局变量,一种是Parameter variables,另外一种是Global variablesParameter variables是Form内的全局变量,Form内的所有Trigger,Program Unit都可以读取或者修改这个:parameter.var,但注意:parameter.var不能跨Form调用。Global variables是系统级别的全原创 2013-04-01 11:32:33 · 2954 阅读 · 0 评论 -
Error:"No method with signature" in OAF
In a OAF page, encounter a rrror like:No method with signature - No method with signature - subinvExitEvent()(subinvExitEvent is a method in AM)Solution:Check methods in AM and CO,re-Load latest relat原创 2013-04-03 18:40:51 · 6451 阅读 · 0 评论 -
Drop-down list in OA Framework
Basic Steps:1.Define a lookup, lookups value are for drop-down list items.2.Create VO, this is used to query above lookups3.in Page file, Add a messageChoice type item in a region.4.Drop-down list wit原创 2013-04-05 10:57:55 · 4870 阅读 · 0 评论 -
Sequence in Oracle DB
A sequence is a database object that generates unique numbers, mostly used for primary key values. One can select the NEXTVAL and CURRVAL from a sequence. Selecting the NEXTVAL will automatically incr原创 2013-04-13 13:57:50 · 2245 阅读 · 0 评论 -
Descriptive Flex Field List
Query:SELECT CONCATENATED_SEGS_VIEW_NAME,APPLICATION_TABLE_NAME,DESCRIPTIVE_FLEXFIELD_NAME,TITLE,CONTEXT_COLUMN_NAME,DESCRIPTION FROM FND_DESCRIPTIVE_FLEXS_VL WHERE APPLICATION_ID = 401 --Take Invent原创 2013-04-17 17:45:07 · 6050 阅读 · 0 评论 -
Oracle EBS中打印二维码
Oracle EBS暂时还只支持一维码,所以如需要二维码的打印和扫描,需要自行开发。PL/SQL还没有成熟的二维码生成类库,但Java已有很多二维码生成和解码的第三方类库(比如,QRCode,ZXing...),这里以比较简单的QRCode为例演示怎么输出和解码二维码。一个QRCode的简单例子:涉及到的主要类库:编码 lib:Qrcode_swetake.jar (官网介绍 -- http:/原创 2013-04-22 15:09:22 · 5457 阅读 · 3 评论 -
Debug log of Cost Management
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 ca原创 2013-04-28 18:29:18 · 3237 阅读 · 0 评论 -
如何下载老版本的Oracle EBS
Oracle eDelivery上只提供新版本的EBS下载链接,如果想下载旧版本的EBS,必须提一个SR(Service Request)来申请。比如现在最新版本的EBS是12.1.x,如果想下载11.5.10或者12.0.6就必须提一个SR来申请,最后Oracle Support会提供下载链接或者实体光盘给你。ps:实际上Oracle的其他产品(比如DB)都是一样的,下载旧版本需要单独提SRRe原创 2013-05-03 09:58:47 · 3593 阅读 · 0 评论 -
Update Data Template(xml file) and RTF(rtf file) Template for BI Publisher Report
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-ma原创 2013-05-03 19:35:19 · 2901 阅读 · 0 评论 -
How to generate an AR debug log file
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$param原创 2013-05-13 16:27:06 · 2865 阅读 · 0 评论 -
How to generate an AP debug log file
FND: Debug Log Enabled YesFND: Debug Log Filename FND: Debug Log Level STATEMENTFND: Debug Log Mode Asynchronous with Cross-Tier SequencingFND: Debug Log Module % or AP%No need to stop and restart E-B原创 2013-05-13 16:36:00 · 3290 阅读 · 0 评论 -
How to generate an GL debug log file
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 dr原创 2013-05-13 16:41:45 · 4048 阅读 · 0 评论 -
Vision Demo Instance Organizations Architecture
相信很多人学习Oracle EBS,都是使用Oracle自带的Vision Demo环境,Vision环境组织架构很复杂,chen_7733在ITPUB上传了一个相当棒的文档,详细介绍了Vision环境的组织架构图。文档下载地址:http://www.itpub.net/thread-790530-1-1.html ,除了前面这个,另外再推荐一个Vision Demo组织架构图的好文档:http:原创 2013-05-13 23:57:36 · 3098 阅读 · 0 评论 -
Open Inventory Periods Script
某个库存组织下,发现有很多库存期间都未打开,而一个一个的开期间比较麻烦,可以使用这个脚本来批量打开库存期间-----------------------------------------------------------l_org_id为 organization's Organization_ID--eg. select * from mtl_parameters where organ原创 2013-05-16 15:30:55 · 3916 阅读 · 0 评论