Oracle Fusion HCM Knowledge Hub

If you want to use position synchronization only for a section of workers, you need to enable position synchronization at the legal employer level. To exclude some assignments from synchronization, select Allow Override at the Assignment in the Position Synchronization Configuration section on the Manage Enterprise HCM Information page. To exclude a specific assignment from synchronization, select No in the Synchronize from Position field in the assignment (even if override is allowed).  All read-only fields become editable but the assignment won't be synchronized and will no longer inherit any changes made at the position level.  However, it isn't possible to exclude only some synchronized attributes.

Tax Reporting Unit: 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. Payroll Statutory Units: Payroll statutory units are legal entities that are responsible for paying workers, including the payment of payroll tax and social insurance.  A payroll statutory unit can pay and report on payroll tax and social insurance on behalf of one or many legal entities, depending on the structure of your enterprise. 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 Configurator. 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 repo...

A person who will be hired or start a contingent worker placement and for whom you create a person record that's effective before the hire or start date. A pending worker is a person who's yet to start employment and doesn't have a person record in the application. You create a pending worker record with a date that's effective before the hire date. You convert a pending worker to the proposed worker type when the new hire is confirmed. For example, when a new employee's hire is completed, you convert the pending worker record to an employee record. The pending-worker functions provide greater control of the hiring process than hiring an employee or adding a contingent worker with a future start date. 

No, but you may be able to cancel work relationships.  If you cancel a person's only work relationship, and the person has no contact relationships, the person record: => Is identified as associated with a canceled work relationship. => Doesn't appear in directory searches.

  The following table outlines the difference between Global names and Local names. Name Type Description Global Names Are in a format and language that can be understood throughout a multinational enterprise. Local Names Are understood by users in a single country, but may not be understood throughout a multinational enterprise. You can have only one local name at a time. Select the local-name language that is most appropriate for your primary assignment and reporting requirements. For example, if your home country is Sweden, you may enter a local name in the Swedish language and format.

Work Tax Address: When you perform a payroll run, the payroll processes the following fields and determines the resident and work tax addresses based on the following hierarchy: Priority Address Type 4 Location address 3 Location override address 2 Assignment-level location override 1 Work at home flag = Yes (overrides assignment, location override, and location) Note: Higher priorities override the lower ones. If Work Tax Address is not entered by default it takes the Location address . We need to enter this field only when we want to tax at location other than the Location address. Primary Mailing Address: The address used by default for correspondence. The home address is automatically the primary mailing address. To use a different address as the primary mailing address: => Create the new address. This can be of any type; you need not define it as a mailing address. => Edit the primary mailing address to select the new address. => If you create a mailing address, that addr...

  Execute the following to change name of legal entity:Name: 1) Go to Functional Setup Manager (FSM) 2) Search for task "Search Legal Entities" and click Go to Task. 3) Select Legal entity you wish to rename, click the Edit (Pencil) icon 4) Enter New Name of Legal Entity, Save and Close.

 SELECT pn.DISPLAY_NAME, pall.PERSON_NUMBER, asg.ASSIGNMENT_NUMBER, aor.* FROM PER_ASG_RESPONSIBILITIES aor JOIN PER_PERSON_NAMES_F pn ON aor.PERSON_ID=pn.PERSON_ID JOIN PER_ALL_PEOPLE_F pall ON aor.PERSON_ID=pall.PERSON_ID JOIN PER_ALL_ASSIGNMENTS_M asg ON aor.PERSON_ID=asg.PERSON_ID WHERE TRUNC(sysdate) BETWEEN pn.effective_start_date AND pn.effective_end_date AND pn.NAME_TYPE='GLOBAL' AND asg.ASSIGNMENT_TYPE IN ('E','C','N','P') AND TRUNC(sysdate) BETWEEN asg.effective_start_date AND asg.effective_end_date

 Select  Txnd.Status As Txn_Status  ,Txnh.Module_Identifier  ,p.person_number  ,txnh.CREATION_DATE  ,Txnh.Transaction_Id  ,txnd.STATE as TXN_STATE  ,txnh.CREATED_BY  ,Txnh.Initiator_User_Id  ,Txne.Fault_Date  ,Txne.Error_Details  ,wft.tasknumber  ,wft.compositeinstanceid  ,wft.TITLE  ,wft.OUTCOME as WF_OUTCOME  ,wft.STATE as WF_STATE  ,Wft.Substate  ,Wft.Assignees  ,Wft.Assigneesdisplayname As Current_Assignee  ,wft.Assigneddate  ,wft.Approvers ,wft.ASSIGNMENTCONTEXT from  Fusion.hrc_txn_header txnh, Fusion.hrc_txn_data txnd,  fa_fusion_soainfra.wftask wft,  fusion.hrc_txn_error txne, Fusion.per_all_people_f p  Where Txnh.Transaction_Id = Txnd.Transaction_Id  and txnh.transaction_id = txne.transaction_id(+)  And To_Char(Txnh.Transaction_Id) = Wft.Identificationkey(+)  And Txnh.subject_id = p.person_id(+)  And Txnh.Transaction_Id = P_TRANSACTION...

 SELECT fdsv.descriptive_flexfield_code ,fdsv.context_code ,fdsv.segment_code ,fdsv.name ,fdsv.column_name ,fvvs.value_set_code ,fdsv.display_type ,fdsv.prompt ,fdsv.short_prompt ,fdsv.enabled_flag ,fdsv.required_flag ,fdsv.read_only_flag ,fdsv.description ,fdsv.sequence_number ,fdsv.derivation_value ,fdsv.bi_enabled_flag FROM fnd_df_segments_vl fdsv, fnd_vs_value_sets fvvs WHERE fdsv.value_set_id = fvvs.value_set_id(+) AND fdsv.descriptive_flexfield_code = 'PER_ASG_DF'

 select papf.person_number, ppnf.full_name from per_All_people_f papf,per_person_names_f ppnf where papf.person_id =ppnf.person_id and ppnf.name_type= 'GLOBAL' and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and trunc(sysdate) between ppnf.effective_start_date and ppnf.effective_end_date and papf.person_id = HRC_SESSION_UTIL.GET_USER_PERSONID

 select gfrt.report_display_name, gfrt.report_description,gfrb.* from GL_FRC_REPORTS_B gfrb, GL_FRC_REPORTS_TL gfrt where gfrb.report_id=gfrt.report_id

select REGISTERED_NAME,REGISTRATION_NUMBER, ADDRESS1,ADDRESS2,ADDRESS3,ADDRESS4, CITY,STATE,PROVINCE,COUNTY,ADDRESS_STYLE, ADDRESS_LINES_PHONETIC,COUNTRY,POSTAL_CODE from xle_registrations a1, xle_entity_profiles a2, HZ_LOCATIONS A3 where 1=1 and a2.legal_entity_id=a1.source_id and source_table='XLE_ENTITY_PROFILES' and a1.location_id=a3.location_id

 Start Flow Retro Calculations: Verify Retroactive Notification Report Recalculate Payroll for Retroactive Changes Verify Retroactive Report Calculate, Validate and Balance Payroll: Calculate Payroll Run Gross-to-Net Report Verify Reports Calculate Payment Distribution: Calculate Prepayments Verify Prepayments Archive Periodic Payroll Results Run Payroll Register Report Distribute Payroll Payments: Make EFT Payments Generate Check Payments Generate Payslips Verify Payslips Run Payment Register Report   Distribute Payroll Accounting Information: Transfer to Subledger Accounting Review Final Journal Entries End Flow

 SELECT ppa.payroll_action_id ,ppa.action_status ,ppa.legislative_data_group_id ,ppa.action_sequence ,ppa.date_earned ,ppa.effective_date ,ppa.start_date ,ppa.end_date ,ppra.payroll_rel_action_id ,ppra.payroll_relationship_id ,ppra.action_status ppra_action_status ,ppra.action_sequence ppra_action_sequence ,pprd.legislative_data_group_id pprd_ldg ,pprd.payroll_relationship_number ,pprd.start_date pprd_start_date ,pprd.end_date pprd_end_date ,petf.base_element_name element_name ,petf_res.base_element_name iv_element_name ,pivf.base_name ,pivf.UOM ,pbav.entry_value FROM pay_bal_adj_lines pbal ,pay_element_types_f petf ,pay_bal_adj_values pbav ,pay_input_values_f pivf ,pay_element_types_f petf_res ,pay_payroll_actions ppa ,pay_payroll_rel_actions ppra ,pay_pay_relationships_dn pprd ,per_all_people_f papf WHERE ppa.payroll_action_id = ppra.payroll_action_id AND ppra.payroll_relationship_id = pprd.payroll_relationship_id AND papf.person_number = :P_PERSON_NUMBER --AND petf_res.base_elem...

Available user-name formats.  Email   is the default format. User-Name Format Description Email The work email (or party email, for party users) is the user name. For example, the user name for john.smith@example.com is john.smith@example.com. To make duplicate names unique, a number is added. For example, john.smith2@example.com may be used if john.smith@example.com and john.smith1@example.com already exist. Email  is the default format. FirstName.LastName The user name is the worker's first and last names separated by a single period. For example, the user name for John Frank Smith is john.smith. To make duplicate names unique, either the user's middle name or a random character is used. For example, John Smith's user name could be john.frank.smith or john.x.smith. FLastName The user name is the worker's last name prefixed with the initial of the worker's first name. For example, the user name for John Smith is jsmith. Person or party number The party number or pe...