If you are implementing Oracle HR for France you must also complete the following additional implementation steps.
A number of user defined tables are used by the reports supplied with Oracle HR for France. These tables interpret the data held in the database and convert it into the format required by the particular report.
In order to ensure the tables contain the correct data for your enterprise you must perform the following step:
A number of tables have been supplied with empty columns that must have the relevant values for your enterprise entered. For details of the supplied tables:
See: User Defined Tables
Use the Table Values window.
See: Entering Values Into Tables
The Declaration Unique d'Embauche reports on information in the employee or applicant assignment, depending on whether it is run before or after the hire date. It also retrieves information entered in the Hiring Declaration assignment extra information type. On delivery, you can only access the Hiring Declaration assignment extra information type from the Assignment window, and therefore you can only enter information for employees. To enable your users to enter information in the Hiring Declaration assignment extra information type for applicants you should include it Navigator.
On selecting the assignment extra information from the navigator you can find the required person and assignment combination and enter details accordingly.
Use the Menus window.
See: Oracle Applications System Administrator's Guide
Before you can run the Bilan Social Report process you must first perform the following setup steps.
You must review the item types, and all the associated restriction and key types that have been supplied with Oracle HR for France. Where these do not meet the requirements of your enterprise you must copy and modify them accordingly.
Use the Setup window.
See: Reviewing and Modifying Calculations
The template groups together all the item types that will be used when the Bilan Social Report process is run. It also defines the key types and restriction types that will apply for each item type. If the supplied Example Template does not meet your requirements you must either copy and amend it, or create a new template.
Use the Generic Summary Process window.
See: Creating the Bilan Social Template
If the folders that are supplied do not meet the requirements of your enterprise you must create new folders accordingly.
Use Oracle Discoverer.
See: Using Oracle Discoverer to View the Bilan Social
If the workbooks that are supplied do not display the data required by your enterprise you must create new workbooks accordingly.
Use Oracle Discoverer.
See: Using Oracle Discoverer to View the Bilan Social
In order for a number of the supplied worksheets to work correctly you must amend them according to the values you have entered in you user defined tables. The worksheets that need to be modified are as follows:
C22: This worksheet has a condition set, Medical Examination Type = `Additional', that limits the records retrieved to those with a medical examination type that has a corresponding value of `Additional' in the FR_MEDICAL_EXAMINATION_TYPE user defined table. You must change the condition so that the value (i.e. `Additional) reflects the value in your FR_MEDICAL_EXAMINATION_TYPE user defined table.
R9: This worksheet uses a number of calculations that rely on the FR_EMPLOYEE_CATEGORY user defined table. The calculation R9:AVG(Ouvrier) includes all records with an employment category that has a corresponding value of `Ouvrier' in the FR_EMPLOYEE_CATEGORY user defined table. You must replace all occurrences of `Ouvrier' in the calculation with the required value from your FR_EMPLOYEE_CATEGORY user defined table.
The calculation R9-R10:AVG(Cadre) includes all records with an employment category that has a corresponding value of `Cadre' in the FR_EMPLOYEE_CATEGORY user defined table. You must replace all occurrences of `Cadre' in the calculation with the required value from your FR_EMPLOYEE_CATEGORY user defined table.
R10: This worksheet uses a number of calculations that rely on the FR_EMPLOYEE_CATEGORY user defined table. The calculation R10-AVG(Employee) includes all records with an employment category that has a corresponding value of `Employee' in the FR_EMPLOYEE_CATEGORY user defined table. You must replace all occurrences of `Employee' in the calculation with the required value from your FR_EMPLOYEE_CATEGORY user defined table.
Use Oracle Discoverer.
See: Oracle Discoverer User's Guide
The D2 and the Declaration Mensuelle Obligatoire des Mouvements de Main d'Oeuvre use Oracle FastFormula to define formulas that control some of the data that is retrieved. If the supplied formulas do not meet the requirements of you enterprise you must create new formulas.
Use the Formula window.
You can set up a particular Business group for Commercial or Public Sector-type functionality.
See: Business Group: Setting Up Public Sector-type Functionality
You need to associate the entitlement items you have created for accommodation, awards and decorations with the specific entitlements you have defined for your enterprise.
See: Setting Up Collective Agreement Entitlement Items
You need to associate the salary share with the appropriate physical share.
You need to indicate which of your contact relationships should be treated as dependent child relationships by the application to calculate the number of dependent children.
See: Setting Up Dependent Child Relationship
You can add more reasons and subtypes for statutory situations to meet your business requirements.
See: Reasons and Subtypes for Statutory Situations and Adding Lookup Types and Values.
You must define a default Normal Inactivity statutory situation for a public sector type organization to select an employee as a Fonctionnaire in the specific public sector type organization.
See: Statutory Situations and Entering Additional Personal Information (People Window)
You must link the fields of professional activity to type of public sector before you associate a field of professional activity as the primary area of professional activity in a corps.
See: Linking Professional Activity to Public Sector Type
You can define types of public sector using the predefined value Other in the system lookup is FR_PQH_ORG_CATEGORY. For example, you can define Other as French Army to maintain and process the workforce details in the French army. The lookup has a DDF in the Further Information field to record whether the type of public sector allows incomplete employment time. The incomplete employment time details enable the HR Administrator to enter the agreed number of work hours and the frequency of work for the workforce.
See: Extending Types of Public Sector
Before you can run the Prod'hommale (Workers Election) Declaration process, you must enable the French Workers Election Person extra information type for your responsibility.
See: Setting Up Extra Information Types for a Responsibility
When you define an element, you select a group name. All the elements allocated the same group name normally appear on one line of the pay advice against the group name, rather than the element reporting name. The exceptions are:
If the elements in the group use different rates, the bases are not summed; they appear on separate lines.
If the elements were prorated and the proration dates are different, they are listed on separate lines.
Some classifications behave differently. For example overtime and payments/deductions for absences show all elements separately.
Selecting a group name is required for most classifications. You set up as many group names as you require using the lookup FR_USER_ELENT_GROUP.
If you want to process pay for sickness, maternity, paternity, or adoption absences, then you must perform some additional implementation.
See: Setting Up Sick Pay
See: Setting Up Maternity, Paternity, and Adoption Pay Processing
To customize the details displayed on the Personnel Registry report, you must complete several tasks.
Use the predefined template RUP_TEMPLATE.rtf as a sample while creating your report template. See: Personnel Registry Report Template Tags
Use the following details of the predefined template definition as a sample while creating a new template definition for your report template:
| Column Name | Column Value |
|---|---|
| Name | French RUP Report |
| Code | PERFRRUP |
| Application | Human Resources |
| Data Definition | French RUP Report |
| Type | RTF |
| Start Date | 01-Jan-1900 |
| Default File | RUP_TEMPLATE.rtf |
| End Date (not mandatory) | |
| Default File Language | English |
| Subtemplate (not mandatory) | |
| Default File Territory | United States |
| Description | French RUP Report |
While creating the template definition, you must specify the data definition as French RUP Report as Oracle XML Publisher associates your template definition with this predefined data definition.
While modifying the predefined template, you can add as new fields the values that are available in the lookup FR_RUP_XML_REPORT and HR tables such as PER_ALL_PEOPLE_F, PER_CONTRACTS_F, but not mapped with the predefined report template RUP_TEMPLATE.rtf. You must not add new fields that have no data source in either the FR_RUP_XML_REPORT lookup or HR tables.
To customize the details displayed on the Training Access Individual report, you must complete several tasks.
Use the predefined template BIAF2005.rtf as a sample while creating your report template. See: Training Access Individual Report Template Tags
Use the following details of the predefined template definition as a sample while creating a new template definition for your report template:
| Column Name | Column Value |
|---|---|
| Name | BIAF |
| Code | BIAFXMLR |
| Application | Human Resource |
| Data Definition | BIAFXMLR |
| Type | RTF |
| Start Date | 01-Jan-1900 |
| Default File | BIAF2005.rtf |
| End Date (not mandatory) | |
| Subtemplate (not mandatory) | |
| Default File Language | English |
| Territory Description | United States |
While creating the template definition, you must specify the data definition as BIAFXMLR as Oracle XML Publisher associates your template definition with this predefined data definition.
You can modify the predefined rich text format template by:
Adding new fields in the predefined template to display the required details in the BIAF report. You can add Full Name, Birth Date (date of birth), and Maiden as new fields without changing the existing fields in the predefined template. The full name, date of birth, and maiden name fields are available in the lookup BIAF_LOOKUP_CODE but not mapped with the predefined report template BIAF.rtf. In order to use these field names, you must customize the rich text format template with these label form fields and the corresponding data form field. You cannot add new data form fields.
Changing the name of the existing labels in the template. To change the display name of the labels in the template, you must change the existing values in the lookup BIAF_LOOKUP_CODE.
To meet the training law requirements, Oracle HRMS enables you to print DIF statement for all your employees. You can print the statement using the sample DIF statement template, or you can change the layout to display details that meet your business requirements. To configure the details displayed on the DIF statement, you must complete several tasks. See: Customizing XML Reports
While configuring the statement details, you can:
Use the predefined template DIF_stmt_tmpl.rtf as a sample while creating your statement template. See: DIF Statement Template Tags
Use the following details of the predefined template definition as a sample while creating a new template definition for your statement template:
| Column Name | Column Value |
|---|---|
| Name | DIF Statement Template |
| Code | DIFSTM |
| Application | Oracle Human Resources |
| Data Definition | FRDIFSTM |
| Type | RTF |
| Start Date | 01-Jan-1990 |
| Default File | DIF_stmt_tmpl.rtf |
| End Date (not mandatory | |
| Subtemplate (not mandatory) | |
| Default File Language | English |
| Territory Description | French Republic (comprises Metropolitan France, French Guiana, Guadeluope, Martinique, Reunion, Mayotte, Saint Pierre, Miquelon, French Polynesia, French Southern Territories, New Caldonia, and Wallis and Futuna) |
While creating the template definition, you must specify the data definition as FRDIFSTM as Oracle XML Publisher associates your template definition with this predefined data definition.
You can modify the predefined rich text format template by:
Adding new fields in the predefined template to display the required details in the DIF Statement. You can add new fields that are available in the DIF_STMT_LOOKUP_CODE lookup but not mapped with the predefined report template DIF_stmt_tmpl.rtf. You can also remove fields from the predefined template.
Note: Ensure you save the modified template with a different name to retain the predefined template as a sample for reference.
Changing the name of the existing labels in the template. To change the display name of the labels in the template, you must change the existing values in the lookup DIF_STMT_LOOKUP_CODE.
Before you define eligibility profiles for the corps, use the predefined PL/SQL function PQH_FR_SPEED.chk_speed_length() to create the formula function and fast formula of type Participation and Rate Eligibility. This fast formula evaluates whether an employee satisfies the length of service required in the current step, current grade, or grade ladder depending upon the career path you defined at the step. You must assign this fast formula to the required participation eligibility profile. See: Setting Up Corps
While creating the formula function, ensure the following:
The formula function definition matches the PL/SQL function PQH_FR_SPEED.chk_speed_length().
Click Context Usages and add Assignment_Id as context name with Number as data type and Date_Earned as context name with Date as data type.
While creating the fast formula, ensure that you select Participation and Rate Eligibility as type and return a variable with name ELIGIBLE. This is required as the calling Eligibility program expects a variable having the name "ELIGIBLE" and should return a value of either "Y" or "N". See: Writing or Editing a Formula
Web/ADI is the replacement for ADE. It allows a view to associated with a professional form. When the export button on the form is pressed the view is executed using the WHERE clause existing in the form to restrict the data. The output of the view is downloaded into either an Excel or Word document, and the system can be configured to automatically link this to become the source of a Word MailMerge.
See: Implementing Web ADI for use with Oracle HRMS
Setting up Web/ADI to produce this behaviour requires the following steps:
The user should be given the responsibility Web ADI with the Standard security group.
Enter the Web Adi responsibility and navigate to Create Document
Select Settings - click Next
Select Integrator - choose HR Integrator Setup - click Next
Select Content - click Next
Document Creation Review - click Create Document
Spreadsheet should be created - complete as follows
a. METADATA_TYPE = DOWNLOAD
b. APPLICATION_ID = 800
c. INTEGRATOR_USER_NAME = FR_TERMINATION
d. VIEW_NAME = HR_FR_TERMINATION_V
e. FORM_NAME = PERWSTEM
Choose Oracle -> Upload
In dialog window - click Upload
Close dialog and spreadsheet
From Web ADI responsibility choose "Define Layout"
Select Integrator - choose FR_TERMINATION - Go
Define Layout
a. Layout Name = FR_TERMINATION
b. Layout Key = FR_PERWSTEM
c. Field List = HR_FR_TERMINATION_V
Click Next
Define Layout - Select All, then deselect system values, i.e. Assignment ID etc. - Apply, Cancel
Add "Web ADI Create Document" function to FR_HRMS_NAV menu
In End Employment form query person. Use Export to download the information to a word document. Save as a temporary file.
Create Mail Merge Template document using the temporary download doc as the data source.
Add "HRMS ADI Document Manager Menu" submenu option to FR_HRMS_NAV
Upload the Mail Merge Temporary document from the Document Management menu option.
Alternatively use the following to upload the document :
FNDGFU apps/apps 0 Y PROGRAM_NAME=HRMS_ADI PROGRAM_TAG=TERMINATION LANGUAGE=US CONTENT_TYPE=application/msword {document}.doc
Check if the document now exists following the upload using
select FILE_NAME
from fnd_lobs
where PROGRAM_NAME like 'HRMS_ADI';
Web/ADI -> Manage Document Links
Select Integrator - choose FR_TERMINATION - Go
Select Layout - FR_TERMINATION - Link a document - Go
In End Employment form query person. Use Export to download the information to a Word 2000.
Mail Merge occurs automatically.
Use the View -> List -> People Folder form (PERWSFPE) to produce the Full Settlement Report for multiple employees.
A new folder should be defined that only contains those employees who have been terminated. One possible way of doing this is to create a folder with the following additional WHERE clause:
1=1 and exists (select null from per_periods_of_service where person_id = per_people_v2.person_id and actual_termination_date is null)
Note: This additional WHERE clause returns all employees who have a period of service with an actual termination date. It may not be restrictive enough in which case an alternative restriction must be found.
This process creates and populates user defined tables using predefined lookup types and rows. It generates new columns in a user defined table that has the same name as the lookup type. There are no parameters to be completed for this report.
You run the 'Seed French Data' process from the Submit Requests window.
To Run the Seed French Data Process
Select Seed French Data in the Name field.
Choose the Submit button.