Oracle EBS Dev
文章平均质量分 70
田攀
tian.pan@qq.com
展开
-
Oracle EBS Technology Webcasts
R11i / R12 : EBS Technology area - Webcasts delivered by Support and Development (Doc ID 1186338.1)MOS Note 1186338.1 记录了不少Oracle EBS技术相关的Webcast(Oracle Dev、Support录制的),非常好的学习材料,分享下。原创 2013-11-27 15:56:46 · 3156 阅读 · 1 评论 -
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 评论 -
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 评论 -
Forms Menu Related Information
APP_SPECIAL.INSTANTIATEExample 1APP_SPECIAL.INSTANTIATE('SPECIAL3','&Book Order', 'POBKORD', TRUE, 'LINE');APP_POPUP.INSTANTIATE('POPUP1','First Entry'); APP_POPUP.INSTANTIATE('POPUP2','Second Entry原创 2013-01-16 11:05:08 · 3245 阅读 · 1 评论 -
Form Trigger Sequence Demo Form
Form Trigger太多太庞杂,新手往往很难上手,加上一些Trigger有点偏门,用的比较少,真到想用的时候,又不知道从哪下手。所以之前就有想法写一个Demo Form,用于显示Trigger的执行顺序,今天发现已经有人写过这个东西了,也就不用重造这个轮子了。作者:Francois Degrelle(Oracle ACE)Site:http://sheikyerbouti.developpez原创 2012-12-31 12:31:33 · 2722 阅读 · 1 评论 -
How to make form Read Only
Form注册里(Application Developer > Application > Function)的Parameter,加上QUERY_ONLY="YES"这样Form就为只读模式了Reference:How to Make a Form Query Only in Oracle Applications (Doc ID 1013404.102)原创 2013-01-11 17:56:31 · 2833 阅读 · 0 评论 -
Windows7(64 bit)下访问Forms Builder - Windows XP Mode
Windows7(64 bit)下Form Builder的安装和使用还是有很多问题,暂时好像也没有太好的解决方案。这里推荐一个的解决方案:微软提供了一款虚拟机软件(Windows XP Mode),虚拟机为XP系统,我们可以在虚拟机里安装Oracle Developer Suit10g.当然你也可以使用其他虚拟机软件,比如Oracle VM VirtualBox,Vmware...但在体验上,个原创 2013-01-09 16:48:05 · 3702 阅读 · 0 评论 -
How to check which responsiblity we are using
DECLAREp_userid NUMBER;p_respid NUMBER;p_applid NUMBER;x_resp_name VARCHAR2(50);BEGIN SELECT user_id INTO p_userid FROM fnd_user WHERE user_name ='MFG'; SELECT responsibility_id INTO p_respid原创 2013-01-24 18:14:34 · 2126 阅读 · 0 评论 -
Set_XXX_Property Build-Ins
Build-In List· SET_APPLICATION_PROPERTY· SET_BLOCK_PROPERTY· SET_CANVAS_PROPERTY· SET_FORM_PROPERTY· SET_ITEM_PROPERTY· SET_ITEM_INSTANCE_PROPERTY· SET_LOV_PROPERTY· SET_MENU_ITEM_PROPERTY· S原创 2012-12-25 18:55:28 · 8339 阅读 · 0 评论 -
frmcmp.sh报FRM-91500
[oracle@bej301441 ~]$ frmcmp.shFRM-91500: Unable to start/complete the build.Reason:frmcmp.sh需要GUI显示,如果通过putty之类的SSH客户端连上服务器的话,无法GUI展示,所以命令会报错。Solution 1:The only catch is when you use frmcmp.sh you n原创 2012-12-28 16:27:34 · 3787 阅读 · 0 评论 -
Oracle EBS中有关Form的触发器的执行顺序
触发器执行顺序:1. 当打开FORM时:(1) PRE-FORM(2) PRE-BLOCK(BLOCK级)(3) WHEN-NEW-FORM-INSTANCE(4) WHEN-NEW-BLOCK-INSTANCE(5) WHEN-NEW-RECORD-INSTANCE(6) WHEN-NEW-ITEM-INSTANCE2.转载 2012-09-14 14:08:31 · 4195 阅读 · 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 评论 -
How to Add Line Number into Oracle Form
Solution:1.Create a Text Item2.Database Item = No3.Calculation Mode = Formula Formula = :SYSTEM.TRIGGER_RECORDCalculation Mode property原创 2013-02-28 11:25:22 · 4345 阅读 · 1 评论 -
Windows 7/Vista下安装Oracle Developer Suit遇到的几个问题
问题1:Checking operating system version: must be 5.0, 5.1 or 5.2. Actual 6.1Win7/Vista下安装Form Builder 10g,点击setup.exe安装,报错:Checking operating system version: must be 5.0, 5.1 or 5.2. Actua原创 2012-09-25 13:27:39 · 11322 阅读 · 0 评论 -
NAME_IN and COPY built-in
You can reference items indirectly with the NAME_IN and COPY built-in subprograms.The NAME_IN function returns the contents of an indicated variable or item. Use the NAME_IN function to get the value原创 2012-04-06 15:29:48 · 4867 阅读 · 0 评论 -
Compilation Sequence for Inherited Forms
假设有两个Form,Base.fmb和Function.fmb,Base.fmb为基础Form,Function.fmb引用了Base.fmb。理论上,修改了Base.fmb之后,Function.fmb也就应该被修改了。但实际上,只编译Base.fmb,Function.fmb是不会被影响到,它仍然使用旧有的逻辑。正确的方法:把Base.fmb和Function.fmb放在同一个目录下,然后先编原创 2013-06-04 18:23:37 · 1976 阅读 · 0 评论 -
[小技巧]寻找菜单项所对应的SpecialX触发器
拿到一个陌生的Form,想知道某个菜单项到底在Form中对应的是哪个SpecialX Trigger,可以使用这个方法。打开Custom Code中的Show Custom Events然后点的菜单项,然后就可以知道这个菜单项到底是哪个SpecialX Trigger了。原创 2013-05-13 21:07:22 · 1933 阅读 · 0 评论 -
如何注册一个新的form到EBS系统
1.通过SSH,上传Form到App Server,然后编译首先把你的form文件上传到App Server,并把fmb文件到相应职责下(eg.$INV_TOP/forms/US),然后编译 frmcmp_batch module=ZYORDERS.fmb userid=apps/apps@instance output_file=ZYORDERS.fmx2.Form注册Application D原创 2012-06-06 13:39:16 · 6605 阅读 · 1 评论 -
Oracle EBS Development Command
Open Form fileR12frmbld.sh INVTOMAI.fmb11if60desm XXX.fmbCompiling formR12frmcmp.sh module=INVRSVF1.fmb userid=apps/apps@mz1ms206 module_type=form compile_all=special(Batch Mode)frmcmp.sh module=INVRS原创 2012-04-24 03:22:49 · 8475 阅读 · 0 评论 -
WebUtil Useful Reference
WebUtil Demo / DocumentationWebUtilHome Page on OTNWebUtil- A simplified guide to understanding WebUtil.WebUtil Version 1.0.6 - Production Release Notes FAQ Oracle Forms 10g WebUtil WebUtilDemoUsing W原创 2013-03-25 00:45:24 · 4067 阅读 · 0 评论 -
FRM-40735: ON-ERROR trigger raised unhandle exception ORA-06508
Form Builder版本10,在本机编译、运行Form(此form基于Template.fmb基础上开发的),编译都没有问题,但是运行时报错。英文:FRM-40735: ON-ERROR trigger raised unhandle exception ORA-06508中文:FRM-40735: ON-ERROR 触发器提出了不能处理的异常状况 ORA-06508原因:基于Template原创 2013-03-24 23:29:18 · 4522 阅读 · 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 评论 -
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 评论 -
(V45) Trigger Execution Sequence in Forms 4.5
(V45) Trigger Execution Sequence in Forms 4.5 ============================================= Introduction This document lists the order in which triggers fire in Oracle Forms 4.5: o The first column,转载 2012-12-14 12:18:36 · 2382 阅读 · 0 评论 -
Oracle Forms Versions
IAF 2CharacterNo IDEFastForms+IAG 4Character SQL*Forms25Character SQL*Forms2.35CharacterNew IDE, No PLSQL, User Exits, INP ASCII File, FRM Runtime FileSQL*Forms36CharacterMajor Rewrite, New IDE, PLSQL原创 2012-12-26 11:03:07 · 2581 阅读 · 0 评论 -
Oracle Form写的九宫格游戏(Sudoku Game)
高人在民间,无意间发现了一牛人用Oracle Form写的九宫格游戏(Sudoku Game),有兴趣的童鞋可以挂在自己EBS系统里,做账做累了玩玩:)详见原帖:SUDOKU.fmb -- An Oracle Forms Sudoku game programForm源码下载:Click here to download sudoku.fmb 304 KB原创 2012-12-04 11:45:12 · 2404 阅读 · 0 评论 -
如何定义一个简单的Concurrent Program
Oracle Apps R12下如何定义一个简单的Hello World的Concurrent Program定义一个表和一个Procedure先create table ptian_table( message_text VARCHAR2(100),creation_date DATE) ;CREATE OR REPLACE PROCEDURE PTIAN_HEL原创 2012-07-03 11:21:06 · 3703 阅读 · 0 评论 -
FRM-40010:Cannot read form .../xxx.fmx
Symtom:新注册的form,在Application Developer职责下,把这个Form注册并挂到菜单后,然后重新登录到系统中,启动新的form,报错错误:FRM-40010:Cannot read form .../xxx.fmxCause:App Server上Fmx所在路径不对,如果你的form在注册的时候制定了具体的模块(Application),那么就应原创 2012-06-06 13:25:10 · 7938 阅读 · 0 评论 -
PTIAN EBS FORM开发(二)
基于TEMPLATE.fmb拷贝TEMPLATE.fmb,改名为MYDEMO.fmb,打开之后把Form Name也改为MYDEMO,一定要保持一致性。增加一个Window增加一个Window,Name为ORDERS,Title为PT ORDERS ENTRY因为一个Forms有多个Window,所以需要明确指出哪个Window是主Window,这样在关闭主原创 2012-06-06 17:47:46 · 4268 阅读 · 0 评论 -
Define a KFF step by step
Define a KFF step by stepAuthor: Pan TianCreation Date: 04/05/2012Last Updated: Version: Status:原创 2012-05-04 18:40:01 · 7073 阅读 · 1 评论 -
把Form转换成TXT格式的文件
把Form转换成TXT格式的文件命令:frmcmp_batch INVIDITM.fmb apps/apps@md0yd201 Compile_All=yes Forms_Doc=yesForm格式的文件可以转换成TXT,转换后可读性其实并不好,只不过在某些特别的情况有点用,比如一个Form内容发生了变化,因为Form不好比对,可以考虑转换成TXT的格式再进行比对转换后的文件内原创 2012-04-24 11:49:33 · 2755 阅读 · 0 评论 -
Forms trigger Firing Sequence
IntroductionThis 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转载 2012-05-04 18:36:36 · 1816 阅读 · 0 评论 -
Form Trigger执行顺序
之前转了一个关于Trigger次序的帖子见(http://blog.csdn.net/pan_tian/article/details/7535875),但是不太全,今天又找到一贴1. 当打开FORM时:(1) PRE-FORM(2) PRE-BLOCK(BLOCK级)(3) WHEN-NEW-FORM-INSTANCE转载 2012-05-04 18:42:15 · 1966 阅读 · 0 评论 -
FND_MESSAGE的用法
关于FND_MESSAGE的详细用法可以参见 http://docs.oracle.com/cd/E18727_01/doc.121/e12897/T302934T462354.htm这里只列出几个常用的Example,方便查用FND_MESSAGE.SET_NAMERetrieves your message from Message Dictionary and sets原创 2012-04-24 10:46:23 · 9654 阅读 · 0 评论 -
如何永久关闭选项"Close Other Forms"
Oracle EBS里Tools>Close Other Forms如果被勾选上的话,那么用户在打开一个Form的时候,就会关闭其他的Form,保证只有一个Form存在。我们去掉了这个选项的勾选,再次登录,有的时候会发现这个选项不知道什么原因又被勾选上了。这里提供一个通过脚本永久修改这个选项的解决方法:SELECT preference_valueFROM applsys.fn原创 2012-07-25 15:31:33 · 4537 阅读 · 0 评论 -
Forms: How to Configure Forms Builder to run forms locally
IntroductionI wrote this document because so many people in the Oracle Technology Network (OTN) Forms Forum have asked “How do I run a form from the Forms Builder?” or “I just installed Forms 10g转载 2012-09-26 18:05:59 · 5076 阅读 · 0 评论 -
Dynamically Change Record Group in Form
From SQL Query1. Create a Record Group(RG)2. Create RG SQL Query asSelect 1,2,3,4,5 from dual;Make sure you set the datatype accordingly w.r.t your col in the dynamic query to be used in the below pac原创 2012-11-30 12:41:57 · 4382 阅读 · 0 评论 -
poplist
How to populate poplist item? Your client has a form that contains a product description. They don’t want that their data entry staffs to type a原创 2012-10-29 17:57:38 · 2552 阅读 · 0 评论 -
ENTER-QUERY Mode
SYSTEM.MODE indicates whether the form is in Normal, Enter Query, or Fetch Processing mode. The value is always a character string.* NORMAL - Indicates that the form is currently in normal process原创 2012-10-08 15:41:51 · 3936 阅读 · 0 评论 -
Pre-Query Samples
Validate the current query criteria or provide additional query criteria programmatically, just before sending the SELECT statement to the database.DescriptionFires during Execute Query or Count Q原创 2012-09-16 15:12:23 · 3095 阅读 · 0 评论