Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Workplace Visibility

Posted on August 15th, 2015 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

VisibilityWhat is visibility?

The M-w Dictionary defines visibility as “clarity of vision or The quality or state of being known to the public.”

But for in Orginizational prospective, workforce, visibility means much more.

Not only is workforce visibility the ability to see the breadth, depth and make-up of your organization, it also extends to your ability to draw insights based on what you see.

Having true visibility of your organization’s workforce means having both a basic vision and a deeper knowledge of what — or who — you need.

The Value of Visibility

A recent Aberdeen Group study showed that the number one trait among companies with best-in-class human capital management practices was “the ability to define the talent required by business needs in terms of skills, behaviors, and attributes.” [ Adopted from Internet]

A better view of your workforce also empowers better decision-making by allowing HR professionals and leaders to share indicative data about the workforce with stakeholders and hiring managers, solidifying HR’s ability to deliver on its evolving role in overall business strategy.

A good article on What Is Workplace Visibility you can read here .

Posted in HRMS | No Comments »

Bespoke Application & Utilizing HR/Payroll APIs

Posted on December 16th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Before start of the topic , let me tell you intresting fact about the word "bespoke application".

Long time back I heard this term while working with a UK based client, in a telecon its sound like "They need a bespoke application with Oracle to cater Billing with Front end” ..What? The only time I had heard the words ‘spoke’ and ‘application’ in the same sentence was when someone told me about an application built on top of a hub and spoke architecture .Well after that , I realized that ‘bespoke application’ means the same ‘custom built application’ or simply ‘custom application’ that we normally used to called as. I really donot know why UK English don't use word custom here. Its sound Interesting localization tidbit.

Bespoke (pronounced bee-SPOHK)

Therefore , "Bespoke" was most commonly used for suits made specifically for a customer without the use of a pattern. In effect, the length of fabric was "spoken for".

dgreybarrowThe Need

IT, Health care based industry are Manpower intensive, therefore Human Capital management system is really is need to cater today growing need. Though Integrated system like Oracle or people soft or SAP there is capability of maintaining each function, but still companies prefer to have a front end application for maintaining some of the key information for employee management system.Therefore Custom web based application possibility can not be ruled out.

If this is the case inhouse development team would like to access the HRMS/Payroll via API's so that they can have there own presentation layer.

1. Is this possible ? Then How?
2. Where do I find the API documentation?

So answer of these questions are

1. Yes, it possible. You need to identify the tables and API's

2. There are enough documentation available for this.

Just Follow these post, you will get answer of most of your query.

dgreybarrowIts all about Table and API

Such kind of Bespoke/custom application requires these Oracle tables access which are divided into three major tracks.

  • Reference tables : The details for driving basic Information.
  • Employee tables : The details for driving employee vital details
  • Payroll tables : Payroll details for employee or any other elements.

1.Reference Tables : What you really required

  • Business groups, payrolls related information : In this set you requires company and payroll reference information , which is required to validate employee information for your company
    • You can map with these payroll table
      • hr_organization_units
      • hr_locations
      • pay_payrolls
      • fnd_common_lookups
  • Counties, cities, states, zips : Contains the address info for employee address and tax validation. Tax validation is required if there is seperate rule for taxation or may have multiorg installation.
    • You can map with these payroll table
      • pay_us_states
      • pay_us_counties
      • pay_us_city_names
      • pay_us_zip_codes
  • Deductions and levies : These are all the deductions and levies whatever configured in Oracle Apps.
    • You can map with these payroll table
      • pay_element_types_f
      • pay_element_links_f
      • pay_element_values

2. Employee Tables : What you really required

  • Persons and address tables :These are employee personal and employment information
    • You can map with these payroll table
      • per_people_f
      • pay_people_groups
      • per_assignments_f
      • per_addresses
  • Deductions and levies
    • You can map with these payroll table
      • pay_element_entries_f
      • pay_element_entry_values_f
  • Direct Deposits
    • You can map with these payroll table
      • pay_external_accounts
      • pay_org_payment_methods_f
      • pay_personal_payment_methods_f

3. Payroll Tables : What you really required

  • Payroll summary :Contains all the payroll details such as earnings, deductions, bonuses, and hours in a few tables
    • You can map with these payroll table
      • pay_payroll_actions
      • pay_assignment_actions
      • pay_run_results
      • pay_run_result_values
      • pay_element_classifications
      • pay_element_types_f
      • pay_input_values_f
  • Payment summary :Contains check and direct deposit details such as amount and account numbers
    • You can map with these payroll table
      • pay_payroll_actions
      • pay_assignment_actions
      • pay_pre_payments
      • pay_org_payment_methods_f
      • pay_personal_payment_methods_f

dgreybarrowAPI Avability of HRMS

So here are few Business events required for your bespoken application and there underline API's details

dgreybarrowAdd a New Employee

  1. Insert person :hr_entry_api.insert_element_entry
  2. Update people group :hr_assignment_api.update_emp_asg_criteria
  3. Update assignment :hr_assignment_api.update_us_emp_asg
  4. Insert base salary :insert into per_pay_proposals
  5. Insert check as the payment method :hr_entry_api. insert_element_entry

dgreybarrowUpdate Employee Information

  1. Update personal information if it changed: per_per_upd.upd
  2. Update assignment and people group information if it exists, set mode to correct or update :hr_assignment_api.update_emp_asg_criteria

dgreybarrowAdd terminating employees

In Oracle On Terminate screen, select Actual Process Date and/or Final Process Date and click on Terminate button. Optionally, enter 'Leaving Reason,' 'Notified,' 'Projected,' 'Last Standard Proces' values.

These are API's are available for termination

  1.  
  2. Hr_ex_employee_api (File name: peexeapi.pkb)
  3. This file contains three (3) procedures.....
  4. hr_ex_employee_api.actual_termination_emp
  5. hr_ex_employee_api.update_term_details_emp
  6. hr_ex_employee_api.final_process_emp
  7. Note: The API's have to be called in that order.
  8.  

dgreybarrowAddress

  1. Insert or Update Addresses :hr_person_address_api.create_person_address
  2. Update existing address records :hr_person_address_api.update_person_address

dgreybarrowPhones

  1. Insert or create a phone :hr_phone_api.create_phone
  2. update existing phone records :hr_person_address_api.update_person_address

dgreybarrowSchools and Colleges

  1. Insert or create a schol and college information :per_esa_ins.ins
  2. update existing records :per_esa_upd.upd

dgreybarrowInsert or Update Deductions

  1. If deduction is ended, use the delete API to set end date :hr_entry_api.delete_element_entry
  2. Update deduction if exists, else insert it :hr_entry_api.insert_element_entry

dgreybarrowQualifications

  1. Insert or create a qualifications information :per_qualifications_api.create_qualification
  2. update qualifications records :per_qualifications_api.update_qualification

dgreybarrowEnd Date /delete Element Enties

  1. End Date /delete Element Enties :py_element_entry_api.delete_element_entry

There are 4 date track delete modes available (variable p_datetrack_delete_mode)

  • DELETE end date element entry
  • DELETE_NEXT_CHANGE delete next changes
  • FUTURE_CHANGE delete future changes
  • ZAP completely remove element entry from the database

dgreybarrowInsert or Update Direct Deposits

  1. If direct deposit is ended, use the delete API to set end date :hr_personal_pay_method_api.delete_personal_pay_method
  2. Insert bank account if it does not exist :insert into pay_external_accounts
  3. Update direct deposit if exists, else insert it :hr_personal_pay_method_api.create_personal_pay_method

dgreybarrow

Inform Manager of Inactive Employee Credit card process

  1. Use this if required inactivate employee credit card process : hr_ex_employee_api.actual_termination_emp

dgreybarrowJobs

  1. Create new Job :hr_job_api.create_job
  2. Updating the job details :hr_job_api.update_job

dgreybarrowPositions

  1. Create new position :hr_position_api.create_position
  2. Updating the position details :hr_position_api.update_position

dgreybarrow

Where I can get the details for these API's

For Oracle release 11 ,11i release 12, the APIs are located in the operating system directories:

$PER_TOP/patch/xxx/sql and $PAY_TOP/patch/xxx/sql,

Refer to filenames like pe****api.pkh, py****api.pkh, and hr****api.pkh, where **** represents wildcard characters.

You can identify the package name and version of the API.

Run this query

  1.  
  2.  
  3. SELECT text
  4. FROM all_source
  5. WHERE name LIKE '%your_api_name%'
  6. AND text LIKE '%Header%';
  7.  

This query will return the header line of the pac kage and package body showing the package name and current version number.

  1.  
  2.  
  3. SELECT object_type,object_name
  4. FROM user_objects
  5. WHERE object_name
  6. LIKE 'HR%API';
  7.  

dgreybarrow

Publicly Callable Business Process APIs in Oracle HRMS

Oracle APIs are a logical grouping of all external process routines. The Oracle HRMS API sets delivers a set of PL/SQL packages procedures and functions that provide an open interface to the database.

There are three options for you to find the details:

  1. Oracle Documents
    To find a current list of publicly callable business process APIs in Oracle HRMS; you need to go into your On Line Help from within applications and use the search field to find 'Publicly Callable Business'. In the Search Results frame you will see a link to 'Publicly Callable Business Process APIs in Oracle HRMS (Oracle HRMS)' listed.
  2. Irep
    To find correct information on APIs you check Oracle Integration Repository (irep) which can accessed via MetaLink by selecting the Knowledge tab - Knowledge Browser sub-tab, then in the Online Documentation box select - Oracle Integration Repository.
  3. Search the database
    You may find official documentation on Publicaly Callable APIs as in options 1.
    You can search in the HR Schema for the stored procedures with name 'HR%API'. Open the Package spec and then read the inline comment about the parameters. This is very useful to understand what is meant by each paramater and what the API does.
  4. Etrm via metalink
    TRM helpful in selecting the appropriate API call.

dgreybarrowConsidertaion for using API

Before using any API's of payroll and HRMS you must have clear understanding of

  1. Data Tracking
  2. Validation paramater
  3. Correction, insert mode of API's

dgreybarrowAdditional Note for API's documents

You can download "Configuring, Reporting and System Administration in Oracle HRMS" document from the Oracle documentation library. It has a list of api's.

dgreybarrowSuggested Reading

Posted in HRMS | 2 Comments »

Payroll to GL Transfer : “All you wanted to Know…..”

Posted on December 11th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Okay.. this was again a hetric week , learn some of new things from HR area. As helping some fresh payroll guys who was doing some report development and other group came for some rescue for balances discrepancy from payroll they transfer to GL. Thought to have this post , and tried to cover some of the vital information which purely focus on Payroll to GL transfer Process.

dgreybarrow What is purpose of Payroll Costing and Transfer to General Ledger ?

In Payroll area, the Costing process basically allocates payroll run which results to cost segments.

  • The Transfer to the General Ledger process transfers cost information to Oracle General Ledger interface tables.
  • At the installation - setting up segments of the Cost Allocation key flexfield to determine the windows in which users can select cost codes.
  • Oracle Costing you use a post–payroll run process to accumulate payroll costs.
  • For Oracle General Ledger you can map the segments of the Cost Allocation key flexfield to the corresponding segments of the General Ledger Accounting flexfield.
  • If you do not using GL in same product, you may consider how to relate information on labor costs entered in Oracle Human Resources to your financial systems.

dgreybarrowWho drives the payroll costing :Its Cost Allocation Flex field Segments

  • Define a structure for your Cost Allocation Flex field which contains the segments you want to use for your Business Group. You will use this structure to enter your payroll costing details in Oracle HRMS.
  • You use Segment Qualifiers to control the level at which costing information can be entered to the system. Each Qualifier determines the level at which costing information can be entered

dgreybarrowHow it works

payroll to GL transferThe costing process picks up 'run results'. The specific 'payroll actions' that will be picked up by the costing process are in PAY_ACTION_CLASSIFICATION table and have a CLASSIFICATION_NAME of 'COSTED".

So the process will create an assignment_action for every assignment that has a run result from one of the 'costed' classifications.

The process then populates the PAY_COSTS table with the run result value (costed value). The actual cost code is stored on the PAY_COST_ALLOCATION_KEYFLEX table in the 'concatenated_segments' column, this is referenced using the 'cost_allocation_keyflex_id' from PAY_COSTS. (Adopted - Source metalink)

When the Payroll costing results are transferred to Oracle General Ledger only the mapped segments and the costing amounts are transferred. The data is transferred from the PAY_COSTS table into the GL_INTERFACE table by running the Oracle Payroll process Transfer to GL. After the transfer from Payroll is complete, the batch will need to be imported into GL. This is done by running the Oracle General Ledger standard GL Import process .

Transfer Program to GL process populates the following columns:

  • status
  • set_of_books_id
  • accounting_date : This is effective date of payroll run
  • currency_code
  • date_created
  • created_by :801...which is the application id for Payroll
  • actual_flag
  • user_je_category_name :hard-coded as Payroll
  • user_je_source_name :hard-coded as Payroll
  • entered_dr :the dollar amount to be debited
  • entered_cr :the dollar amount to be credited
  • reference21 :payroll_action_id of the transfer to GL process from pay_payroll_actions
  • reference22 :cost_allocation_keyflex_id from pay_cost_allocation_keyflex

dgreybarrow Which program take care of payroll cost transfer.

It is pytrangl.pkb, located in $PAY_TOP/patch/115/sql/pytrangl.pkb

dgreybarrowWhat data is mapped from Payroll to General Ledger when information

Similar to other Application transfer program, Payroll transfer populates the following reference columns in GL_INTERFACE:

  • Reference21 :Payroll_action_id of Payroll Transfer to GL process
  • Reference22 :Cost_allocation_keyflex_id of Payroll cost flexfield for this entry
  • Reference23 :effective date of the Payroll Run this entry is derived from
  • Reference24 :Date_earned of the Payroll Run this entry is derived from
  • Reference25 :Payroll_action_id of Payroll Run this entry is derived from

Journal import is then placed these in reference1, reference2, reference3, reference4 and reference5 in GL_IMPORT_REFERENCES table.

The GL_IMPORT_REFERENCES columns are actually populated during the GL Journal Import process. Although these are mapped from the columns in the GL_INTERFACE table, the 'Transfer to GL' process does not actually populate the GL_IMPORT_REFERENCES table

dgreybarrowTechnical Tables Involved

  • pay_assignment_actions
  • pay_action_interlocks
  • pay_assignment_actions
  • pay_gl_interface
  • pay_cost_allocation_keyflex
  • gl_import-refrence
  • gl_interface

dgreybarrowStep for Payroll Tranfer To GL

1) insert the following parameters in PAY_ACTION_PARAMETERS

Costing results are generated based on the check date of the payroll process. However, you do have the ability to set the accounting date for the transfer to date earned rather than date paid. To do this you would need to change the TGL_DATE_USED pay action parameter to "E". If you do not do this then the accounting date of the transfer defaults to the check date of the originating payroll

  1.  
  2. INSERT INTO PAY_ACTION_PARAMETERS VALUES ('TGL_DATE_USED','E');
  3. INSERT INTO PAY_ACTION_PARAMETERS VALUES ('TGL_REVB_ACC_DATE','Y');
  4. INSERT INTO PAY_ACTION_PARAMETERS VALUES ('TGL_GROUP_ID','Y');
  5.  

2) Setup your costing flexfield qualifiers.

3) Create an element.

4) Link the element : You need to check the costing radio button,and transfer to GL checkbox. Then you have to enter the values for the costing/balancing field.

5) Then you need to run the quickpay/pre-payments/costing process

6) Then you can track the ASSIGNMENT_ACTION_ID and PAYROLL_ACTION_ID navigating to View-->Payroll Process Results/Assignment Process Results

7) Verify that the costing details are created in PAY_COSTS table.

This is small query which you can use to get the details:

  1.  
  2.  
  3.  
  4. SELECT * FROM PAY_COSTS WHERE ASSIGNMENT_ACTION_ID = &assignment_action_id;
  5.  
  6.  

8) Then you need to run the Payroll transfer to GL process: Here are the data get inserted in GL Interface.

  1.  
  2.  
  3. SELECT gl.*
  4. FROM pay_payroll_actions ppa,
  5. pay_assignment_actions paa,
  6. pay_costs pcv,
  7. gl_interface gl
  8. WHERE ppa.payroll_action_id = :costing_payroll_action
  9. AND ppa.action_type='C'
  10. AND pcv.transfer_to_gl_flag='Y'
  11. AND ppa.payroll_action_id = paa.payroll_action_id
  12. AND paa.assignment_action_id=pcv.assignment_action_id
  13. AND gl.user_je_source_name='Payroll'
  14. AND gl.reference22=TO_CHAR(pcv.cost_allocation_keyflex_id));
  15.  

9) Verify the data should be imported into gl_interfaces

Do a quick check

  1.  
  2. <pre>select * FROM gl_interface
  3. WHERE set_of_books_id =1003 --(set_of_books_id)
  4. AND GROUP_ID =123 -enter_group_id
  5.  

10) Then import the same in GL by navigating to Journal-->Import.

dgreybarrow Running Transfer To GL Process

  1. Select View tab in the menu and then select requests
  2. Select Submit a New Request button
  3. Select Single Request radio button and then click ok button
  4. Now enter as follows
    Name : Transfer To GL
    Select the parameters Field then enter the Following details
    Payroll Name: enter the Payroll Name for which you want to Process
    Consolidation Set : Consolidation Set name of a Payroll
    Start Date : Select the Start Period for which you want to run the Payroll
    End Date: Period End Date
  5. Then after filling the above fields then select OK Button
  6. Select Submit button to submit the

dgreybarrow Query to get Payroll data in GL side

Here is small query that you can use to get the details of Payroll data from GL side.Script

Let me know, if you have any question and comments for GL transfer of Payroll area.:)

Posted in HRMS | 18 Comments »

“Business Group” in EBS

Posted on February 22nd, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Lets talk about one of the basic concept of Oracle Application which is so called "Business Group" , part of Multi-org architecture. Understanding this is important for non HRMS consultant as in R12 Finance the new legal Entity architecture is equally important.

double-arrowBusiness Group in HRMS Shared Mode

A business group is a basically Human Resources organization to which you assign employees. You assign each operating unit to a business group in the financial options setup. You can assign the same business group to different operating units including to operating units in different financial sets of books. You can setup a separate business group for each operating unit if you want to segregate and maintain each group of employees separately. Oracle provides one setup business group you can use.

In case of not having HRMS (Full mode),what you have to do is ,to create at least one business group to cater requirement for Oracle Financials and Manufacturing, so that only the employees can perform some of application functionality , which are as follows:

  • Entry and approvals of purchase orders and requisitions require requisitioners, buyers, and approvers to be setup as employees.
  • Purchasing receiving staff must be setup as employees in order to use receiving screens.
  • Engineering change order approver lists use the employee database to validate approvers.
  • AP expense report features allow you to create suppliers from employee information and to generate expense report coding using employee default account numbers.
  • iExpense requires users who enter or approve expense reports to be setup as employees.
  • Fixed Assets allows you to optionally assign assets to employees for tracking purposes.
  • Standard Workflow approvals of GL journal entries in Release 11 require approvers to be setup as employees.
  • Standard Workflow approvals of AR credit memos in Release 11i require approvers to be setup as employees.
  • AP may add invoice approval through AME , which will likely require approvers to be setup as employees.

There are few exceptions, where you have to understand when your installation site is having HR and Projects modules installed, as there are significant implications of business group and HR organizations.

double-arrowBusiness Group is part of MultiOrg model of Organizations

The Multi-Org model provides a four level hierarchy that dictates how transactions flow through different business units and how those business units interact

  • Set of Books- GL- Balancing Entities/Funds
  • Business Group
  • Legal Entity -HR- Fin- Legislative Reporting
  • Balancing Entity
  • Operating Unit- AP, AR, PO, OE -Bal Segment 1, Bal Segment 2,Bal Segment 3
  • Inventory Org MFG, INV, Ship

There is one confusion between Oracle Financial and HRMS consultant, as they simply assume SOB is more meant for non HRMS module and BG is more for HRMS, in certain extend this is true.Lets investigate this on GRE\LE and OU as follows:

double-arrow

Know something more for SOB

  • As covered in earlier post ,a set of books is a financial reporting entity that shares the three C’s that is Chart of accounts(accounting flexfield structure), functional currency and calendar.
  • Oracle General Ledger secures transaction information (journal entry),When we use General Ledger, we choose a responsibility that specifies a set of books. We then see information only for that set of books.
  • In the multiple set of books, the concept of “global” item master Organization exist, since the item master organization is used for item definition and not item accounting information.
  • More over all accounting activity releated to the item master can be controlled at the item or organization level. Example is consolidation at the corporate office or Head office.

double-arrow

Is SOB linked to HR module?

Yes,. Once SOB is created from GL setup part, this can be linked in HRMS by such navigation

Work structure => GL organization Description ==> Business Group

double-arrow

What is a Business Group/Legal Entity?

  • Represents the consolidated enterprise, a major division, or an operation company.
  • Human resources information is secured by business group.(For example, when you request a list of employees, you see all employees assigned to the Business Group of which your organization is a part. )
  • This is true in all applications except the Human Resources applications themselves, which support more granular security by a lower-level organization unit.
  • Multiple sets of books can share the same business group if they share the same business group attributes, including Human Resources flexfield structures.
  • Business Groups separate major segments of a business. Each can have it's own set of books.
  • Each Group will also have a structure of other organizations classifications assigned to it.
  • Till Release 11i Legal Entities post to a
    • Set of Books
    • Operating Units are part of a Legal Entity
    • Inventory Organizations are part of an Operating Unit ·
    • Inventory Organizations define and maintain items used by other manufacturing modules (Order Entry,Purchasing, MRP, etc.). They also collect and pass data to the Financials modules.

double-arrowOperating Unit vs Business Group

  • With Multi-Org you can define an owning Operating Unit and associate this with a profile option -MO:Operating Unit. When you define data or execute a business process within Oracle Financials, then the system automatically attaches the id of your Operating Unit organization to the data or transaction.
  • With Business Group security model in HRMS you can secure data and processes by id of the Business
    Group.However, in HRMS, the Business Group id is closely related to the country of operation, and not simply a division or line of business.
  • Both look the same but it is important to realize that these are distinct and different mechanisms for two different functional areas. This is especially true for any global implementation of HRMS where the data for each country exists within a single business group but Operating Units exist across many countries, and business groups.

double-arrowSetup Business Group

As per standard User Documentation: A ’Setup’ Business Group is supplied with Oracle HRMS. This business group is used by the default responsibility. You can use this business group with all of its default definitions as the starting point for your own Business Group, or you can define other business groups to meet your own needs.

BU

A business group enables you to group and manage data in accordance with the rules and reporting requirements of each country, and to control access to data.

The critical factors for deciding when to use a separate business group, or an international business group, are based on the following factors:

  • If you use Oracle Payroll
  • The number of people you employ in a country
  • If you require legislative support for Oracle HR

Generally the laws are so different in each country that to be compliant, there must be a different business group for each country in which an enterprise has employees.

double-arrowBU in HRMS and other Integration

The need for cross functional integration cann't be denied as most of the base information is pulled from HRMS to Oracle Finance , Manufacturing as well as CRM Modules. A typical integration aspect with some of the core module can be best understood as figure below:

CrossFunctional BU HRMS

double-arrowSimilar Post

Posted in EBS Suite, HRMS | 2 Comments »

Let’s Talk About ‘Security Groups’ functionality available within Oracle HRMS

Posted on December 19th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

There was a requirement to provide a particular BU user to access to other BU PO's for approval. Normally such kinds of requirement always happen in today's complex business model . To implement this requirement a best we can do it is to use of new profile option which was introduced in Oracle 11i called HR: Cross Business Group , which need to switched on (i.e. set to "Yes") can be used .This new profile option makes it possible for Oracle Application users to view and modify certain specific areas of data across all business groups.

From 11.5.9 onward in HRMS there are two Security Models as:

  • Standard HRMS Security
  • Security Groups

The first one is Standard HRMS security which normally requires defining a security profile, and defining a responsibility for use by application users, whereas security groups means whereby you can reuse a responsibility and assign it to different security profiles in different business groups if required.

Typically Multi-national Companies would be benefited from security as they normally have concept of service centres using multiple business groups and security profiles.

gre The good and bad in new Security Group Model

The Standard Security Model on Oracle HRMS forces a responsibility to be tied to only one business group/security profile. This means that when new business groups are added a brand new set of responsibilities must be set up for the business group, even if the new set of responsibilities is identical in every respect to existing responsibilities assigned to another business group.

The new security group model can cut down dramatically on the number of responsibilities required as it allows responsibilities to be reused by many different business groups.

Here are the key points of how the new security group functionality works.

  • Every time a business group is created a new security group of the same name is also created.
  • Security profiles are defined the same way they are now. There is no change in this functionality.
  • Form Assign Security Profile is activated under the new security model. This form allows a user to be linked to a security profile, responsibility, security group (business group) combination.
  • Profile option HR: Business Group is no longer set manually for HRMS responsibilities. This profile option will be set dynamically when a user selects a responsibility/security group combination at logon.
  • Profile option HR: Security Profile is no longer set manually for HRMS responsibilities. This profile option will be set dynamically when a user selects a responsibility/security group combination at logon.
  • The \Security\User Define Screen in the System Administrator responsibility is no longer user to assign HRMS responsibilities to users as this is now done in the new Assign Security Profile screen.

Please note, that although it is possible in the new security group model to access many business groups through the same responsibility, because of the way users are now assigned to responsibility/security group combinations, an HRMS user can only access the data in one business group at any one time.This can be best understood in next section.

red Overview of Standard Security Model versus new Security Group Model

Lets try to understand by a simple diagram below, what is here is 3 BU defined in global instance representing three BU X-Singapore, X- Australia and third one X-UK. The simple diagram below shows the difference in responsibility set-ups associated with each model.

old securitymodel

In the standard security model when a user logs on or decides to change responsibility the list of responsibility names they have access to are presented to them to select from. In the security group model when a user logs on or decides to change responsibility the list of responsibility names and the associated security group (i.e. business group) assigned to the user are presented to the user to select from. This difference can be best described as:

comparebothmodel

ora3 steps away to switching to the new security model

The steps required to switch to the new security model are as follows;

  • Profile option HR: Cross Business Group should be set to "Yes".
  • Profile option Enable Security Groups must be set to "Service Bureau"
  • Concurrent request Enable Multiple Security Groups must be run.

purpNot to Forget

Once the new security model is switched on, it cannot be switched off.

bluSuggested Reading

  • Enhancements in Oracle HRMS Security in R11.5: Note:202478.1
  • How Does the Cross Business Group Profile Option Impact the Application :Note:224822.1
  • Understanding and Using HRMS Security in Oracle HRMS :Note:394083.1

Other related post in Security

Posted in 11i, EBS Suite, Functional, HRMS | 6 Comments »

Page 1 of 11