29 January 2009

How to generate, develop or edit a QuickPaint Report or Formula in Oracle HRMS

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


Please share your views about this Article.For more articles visit About Oracle Apps


Continue Reading..>>

Fast Formula to Validate User Tables in Oracle HRMS

In this practice you will learn how to write a fast formula that validates the user table. For this you need to first write a validation formula and then select the formula in the Columns window and test it by entering values outside the valid range in the Table Values window.

Writing Formulas to Validate User Tables
Write a validation formula that returns an error and a message if a user enters a value less than 10 or greater than 50 in the Dues column of your Union Dues user table. Name the formula XX_CHECK_UNION_DUES, where XX is your group identifier.

Select the formula in the Columns window, and test it by entering values outside the valid range in the Table Values window.

Writing Formulas to Validate User Tables
1. Navigate to the Formula window using your local Super HRMS Manager responsibility.
(N) Total Compensation > Basic > Write Formulas
2. Set your effective date to 1 January 2000.
3. Enter XX_CHECK_UNION_DUES in the Name field.
4. Select User Table Validation in the Type field.
5. Select the Edit button.
6. Write your formula, and verify it.
7. When the formula verifies successfully, close the Edit Formula window.
8. Save your work.

Formula
Your formula should be similar to the following:

INPUTS ARE entry_value(text)
IF TO_NUM(entry_value) <> 50
THEN
(formula_status = 'e'
formula_message = 'Union Dues must be between 10 and 50. Please re-enter.')
ELSE
formula_status = 's'
RETURN formula_status, formula_message

Selecting the Validation Formula in the Columns Window
9. Navigate to the Table Structure window using your local Super HRMS Manager responsibility.
(N) Other Definitions > Table Structure
10. Set your effective date to 1 January 2000.
11. Query: xx Union Dues in the Name field, where xx is your group identifier.
12. Select the Columns button.
13. Select your validation formula in the Formula field.
14. Save your work.

Testing Your Validation Formula
15. Navigate to the Table Values window using your local Super HRMS Manager responsibility.
(N) Other Definitions > Table Values
16. Set your effective date to 1 January 2000.
17. Query: xx Union Dues, where xx is your group identifier.
18. Select Query By Example - Run from the View menu.
19. In the Union A row of the Values region, enter 5 in the Value field. Tab to the next field. Your error message should be displayed.
20. Re-enter 30 and tab to the next row.
21. Select Correction.
22. Enter 60 in the Value field and tab to the next field. Again, your error message should be displayed.
23. Re-enter 32.
24. Select Correction.
25. Save your work.

Please share your views about this Article.For more articles visit About Oracle Apps


Continue Reading..>>

02 January 2009

Oracle Apps Technical Interview Questions

Below is the list of question asked in Oracle Apps Technical Interviews.

1. Explain Directory Structure of APPS?
2. How to activate, deactivate and run Concurrent Managers?
3. What is the location for concurrent request or manager logfiles and output files?
4. Specify the standard naming conventions for the logfile and output file?
5. How to write LOG information from PL/SQL block to log file?
6. What is Request Group?
7. What is Request Set?
8. What is difference between the Request Group and Request Set?
9. What are the steps to develop a simple Oracle Apps form?
10. What are the important Libraries in Template.fmb?
11. Which Concurrent Manager will run when you run the report in Oracle Application ?
12. How to create a Multi-org report in Apps?
13. State the mandatory parameters while developing Multi-org report in Apps?
14. What is the Schema for AOL?
15. What is the significance of :$FLEX$ ?
16. State some of the FND tables?
17. How to create Query-only form in Oracle Apps with out touching the fmb file?
18. What is the profile option pertaining to Operating Unit?
19. What is the difference between Applsys and Apps?
20. How to Register Shell Script Program in Oracle Applications? How to use parameters while registering shell script as a concurrent program?
21. How to Register PL/SQL Stored Procedure in Oracle Apps? What are the Mandatory thing we need to do for creating PL/SQL Procedure before Registering into Apps?
22. What is Zoom? How to enable zoom feature using Custom.pll?

Please share your views about this Article.For more articles visit About Oracle Apps


Continue Reading..>>

How to register shell script as concurrent program?

Below is the step by step process of registering shell script as a host program or concurrent program in Oracle Applications.

1. Create a shell script ( say xyz) and move it to the appropriate BIN directory in Oracle Application.
2. The parameters in the shell scripts should start with $5 , $6 Onwards.
3. Rename the shell script to *.prog ( xyz.prog).
4. Change Permissions to 755 for the *.prog file.
5. Create Link to the shell Script ( ln -s $FND_TOP/bin/fndcpesr/xyz.prog) to create xyz file.
6. Now Register this executable in the application as a host executable (Using System Administrator Responsibility).

While registering the shell script as a concurrent program make sure that the first parameter in the concurrent program is passed as the Fifth parameter in the shell scripts because the first four parameters are allocated to userid,request_id,resp_id,resp_appl_id.


Please share your views about this Article.For more articles visit About Oracle Apps


Continue Reading..>>

29 December 2008

Oracle Fast Formula Tutorial-Defining User Tables and Accessing Table Values

You should now be familiar with Oracle Fast Formulas. In the following tutorial you will learn how to define user tables and access table values in Fast Formulas.

Assignment

Create a user table called xx Union Dues (where xx is your group identifier), using the following information.Enter 30 and 32 as Value against column dues.

Row1-Union A 30
Row2-Union B 32

Then write a formula called XX_UNION_DUES to get the appropriate deduction from the table, using the input Union.

Tasks to be carried out
Defining User Tables and Accessing Table Values

Imagine a company has defined a deduction for union dues. The deduction element has one input value (Union) for entering the name of the union to which the employee subscribes: Union A or Union B.

1.Create a user table called xx Union Dues (where xx is your group identifier), using the following information.

Union A 30
Union B 32

2.Then write a formula called XX_UNION_DUES to get the appropriate deduction from the table, using the input Union.

Solution - Defining User Tables and Accesing Table Values
Defining the Table Structure

1. Navigate to the Table Structure window using your local Super HRMS Manager responsibility.
• (N) Other Definitions > Table Structure
2. Set your effective date to 1 January 2000.
3. Enter xx Union Dues in the Name field, where xx is your group identifier.
4. Select Match in the Match Type field.
5. Select Number in the Key Units of Measure field.
6. Enter Union in the Row Title field.
7. Save your work.
8. Select the Columns button.
9. Enter Dues in the Name field of the Columns window.
10. Save your work.
11. Close the Column window.
12. Select the Rows button.
13. Enter 1 in the Sequence field and Union A in the Exact field of the Rows window.
14. Select New from the File menu.
15. Enter 2 in the Sequence field and Union B in the Exact field of the next row.
16. Save your work.
Entering Table Values
17. Navigate to the Table Values window using your local Super HRMS Manager responsibility.
• (N) Other Definitions > Table Values
18. Set your effective date to 1 January 2000.
19. Query: xx Union Dues, where xx is your group identifier.
20. In the Values region, select Union A in the Exact field and enter 30 in the Value field.
21. Tab to the next row and select Union B in the Exact field and enter 32 in the Value field.
22. Save your work.
Writing the Formula
23. Navigate to the Formula window using your localSuper HRMS Manager responsibility.
• (N) Total Compensation > Basic > Write Formulas
24. Set your effective date to 1 January 2000.
25. Enter the name XX_UNION_DUES, where xx is your group identifier.
26. Select Oracle Payroll in the Type field.
27. Select the Edit button.
28. Write your formula in the Edit Formula window, then select the Verify button.
29. When the formula verifies successfully, close the Edit Formula window.
30. Save your work.
Formula
Your formula should be similar to the following:
DEFAULT FOR union IS ' '
INPUTS ARE union(text)
deduction = 0
IF NOT union WAS DEFAULTED
THEN
deduction = TO_NUMBER(GET_TABLE_VALUE('xx_union_dues',
'dues', union))
RETURN deduction

Note: To complete the setup for the union dues deduction, you would:

• Define a formula processing rule to associate the formula with the Union Dues Deduction element
• Define a formula result rule to return the union_dues formula result to the element’s Pay Value

Please share your views about this Article.For more articles visit About Oracle Apps


Continue Reading..>>

 

© 2008 About Oracle Apps - A Complete Guide to Oracle Applications Professionals. | Contact|About us.

All articles are copyrighted to About Oracle Apps.