Before users can access Authoria HR pages from Oracle HRMS windows or self-service web pages, you must configure the mappings between your Oracle HRMS benefits and the pages you have set up in Authoria HR.
Identify the pages in Authoria HR that you want to link to each of your Oracle benefit plans and programs.
Edit the following select statement in the example SQL script to include the appropriate business group by replacing "SC Benefits" with the required business group name:
select business_group_id into l_business_group_id from per_business_groups where name = 'SC Benefits';
For each mapping, add a create_page_map procedure, replacing the example create_page_map procedure lines. Add a separate line for each mapping.
The create_page_map procedure takes the following arguments:
| Procedure | Description |
| p_plan_name | the name of the benefits plan |
| p_program_name | the name of the benefits program (null if the plan is not in a program) |
| p_open_enrollment_flag | indicates whether the page mapped to is for open enrollment. Allowed values are Y or N. |
| p_target_page | the name of the target page in the Authoria application |
| p_business_group_id | the business group id, as determined using the select statement |
Run the SQL script.
The script calls the HR_AUTHORIA_MAPPING API, which saves the mappings in the Oracle database table HR_AUTHORIA_MAPPINGS.