Have any question?
+2 0100 62 62 837
[email protected]
Register Login

Login with your site account

Lost your password?

Not a member yet? Register now

AppsLead | Learn Oracle From The LeadersAppsLead | Learn Oracle From The Leaders
  • Home
  • Courses
    • About Courses

      • Free Training
        • Oracle ebusiness suite Free
        • Oracle Fusion Free
      • Online Live Training
        • Oracle ebusiness suite
        • Oracle Fusion
        • Oracle Database
        • Java & Middleware
      • All Training Courses
      • Training Schedule
      • Register For Live Course
      • Join Our Team
      • Exam Request
  • Blog
    • Oracle ebusiness Suite
      • Oracle Financial
      • Oracle HCM
      • Oracle SCM
    • Oracle Fusion
      • Fusion Financial
      • Fusion HCM
    • Our Authors
    • Be an Author
  • Schedule
  • FAQs
  • About Us
    • About Us
    • Our Services
    • Our Authors
  • Contact Us
  • Home
  • Courses
    • About Courses

      • Free Training
        • Oracle ebusiness suite Free
        • Oracle Fusion Free
      • Online Live Training
        • Oracle ebusiness suite
        • Oracle Fusion
        • Oracle Database
        • Java & Middleware
      • All Training Courses
      • Training Schedule
      • Register For Live Course
      • Join Our Team
      • Exam Request
  • Blog
    • Oracle ebusiness Suite
      • Oracle Financial
      • Oracle HCM
      • Oracle SCM
    • Oracle Fusion
      • Fusion Financial
      • Fusion HCM
    • Our Authors
    • Be an Author
  • Schedule
  • FAQs
  • About Us
    • About Us
    • Our Services
    • Our Authors
  • Contact Us

Blog

  • Home
  • Blog
  • Change data in LOV using Forms Personalization

Change data in LOV using Forms Personalization

  • Posted by Sameh Bakkar
  • Categories Blog
  • Date January 31, 2013
  • Comments 0 comment
Sometimes you will need to change displayed date in list of value. Hum, say that we need to show only one category of HR leave when an employee appling for new vacation. so now our goal to change the love data in absence type which located in absence form under HRMS responsibility. Steps: 1- Navigate to Human Resource responsibility then open enter and maintain screen 2- Press on other button then select absence 3- In the first filed, absence type , change LOV In such a way that only ‘OTH’ category will displayed. 4- Navigation: Help Menu >> Diagnostics >> Custom Code >> Personalize 5- Enter the information as per below screen:   6- Click on Actions and enter the following. Seq: 1 Type: Builtin Language: all Builtin type: Create Record Group from Query Argument: Paste your new SQL statement here. In this case it would be

select a.absence_attendance_type_id, a.name, iv.element_type_id, a.absence_category, a.hours_or_days,iv.name, a.increasing_or_decreasing_flag, iv.uom, a.input_value_id, a.date_effective, nvl(a.date_end, :ctl_globals.end_of_time) date_end, (select hrl.meaning from hr_lookups hrl where hrl.lookup_type = 'ABSENCE_CATEGORY'and hrl.lookup_code = a.absence_category) category_meaning from pay_input_values_f iv, per_abs_attendance_types_vl a where ((a.business_group_id = :ctl_globals.business_group_id) or a.business_group_id is null) and a.input_value_id = iv.input_value_id(+) and nvl(a.date_end, :ctl_globals.end_of_time) >= :ctl_globals.session_date and ((a.input_value_id is not null and :ctl_globals.session_date between iv.effective_start_date and v.effective_end_date) or (a.input_value_id is null)) <strong>and a.ABSENCE_CATEGORY = 'OTH'</strong> order by a.name

7- Now Create New Record with below information Seq:2 Type: Property Language: All Enabled: Checked Object Type: LOV   8- Apply 9- Test

Tag:Change data, Change data in LOV, Forms, Forms Personalization, Personalization

  • Share:
Admin bar avatar
Sameh Bakkar
Sameh Bakkar has over 15 years Oracle Applications implementation experience (EBS/Fusion) and he is an Oracle authorized trainer. He has in-depth technical and Functional knowledge of Oracle Applications and Oracle HCM Cloud. Sameh has excellent experience in Team management, Man Power and resource planning, and Pre-Sales management Process. Additionally he has also given Best Practices seminars on Oracle e-business suite and Oracle Fusion.

Previous post

How To Get The Password For Any Oracle Apps User?
January 31, 2013

Next post

How to hide the Global links which appear on the Top of OAF Pages
31 January, 2013

You may also like

  • Entering Request for Quotations (RFQ)
    19 June, 2012
  • HRMS Assignment Migration – API
    9 March, 2011

Leave A Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Categories

  • Blog
  • Fusion HCM
  • Oracle ebusiness Suite
  • Oracle Financial
  • Oracle Fusion
  • Oracle HCM
  • Oracle SCM

Latest Courses

R12.x Oracle E-Business Suite Essentials for Implementers

R12.x Oracle E-Business Suite Essentials for Implementers

Free
R12.x Oracle HRMS Work Structures Fundamentals

R12.x Oracle HRMS Work Structures Fundamentals

Free
R12.x Oracle Payroll Fundamentals

R12.x Oracle Payroll Fundamentals

Free
AppsLead | Learn Oracle From The Leaders

+2 0100 62 62 837

[email protected]

Company

  • About Us
  • Blog
  • Contact Us

Links

  • Events

Copyright © 2017 AppsLead, All rights reserved. Developed by ECDSCS Co.

  • Privacy
  • Terms
  • Sitemap