随笔分类 - Oracle EBS Form
摘要：Sharing an Oracle Form Htoolbar.fmb for Oracle Forms 10g/11g containing Horizontal Toolbar canvas and a control block with basic navigational and operational buttons, which can be customized easily as...
阅读全文
摘要：Post-Form trigger in Oracle Forms fires during the Leave the Form process, when a form is exited. You can use Post-Form trigger for the tasks such as: To clean up the form before exiting. For examp...
阅读全文
摘要：Pre-Form trigger in Oracle Forms fires during the form start-up, before forms navigates to the first navigable data block of that form. Use a Pre-Form trigger to perform the tasks such as maximize t...
阅读全文
摘要：Example is given below to Populate a List Item in Oracle Forms using Create_Group_From_Query , Populate_List and Populate_Group command. In this example you can specify the query at run time to popula...
阅读全文
摘要：Example is given below to validate a Text Item in Oracle Forms with specific rules condition which can be define at run time with the use of T-List item and When-Validate-Item trigger. Below is the...
阅读全文
摘要：ID_NULL built in function is used to determine that an object type variable is null or not null in Oracle Forms and returns a BOOLEAN value that indicates whether the object ID is available or not mea...
阅读全文
摘要：Created XO Checker game in Oracle Forms and sharing its FMB (source code) for reference so that you can view its code written on the objects. You will learn a lot by looking its code and logic, you...
阅读全文
摘要：If the mouse is in an item, SYSTEM.MOUSE_ITEM represents the name of that item as a CHAR value.For example, if the mouse is in Item1 in Block2, the value for SYSTEM.MOUSE_ITEM is :BLOCK2.ITEM1.SYSTEM....
阅读全文
摘要：Highlight a Text Item in Oracle Forms With Visual AttributeIt is very necessary to highlight the current cursor text item in data entry forms so that a user can easily notice the current item. Steps t...
阅读全文
摘要：You can test or tune your program unit performance in Oracle forms with Ora_Prof package.Suppose you have created to procedure to perform a single task with different logic and you want to check exact...
阅读全文
摘要：Creating Timer in Oracle D2k / Forms 6i and Displaying a ClockThis is about timer in D2k An external clock can be constructed using timers. Timers correspond to internal clocks, which have a specific ...
阅读全文
摘要：Suppose you want to change multiple images after a specified time in home screen of your oracle forms application. Follow these simple steps to create image presentation with create_timer: (1) Place...
阅读全文
摘要：I have written many posts previously on Timers in Oracle Forms like how to change images randomly with timers and how to display a clock using timer, but in this post I am simply describing to how to ...
阅读全文
摘要：Set Icon_File property in When-Mouse-Enter triggerSuppose you are creating icon based menu system in Oracle Forms 6i and you want to change icon when mouse over on any push button. You can accomplish...
阅读全文
摘要：Change the font size and weight of text items and push buttons on mouse hover in Oracle Forms. An example is given below to highlight the text in text items and highlight the label of a push button ...
阅读全文
摘要：Set_Item_Property is used to change an object's settings at run time. Note that in some cases you can get but not set certain object properties. The following are Syntax of Set_Item_property command:S...
阅读全文
摘要：Calling / Running a report in Oracle forms 10g / 11gBelow is the procedure to call a report in Oracle Forms 10g/11g by passing report file name with full path and report format like 'PDF', 'RTF' etc....
阅读全文
摘要：Sets the Report object property at run time in Oracle Forms of an report object.The following are the Syntax of Set_Report_Object_Property:PROCEDURE SET_REPORT_OBJECT_PROPERTY(report_id REPORT_OBJECT,...
阅读全文
摘要：Refresh / Updating a form screen in Oracle D2k Forms 6iProblemYou want to show number of records processed progress or a progress bar on form through a procedure. SolutionDeclare nTotalRec Number := ...
阅读全文
摘要：SYSTEM.MESSAGE_LEVEL is used to control the messages that end users see when they use the Oracle Form's application. You can control to not to display simple warning messages or even error messages t...
阅读全文
浙公网安备 33010602011771号