To run the Bilan Social Report process:Once you have created your template, you must run the Bilan Social Report process. Here you define the parameters for your report. This process produces results that are stored in the HR_SUMMARY table, which can then be displayed in Oracle Discoverer.
Attention: If you have made any changes to the NATIONALITY, FR_MEDICAL_EXAMINATION_TYPE, or FR_EMPLOYEE_CATEGORY Lookups, you must ensure that the new values are included in BS_NATIONALITY, BS_MEDICAL_EXAMINATION_TYPE, or BS_EMP_CAT_HIERARCHY column of the relevant user defined table. See: User Defined Tables Used by the Bilan Social
Run the Bilan Social Reports process in the Submit Requests window.
To run the Bilan Social Report process:Select the template and year for which you want the process to retrieve data.
Select the required company and establishment.
Enter a name for the process. This will be required when populating the Oracle Discoverer workbooks.
Note: If a record already exists in the HR_SUMMARY table with the process name you enter, the process will fail.
Choose the Submit button.
The contents of the log file indicate the number of rows entered into the HR_SUMMARY table for each calculation.