1) Whenever
select Business Unit(US) only us employees shoing other then Business units of
employees not visible why ?
2) In HDL Loader what is
option :import and export what is the functionality work ?
3) What is content id
process id how find out process id we don't have like business object and
process id we don't process id
4) Why need import data
in fusion system thought HDL loader ?
5) How to HCM extract
changed functional data we achieved ?
Ans : the best
part HCM extract flexibility mode extract and run ...
=> Change Mode - it compare with privies
data then changed data fetching
A person prives data
noting changed
B person changed then
fecing the "B"recoded only
=> full mode
6) Which data your extracted
for HDL extract?
Ans : =>
HR and Payroll data to 3rd party service
=>
providers
=>
HR and Payroll data to another application in co-existence
Reposing and process
----------------------------
=> payslip to
employee
=> Letter for
mass processes such as promotion and salary review
=> statuary
reporting
=>Data achieve
7) We have a lookup name
contry_lookup like country_id and country_name whow
11 what is fast formula
type?
12 Can you explain HCM
extract?
13 What is different
between work list and watch list ?
Ans : in work list you will get approval
notification or any other notification
In watch list u can see all your
pending actions
14 what is the sandbox ?
sandbox A testing
environment that isolates untested code changes from the mainline environment
so that these changes don't affect the mainline metadata or other sandboxes.
35 what is employee
model? Which one you’re using?
36 what is the sand box?
37 what are the absence
types?
38 payroll Bach brief
and what are your doing explain?
39 what are the lookups?
40 Can you explain
complex BI report did you developed?
41 HCM impotents tables?
42 It is possible to
scheduled extract HCM report?
43 how assigned
assignment to user?
44 Once get instant
access what we will do?
45 how to assigned role
to user more than 10 roles ?
46 how find out
employees active or not?
47 How to terminated
employees? How to find out status?
48 Component modal?
49 can you explain BI
report?
50 can you explain
custom absence types did you setup ?
51 what is context?
52 How to links between
data group to records?
53 How to find out
eligibility user entities HCM extract?
54 Which table employees
terminate stored record?
55 Fast formulas what is
the default value and DBI value?
56 Integration
Key Map table HCM data loader table?
Source_intergration_key_map
hrc_integration_key_map
select
object_name, source_system_id, source_system_owner, surrogate_id,
rawtohex(guid) guid from fusion.hrc_integration_key_mapwhere
source_system_owner ='student1‘
56 how find out HCM
extract in BI report path?
Ans : Navigate to Shared Folders - > Human Capital Management -> Payroll
-> Data Models -> globalReportsDataModel
57 Manager_id which
table will store?
Ans : Per_assingnment
_supervisors_f
58 worker data loader
what are the mandatory columns?
Person name
59 people hire what are
mandatory fields and who many tabs open?
60 HCM data loader what
errors your facing?
61 HCM mandatory tables?
62 Did you facing
content id issues?
63 We have 4 flexfieds
how to set person management forma that 4 fields?
64 What are the extract
types?
65 which table manager
information stored.
Ans per_assignment_supervisors_f
68 Configure Source System Owner
Ans : Navigator
-> Setup and Maintenance -> (Click on Task List and click on “Search”) Once you click on the “Search” link you need
to search for “Manage Common Lookups” and then search for Lookup Type as
“HRC_SOURCE_SYSTEM_OWNER” and add new entry
1 How
to identify DB items in fast formula?
2 How
to given DB liken Data group?
3 write
a query person name and hire date columns 2017 years data fetch?
4 in
fast formula what is context?
5 HDL
how may records loaded? Historical data?
6 what
is lookups and values set?
7 what
is different between job and option?
8 what
is payroll user entity?
1)
In HCM extract processed fetch duplicate records how to
resolved it ?
2)
HCM data loading
two records one correct record second one is update record how loading both
scenario ?
3)
What are keys?
4)
What is user entity?
5)
What are LDG and Legal entity?
6)
After employee terminated how many tables effected? in
data base how many records have ?
ANS : 1 PER_PERIODS_OF_SERVICE :
ACTUAL_TERMINATION_DATE
ORIGINAL_DATE_OF_HIRE
REHIRE_REASON
2 PER_ASSIGNMENTS_F
---------------------------------------------------
PER_ALL_PEOPLE_F
PER_ALL_ASSIGNMENTS_F
PER_PERIODS_OF_SERVICE
hr.per_person_type_usages_f
hr.per_person_types
----------------------------------------
7)
1. When you start implement ion project what are the first
you will do it ?
Answer : The first step is setup ESC Enterprise structure
configuration the will do farther steps remaining …
2. In HDL data loader having source id is like below can we loaded data ?
METADATA|personnumber|Sourceid|EffectiveStartDate|EffectiveEndDate….
MERGE|234234|EBS|2342UJHFI2323|2013/01/01|4712/12/31
METADATA|personnumber|Sourceid|EffectiveStartDate|EffectiveEndDate
MERGE|234235|EBS_I|2342UJHFI2323|2013/01/01|4712/12/31
Answer : No
3. What is job and option?
4. What is grade and grad ladder?
5. What are absent type and what are the plans?
6. For paternity what is eligibly plan?
7. Entitlement usage?
8. What the flex
field?
9. DFF field having Y/N tow list values when chose Y field
shooing below
Passport
id
Passport
valid date
Nationality
When I
chose N there no records shooing who do it configurations’?
10. What are global
segments?
11. Without absence types we can create absence plan?
1
what the mines purpose of enterprise structure?
Answers:
in oracle fusion the enterprise purpose of employee across global unique.
2 HDL
data loader how to fled fields?
3 HCM
extract that are types?
4 HCM
extract that are changes MODE types?
|
Mode |
Lookup Value |
Description |
|
N |
All attributes |
Includes all data in the extract. A full extract is run which produces
the full data output at that point of time. The archived data is utilized as
a baseline. |
|
Y |
Changed attributes |
Compares this extract run with the previous extract runs and by
comparing against the baseline (to identify the incremental data), displays
the data that has changed only. |
|
ATTRIBUTE |
Changed and marked attributes |
Includes elements that have changed or marked as mandatory |
|
ATTRIB_OLD |
Changed and marked attributes with previous values |
Displays elements that have changed or marked as mandatory plus their
previous value Note You must run
the Payroll Interface with the Attrib_Old mode whenever you use the US ADP
PayForce Third-Party Periodic Extract. |
|
BLOCK_OLD |
Changed, marked attributes, previous data under threading group |
Displays the following data under threading data group: Changed data Data marked as mandatory Previous values Parent data group values |
|
BLOCK |
Changed and marked attributes under threading group |
Displays the following data under threading data group: Changed data Data marked as mandatory Parent data group values |
5HCM
data loader what are modes?
6 In BI
repots how to billed bursting?
7 in
HCM extract the person user entity will fetch the phone no also?
8 what
is the content types?
Ans:
1
Salary holds details of salary proposals for Employee?
Table
name : CMP_SALARY columns like SALARY_AMOUNT
2
Department id table?
PER_KEYWORDS
1 what
is relation 2-3 tire employee data modal ?
2 what
is the extend flex field how will set up
?
3 we
have requirement like bank amount, employee adjust amount who will conjugation
? it a regular base flex field configuration
?
4
Absence plan after configuration how to enrollment?
5
absence period how to adjustment?
6
explain geography structure?
7 we have organization have 2 legal entity how
to configuration department ?
8
organization trees explain ?
9 what
is the login ?
10 When
multiple changes per day how find out business objective?
Ans
. Used EffectiveSequence Attribute
11 For
objects with multiple changes per day, this attribute identifies the latest
record for the effective start date.
Ans Used attribute in meatadate line
“EffectiveLatestChange “ METADATA|Assignment|SourceSystemId|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|EffectiveEndDate|...
What's a legal employer?
A legal employer is a legal entity that employs
workers. You define a legal entity as a legal employer in the Oracle Fusion
Legal Entity Configuration.
The legal employer is captured at the work
relationship level, and all assignments within that relationship are
automatically with that legal employer. Legal employer information for worker
assignments is also used for reporting purposes.
What's a legal
address?
A legal address is the mailing address of a legal
entity or legal authority. A legal address is also the address a legal entity
uses to register with a legal authority.
You can use legal addresses to send correspondence,
such as invoices, bills, reports, and so on, to a legal entity or authority.
Note:
- You must create legal addresses before creating
legal entities
- You can create legal addresses for legal
authorities when creating legal authorities
What is WSA:
As per the Fast
Formula documentation,
“The working
storage area is a mechanism for storing global values across
formulas. The values are accessed by name. The names are case-independent”.
There are four
working storage area methods:
1.
WSA_EXISTS
2.
WSA_DELETE
3.
WSA_SET
4.
WSA_GET
|
|
How
can I reduce the size of my extract output? |
|
|
|
|
In the Delivery tab, set the Compress option as
Yes. You can use the compress feature with the WebCenter Content delivery
option only. This feature extracts a compressed output, which helps to speed
up large file transfers, uploading, and downloading. Compressing the extract
output uses less disk space too. |
||
1 Before
going load woke data what are the key files setup required?
2 In
rtf template how add in table and columns?
3 UE how will generate?
4 in report how to access financial module
reports only ?
5 how to pay the salary contingent workers
pending and non worker?
6 how
to find out in order load business objectives?
General Questions
:-
1.Anyone had an issue
where you added privileges to a role then when you go back and remove those privileges
the employee that has the role still has the ability to perform the tasks.I
regenerated the role ran sync jobs and the access hasn't reverted back... Or is
that it takes a while for the system update at the employee level?
ANS
: I would run the "Import Users and Role Application Security Data"
scheduled process. Then once this is completed the "Retrieve Latest LDAP
Changes"--usually this fixes it for me. Regenerate supposedly is supposed
to be sufficient, but sometimes it does not seem to work.
1) whenever
select Business Unit(US) only us emplyess shoing other then Bussiness units of
emplyees not
2) In HDL Loader what is
option :import and expport what is the fustionality work
3) what is content id
process id how find out process id we don't have like business object and
process id we
don't process id
4) why need import data
in fusion system trought HDL loader ?
5) How to HCM extraxt
changed funsional data we achvived ?
ans : the best
part HCM extract flixbility mode extract and run ...
=> Change Mode - it compare with prives
data then changed data feching
A person prives data
noting changed
B person changed then
fecing the "B"recoded only
=> full mode
6) which data your
extracted for HDL extraxt ?
Ans : =>
HR and Payroll data to 3rd party service
=>
providers
=>
HR and Payroll data to anothere application in co-exitence
Repoing and process
----------------------------
=> payslip to
emplyee
=> Letter for
mass processes such as promotion and salary review
=> statury
reporting
=>Data achive
7) we hava a
lookup name contry_lookup like country_id and country_name whow
How many key flex fields
in HRMS?
There are 6 Key
Fields, Namely1. Job KeyFlexFields.2. Position KeyFlexFields.3. Grade
KeyFlexFields.4. Cost
Allocation
FlexFields.5 . Competence FlexFields.6. People Group FlexField
How do you define
B.G.?
Business Group
navigation: HR: Work Structures>Organisation>Description
here you will
attach the structure of all the Key Flexfields which you define . Also the
default Payroll
currency gets
attached to the Business group
What are the key tables
used in HRMS?
PER_ALL_PEOPLE_F
PER_ALL_ASSIGNMENTS_F
HR_ALL_ORGANIZATIONS_UNITS
PER_LOCATIONS_ALL
PER_POSITION_DEFINITAION
PER_POSITIONS
PER_GRADES
PER_JOBS
PER_PERSON_TYPES
PER_ASSIGNMENT_TYPES
PER_PERSON_TYPE_USAGE
PER_PEOPLE_EXTRA_INFO
PER_DISABILITIES
PER_QUALIFICATIONS
PAY_PEOPLE_GROUP
What is date
tracking, how it is used in HRMS ?
date track allows
you to maintain a continuous history of the record or information over a period
of time.you
can use date
track history to view a report of every update ever made to a record..whenever
you update a
record a new
record gets created with the updated information and the previous record gets
end dated a day
before your
updation….presence of effective dates in the windows tells that the window is
date tracked….in
oracle hrms it is used
for assignments and information on workers.
Following are the
tasks for system administrator
— Set Profile
Options
— Create Menu and
Request Group for Custom Responsibilities
— Create
Responsibilities
— Create Users
— Attach
Responsibilities with User
What are the reporting
tools available with Oracle HRMS?
1.Oracle Reports
2. XML Report
3. Discoverer
Reports
How is gross pay
elements defined in Oracle HRMS?
Gross pay element
is nothing but salary paid to the employee before deductions. so in this scenario
we can
Assumes that the
total amount divide by 12 months right. Firstly we need to create an element
follow the below navigation
Total
Compensation -> Basics -> Element Description
After the
creation of the element we need to create a fast formula that will be
calculating the gross amount.
Total
Compensation -> Basics -> Formula Results.
Than assign it to
the earning element and link the element. So i believe this is how we need to
create a gross
Element
What are the tools used
with Oracle HRMS?
The tools used in
HRMS are:
Discoverer — To
develop reports
Web ADI — Either
to upload or down load the data from Oracle to legacy system or viceversa
RDF Reports —
Standard reports developed by Report Builder
TOAD — Testing
Tool
Data Loader — To
upload different data into oracle data base
XML Publisher —
Integrated Oracle Reports with the help of Microsoft Template Builder
What is the significance
of cross validate segments in the Key flexfield structure screen
Cross validation
(also known as cross segment validation) controls the combinations of values
you can create
When you enter
values for key flexfields. A cross validation rule defines whether a value of a
particular
Segment can be
combined with specific values of other segments.
Cross validation
is different from segment validation, which controls the values you can enter
for a
Particular
segment.
When a user
finishes entering segment values in a flexfield popup window, the flexfield
checks whether the
values make up a
valid combination before updating the database. If the user entered an invalid
combination, a
Diagnostic error
message appears, and the cursor returns to the first segment assumed to contain
an invalid
value.
What is the significance
of reference field in a DFF?
Based on the
value selected in a particular field,if you want to pop-up DFF segments, then
reference field
will be used.
eg:you have a
field called Item. if you choose Computer as an Item, then in DFF segments you
want to show
Computer Brand
name, Size.
If you choose TV
as an item , then in DFF you may want to show TV name,TV Color,TV Inches etc
in reference
field, we enter :Item as Reference, then in context values, we enter the Item
Values and then
Respective
Segment names
How do I enter the
default value of Key flexfield or DFF segment?
While defining
segments or attribute of KFF or DFF in segement(accounting flexfield) window in
validation box
select constant
in default type and enter default value.
What are costing types?
Fixed costed
Costed
distributed
what are six
validation types?
Dependent
Independent
None
What is the termination
rule of the element?
Actual
termination: for a non-recurring element select actual termination if you want
the entries to close down at the end of the pay period in which the employee
leaves.
Final close: if
you want the entries to stay open beyond the employees leaving date so that you
can continue to pay the employee.
The last standard
process date defaults to the last day of the pay period in which the employee
is terminated, but you can set it to a later period when you terminate an
employee.
How
can I remove someone from the payroll run?
Roll back the
person’s record from the View Person Process Result page, which deletes the
record
How do you set
the payroll license in Releases 10 and higher?
.
Navigator>Setup and Maintenance
Search for task
Manage Features by Country or Territory
Select Go to Task
Set the Payroll
license by country based on your Fusion licensing.
2) What are Object Groups?
Object groups are
user-defined sets of elements or people used to restrict which of these items
to include in various processes and reports.
There are four types of
object groups:
Element
Payroll
Relationship
Work Relationship
Deduction Card
Users can create
and maintain object groups in the Manage Object Groups page from the Payroll
Calculation work area. Object groups also could be loaded using the batch
loader from the Payroll Administration work area or the Data Exchange work
area.
3) What are Element
Groups?
Element Groups
limit the elements processed for payroll, reporting, or cost distribution
purposes.
There are two
usages for an element group:
Run group
Specifies the
elements to use in a process.
Distribution
group
Defines the
grouping of elements to distribute element costing results.
All element
groups are static. You select the element classifications to add and then include
or exclude additional elements from the group. Or you can select specific
elements to include without using element classifications.
4) What are Payroll
Relationship Groups?
Payroll
Relationship Groups limit the persons processed for payroll, data entry, and
reporting. When defining the group specify the payroll definition which
retrieves the payroll relationships assigned to it. Every group is limited to
the payroll relationships assigned to a single payroll that you select. You can
further define the group statically or dynamically.
If you define the
group statically, select the payroll relationships, terms, and assignments to
include or exclude in the group.
If you define the
group dynamically, use a fast formula of type Payroll Relationship Group to
determine the criteria that determines the payroll relationships, terms, and
assignments to include in the group. Then you can individually select
additional payroll relationships, terms, and assignments to include in or
exclude from the group.
5) What are Work
Relationship Groups?
Work Relationship
Groups limit the persons processed for human resources and reporting. For
example, you can use work relationship groups in custom extracts. If you define
the group statically, select the work relationships, terms, and assignments to
include or exclude in the group. If you define the group dynamically, use a
fast formula of type Work Relationship Group to determine the criteria that
determines the work relationships, terms, and assignments to include in the group.
Then you can individually select additional work relationships, terms, and
assignments to include in or exclude from the group.
6) What are Deduction
Card Groups?
Deduction Card
Groups are read-only. They are automatically created when deductions cards are
created. For example, in the UK, they are used for year-end processing.
7) How to include or
exclude an employee assignment from a payroll process?
Create a payroll
relationship group to include or exclude employees from payroll processes or
reports. In Oracle HRMS in EBS this functionality was called Assignment Set.
Navigate to
Payroll Calculation work area.
2. Open Manage Object Groups task.
3. Click on Create icon to create a new record.
4. In Create Object Group pop-up enter a name, select Payroll Relationship
Group for Type, click on Static radio button. Click Continue.
5. In Create Object Group page select appropriate Start Date.
6. In Object Group Parameter section click on magnifying glass under Value and
select a payroll. Click Next.
7. Under Payroll Relationship, Term or Assignment Inclusions and Exclusions
click on green plus to add a new record, then click on magnifying glass.
8. In Search and Select pop-up select needed record. Click on the hyperlink of
the number on the first column.
9. See the record that has been added to the inclusion or exclusion.
10. Click on Save and Submit.
What is the best
practice for the use of Payroll Relationship Group?
When payroll
process completes and there are several employees in error, you can rollback or
mark for retry these employees either individually in the View Payroll Process
Results page or by submitting a Rollback process or Mark for Retry process for
a specific payroll relationship group.
Oracle Fusion
Payroll delivers several types of involuntary deduction which are available for
the element creation:
Bankruptcy
Child Support
Creditor Debt
Educational Loan
and Debt Collection Improvement Act (DCIA)
Garnishment
Spousal Support
and Alimony
And tax levy
No comments :
Post a Comment