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
  • QuickPaint Report in Oracle HRMS

QuickPaint Report in Oracle HRMS

  • Posted by Sameh Bakkar
  • Categories Blog
  • Date July 18, 2012
  • Comments 0 comment
Hi Dears, In this article you will learn how to define a QuickPaint Report in Oracle HRMS. The article also speaks about how to edit QuickPaint Formula. Defining a QuickPaint Report
1. Define a QuickPaint report that displays contact information for an employee. For example, your report could display the following database items: PER_EMP_NUMBER PER_FULL_NAME PER_KNOWN_AS PER_WORK_PHONE PER_ADR_PHONE_1 PER_MAIL_DESTINATION PER_SEND_EXPENSES CON_FULL_NAME CON_WORK_PHONE CON_ADR_PHONE_1 2. Query the generated formula in the Formula window. 3. Find the Line displaying the PER_KNOWN_AS database item. 4. Edit the formula so that this line is displayed only for employees who have a preferred name on record. Solution – Writing Generating and Editing a QuickPaint Report Defining a QuickPaint Report 1. Navigate to the Define QuickPaint Report window using your local Super HRMS Manager responsibility. • (N) Processes and Reports > Define a QuickPaint Report 2. Enter the name XX_Employee_Contact_Details (where xx is your group identifier) and, optionally, a description for your report. 3. Enter a report header and labels for your data in the Report Definition area. 4. Select the Show Items button and run queries to find the database items you want to include in the report. Copy each item and paste it into the Report Definition area. 5. When you have the field labels and database items in the appropriate positions, save your work. This generates a formula. Report Definition Your report definition should be similar to the following: Employee Contact Details ——————————– Employee Number: &PER_EMP_NUMBER Employee Name: &PER_FULL_NAME Preferred Name: &PER_KNOWN_AS Home Phone: &PER_WORK_PHONE Work Phone: &PER_ADR_PHONE_1 Address for Mail: &PER_MAIL_DESTINATION Address for Expenses: &PER_SEND_EXPENSES Emergency Contact ———————— Name: &CON_FULL_NAME Home Phone: &CON_ADR_PHONE_1 Work Phone: &CON_WORK_PHONE Editing a QuickPaint Formula 6. Navigate to the Formula window using your local Super HRMS Manager responsibility. (N) Total Compensation > Basic > Write Formulas 7. Query: XX_EMPLOYEE_CONTACT_DETAILS, where xx is your group identifier. 8. Select the Edit button. 9. Find the Line displaying the PER_KNOWN_AS database item. Move this line within an IF statement, as follows: IF NOT PER_KNOWN_AS WAS DEFAULTED THEN LINE06=’Preferred Name: ‘ + PER_KNOWN_AS ELSE LINE06=’ ‘ Note: The line number may be different in your formula. 10. Save your work. Note: If someone resaves the QuickPaint definition, your edits will be overwritten. So copy your formula to a formula of another name, such as XX_EMP_CONTACT_DETAILS_BACKUP. Note: If you are saving to your orginal name a dialog box appears. Select Correction. Formula -Your formula should be similar to the following:
DEFAULT FOR CON_FULL_NAME is ' '
DEFAULT FOR CON_WORK_PHONE is ' '
DEFAULT FOR PER_KNOWN_AS is ' '
DEFAULT FOR PER_FULL_NAME is ' '
DEFAULT FOR PER_EMP_NUMBER is ' '
DEFAULT FOR PER_WORK_PHONE is ' '
DEFAULT FOR PER_MAIL_DESTINATION is ' '
DEFAULT FOR PER_SEND_EXPENSES is ' '
DEFAULT FOR PER_ADR_PHONE_1 is ' '
DEFAULT FOR CON_ADR_PHONE_1 is ' '
LINE01=' '
LINE02='Employee Contact Details'
LINE03='--------------------------------'
LINE04='Employee Number: ' + PER_EMP_NUMBER
LINE05='Employee Name: ' + PER_FULL_NAME
IF NOT PER_KNOWN_AS WAS DEFAULTED
THEN
LINE06='Preferred Name: ' + PER_KNOWN_AS
ELSE
LINE06=' 'LINE07=' '
LINE08='Home Phone: ' + PER_WORK_PHONE
LINE09='Work Phone: ' + PER_ADR_PHONE_1
LINE10=' '
LINE11='Address for Mail: ' + PER_MAIL_DESTINATION
LINE12='Address for Expenses: ' + PER_SEND_EXPENSES
LINE13=' '
LINE14='Emergency Contact'
LINE15='------------------------'
LINE16='Name: ' + CON_FULL_NAME
LINE17='Home Phone: ' + CON_ADR_PHONE_1
LINE18='Work Phone: ' + CON_WORK_PHONE
LINE19=' '
LINE20=' '
RETURN LINE01, LINE02, LINE03, LINE04, LINE05, LINE06, LINE07, LINE08, LINE09, LINE10, LINE11, LINE12, LINE13, LINE14, LINE15, LINE16, LINE17, LINE18, LINE19, LINE20

Tag:Oracle HRMS, QuickPaint Report, QuickPaint Report in Oracle HRMS

  • 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

Entering Request for Quotations (RFQ)
July 18, 2012

Next post

Create a Query only Form
21 July, 2012

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
  • Oracle ebusiness Suite
  • Oracle Financial
  • 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