Configuring Mappings between Oracle and Authoria HR

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.

arrow icon   To Configure Mappings:

  1. Identify the pages in Authoria HR that you want to link to each of your Oracle benefit plans and programs.

  2. 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';
    
  3. 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:

    Mapping 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
  4. Run the SQL script.

    The script calls the HR_AUTHORIA_MAPPING API, which saves the mappings in the Oracle database table HR_AUTHORIA_MAPPINGS.