Oracle Apps

Seting up Employer Tax Information includes:

1. Entering Federal, State and Local tax information for GRE
2. Setting up Transmitter information for GRE
3. Setting up Multiple Worksite Reporting

Employer Liabilities for federal taxes are:
– Social Security (FICA-OASDI)
– Medicare (FICA-HI)
– Federal Unemployment Tax Act (FUTA)

Employer Liabilities for state taxes are:
– State Unemployment Insurance (SUI)
– State Disability Insurance (SDI)

For US legislation, Vertex maintains the
tax table information and assist in the
calculation of specific employer and employee taxes

When you set up your enterprise work structures
You must enter federal, state and local tax details for
each GRE/Legal Entity
• If you define new tax categories when you set up
compensation types of supplemental or imputed
earnings, or pre-tax deductions
– You must enter taxability rules for these categories at
the federal, state and local levels

Setting up Transimitter Information for GRE

Several reports must be submitted to federal or state agencies quarterly or yearly
– Submission is often made through magnetic media and requires ‘Transmitter’ details
– Enter GRE transmitter information in the Organization window
• Set up Federal level Transmitter details for Multiple Work Site Reports (BLS-3020), W-2’s
and Retirement Plan Distribution (1099-R)
• Set up State level Transmitter details for State Quarterly Wage Listings (SQWL)

Multiple Worksite Report:

Employers with multiple worksites must file quarterly employment and wage reports
• This information is used by the Bureau of Labor Statistics to analyze
U.S. employment data
• The MWS Report is submitted on magnetic media
• Only one GRE submits the MWS Report to the Bureau of Labor Statistics
regardless of the number of locations in multiple states

This reporting GRE reports the wages and locations of employees in all
locations across all states and other GRE’s
– Use the Reporting Establishment classification to identify this GRE
– Enter MWS Transmitter details for this GRE

Taxibility Rules for Earnings and Deduction:

We have predefined Taxibility Rules for the correct taxation of regular and overtime
earnings.
• The Earnings classification and Regular category are always subject to federal and state taxes
• Categories associated with Supplemental and imputed earnings classifications may be subject to
different taxes at the federal, state and local tax levels

We can define additional Tax categories with different tax rules:
Define additional tax categories using the lookup types:
– US_SUPPLEMENTAL_EARNINGS
– US_IMPUTED_EARNINGS

Eentering and calculating FUTA credits

FUTA or Federal Unemployment Tax is an employer liability
that must be reported annually on form 940
• Calculating FUTA Credits
– An employer’s FUTA tax rate can be reduced through credits it can
take based on the amount and timeliness of state unemployment taxes it pays

Vertex Updates:
The Vertex is the vendor which on regular intervals provides updates to the various tax tables for
the US legislation. For correct tax calculations the application must be up to date with the Vertex Update

VB Script to automatically login into a website:

Create two VB-script

1. citrixlogin.vbs

dim Shell
set Shell = CreateObject("Wscript.Shell")
Shell.run "http://www.xyz.com/auth/login.aspx"
Wscript.sleep(5000)
Shell.sendkeys ("khwaja")
Shell.sendkeys chr(9)
Wscript.sleep(2000)
Shell.sendkeys ("danger")
Shell.sendkeys "{Enter}"
Wscript.quit

2. citrixshort.vbs

dim Shell
set Shell = CreateObject("Wscript.Shell")
str_dsk_top = shell.SpecialFolders("Desktop")
set shortcut = shell.CreateShortcut(str_dsk_top & "\citrix.lnk")
shortcut.TargetPath = "D:\Documents and Settings\khwaja.hassan\My Documents\Login Scripts\citrixlogin.vbs"
shortcut.Hotkey = "CTRL+SHIFT+L"
shortcut.save

Save the two scripts in a Folder of your choice. In my case I saved it in
D:\Documents and Settings\khwaja.hassan\My Documents\Login Scripts

Now go to command prompt and then use the below command:

Cscript citrixshort.vbs

This will create a shortcut for the citrixlogin.vbs script on Desktop and
assign the HotKey to the vbscript, "citrixlogin.vbs" as mentioned in the
citrixshort.vbs

Now if you press "CTRL+SHIFT+L" you will see the internet explorer launching and then
the url that you have mentioned in the citrixlogin script, will open and automatically
log you in by entering the user name and password on the login page.

Query to find concurrent requests’ status for a given request id.

select fcr.request_id
,decode(fcr.phase_code,’P',decode(fcr.hold_flag,’Y',’Inactive’,fl_p.meaning),fl_p.meaning) phase
,decode(fcr.phase_code,’P',decode(fcr.hold_flag,’Y',’On Hold’,decode(sign(fcr.requested_start_date - sysdate),1,’Scheduled’,fl_s.meaning)),fl_s.meaning) status
from fnd_concurrent_requests fcr
,fnd_lookups fl_p
,fnd_lookups fl_s
where 1=1
and fcr.phase_code = fl_p.lookup_code
and fl_p.lookup_type = ‘CP_PHASE_CODE’
and fcr.status_code = fl_s.lookup_code
and fl_s.lookup_type = ‘CP_STATUS_CODE’
and fcr.request_id = &request_id
order by fcr.request_id desc;