Oracle Apps R12 Standard Report

As salamo alaikum wa rahmatullah.

Reports Available from the Oracle Payroll Area

The following table describes key reports available from the payroll area in Oracle:

RF Custom and Oracle Reports	Description of Report	Responsibility with Access to Run the Report
Element Result Listing	Displays the name, assignment number, organization, amount and up to three input values of a particular element that has processed in payroll. Operating locations can run the report at any time after a payroll has been run. It can be run for previous payrolls as well. Data will be reflective of reversals if run for previous payrolls.	HRMS Administrator HRMS Inquiry HR/PR Specialist HR PR Inquiry
Employee Run Results Report	Displays the amount of each element processed for a person in a particular pay period. Operating locations can run the report at any time after a payroll has been run. It can be run for previous payrolls as well.	HRMS Administrator HR/PR Specialist
RF Person Payroll Activity Report	The "RF Person Payroll Activity Report" displays the employee’s name, assignment number, organization, tax filing status, tax exemptions, gross and net earnings and all deductions for the specified pay period. It also lists the year to date totals for earnings and deductions.	HRMS Administrator HR/PR Specialist
RF Quick Pay Pending by Date Paid	Displays quick pays that have been run but not paid in date order. Operating locations should run this report before every preliminary and final payroll. There should be no quick pays on this report right before a payroll.	HRMS Administrator HR/PR Specialist
RF Non US Citizen SIT and Tax Data	Displays noncitizen residency information, noncitizen tax Special Information Type (SIT) information and tax data for each employee and fellow who is not a U.S. citizen. Operating locations should run this report once a month to ensure noncitizen information is up-to-date. SIT information is used to produce IRS 1042-S forms at the end of the year.	HRMS Administrator HR/PR Specialist
RF Detail Control Register Full Report RF Detail Control Register Range of Dates	RF Detail Control Register Full Reportdisplays all changes entered for the current pay period and changes entered during the current pay period for future pay periods for certain fields in the following forms: Person Form, Assignment Form, Salary Form, and Element Entries Form. RF Detail Control Register Range of Dates displays all changes entered during the dates selected for certain fields in the following forms: Person Form, Assignment Form, Salary Form, and Element Entries Form. Note: Operating locations can run either report at any time during the payroll cycle	HRMS Administrator HR/PR Inquiry HR/PR Specialist
RF Auto Termination Report	The "RF Auto Termination Report" is a payroll report that displays the auto termination data for each campus. This monitoring report is divided into three different sections of output: Assignments Active to Terminated, Assignments Process Pending to Terminated, and Assignments With Future Terminations Unchanged. Operating locations should run this report after each payroll to verify that the termination dates are accurate and as expected.	HRMS Administrator HR/PR Specialist HR/PR Inquiry HRMS Inquiry

Payroll Reports Run by Central Office

The following reports are run by central office and posted to the RF web site. Operating locations can retrieve the report from the Web site.

Corporate Payroll Reports Run by Central Office
Payroll Message Report	Displays the errors for each person for a payroll run. Those with fatal errors did not process through on the payroll. Central office runs this report for every preliminary and final payroll. For the preliminary payroll, the report can be used to correct errors before the final payroll is run. For the final run, the report serves as documentation and explanation as to why a person was not paid.
Retro Biweekly	This report is run nightly for any system generated biweekly retro errors that have occurred for that day. The report will display the assignment number and reason for the error.
Retro SUNY	This report is run every Tuesday night for any system generated SUNY retro errors that have occurred for that week. This report will display the assignment number and the reason for the error.
RF Payroll Check Distribution Report	Displays people receiving a check or direct deposit for a particular payroll, in delivery drop order. Central office runs this report every payroll and sends it via Federal Express to operating locations, along with their payroll checks and Direct Deposit Stubs.

Ma Asalaam
--
Passion 4 Oracle

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