The Apps Traction Blog

Homepage  Xml - Vorschau mit Bildern

Disable a Button
This very simple example will present a Form Personalization to remove the "New PO" button normally found at the bottom of Purchase Order Summary form. Clients ask for this request all the time for many different forms. Use the following logic to apply to your case examples. From the Purchasing Super User Responsibility, navigate to Purchase Orders > Purchase Order Summary. Enter the Form Personalization form. (M) Help > Diagnostics > Custom Code > Personalize. Rules Sequence: 1

Export Hidden Canvases Using Form Personalization
The following example will present the setup required to enable the export function of data from hidden canvases within a form using Form Personalization. For this example, we will use the Purchase Order window. Generally, when exporting data from a forms block, only the data that is currently displayed for the block is exported. We want to allow exporting the block data that is on other hidden canvases. The business requirement is to include as part of the export all data for the PO_LINES bl

Launch a URL Using Form Personalization
The following example will present the setup required to launch a URL from any Oracle Forms using Form Personalization. For this example, we will use the Purchase Order window. We will define a new Menu Item "Google" to help us open a new browser window to the Google main page. Use the same principles to achieve this in any of the windows within the Oracle Forms User Interface. Navigate to the Purchase Orders window using the Purchasing SuperUser responsibility. Enter the Form Personalization

Using the Form Personalization Feature
For those looking to find out what Form Personalization offers, follow this link for a complete description recently published on Metalink: Scribd.com

Make AMOUNT Field Non Updatable When Status is Unreconciled
The following example will demonstrate a personalization, using Form Personalization, in the Enter/Reconcile Bank Statement form. Navigation: Cash Management > Bank Statements > Bank Statements and Reconciliation Requirement: Make the Amount field non updatable when status = 'Unreconciled'. This is required for each event WHEN_NEW_RECORD_INSTANCE Set-up a Rule with Trigger Event WHEN-NEW-RECORD-INSTANCE. Select LINES Trigger Object Enter the Condition :lines.status_dsp = 'Un

Enabling The Select All in The Write-Off Form
This post in in response to Wishall's inquiry. Requirement: The original requirement was to enable the "Select All" menu entry to be able to select all the lines queried. From a functional perpective, I will be using a slightly different approach to solution the requirement. I will be using Form Personalization to enable the "Auto-Select" check box upon entering the Find Write-Off Transactions Form to replicate basically the

Duplicating Values Using Form Personalization
The following is an example for duplicating a value from one field to another using Form Personalization. Requirement: While defining a new item in the Item Master, the user would like for the item description value to be automatically populated to the item long description field when the user saves the record. Rule sequence: 10 Description: Auto-populate item description value to long item description field Trigger Event: WHEN-VALIDATE-RECORD Trigger Object:

How to Capitalize First Letter Using Form Personalization
The following example is based on information published in Anil Passi's post in response to a requirement from one of his readers (Niraj on comment #10). For those of you who have not yet visited Anil's blog, it is filled with tons of information on various Oracle subjects. It is truly a must see:) This is a popular requirement you will get from clients. Requirement: The cli

Personalize the Enter and Maintain People form
The following will personalize the "Enter and Maintain People" form. It is a solution for a requirement posted by Khathu, a reader on this blog. When "Mr." is selected, the gender field will change automatically to "Male". Use the same logic if you want to make other similar rules. Navigate to and open the Enter and Maintain People window using the HRMS Management responsibility Enter the Form Personalization form. (M) Help > Diagnostics > Custom Code > Personalize Rule

Oracle Form Personalization - Personalize the Master Suppliers Form
I have not had a chance to publish new content lately so here is a new post on Form Personalization for the Supplier Form. This example was triggered by a reader (Ankur) who was asking a solution to his business requirement. Many clients might have similar requests so I thought it deserved a post. Here are the details: Business Requirement The client wants to personalize the Suppliers master form. The requirement is that if a particular supplier is a 'Carrier' then the information in th

Making Buttons Bigger or Wider in Oracle Forms
From time to time, clients will require an Action button to be bigger on a specific Form. The following example will demonstrate the actions requires to make the "Find" button" larger within the Query Material form (INVMATWB) in Oracle Inventory. It' a very simple request but helpful. Use caution when altering button sizes. You need to be aware of the X_POS and Y_POS, they might have to adjusted. EXAMPLE # 1 From the Inventory Super User Responsibility, navigate to On-hand, Av

Another Zoom example using Oracle Form Personalization
This example will demonstrate a Zoom from the AR Transactions form the AR Receipts form. A value (CASH_RECEIPT_ID), generated with a SQL statement, will be passed and defaulted to the AR Receipts form. The Rules definition logic will be as follows: For the AR Transactions form Create Menu Item "Receipt Details" Check for NULL value Set Value of Global Variable and launch Function For the AR Receipts form Set Initial Value of Global Variable Go to Block RGW_F

How to create a Zoom using Oracle Form Personalization
This next example will feature the definition of a Zoom using Oracle Form Personalization functionality. We will define a Zoom from the PO form to the Supplier form. This is a request that clients often ask for. We will need to define three Rules for each of the forms used to achieve this. Each Rules will have their own set of Conditions and Actions. The Rules definition logic will be as follows: For the PO form Create Menu Item Check for NULL value Open the Supplier form

Oracle Form Personalization, Intermediate Examples II
As mentioned in my last post yesterday, the following Form Personalization intermediate example demonstrates a change to the Responsibilities form title. When the Responsibilities form has a query record, the form's title will be "Responsibilities ('RECORD QUERIED')" with 'RECORD QUERIED' being the Responsibility Name of the actual record being queried. When there is no record, the title will be "Responsibilities ('NEW')". EXAMPLE # 2 Navigate to the Responsibilities window using the

Oracle Form Personalization, Intermediate Examples
Following my two previous entries on Form Personalization, here is an example of an intermediate custom using Form Personalization. Once again, this example requires very little time to set up (like 2 minutes!) and no code programming was required in the CUSTOM Library (swwweet!). For this first example, we will set up a dialog box asking the user if they want to enter the Item Master window in Query mode. A "Warn" message type and a builtin will be defined and this personalization will