Subscribe: The Apps Traction Blog
Preview: The Apps Traction Blog

The Apps Traction Blog

Welcome to The Apps Traction Blog. I'm a functional consultant from Québec City looking to discuss and share ideas and tips with other implementers and IT professionals about Oracle EBS applications.

Published: Sat, 24 Mar 2018 07:05:22 +0000


Disable a Button

Thu, 07 Jun 2007 11:41:35 GMT

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

Tue, 15 May 2007 15:16:37 GMT

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

Tue, 15 May 2007 13:40:31 GMT

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

Tue, 08 May 2007 15:59:02 GMT

For those looking to find out what Form Personalization offers, follow this link for a complete description recently published on Metalink:

Make AMOUNT Field Non Updatable When Status is Unreconciled

Tue, 01 May 2007 14:49:08 GMT

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

Fri, 27 Apr 2007 11:15:26 GMT

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

Thu, 26 Apr 2007 15:58:25 GMT

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

Wed, 25 Apr 2007 15:54:08 GMT

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

Tue, 06 Feb 2007 10:50:38 GMT

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

    Wed, 17 Jan 2007 15:49:42 GMT

    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

    Wed, 13 Dec 2006 12:40:23 GMT

    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

    Wed, 01 Nov 2006 10:32:22 GMT

    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

    Wed, 04 Oct 2006 15:21:21 GMT

    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

    Wed, 04 Oct 2006 10:23:23 GMT

    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

    Tue, 03 Oct 2006 08:28:28 GMT

    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