Sunday, February 24, 2019

Oracle HRMS R12.1 Brief Description

Setup:

1) Define Key Flexfields
2) Define Descriptive Flexfields
3) Administration setups
4) Define Organization Strutures
5) Define Roles
6) Define Grade Information
7) Define Payroll Information
8) Define Compensation and Benefits
9) Salary Administration
10) Element Sets
11) Person Types and Assignments Statues
12) Special Peronal Information
13) Recruitment
14) Methods of Measurement and Creation Competencies
15) Comptence Recruitments
16) Qualification Types and Educational Details/Establishments
17) Assessement and Appraisal
18) Absence Management/ Accurals of Paid Time off(PTO)
19) Human Resource Budgets
20) Evaluation Systems
21) Requirements Matching
22) Career and succession planning
23) Define Reports and Generate Standard letters
24) Define user security
25) Define Audit Requirements
26) Self Service Implementation


Key Flexfields
================================
1) Specify Key Flexfields Strutures for Business Group
2) Define Job Flexfield **
3) Define Position Flexfield **
4) Define Grade Flexfield
5) Define People Group Flexfield (For special grouping of employees)
6) Define Cost Allocation Flexfield (Payroll to Gl transfer)
7) Define Personal Analysis Flexfield (For Special information Types)

Administration Setup
========================================
Enable Currencies:
Create "View All" User. Responsiblility Name : US HRMS Super Manager.
Run Grant Permission to roles process (ROLEGEN)
Define QuickCode Values (Lookup Values)

Define Organization Strutures
======================================

Define Locations

Navigation :- HRMS Manager :-> Work Structure :->  Organization :-> Description

Define Business Group
Create a "View All" Access to the Business Group by setting up "HR:Security" Profile value to the default businesss group.
Create Organization and enter the appropriate classification
  - HR Organization for employee assignment orgs
  - Enter defalt Work Schedule details
Use the Organizaton Hierarchy form to define Org hierarchy.

In the Buniness group we have to specify details :

 - Processing Rule
 - State Tax Rule (Yes/No)
 - Work Day Information(Start Time , End Time , Working Hours, Frequency)

   - Employee Number Generation (Automatic/ Manual)
   - Grade Flexfield Struture
   - Group Flexfield Struture
   - Job Flexfield Struture
   - Costing Flexfield Struture
   - Position Flexfield Struture
   - Competence Flexfield Struture
   - Legislation Code
   - Currency
   - Payslip information (When it will start)
 





Payroll Process
============================
Payroll Run
PrePayments
Payroll Archive
NACHA
Check Writer (XML)
Direct Deposit (XML)
Costing
Costing Details Report (Optional)
Transfer to GL
Payroll Register Report (Optional)


Payrol Building blocks (Elements, Fast Formula)
================================
Elements
=================
Elements are the building blocks for payroll processing. In Oracle every component of your paycheck is an element. Eg regular salary, housing allowance

Navigation :- Total Compensation :->  Basic :-> Element Description

 Fields:- Name , Earning / Dedudication , Recuring/ Non Rerecuring, Priority


Fast Formula
=========================
Oracle payroll gives you complete control over your processing rules and calculations, even the most complex ones. Fast Formula is a powerful
way to module business rules. With Fast Formula, Oracle Payroll's easy-to-learn caluculation feature, you can quickly specify detaied payroll
Calculation using canditional logic and references to any oracle human resources, oracle payroll, and oracle advanced benefits or Oracle time &
labor information.

Payroll Run
=======================
Concurrent Program :Payroll Run/ Payroll Process


Prepayment Method
=======================
This is a mandatory process. This process looks in to the amounts processed for each of the employees and their respective payment methods.
eg: 2000 is divided as 1600 to bank & 400 is given as check etc
Concurrent program : Go to single request and put the process name as PrePayments.

Payment Method Setup
================================

Navigation :- HRMS Manager :->  Payroll :-> Payment Methods

Check Payment / Direct Deposit / Child Deposit (Child Support - Third Party Payment)

- Employer Bank Account Details
- Costing  / Transfer to GL (Check Box)
- Genearal Ledger
- Cost Management


Consolidation Sets
=======================

Navigation :- HRMS Manager :->  Payroll :-> Consolidation (Just give the Consolidatoin Set Name)

Create Payroll
========================

Navigation :- HRMS Manager :->  Payroll :-> Description

Period Type, First Period end date, Number of years, Date Offset(Check, Scheduled Run, Cut Off , Payslip)
Payment Method, Consolidation set
Costing , Suspense Account




Payroll Archive
=======================
This is done through a seed concurrent program. "Payroll Archive". This process populates the data in the payroll archive table.
This enables the check writer and the deposit advices process to pick the data from the archive table to be displayed on the SOE.

NACHA
=======================
This is the process for direct deposit. UK localization supports the BACS and North American Localiazation supports NACHA.
All localization follows a specific payment gateway. This process generates an output file that can be sent to bank and the treasury.
We can transfer the output to the bank via established preferred electronic media.

Direct Deposit(XML)
=======================
This deposit advice prints the payslips.It will have earning & deductions in a more understandable format as a report.

Check Writer (XML)
=======================
To print the check for employee salary. Process Name : "Check Writer"

Costing
=======================
Done based on the Costing flex field. To transfer payroll to GL

Transfer to Gl
=======================

Oracle EBS R12.1 and 12.2 Difference


====================================
Application Front End Difference
====================================


1) New Profile :- Self Service Personal Home Page mode (Framework Simplified)
      Oracle Applications Look and Feel profile option to "Skyros Look and Feel"
   FND: Enable Rich Table Interactions profile option to "True"


2) OAF Admin Personalization Workbench - Redesigned (Easier Page Personalization with visual Design)
  - What You See Is what you get
  - Layered View of Personalization Levels, with Preview of Resulting Page
  - Drag and Drop to Move Page Elements
  - Personalizatoin inclue :
    = Expand Tables/ Add Columns
= Hide/Show Regions
= Reorder Page/ Region Elements
= Change Lables
= Set Default Values
Reordering columns
Resizing columns
Hiding and showing columns
Detaching tables from the base page (except HGrids)
Scroll horizontally if the contents of a table exceeds the browser width
Refresh a table by querying for the latest records
Reset a table back to its original definition

3) Added New Theams

4) Iprocurement  with information discovery
 - Auto-Suggest Catalog Items
 - Show Procurement Activities to Requesters
 - New Supplier Onboarding for non catalog
 - New Supplier Creation for Spoy Buy
 - Simplified Shopping cart

 Purchasing
--------------------------------------
 Automated Grouping of multiple requests to PO
 Validate agreement line amount during Order/Release Submission

 Procurement Contracts

 Content Search and Snippet Review (Search inside pdfs of the contracts)


 Payables
-------------------------------------


 Sending workflow approval notificaions in parallel.
 Invoice validation concurrent program support multiple child
 request based on the Purchase Order matched invoice.

 Profile Name  AP: Maximum lnvoice Validation Child Requests

 Customer and Supplier bank accounts can be created or searched

 on IBAN

====================================
 Database
====================================

 Dual File System
         (3 files for each object from 11.2.0.3)
- File System 1 - Run Edition
- File System 2 - Patch Edition
- FS NE - Non Edition File system
DB
- Run Edition , Patch Edition , Old Edition
 Online Patching

 Mobile compactability


====================================
 Technical
====================================
 Scripts required for 12.2.X custom table development

Table Names must be unique at 29 bytes or less
Column Names must be 28 bytes or less
Editioning View added (# suffix) to the base table.APPS synonyms now point to the Editioning View
Use Synonym to point to Global Temp Table
Materialized Views - Create a Logical View A Materialized View Definition must be stored in an ordinary view called MV_NAME||'#'

1) For new table creations - after creating the table in custom schema execute below script to generate editoning view and synonym for it in APPS schema.

exec AD_ZD_TABLE.UPGRADE('XXCUST','XX_CUST_TBL1');

2) For table alteratuons - after running the DDL run below script to regenerate the editioning view for syncing any table changes.

exec AD_ZD_TABLE.PATCH('XXCUST','XX_CUST_TBL1')

3) Table grants must be done through API to avoid invalids.

exec AD_ZD.GRANT_PRIVS('SELECT','XX_CUST_TBL1','XX_ROLE0')

4) To view objects in all editions..add _ae to the data dictionary views

select * from user_objects_ae;

5) To update seed data tables in Patch edition, execute prepare command.

example:
 exec ad_zd_seed.prepare('WF_MESSAGES');

The prepare will create a edition based storage for the run edition data for which the updates will be made. During cutover, the run time data will be synced using forward/reverse cross edition triggers.