Title and Copyright Information
Compensation and Benefits Management
Payroll Payment and Distributions
Payroll Statutory Deductions and Reporting
Payroll Processing and Analysis
If you are implementing Oracle HRMS for Hong Kong, you must also complete the following additional implementation steps.
For the purpose of administering MPF processing for your employees, you need only define one element link in Oracle Payroll. This link is for the element MPF Information. This element requires a scheme to be entered for all employees at the time of enrolment. The link for MPF Information must not be a Standard link, and is normally a link to all payrolls.
See: Defining Element Links, Oracle HRMS Compensation and Benefits Management Guide
In order to process MPF contributions, you must create balance feeds for the following two balances:
MPF_RI (Relevant Income for MPF calculations)
MPF_BASIC (Basic Pay for MPF calculations)
See: Creating Balance Feeds for Individual Elements
Oracle provides a new function to report the break up the Retro MPF Liability component amounts by payroll period rather than displaying as a consolidated amount within the MPF Remittance report.
Follow the steps given below to report the break up amounts by payroll periods:
Use the predefined non-recurring elements Retro MPF Liability for First Period and Retro MPF Liability for Second Period for displaying the break up amounts of Retro MPF Liability component for each pay period. The values for these elements are fed indirectly from MPF formula of MPF Information element
If you want to use the existing Retro MPF Liability element for balance adjustment, then feed the same values for the Retro MPF Liability for First Period.
If you want to use get_retro_mpf function, then add the following parameters to return value, date for different pay period.
l_er_liab_prd_fp
l_er_liab_prd_sp
l_er_start_date_fp
l_er_start_date_sp
l_er_end_date_fp
l_er_end_date_sp
If you are using a custom MPF formula, the formula results should add values into Retro MPF Liability for First Period and (or) Retro MPF Liability for Second Period elements.
You must create balance feeds for the following balances before you can run your IR56 reports:
IR56_A
IR56_B
IR56_C
IR56_D
IR56_E
IR56_F
IR56_G
IR56_H
IR56_I
IR56_J
IR56_K1
IR56_K2
IR56_K3
IR56_L
IR56_M
See: Create Balance Feeds for Individual Elements
If you plan to use the average daily wage rate based on salary earned in the last 12 months feature, then complete the following steps:
Oracle HRMS provides seeded balance, formula and function to support 12-month Average Wage calculation.
Create a new balance or for an existing balance, feed all earnings elements that contribute to calculation of average pay rate.
Attach dimension _ASG_12MTHS_PREV to the balance to generate appropriate DB item, <Balance>_ASG_12_MTHS_PREV.
Using the DBI in custom fast formula, retrieve the total earnings in last 12 months. For custom formula, use the template formula HK_12MONTH_AVG_RATE as reference.
Calculate the number of days in last 12 months using the formula function HK_LAST_12_MNTH_DAYS ( ) and the DB item.
The application calculates the average daily wage rate = Last 12 months earnings sum/No of days in last 12 months
There are five postscript reports produced for Oracle HRMS for Hong Kong.
IR56F - Employee Cessation Remaining in Hong Kong
IR56G - Employee Cessation departing Hong Kong
IR56E - Employers Return
IR56B - Annual Employers Return Hong Kong (Full)
IR56B - Annual Employers Return Hong Kong (Partial)
To print the postscript reports, you must install and configure the required fonts for your printer.
Make a note of the printer type specified at the concurrent program level, when you are submitting the postscript report.
Locate the directory $ORACLE_HOME/guicommon6/tk60/admin, and open the uiprint.txt file
Find the printer specified in step 1 while submitting the postscript report, and its corresponding generated .PPD file. Make a note of the file name and proceed to the next step.
Locate the directory $ORACLE_HOME/guicommon6/tk60/admin/PPD, open the .PPD file that was generated (Step 3), and search for the font type Courier-BoldItalic.
Note: If you do not have the Courier-BoldItalic font, download the appropriate PPD files. The application picks up this font while printing the report, only if the font entry exists in the .PPD file.
Edit the uiprint.txt file. Remove the dummy line at the end of the file, and create your entry. For example, FRED:PostScript:2:team_hpljet5:HPLJ5SI1.PPD
Save your file and exit.
Print the postscript report from the Oracle HRMS application.
To ensure that the IR56B Annual Employers Return Hong Kong Report display the Chinese full name correctly, follow the steps given :
Login using the System Administrator responsibility to set environment variable IX_PRINTING
Run the Prints Environment Variable process. Check if the value is
/slot/ems2903/appmgr/apps/apps_st/appl/fnd/12.0.0/resource/ixlib.cfg
If the value returns NULL, see My Oracle Support Doc ID 415967.1 for the steps.
Ensure to backup the configuration file - ixlib.cfg file
cp ixlib.cfg ixlib.cfg.bkp
Modify the configuration file ixlib.cfg
vi ixlib.cfg
Comment the existing lines under section [AMERICAN,,,,,]
%Font.Times.Plain= printer:Times-Roman %Font.Times.Bold = printer:Times-Bold
Add the following two new lines:
Font.Times.Plain = <FND_TOP>/<APPLRSC>/ALBANWTT.ttf Font.Times.Bold = <FND_TOP>/<APPLRSC>/ALBANWTT.ttf
Restart all the services.
If concurrent manager is inactive, run the following command:
adcmctl.sh start apps/apps
Enter the full name in Chinese characters for employees.
See: Entering a New Person (People Window) and Entering Additional Personal Information, Oracle HRMS for Hong Kong Supplement.
Run the QuickPay.
See: Running the QuickPay Process, Oracle HRMS Payroll Processing Management Guide
Run Prepayment processes.
See: Running the Prepayment Process, Oracle HRMS Payroll Processing Management Guide
Run IR56B Annual Employers Return Archive process. See : Running the IR56B Annual Employers Return Archive process.
Run IR56B Annual Employers Return Hong Kong (Full) process. See: Running the IR56B Annual Employers Return Hong Kong (Full) process
You map the user-defined Reasons for Leaving/Termination to the standardized eMPF Reporting Values to ensure compliance with MPF reporting requirements.
Navigate to the Application Utilities Lookups.
Select HK_EMPF_TERMINATION_REASON_MAP. This lookup is used to map the user-defined Reason for Leaving/Termination to standardized eMPF Reporting Values.
In the Code field, enter a unique code.
In the Meaning field, enter the Code from LEAV_REAS that you want to map from (this field is case sensitive), for example, BEN.
In the Description field, enter the eMPF Leaving Reason that you want to map to (this field is case sensitive), for example, RESIGN.
Enter Effective Dates From, for example, 31-JAN-2025.
You can map multiple Codes from LEAV_REAS to a single eMPF value. You must not have a single code to multiple eMPF values. All the codes in LEAV_REAS must be mapped. Continue step 2 to step 5 to map all the codes.
Save your work.
When an employee is terminated with the Leaving Reason as Benefits in the Termination window, the employee is reported as RESIGN in eMPF after you complete this mapping.