Data Upload using CSV file

As salmo alaikum wa rhamatullah.

Effective Start Date	Effective End Date	Job Code	Job Name	Regular Temporary	Full Part Time	Active Status
01-01-1950	31-12-4712	ACC1	Account Clerk	T	PART_TIME	A
01-01-1950	31-12-4712	ACC1	Account Clerk	T	FULL_TIME	A
01-01-1950	31-12-4712	ACC1	Account Administrator	T	FULL_TIME	A

Ma Asalaam

Passion 4 Oracle

Oracle Fusion Workforce Compensation

As salamo alaikum wa rahmatullah

Workforce Compensation - Key Feature
-> Facilitates review cycles for global organization for
* Annual focused review cycle
* Anniversary based review cycle
-> Allocate multiple types of compensation
-> Manage budgets at the manager level or at the worker level
-> Create models to automatically determine worker allocation, 

budgets amounts and targets
-> View performance ratings or rate performance
-> Promote workers
-> Review and approve work of lower managers
-> Analyze allocations using online reports
-> Generate compensation change statements


----------
Key Decision Points
* Who are eligible for the Plan?
* How many plans are required?
* Who should have access to setups, administrator and 

worksheet pages?
* What compensation components are being awarded through the 

plan?
* How does the reporting hierarchy look like?
* What are key plan cycle dates?
* How does the worksheet look like?
* Do you want to use performance rating in compensation

plans? if so whether you want to award performance rating in 

compensation module or import from Fusion Performance 

management?
* What kind of budgeting will be used?
* What kind of modeling will be used?
* What kind of approval process is required?
* How to communicate awards and promotions to the workers?


-----------------------------
Pre-Requisite Configurations

# Eligibility Profiles
# Elements
# Fast Formulas



-------------------------------
Workforce Compensation - Roles

=> Compensation Administrators:
* Configure and maintain compensation plans
* Update information, run processes and review 

administration
* Maintain currency rates and access to plans from the 

watch list
* Run processes to initiate a compensation cycle, 

transfer data to the HR System, and refresh HR data reports.


=> Compensation Managers:
* Manage worker data by changing assignment data for 

the current plan cycle
* Distribute initial budget
* Change budget and worksheet access
* Override line manager allocations, Job changes, and 

Performance ratings.
* Analyze plan results using administrative reports
* create model for use by line manager or by 

administrator to distribute compensation directly to workers


=> Line Manager:
* Line manager can allocate one or more types of 

compensation manually or automatically for group of workers on 

a focal, anniversary, or periodic basis
* Approval allocations of lower level managers
* Promote and rate worker performance
* View compensation history
* Run report to analyze the compensation cycles.


=> Worker:
* The worker can view the compensation details in my portrait

---------------------
WORKFORCE COMPENSATION TASK FOR COMPENSATION ADMINISTRATOR 

ROLE
** MANAGE PLANS
** MANAGE ACTIVE PLANS
** RUN BATCH PROCESSES
** CONFIGURE GLOBAL SETTINGS

WORKFORCE COMPENSATION TASK FOR COMPENSATION MANAGER ROLE
** ACT AS PROXY MANAGER
** ADMINISTER WORKERS
** MANAGE GLOBAL MODELS
** VIEW ADMINISTRATION REPORTS


WORKFORCE COMPENSATION - PROCESS FLOW
------------------------------------

-> SETUP PLAN -> LOAD DATA FROM HR SYSTEM OF RECORD -> START 

COMPENSATION CYCLE -> PLAN DETERMINES BUDGET, TARGETS DEFAULTS 

-> ALLOCATE COMPENSATION -> APPROVER WORK OF LOWER MANAGER -> 

TRANSFER APPROVED COMPENSATION AND PROMOTIONS TO FUSION HR -> 

COMMUNICATE TO WORKERS -> TRANSFER APPROVED DATA TO HR SYSTEM 

OF RECORD

* Configure workforce compensation plan
* Load data from HR system of record HR into Fusion (Optional 

if using Fusion Global HR for HR system of record)
* Run batch process to start compensation cycle
* Plan and load budgets, targets and defaults using modeling 

or manual process
* Open system to managers to being allocations
* Review and approve work of lower managers (Can occur during 

the entire cycle)
* Run batch process to transfer approved compensation and 

promotions to Fusion HR and Payroll
* Communicate awards and promotions to workers
* Transfer compensation and promotions to HR system of record
* Review and analysis can take at any time using delivered 

reports and data downloads




--------------------------
Workforce Compensation - Batch Processes

* Start Workforce Compensation Cycle : Build manager 

worksheets with eligible workers for a new plan and initiate 

the compensation cycle.

* Refresh Workforce Compensation Data : Synchronize workforce 

compensation data with HR data, update plan design and 

currency conversion rates, and recalculate summary data.

* Transfer Workforce Compensation Data to HR : Post base pay 

adjustment to salary records, Job, Grade and Position changes 

to Human Resources, and element entries to Payroll.

* Back Out Workforce Compensation Data : Reverse a completed 

Start Workforce Compensation Cycle process or remove salary, 

Payroll and HR changes posted.

* Purge Workforce Compensation Data : Remove unneeded 

transaction data from prior plan cycle.



--------------------------------
Define Workforce Compensation
TASK LIST

## FOUNDATION
-> Configure Plan Details
-> Configure Plan Eligibility
-> Configure Plan Cycle
-> Configure Plan Currency
-> Configure Plan Access
-> Configure Plan Feedback Survey


## BUDGETS
-> Configure Budget Pools
-> Configure Budget Displanb

## WORKSHEETS
-> Configure Compensation Components
-> Configure Performance Ratings
-> Configure Approvals
-> Configure Compensation Change Statements
-> Configure Alerts
-> Configure Worksheet Display

## MODEL AND REPORTS
-> Configure Modeling
-> Configure Reports
-> Configure Report Dimensions
-> Configure Report Filters

## VALIDATION AND PROCESSING
-> Validate Plan and Start Compensation Cycle


--------------------------

STEP 1 : CONFIGURE PLAN DETAILS
Define basic plan details such as Name,Description, and Status 

etc.

* Display Order : Order in which you want the plan to appear 

in the list of other plans
* Hierarchy Type : Determines hierarchy type to be used to 

summarized and organize data on the worksheets.
* Frequency : Determines how adjusted salary is calculated, 

Brings salaries paid in different frequencies (hourly, 

monthly, annually) to the selected frequency.
* Annualized Factor : Converts base pay in the selected 

frequency to an annualized value.
* Employee Record to Use
Determines :
> Employment records evaluated by the start 

compensation cycle process
> Which records are used during the 

compensation cycle
* Plan Status
You can run the start Compensation Cycle process for 

active plans.
Note : Inactive plans can't be processed.

Oracle Payable Setup

As salamo alaikum wa rahmatullah




---
Ma Asalaam

General Ledger Table with Navigation Steps

As salamo alaikum wa rahmatullah


-- RESPONSIBILITY TABLE
SELECT * FND_RESPONSIBILITY

-- LOCATIONS TABLE
NAV>WORKSTRUCTURE>LOCATION

SELECT * FROM HR_LOCATIONS_ALL WHERE LOCATION_CODE LIKE 'TITAN%'


-- BUSINESS GROUP
NAV>WORKSTUCTURE>ORGANIZATION>DESCRIPTION

SELECT * FROM HR_ALL_ORGANIZATION_UNITS WHERE  NAME LIKE '%_BG%'

--LEDGER
--========
-- CURRENCY
NAV>SETUP>CURRENCIES>DEFINE

SELECT * FROM FND_CURRENCIES_TL WHERE NAME LIKE 'India%'

-- CALENDAR TYPE
NAV>SETUP>FINANCIAL>CALENDARS>TYPES

SELECT * FROM GL_PERIOD_TYPES WHERE USER_PERIOD_TYPE LIKE 'TITAN%'

-- CALENDAR MONTHS (PERIOD)
-------------------
NAV>SETUP>FINANCIAL>CALENDARS>ACCOUNTING

SELECT * FROM GL_PERIOD_SETS WHERE PERIOD_SET_NAME LIKE 'TITAN%'

SELECT * FROM GL_PERIODS WHERE PERIOD_SET_NAME LIKE 'TITAN%'


-- CHART OF ACCOUNT
--- FLEX FIELD - TWO TYPES OF FLEX FIELD KEY FLEX FIELD AND DESCRIPTIVE FLEX FILED
NAV>SETUP>FINANCIAL>FLEXFIELDS>KEY>SEGMENTS

SELECT * FROM FND_ID_FLEX_STRUCTURES_VL

SELECT * FROM FND_ID_FLEXS

-- SEGMENTS STRUCTURE STORED
------------------------------
SELECT * FROM FND_ID_FLEX_STRUCTURES_TL WHERE ID_FLEX_STRUCTURE_NAME LIKE 'TITAN%'

SELECT * FROM FND_ID_FLEX_SEGMENTS WHERE ID_FLEX_NUM='53542'

--VALUE SET  TABLEN

SELECT * FROM FND_FLEX_VALUE_SETS WHERE FLEX_VALUE_SET_NAME LIKE 'TITAN%'

--VALUE SET VALUE
-----------------
NAV>SETUP>FINANCIAL>FLEXFIELDS>KEY>VALUES

Select * from FND_FLEX_VALUES

-- ACCOUNTING SETUP MANAGER LEDGER
--LEDGER
==
NVA>SETUP>FINANCIALS>FINANCIAL ACCOUNTING SETUP MANAGER>ACCOUNTING SETUPS

LEGAL ENTITY INFO
----

SELECT * FROM HZ_PARTIES WHERE PARTY_NAME LIKE 'TITAN%'

SELECT * FROM GL_LEDGERS WHERE NAME LIKE 'TITAN%'

OPERATING UNIT
----------------

SELECT * FROM HR_ALL_ORGANIZATION_UNITS
WHERE NAME LIKE 'TITAN%'

ONLY OPERATING UNIT
--------------------

SELECT * FROM HR_OPERATING_UNITS
WHERE NAME LIKE'TITAN%'

INVENTORY ORGANIZATION
=====================
NAV>SETUP>ORGANIZATIONS>ORGANIZATION

SELECT * FROM HR_ALL_ORGANIZATION_UNITS
WHERE NAME LIKE 'TITAN%'

ONY INVENTORY ORGANIZATION
========================
SELECT * FROM

SELECT * FROM ORG_ORGANIZATION_DEFINITIONS WHERE ORGANIZATION_NAME LIKE 'TITAN%'


--
MA AS

Tax Reporting Unit in Fusion HCM

As salamo alaikum wa rahmatullah

Use a tax reporting unit to group workers for the purpose of tax and social insurance reporting. A tax reporting unit is the Oracle Fusion Human Capital Management (HCM) version of the legal reporting unit in Oracle Fusion Applications.

To create a tax reporting unit, you use the Oracle Fusion Legal Entity Configurator to define a legal entity as a payroll statutory unit. When you identify a legal entity as a payroll statutory unit, the application transfers the legal reporting units that are associated with that legal entity to Oracle Fusion HCM as tax reporting units. You can then access the tax reporting unit using the Manage Legal Reporting Unit HCM Information task.

If you identify a legal entity as a legal employer, and not as a payroll statutory unit, you must enter a parent payroll statutory unit. The resulting legal reporting units are transferred to Oracle Fusion HCM as tax reporting units, but as children of the parent payroll statutory unit that you entered, and not the legal entity that you identified as a legal employer.

Ma Asalaam

Passion 4 Oracle

REMOVE THE \r\n FROM THE COLUMN VALUE IN SQL SERVER

AS SALAMO ALAIKUM WA RAHMATULLAH

REMOVE THE \r\n FROM THE TABLE COLUMN VALUE AND UPDATE.


Select replace(replace(mobile_slno,char(10),''),char(13),'')
from tbl_str_receipt_det
where mobile_slno like'%'+char(13) or mobile_slno like '%'+char(10)

begin transaction a
update tbl_str_receipt_det
set mobile_slno=replace(replace(mobile_slno,char(10),''),char(13),'')
where mobile_slno like'%'+char(13) or mobile_slno like '%'+char(10)
rollback transaction a

MA ASALAAM
Passion 4 Oracle

E-Business Suit Fast Formula

As salamo Alikum wa rahmatullah

Fast Formula in E-business Suit, Please find at the following link

http://www.erpschools.com/articles/fast-formula


--
Ma Asalaam
Passion 4 Oracle