ITPub博客

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 processing mode. * ENTER-QUERY - Indicates that the form is currently in Enter Query mode. * QUERY - Indicates that the form is currently in fetch processing mode, meaning th 1.After pressing F11, Then system will switch to ENTER-QUERY mode. 2.If you hit Ctrl+F11, system will execute

Introduction I 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 and all I get is a blank browser window when I run a form.” After I responded to numerous posts (always writing the instructions from scratch) I decided to write this document. As they say, “It is always better to reuse then to recreate!” Disclaimer First and foremost, this doc

1. set up FORMS_PATH(in 11i,it is FORMS60_PATH), make this env parameter point to directory where pll location FORMS_PATH is used by Forms Builder to record the location of attached libraries (.pll) and subclassed objects (such as items from a Template.fmb or Object Library [.olb]). 2.In your pld file header, write .attach LIBRARY library_name END NOCONFIRM 3.Then in your new pld file, you can invoke procedure/function from attached Libary. .pld file structure see below example:

1. 打开Template.fmb，并另存为一个名字(QUERYFIND.fmb) 2.从Window,Canvas,Data Block中删除BLOCKNAME，从Data Block中删除DETAILBLOCK 3.创建一个Window（DEPT_WINDOW），subclass选择WINDOW 4.Pre-Form trigger中，把DEPT_WINDOW设置为第一个显示的窗口 Program Unit:APP_CUSTOM中，设置关闭窗口的行为 5.定义一个Canvas(DEPT_CANVAS),subclass设置为CANVAS 6.通过Wizard创建Data block:DEPT，在Table中使用DEP

Perform an action after fetching a record, such as looking up values in other tables based on a value in the current record.  Fires once for each record fetched into the block. Description When a query is open in the block, the Post-Query trigger fires each time Form Builder fetches a record into a block.  The trigger fires once for each record placed on the block\'s list of records. Definition Level  form or block Legal Commands SELECT statements, unrestricted built

Validate the current query criteria or provide additional query criteria programmatically, just before sending the SELECT statement to the database. Description Fires during Execute Query or Count Query processing, just before Form Builder constructs and issues the SELECT statement to identify rows that match the query criteria. Definition Level  form or block Legal Commands SELECT statements, unrestricted built-ins Enter Query Mode  no Usage Notes Use a Pr

F11查询过程： 1)WHEN-CLEAR-BLOCK 2)WHEN-NEW-RECORD-INSTANCE 3)WHEN-NEW-ITEM-INSTANCE 在输入查询条件后点CTRL+F11： 4)PRE-QUERY Provide additional query criteria programmatically, just before sending the SELECT statement to the database. Sample Code: If :parameter.G_query_find = \'TRUE\' then   :trans_reasons.reason_id := :parameter.trans_reasons_qf;   :parameter.G_query_find := \'FALSE\'; end if; 5)WHEN-CLEAR-BLOCK 6)POST-QUERY Perform an

Help > Record History

Lot Entry中的有两个DFF，一个是Maintain Lot Number DFF,另一个是Lot Attributes DFF知道基表，查看对应DFFSELECT * FROM FND_DESCRIPTIVE_FLEXS WHERE application_table_name = \'MTL_LOT_NUMBERS\';FND_DESCRIPTIVE_FLEXS表中几个字段需要注意,APPLICATION_TABLE_NAME:表明这个DFF是基于哪个表建立的DESCRIPTIVE_FLEXFIELD_NAME：DFF的标识字符串，比如：“Lot Attributes”表示Lot Attributes DFF,“MTL_LOT_NUMBERS”表示Maintain Lot Number DFFCONTEXT_COLUMN_N

Oracle Apps R12下如何定义一个简单的Hello World的Concurrent Program 定义一个表和一个Procedure先 create table ptian_table ( message_text VARCHAR2(100) ,creation_date DATE ) ; CREATE OR REPLACE PROCEDURE PTIAN_HELLO (errbuf OUT VARCHAR2, retcode OUT VARCHAR2) IS BEGIN INSERT INTO ptian_table VALUES (\'Hello World\' ,SYSDATE); END PTIAN_HELLO; --两个参数用于concurrent program和pl/sql Program的交互 Application Developer职责下： Concurrent > Executa

基于TEMPLATE.fmb 拷贝TEMPLATE.fmb，改名为MYDEMO.fmb，打开之后把Form Name也改为MYDEMO，一定要保持一致性。 增加一个Window 增加一个Window，Name为ORDERS,Title为PT ORDERS ENTRY 因为一个Forms有多个Window，所以需要明确指出哪个Window是主Window，这样在关闭主Window的时候将退出整个Forms；此外，我们也须要在源代码中记录作者、开发时间、版本等备注信息。这些是通过代码而非属性

PTIAN EBS FORM开发（一）之 环境配置 OS:Windows XP Form Builder:Version 10.1.2.0.2  FORMS_PATH FORMS_PATH是用于Form Builder找到attached libraries (.pll)文件的路径 注册表>HKEY_LOCAL_MACHINE>Software>Oracle>KEY_DevSuiteHome1>FORMS_PATH 注：FORMS_PATH路径中最好不要有中文，另外你fmb所在的路径也不要有中文，否则可能会遇到Error "FRM-10043: Cannot open file. " 并且要把基本的pll文件放置

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 Developer职责 > Application > FormForm:你的Form名字，注意不要加后缀(fmb/fmx),并且这个form文件一定已经在相应的模块下了，别把文件放错模块，这里你制定Application为Inventor

Symtom： 新注册的form，在Application Developer职责下，把这个Form注册并挂到菜单后，然后重新登录到系统中，启动新的form，报错 错误：FRM-40010:Cannot read form .../xxx.fmx Cause： App Server上Fmx所在路径不对，如果你的form在注册的时候制定了具体的模块(Application)，那么就应该fmx放到相应$Module_TOP/form/US下去 转载请注明出处：http://blog.csdn.net/pan_tian/article/details/7637776

之前转了一个关于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

把Form转换成TXT格式的文件 命令：frmcmp_batch INVIDITM.fmb apps/apps@md0yd201 Compile_All=yes Forms_Doc=yes Form格式的文件可以转换成TXT，转换后可读性其实并不好，只不过在某些特别的情况有点用，比如一个Form内容发生了变化，因为Form不好比对，可以考虑转换成TXT的格式再进行比对 转换后的文件内容类似于 * Name ENTRY_STATE - Item

关于FND_MESSAGE的详细用法可以参见 http://docs.oracle.com/cd/E18727_01/doc.121/e12897/T302934T462354.htm 这里只列出几个常用的Example,方便查用 FND_MESSAGE.SET_NAME Retrieves your message from Message Dictionary and sets it on the message stack. You call FND_MESSAGE.SET_NAME once for each message you use in your client-side PL/SQL procedure. You must call FND_MESSAGE.SET_NAME before you call FND_MESSAGE.SET_TOKEN. Example 1 /* Display a warning, asking OK/Cance

Windows下用Form打开fmb文件，报错 FRM-10043: Cannot open file. Cause:最有可能的原因是fmb所在的路径中包含中文 Solution:把Form文件放到一个全英文的目录,需要注意中文的Windows，“桌面”的全路径是有中文的