HRMS Assignment

1. How do you change the Secondary Assignment to become the Primary Assignment?
To make a secondary assignment the primary assignment, follow the steps
listed below:
Responsibility = Must be a HRMS Responsibility
Navigation = People ->Enter and Maintain -> Assignment
Form Name = PERWSEMA or PERWSHRG (Assignment)
1. Sign into Oracle Applications and navigate to the
Assignment form by clicking on People ->Enter and Maintain.
2. Query an employee and click on the [Assignment] button.
3. Date-track to the date you want the change to take affect.
4. Query back the relevant secondary assignment.
5. In the alternate region, select Miscellaneous.
6. Make sure the 'Primary' flag is marked and save the record.
Note: Some times you have to exit the application and come back in to view the changes to the record.

2. How do you end a Secondary Assignment?
Answer Set your effective date to the actual termination date for the assignment and update the assignment status to End or Terminate Assignment as follows:
Responsibility = Must be a HRMS Responsibility
Navigation = People ->Enter and Maintain ->Assignment
Form Name = PERWSEMA or PERWSHRG (Assignment)
1. Sign into Oracle Applications and navigate to the Assignment form by clicking on People ->Enter and Maintain. Query an employee and click on the [Assignment] button.
2. Date-track to the date you want the change to take affect.
3. Query back the relevant secondary assignment.
4. In the Status field, select End or Terminate Assignment from your list of values.
For example, if you want to terminate the assignment on the 1st of June you would date-track to the 1st of June and perform the above steps. -- Use Status = End, if all pay processing for the assignment is finished. This makes your effective date the assignment's final processing date, after which no further processing for the assignment can occur. -- Use Status = Terminate Assignment, if further pay processing of the assignment is required after the date the assignment ends.

3. How do you input Default Expense Codes for Payables in a full install of HR?
Value is input through Purchase Order Information stacking (alternate) Region on Assignment form (PERWSEMA or PERWSHRG).
Responsibility = Must be a HRMS Responsibility
Navigation = People ->Enter and Maintain ->Assignment
Blue pull-down menu - alternate region
Select Purchase Order Information. Form Name = PERWSEMA or PERWSHRG (Assignment)
This option only appears in the alternate region when Oracle Financials are
installed.

4. Using a secure user responsibility you are receiving an error on the People
Form(PERWSEPI) and assignment form (PERWSHRG).
Value XX is invalid.
*XX can be any number.
Answer The error message is produced when the GRE assigned to the employee's
assignment record is not in the secure user's security profile. Therefore the
secure user has not been given access to this GRE. To confirm, using a "view
all" responsibility, navigate to the assignment form and display the GRE
information for the employee.
Please Note: If you use the secure user responsibility, you will not be able to
see the GRE. The List of Values is controlled by the security profile.
People ->Enter and Maintain
Query back employee
Hit
GRE's and other data
Note the GRE Name.
Now switch your responsibility to the secure user and navigate to
Work Structures ->Organization ->Description
You will not be able to query the GRE assigned to the employee, because your
secure user has not been given access to it.
The secure user must either be given access to the GRE via the security
profile, or the employee must be assigned to a GRE already accessible by the
secure user.

5. You are entering information on the employee assignment screen PERWSEMP. Upon saving the employee assignment you get the following error: 'Please Choose a Valid Combination? What is the cause of this error?
Responsibility = Must be a HRMS Responsibility
Navigation = People ->Enter and Maintain
Enter employee information
Go to Assignment and enter data SAVE receive error Please Choose a Valid Combination
Answer When defining the Key Flexfields, Allow Dynamic Insertion must be checked.
In this situation it was the Flexfield People Group which did not check the
Allow Dynamic Insertion checkbox..

6. What is the possible reason for the system hanging on the Assignment Form? For instance, you are in the Assignment form and date-track to an earlier date. You then make any change and try to save but the system hangs.
Answer One of the possible reasons this is occurring is the element link
created was not date-tracked correctly. The element and link are both in
date-track tables. The person that this problem is occurring for probably had
an API insert this element to a person before the link's dates.
You should check to see if the link was created after the element being applied
to this person. Navigation: Total Compensation > Basic > Link. You can check the link start date by going
to the Alternate Region and clicking on the Miscellaneous tab.
You must remove the element from the person and correct the link by end-dating
the link and re-creating another one.
Another possibility would be to remove the element from the person, thereby
freeing the link to be removed and correctly inserted with the correct date.

7. When a new employee is created in HR, an assignment record is created
by default - with an organization, location and Assignment status.
Can this be stopped, so that the user can create an assignment when
they are ready with all the information for the assignment?
Answer Information for the assignment is automatic. This is the functionality
of the product and the defaults are tied to the Responsibility. HR
Security Profile pulls the Business Group, the location defaulted is the
location for the Business Group.

8. How do you create an employee who is currently an applicant? You are trying to hire an employee who is currently recorded in the system as an applicant. You receive the following error: APP-52347: The hire date is outside the DD-MON-YYYY and 31-DEC-4712
Answer The status of the application must be changed to Accepted before the
applicant can be changed to an employee. Once that is completed, you
cannot hire the employee on the same day that the application is
accepted. Datetrack forward one day to complete the transaction or
datetrack back one day to set the application status to accepted and
then reset to today to hire the employee. See Note 99066.1 for more
information.

9. How do you add the GRE and Other Data Tab back to the Assignment Form? After applying PER.G
unable to open the GRE and Other Data Tab on Assignment Form.
Answer Verify that your Profile Option: Flexfields: Open Key Window is set to "Yes".
System Admin/Profile/System
Responsiblity: US HRMS Manager
Option: Flex%Open%Key%

ORACLE HUMAN RESOURCES

1. What are the seeded Person Types?
Person types are used to describe people entered into the Oracle Human Resources product. The person types names may be modified if needed, or new person types can be added. In 10.7 and 11.0.3 there are eight person types delivered by the system, and identified by a system name. For each, there is a predefined user name. You can change the predefined name and you can create unique user names.
The 10.7 and 11.0.3 delivered person types are:
Applicant
Applicant and Ex-Applicant
Employee
Employee and Applicant
Ex-applicant
Ex-employee
Ex-employee and Applicant
External
In 11i additional person types have been delivered to accommodate legislations
and customers using 11i benefits modules.
The information is stored in PER_PERSON_TYPES.
In 10.7 and 11.0.3 go to PER_ALL_PEOPLE_F to PER_PERSON_TYPES. In 11i go to PER_PERSON_TYPE_USAGES_F and then to PER_PERSON_TYPES.

2. Where do I add or change the person types? (10.7/11.0.3 & 11.5.x)
In application versions 10.7, 11.0.3 and 11.5.x follow this navigation:
Other Definitions > Person Types.
To change a user name for a Person Type:
Delete the contents of the User Name field and type in your preferred name. To map other User Names to a Person Type system name:
A. Select New Record from the Edit menu.
B. Enter a unique User Name and select the System Name to which you want to map.
Deactivating User Names
You cannot delete User Names in use in the system, but you can deactivate them by unchecking the Active check box. Notice that you cannot deactivate a default User Name. You must first select another User Name as the default.

3. Can external Person Types be contacts?
Yes, anything defined with a System Name of External is considered a contact and will appear in the Contact Type list of values. A contact is someone associated with an employee or an applicant. For example, people who are dependents of employees, people whom employees name as beneficiaries, and people whom employees list as their contacts in case of emergency are all entered as contacts.

4. There is a new form in application version 11.5.x called Person Type Usage. How
does this work in connection with the person types?
This new form in 11.5.x (Navigation: People> Enter & Maintain, Others) is called Person Type Usage. If you need to change the user value for any person type applied to a person, you do this in the Person Type Usages window, which is now datetracked for HR user person type changes. The information is stored in the table: PER_PERSON_TYPE_USAGES_F. The form is also used by 11i Benefits module customers for managing benefits.

5. What is the difference between the Contact Type and the Relationship Type on the Contact form (PERWSDPC)?
The Type field refers to the Person Type as defined in the Person Types form. The information is stored in the PER_PERSON_TYPES table. It is defined and maintained in the Person Types (PERWSDPT) form located under Other Definitions off the main navigation menu. Anything defined with a system name of external is considered a Contact and will show up in the Contact Type list of values.
The Relationship Type refers to the definition of the association that this contact has to the employee (i.e. spouse, emergency contact, friend, etc.). The information is stored in the PER_CONTACT_RELATIONSHIPS table. The list of values is created and maintained in the Other Definitions > QuickCode Values navigation on the main menu.

6. Why does the Person Type that I just created not show up on my list of values on the Enter and Maintain form?
If the Person Type has a system name of 'External' then that Person Type is not eligible for this list of values. 'External' system name values are Contacts.

7. How do I delete or end date a Person Type?
Person Type cannot be deleted or end dated. The Person Type may only be deactivated. Navigate to Other Definitions > Person Types. The user may either check or uncheck the Active column.

8. What has happened to the 11i person types since applying PER G (1988754)?
After applying PER G, the person type field is not available for direct updates on the Person form. (Navigation: People > Enter & Maintain) The functionality of this field has been changed. The Type field (person_type) now works in relation to the Action field that appears under the Type.
These changes were also explained in the PER G readme.
The manner in which person types are recorded against a person has been changed to enable you to record multiple person type records against a person. Now you can update a person's type using the new Actions field available on the People form. For example, when you create a new employee select the Create Employment action and a list of user person types for the system person type of Employee is displayed for your selection. If this person also becomes an applicant, you select the Create Applicant action and an applicant record is created for the person. The Type value now displayed will be Employee.Applicant.
Previously, using the example above, this person would have been given a single person type of 'Employee and Applicant'. With this new functionality this person will have two records, one Employee and one Applicant. This is displayed in the Type field as a concatenated version of the two types. If you are using the default user values for these types, the value displayed is Employee.Applicant.
If you need to change the user value for any person type applied to a person, you do this in the Person Type Usages window, which is now datetracked for HR user person type changes.
Navigation: People > Enter & Maintain, Others.
This means you can reduce the number of system person types that need to be maintained and offer greater flexibility in defining person type combinations. The eight system person types previously recognized by the application continue to be maintained for existing persons but can no longer be used for new records in 11i.
Because of this update you may need to make a few changes to your application in order for it to work with the latest data.
If you are using the USER_PERSON_TYPE column of the PER_PERSON_TYPES table
in your custom reports or forms you must redirect them. Instead of going from PER_ALL_PEOPLE_F to PER_PERSON_TYPES, you will need to initially join to PER_PERSON_TYPE_USAGES_F and then go to PER_PERSON_TYPES.
If you have any formulas that use the following database items, you should replace them with the new items as the current ones will be obsoleted in a future patch. See the following listed columns of Current DB Items and its corresponding New DB Items.
Current DB Item: New DB Item:
PER_PERSON_TYPE PTU_PER_PERSON_TYPE
CON_PERSON_TYPE PTU_CON_PERSON_TYPE
REC_PERSON_TYPE PTU_REC_PERSON_TYPE
SUP_PERSON_TYPE PTU_SUP_PERSON_TYPE
The new person type usages model enables you to have more flexibility when using person type as a parameter to create customized windows. You should no longer need be able to customize windows by Person Function and therefore this option will be removed.

SQL*Plus

1 Which command in SQL*Plus is used to save the query output to a file?
SPOOL

2 How would you extract a SQL statement in the SQL buffer of SQL*Plus?
Enter a SLASH (/)

3 What is the default display length of the DATE Datatype column?
Eight

4 Which Clause in a query limits the rows selected?
WHERE

5 Which SQL*Plus command always overwrites a file?
SPOOL

6 Which single-row function could you use to return a specific portion of a character?
SUBSTR

7 Which of the following is not a Group Function? (AVG, COUNT, LEAST, STDDEV, VARIANCE)
LEAST

8 When using multiple tables to query information, in which Clause do you specify the table names?
FROM

9 What are the special characters allowed in a table name? (&, #, @, $)
#, $

10 What is the default length of a CHAR Data type column, if no length is specified in the table definition?
1

11 Which named PL/Sql program must return a value?
FUNCTION must include a RETURN statement and must return a value

12 How do you return multiple values from a procedure?
Use OUT parameter
OUT parameters pass values out of a procedure
IN parameters pass values into the procedure

13 Which section of the PL/Sql block handles errors and abnormal conditions?
EXCEPTION SECTION

14 What is the mandatory clause in a SELECT statement when used inside a PL/Sql block?
INTO

15 In which section of a PL/Sql block is a constant assigned value?
DECLARATION SECTION

16 What is the name of the Pl/Sql block that is associated with a table and executes automatically when an event occurs?
TRIGGER

17 What type of constant can be defined when you declare a variable?
NOT NULL

18 What is the PL/Sql stored program that fire when an event occurs?
TRIGGER

19 In a PL/Sql block, what is the value of SQL%NOTFOUND before executing any DML Statement?
NULL

20 Which of the following requires an explicit cursor if processing more than one row? (SELECT, UPDATE, DELETE, INSERT)
SELECT

21 Which commands are allowed inside a PL/Sql block? (TRUNCATE, DELETE, SAVEPOINT, ALTER TABLE)
DELETE, SAVEPOINT
DDL Statements are not allowed inside a PL/Sql block
TRUNCATE and ALTER TABLE are DDL statements

22 What is the PRAGMA exception_init used for?
To associate an exception name with and exception number
Exception_init is used to associate (give a name) to an error number

23 What command do you use to induce an error condition?
RAISE

24 What causes a TOO_MANY_ROWS exception?
A SELECT INTO returned more than one row

25 Which of the following types of exceptions cannot be handled in an exception? (Syntax Errors, database Errors, Datatype Mismatch Errors, Divide By Zero Errors)
Syntax Errors
Syntax Errors are handled by PL/Sql compiler and not the runtime engine
The exception section cannot handle them

26 What function can be used to retrieve the error number for the current exception?
SQLCODE

27 What function can be used to retrieve the text associated with the current exception?
SQLERRM

28 What Clause do you need to include in your exception section to handle any exception not previously specified?
WHEN OTHERS

29 At a minimum, how many join conditions should be there in the WHERE Clause to avoid a Cartesian join if there are Three Tables in the FROM Clause?
2
There should be at least (n - 1) join conditions when joining (n) tables to avoid a Cartesian join

30 A view can only be used to query and update data, you cannot Insert into or delete from a view. True or false
FALSE

31 Which option is not available in Oracle when modifying tables? (Add new Columns, Rename an Existing Column, Drop an Existing Column)
Rename an Existing Column
You cannot rename an Existing column using ALTER TABLE