Default Value In Text Filed Through Personalization

Are you able to default a value in a text filed through personalization? How to do it?

Answer

Responsibility: System Administrator

1 – Ensure to set system profile ‘Hide Diagnostics menu entry’ to ‘No’ and ‘Utilities: Diagnostics’ to ‘Yes’ at the user level.

2 – Open the Users form. (N) Security > User > Define.

3 – This is the basic Users form as shown here:
 

Oracle Basic Users Form

4 – From the menu, select (M) Help > Diagnostics > Custom Code > Personalize.

5 – If some Rules are already defined in the Users form, you will see them this window (as in this example).

6 – Add a new Rule by selecting (M) File > New.

7 – This is the Form Personalization form and it’s Rules already defined. We will be adding seq. 40.
 

Oracle Form Personalization (Users)

A – Rules Seq.: 40

B – Description: Hide Person, Customer and Fax fields

C – Trigger Event: WHEN-NEW-FORM-INSTANCE

D – Context or Scope: Set at User level and enter your user in the Value field

E – Select the Actions tab. This is the Actions tab of Rule seq. 40
 

Oracle Form Personalization (Users) Actions tab

F – Action Seq.: 1

G – Type: Property

H – Object Type: Item

I – Select the Select By Text button
 

Oracle Form Personalization (Users) Actions tab Select by text button

J – Select the Person (Users) item from the LOV

K – Property Name: DISPLAYED

L – Value: False

M – Save your work

N – When you are done, it should look like this:
 

Oracle Form Personalization (Users) Actions tab Actions seq. 1 final

O – Repeat Steps F to L for the Customer and Fax items. Save all of your work. It should now look like this:
 

Oracle Form Personalization (Users) Actions tab Actions all seq. final

P – Close the Form Personalization form, close the User form and reopen it. Your User form should now look like this: Notice that the User, Customer and Fax fields are no longer displayed.
 

Oracle Form Personalization (Users) Final

Oracle Application

See Also
Oracle Financials Faqs

Have a Oracle Question
Do you have an Oracle Question?

Oracle FI Books
Oracle Financials and Certification Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.