随笔分类 -  Oracle EBS Form

1 2 3 4 5 ··· 8 下一页
ORACLE FORMS PL/SQL PACKAGE SHOW TIPS WINDOW
摘要：--在开发ORACLE FORM的程序中，要编写PL/SQL程序包产出异常情况时，直接在FORM弹出一个异常提示窗口 DECLARE BEGIN app_exception.raise_exception ( exception_type => 'APP' , exception_code => -20001 , exception_text => 'OTHERS EXCETPITON ' || ... 阅读全文
posted @ 2017-12-30 11:30 全威儒 阅读(642) 评论(0) 推荐(0)
Oracle Form删除list项
摘要：Oracle From中的list项点击后就会新增一个下拉列，此时可以使用 Ctrl+shift+< 进行删除 阅读全文
posted @ 2017-11-30 18:55 全威儒 阅读(1266) 评论(0) 推荐(0)
FORM - FILE.EXPORT 导出功能
摘要：对于数据块项，是不用添加任何触发器就可以使用导出功能的。 如果不能使用该功能，可能是由于在需要使用导出功能的块上添加了block级触发器when-new-item-instance,但执行层次为“忽略”，应该把执行层次改为“之前”，这样就可以实现导出功能了。 阅读全文
posted @ 2017-02-22 10:40 全威儒 阅读(1264) 评论(0) 推荐(0)
How to set window title name on Oracle EBS Form?
摘要：--1. 置換掉原來Winodw Property上的Title String ex. SET_WINDOW_PROPERTY('XXDII_INV_MISC_TXN_V',TITLE,:misc_trx_qf.Q_TYPE_NAME||'['||:misc_trx_qf.Q_MISC_TRX_NUM||']'); --2. 使用EBS Standard Library, 在Window titl... 阅读全文
posted @ 2017-01-19 11:28 全威儒 阅读(1007) 评论(0) 推荐(0)
FORM-加载前指定日期时间格式
摘要：PRE-FORM -- Standard date format --BEGIN set_application_property(DATE_FORMAT_COMPATIBILITY_MODE, '5.0'); set_application_property(PLSQL_DATE_FORMAT, 'DD/MM/YYYY HH24:MI'); set_application_property... 阅读全文
posted @ 2017-01-13 09:13 全威儒 阅读(950) 评论(0) 推荐(0)
ORACLE EBS FORM 二次开发常用小技巧
摘要：1.锁住当前行 Set_Item_Instance_Property('main.import_flag', CURRENT_RECORD, UPDATE_ALLOWED, PROPERTY_OFF); 用在WHEN-NEW-RECORD-INSTANCE 或者POST-QUERY中。 同:app_item_property.set_property('MAIN.REF_COST',ALTERAB... 阅读全文
posted @ 2017-01-11 21:28 全威儒 阅读(7002) 评论(0) 推荐(0)
FORM动态LIST ITEM
摘要：DECLARE rg_list_item recordgroup; ret_code NUMBER; BEGIN --SQL里必做是以值键两个字段顺序，并且都要为字符串类型 rg_list_item := CREATE_GROUP_FROM_QUERY ('RG_LIST_ITEM_NAME' , ' SELECT meaning, lookup_code FROM FND_LOOKUPS WHE... 阅读全文
posted @ 2017-01-09 17:43 全威儒 阅读(934) 评论(0) 推荐(0)
如何在form初始化时自动隐藏FOLDER列
摘要：方法1：直接设定PROMPT列和数据列ITEM的VISIBLE属性为No 方法2：在WHEN-NEW-FORM-INSTANCE触发器里： l_old_itm := :system.cursor_item;-- 转到你要删除的ITEM上go_item('BLOCK.ITEM');-- 调用标准api隐藏当前列APPL_FOLDER_DEL_FLD;go_item(l_old_itm); Troub... 阅读全文
posted @ 2017-01-09 16:04 全威儒 阅读(1562) 评论(0) 推荐(0)
Obtaining Query Count Without executing a Query in Oracle D2k
摘要：Obtaining Query Count Without executing a Query in Oracle D2k Obtaining a count of records that will be retrieved by EXECUTE_QUERY before actually performing it in a database block is especially usefu... 阅读全文
posted @ 2016-12-25 22:30 全威儒 阅读(459) 评论(0) 推荐(0)
Using Call_Form in Oracle D2k
摘要：Using Call_Form in Oracle D2kCALL_FORM examples/* Example 1:** Call a form in query-only mode.*/BEGINCALL_FORM(’empbrowser’, no_hide, no_replace, query_only);END;/* Example 2:** Call a form, pass a pa... 阅读全文
posted @ 2016-12-25 22:28 全威儒 阅读(355) 评论(0) 推荐(0)
Upload Files To FTP in Oracle Forms D2k
摘要：Upload Files To FTP in Oracle Forms D2k Use following procedure to upload files to Ftp. PROCEDURE Ftp_Upload IS outfile text_io.file_type;BEGIN -- write a ftp script outfile := text_io.fope... 阅读全文
posted @ 2016-12-25 22:27 全威儒 阅读(503) 评论(0) 推荐(0)
Using GET_APPLICATION_PROPERTY in Oracle D2k Forms
摘要：Using GET_APPLICATION_PROPERTY in Oracle D2k FormsDescriptionReturns information about the current Form Builder application. You must call the built-in once for eachvalue you want to retrieve.Usage No... 阅读全文
posted @ 2016-12-25 22:26 全威儒 阅读(648) 评论(0) 推荐(0)
Download Free Oracle Reports Building Guide eBook
摘要：A very nice ebook on building reports in Oracle fusion middleware 11g. This manual is intended for anyone who uses Oracle Reports to build reports. The needs of both novice and advanced users are addr... 阅读全文
posted @ 2016-12-25 21:55 全威儒 阅读(559) 评论(0) 推荐(0)
Oracle Forms 10g Tutorial Ebook Download - Oracle Forms Blog
摘要：A step by step tutorial for Oracle Forms 10g development. This guide is helpful for freshers in Oracle forms 10g. To download this ebook click the below button: Download Oracle Forms 10g eBookSee Also... 阅读全文
posted @ 2016-12-25 21:48 全威儒 阅读(1155) 评论(0) 推荐(0)
Download Oracle Forms 6i
摘要：To download Oracle Forms Developer 6i from Oracle click this link http://download.oracle.com/otn/nt/forms/6i_rel2_xp.zipNote. You must have Oracle username and password to download any software from ... 阅读全文
posted @ 2016-12-25 21:41 全威儒 阅读(1188) 评论(0) 推荐(0)
Number To Indian Rupee Words in Oracle Forms / Reports
摘要：Convert numbers to Indian Rupees format in Oracle Forms / Reports.Create the below mention function in Oracle Forms / Reports and call it with passing a number parameter.FUNCTION INR_words( p_number I... 阅读全文
posted @ 2016-12-25 21:39 全威儒 阅读(271) 评论(0) 推荐(0)
Creating Custom Login Screen In Oracle Forms 10g
摘要：Below is the example plsql unit to validate login credentials and after successful validation open a new form by passing some parameters to it, in Oracle forms 10g.Create a form for custom login. Crea... 阅读全文
posted @ 2016-12-25 21:38 全威儒 阅读(431) 评论(0) 推荐(0)
Writing Text Files On The Client in Oracle Forms 10g
摘要：Below is the example to write file on client in Oracle Forms 10g with webutil library package.Note: Webutil library must be attached to the form.DECLAREv_dir VARCHAR2(250) := 'c:\temp';ft_tempfile CL... 阅读全文
posted @ 2016-12-25 21:36 全威儒 阅读(554) 评论(0) 推荐(0)
Displaying Window In Center In Oracle Forms 6i
摘要：Center window automatically in Oracle Forms 6i, use the following procedure by passing window name as parameter:ExamplePROCEDURE auto_centre (pwn in varchar2) ISvw number := get_window_property(forms... 阅读全文
posted @ 2016-12-25 21:34 全威儒 阅读(429) 评论(0) 推荐(0)
Adding List Item Element At Runtime In Oracle Forms
摘要：Add combo list / drop down list item element at runtime in Oracle forms.SyntaxPROCEDURE ADD_LIST_ELEMENT(list_name VARCHAR2,list_index, NUMBERlist_label VARCHAR2,list_value NUMBER);ExampleDeclare nEl... 阅读全文
posted @ 2016-12-25 21:32 全威儒 阅读(996) 评论(0) 推荐(0)

1 2 3 4 5 ··· 8 下一页