Showing posts with label Source Keys. Show all posts
Showing posts with label Source Keys. Show all posts

Thursday, 28 January 2021

Oracle Cloud - Load Worker Data - HDL

 Load Worker Data using HCM Loader


In earlier blog we have seen how to define Source Keys and we have created "XXTEST".

Prerequisite: 
1. Work structure should be loaded. Click here to find the sample Work structure.   


We will use the same Source Key while loading the HCM Object in Oracle Fusion.

You can see step by step video using this link

Now we will see how to load Worker data in Oracle Fusion using HCM Loader.

Components in Worker File which we are going to load :
Worker
Person Name
National Identifier
Email
Phone
Address
Citizenship
Ethnicity
Legislative Data
Work Relationship
Work Terms
Assignments

Download the object template from instance.

Navigation to download :

Navigator -> My Client Group -> Data Exchange -> View Business Objects 

You can see list of all object template.

Download the template for Worker Objects.

We will use only required fields from that template to load the Worker Object.

Lets see object wise HDL File.

METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|ActionCode|StartDate|DateOfBirth

MERGE|Worker|XXTEST|XXTEST_PER1|2018/01/01|4712/12/31|XXTEST1|HIRE|2018/01/01|1975/01/01

METADATA|PersonName|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|LegislationCode|NameType|FirstName|MiddleNames|LastName|Title

MERGE|PersonName|XXTEST|XXTEST_PERNAME1|XXTEST_PER1|2018/01/01|4712/12/31|US|GLOBAL|Adam||Baro|MR. 

METADATA|PersonNationalIdentifier|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegislationCode|IssueDate|ExpirationDate|NationalIdentifierType|NationalIdentifierNumber|PrimaryFlag

MERGE|PersonNationalIdentifier|XXTEST|XXTEST_NID1|XXTEST_PER1|US|||SSN|456-23-4167|Y

METADATA|PersonEmail|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|DateFrom|DateTo|EmailType|EmailAddress|PrimaryFlag

MERGE|PersonEmail|XXTEST|XXTEST_EMAIL1|XXTEST_PER1|2018/01/01|4712/12/31|W1|Adam.baro@ha.com|Y

METADATA|PersonPhone|SourceSystemOwner|SourceSystemId|PhoneType|DateFrom|DateTo|PersonId(SourceSystemId)|PhoneNumber|PrimaryFlag

MERGE|PersonPhone|XXTEST|XXTEST_WPH1|W1|2018/01/01|4712/12/31|XXTEST_PER1|789-123-2345|Y

METADATA|PersonAddress|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|AddressType|AddressLine1|AddressLine2|AddressLine3|AddressLine4|Building|FloorNumber|TownOrCity|Region1|Region2|Region3|Country|PostalCode

MERGE|PersonAddress|XXTEST|XXTEST_ADDR1|2018/01/01|4712/12/31|XXTEST_PER1|HOME|300 Some street|Unit 1|||||Pasadena|Los Angeles|CA||US|91101

METADATA|PersonCitizenship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|DateFrom|DateTo|LegislationCode|CitizenshipStatus

MERGE|PersonCitizenship|XXTEST|XXTEST_CTZSHIP1|XXTEST_PER1|2018/01/01|4712/12/31|AM|A

METADATA|PersonEthnicity|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegislationCode|Ethnicity|PrimaryFlag

MERGE|PersonEthnicity|XXTEST|XXTEST_ETHNIC1|XXTEST_PER1|US|1|Y

METADATA|PersonLegislativeData|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|LegislationCode|MaritalStatus|MaritalStatusDate|Sex

MERGE|PersonLegislativeData|XXTEST|XXTEST_LEG1|2018/01/01|4712/12/31|XXTEST_PER1|US|M|1998/05/12|M

METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|DateStart|EnterpriseSeniorityDate|LegalEmployerSeniorityDate|ActualTerminationDate|Comments|LastWorkingDate|NotifiedTerminationDate|PrimaryFlag|ProjectedTerminationDate|RehireAuthorizerPersonId|RehireAuthorizor|RehireReason|WorkerNumber|WorkerType|OnMilitaryServiceFlag|RehireRecommendationFlag

MERGE|WorkRelationship|XXTEST|XXTEST_PDSERVICE1|XXTEST_PER1|US1 Legal Entity|2018/01/01|||||||Y|||||XXTEST1|E|N|Y

METADATA|WorkTerms|ActionCode|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|PositionOverrideFlag|PrimaryWorkTermsFlag|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|LegalEmployerName|SystemPersonType

MERGE|WorkTerms|HIRE|XXTEST|XXTEST_WRKTERM1|2018/01/01|4712/12/31|1|Y||XXTEST_WRKTERM1|ACTIVE_PROCESS|ET|US1 Business Unit|Y|Y|XXTEST_PDSERVICE1|XXTEST_PER1|US1 Legal Entity|EMP

METADATA|Assignment|ActionCode|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|PositionOverrideFlag|PrimaryAssignmentFlag|PrimaryFlag|SystemPersonType|LegalEmployerName|JobId(SourceSystemId)|LocationId(SourceSystemId)|OrganizationId(SourceSystemId)|PositionId(SourceSystemId)|GradeId(SourceSystemId)|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|PersonTypeCode|ManagerFlag|LabourUnionMemberFlag|WorkTermsAssignmentId(SourceSystemId)|AssignmentCategory|Frequency|HourlySalariedCode|NormalHours|NoticePeriod|ProbationPeriod|ProbationUnit|ReasonCode

MERGE|Assignment|HIRE|XXTEST|XXTEST_ASSIGN1|2018/01/01|4712/12/31|1|Y|E-XXTEST1|XXTEST_ASSIGN1|ACTIVE_PROCESS|E|US1 Business Unit|Y|Y|Y|EMP|US1 Legal Entity|XXTEST_JOB1|XXTEST_LOC65XXTEST_DEPT1||XXTEST_GRADE01|XXTEST_PDSERVICE1|XXTEST_PER1|Employee|Y|N|XXTEST_WRKTERM1|FR|W|S|40|0|||NEWHIRE

Save as "Worker.dat"

Make zip file including all object's HDL File.

Load the zip file in Oracle Fusion

Navigator -> My Client Group -> Data Exchange -> Import and Load -> Import

Import the prepared zip file.

Refresh to see the status of loading.

Once Loaded successfully, you can verify the Work Structure.

You can see step by step video using this link





Monday, 11 January 2021

Oracle Cloud - Load Work Structure Components - HDL

 Load Work Structure using HCM Data Loader


In earlier blog we have seen how to define Source Keys and we have created "XXTEST".


We will use the same Source Key while loading the HCM Object in Oracle Fusion.

You can see step by step video using this link

Now we will see how to load Work Structure Components in Oracle Fusion using HCM Loader.

Work Structure Components :
  • Grade
  • Job
  • Location
  • Organization
  • Position 
Download the object template from instance.

Navigation to download :

Navigator -> My Client Group -> Data Exchange -> View Business Objects 

You can see list of all object template.

Download the template for Work Structure Objects.

We will use only required fields from that template to load the Work Structure Object.

Lets see object wise HDL File.

Grade : 

METADATA|Grade|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|SetCode|GradeCode|GradeName|ActiveStatus
MERGE|Grade|XXTEST|XXTEST_GRADE01|1951/01/01|4712/12/31|COMMON|XXTEST_GRADE01|XXTEST Grade01|A

Highlighted in Yellow are the Source Keys used to load.

Save file as "Grade.dat"

Job:

METADATA|Job|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|SetCode|JobCode|Name|ActiveStatus|RegularTemporary
MERGE|Job|XXTEST|XXTEST_JOB1|1951/01/01|4712/12/31|COMMON|XXTEST_CFO|XXTEST: Chief Financial Officer|A|R


Save file as "Job.dat"

Location :

METADATA|Location|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|SetCode|LocationCode|LocationName|Description|ActiveStatus|AddressLine1|AddressLine2|TownOrCity|Region1|Region2|PostalCode|Country
MERGE|Location|XXTEST|XXTEST_LOC5|1951/01/01|4712/12/31|COMMON|XXTEST_LOC5|XXTEST Location5|XXTEST Location6|A|250 Some st1||Pasadena|Los Angeles|CA|91101|US

Save file as "Location.dat"

Organization :

Organization has 2 components to load:
1) Organization
2) Org Unit Classification


METADATA|Organization|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|Name
MERGE|Organization|XXTEST|XXTEST_DEPT1|1951/01/01|4712/12/31|XXTEST Department1

METADATA|OrgUnitClassification|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|OrganizationId(SourceSystemId)|ClassificationCode|SetCode|Status
MERGE|OrgUnitClassification|XXTEST|XXTEST_DEPT_CLASS1|1951/01/01|4712/12/31|XXTEST_DEPT1|DEPARTMENT|COMMON|A


Save file as  "Organization.dat"

Position :

METADATA|Position|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PositionCode|Name|BusinessUnitName|ActiveStatus|JobId(SourceSystemId)|DepartmentId(SourceSystemId)|HiringStatus|PositionType|FTE|HeadCount|FullPartTime|WorkingHours|Frequency
MERGE|Position|XXTEST|XXTEST_POISITION1|1951/01/01|4712/12/31|XXTEST_POS1|XXTEST Position1|US1 Business Unit|A|XXTEST_JOB1|XXTEST_DEPT1|APPROVED|NONE|1|1|FULL_TIME|40|W

Save as "Position.dat"

Make zip file including all object's HDL File.

Load the zip file in Oracle Fusion

Navigator -> My Client Group -> Data Exchange -> Import and Load -> Import

Import the prepared zip file.

Refresh to see the status of loading.

Once Loaded successfully, you can verify the Work Structure.

You can see step by step video using this link

In Next Blog we will see how to load Worker Data in Oracle Fusion Using HCM Data Loader.






Sunday, 10 January 2021

Define Source System Owner In Oracle HCM Fusion

Define Source System Owner 

 

In this blog we will learn how to define Source Keys in oracle fusion.

Source Keys has 2 components SourceSystemOwner, SourceSytemId.

To use this Source Keys while loading the data in Oracle Fusion we need to define the Source System Owner, now we will see how to define Source System Owner.

You can see step by step video using this link.


Navigation:

Navigator -> Setup & Maintenance -> Task Panel Tab -> Click Search

It will popup Search Page.

On this page you can search for “Manage Common Lookups”.

Open the Manage Common Lookups definition page.

In Meaning field enter Source System Owner and search for the same.

In search results you can see Source System Owner Definition of lookup followed by values

In Lookup code values section you can add values.


Below are the details you need to enter:


1)    Lookup Code         – XXTEST

2)    Display Sequence   - 1

3)    Enabled                  - Checked

4)    Start Date               - 01/01/1951

5)    End Date                - 12/31/4712

6)    Meaning                - XXTEST

7)    Description            - XXTEST

     

        Click Save and close.

    In this way you can define Source System Owner.

   Now you can able to load the data using Source Keys in Oracle HCM Fusion (HDL/HCM Loader).

In next blog we will see How to Load WorkStructure in Oracle HCM Fusion.


Monday, 9 April 2018

Top 50 Fusion HCM Technical Questions - Part 1

Top 50 Fusion HCM Technical Questions

HCM Interview Questions

Top 50 Fusion HCM Technical Questions - Part 2 Click 



Q) Explain HCM Loader Keys.
-> 
1. Source Key - Originate in the object source environment. Source Key has 2 components, SourceSystemOwner,SourceSytemId. 
      E.g.METADATA|Job|JobCode|EffectiveStartDate|EffectiveEndDate|Name|SetCode|SourceSystemOwner|SourceSystemId

MERGE|Job|SE|2010/01/01|4712/12/31|Software Engineer|COMMON|EBS-UK|12349

 2. User Key - User keys are part of that object that they belong to. You can use user to create and update object
e.g.
METADATA|Job|JobCode|EffectiveStartDate|EffectiveEndDate|Name|SetCode
MERGE|Job|SE|2010/01/01|4712/12/31|Software Engineer - Java|COMMON

 3. Surrogate Id - Surrogate Id is numeric value. It is automatically generated at the time of creation of object in fusion. You can use surrogate Id to identify existing objects only. Surrogate ID is the unique numeric value for that record. (like for location it is location id , for job it is job id)
e.g.
METADATA|Job|JobId|EffectiveStartDate|EffectiveEndDate|Name
MERGE|Job|13413|2010/01/01|4712/12/31|Software Engineer - Java

4. Fusion GUID - GUID is hexadecimal value. GUID is automatically generated at the time of creation of object.
e.g.
METADATA|Job|GUID|EffectiveStartDate|EffectiveEndDate|Name
MERGE|Job|2342UJHFI2323|2010/01/01|4712/12/31|Software Engineer - Java


Q) How to change primary Work Relation Flag to Primary?
->  Click Here to see details


Q) Where you can find the HCM Loader keys?
-> hrc_integration_key_map table

Q) Can you track multiple transaction happen in single day on assignment record?
-> Yes we can track. For some objects more than one update per day is maintained by creating physical record for each one. Such object include an effective sequence number in each record to show the order in which update made multiple times in a day.

Q) How to find records error out using HCM Data Loader?
->  1) You can check the errors by clicking the message icon in import and export window.
     2) You can find in below Tables
          hrc_dl_message_lines
          hrc_dl_physical_lines
          hrc_dl_data_sets
          hrc_dl_file_rows
          hrc_dl_file_linesFusion Interview Question

     3) Using Run Diagnostics Test - Test Name  (HCM Data Loader Data-Set Status ) provide the         Content ID  for the same. This one is the oracle standard method to find error records in HCM Data loader.

Q) Common Entity used in HCM Fusion Extracts 
-> 
Person (PER_EXT_SEC_PERSON_UE)
Retrieves all persons across the enterprise and all person related attributes.
Worker Payroll (PER_EXT_PAY_EMPLOYEES_UE)
Retrieves all workers and their payrolls across the enterprise, all person, worker, payroll related attributes, and element entry data.
Extract Assignment Basic History (PER_EXT_ASSIGNMENT_BASIC_HISTORY_UE)
Retrieves assignment history as on the assignment effective start date.
Extract Assignment Basic Information (PER_EXT_SEC_ASSIGNMENT_BASIC_UE)
Retrieves assignment data as on the effective date.
Assignments Range (PER_EXT_SEC_ASSIGNMENT_RANGE_UE)
Retrieves assignment history as on the effective date.
Extract Current and Future Persons (PER_EXT_SEC_PERSON_NOW_FUTURE_UE)
Retrieves current and future person details. Specify advanced filter criteria to restrict person types.
Extract Current and Future Assignments (PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE)
Retrieves current and future assignments.

Fusion Interview Question

Q) Different type of person types in HCM Fusion?
->
Beneficiary, dependent,  retiree, APL, EMP, CWK, EX_APL, EX_CWK, EX_EMP, volunteer, etc.


Q) How you will correct termination date of Work Relationship in HCM Fusion application using HDL?
-> To correct the termination date, need to pass newActualTerminationDate and also set CorrectTerminationFlag attribute to Y.

Q) Significance of EffectiveSequenceNumber.
->  
If you are loading date effective history for an object with multiple changes in a single date, EffectiveSequencenumber will increase by 1. 
If only one change exists for an effective start date then effective sequence number must be 1. 
Do not leave EffectiveSequenceNumber blank when you are trying to load multiple changes on the same day.

Q) FBL v/s HDL
->
HDL Supports all flex field including Extensible Flex Field and People group Flex field.
Supply components data separate data files in FBL whereas you can supply data using single file in HDL.
FBL supports only GUID whereas HDL supports 4keys.
FBL supports around 21 objects and HDL supports around 90 objects. 

 Q) Can Oracle transaction Business Intelligence(OTBI) integrate with Fusion HCM extract?
->
Yes. You have two options:
1: HCM Extracts can extract the data and produce an output using CSV, XML or PDF. OTBI can then accept a data source in excel or XML format (SaaS customers will need Oracle to set this up for them).
2: BI Publisher can also accept a data source in excel or XML format (again SaaS customers will need Oracles help). HCM extracts has integration with BI Publisher.

 Q) What is the difference between the ‘Assignment Status Type’ and the ‘Extract Employee Assignment Status Type’ attributes? 
-> 

The 'Extract Employee Assignment Status Type' attribute is a DBI group which is directly associated with the user entity when defining the block. The 'Assignment Status Type' attribute is a DBI group which is associated with a different user entity, and is accessible because of contexts that have been set (indirectly derived).
Directly associated DBI groups are more efficient compared to indirect. Therefore, it would be better to use the 'Extract Employee Assignment Status Type' attribute rather than the 'Assignment Status Type' attribute because of performance considerations.

Q) Can you create a user entity? 
 -> No. 

Q) How do you schedule the HCM Extract in fusion application?
-> You can schedule the HCM extract using fast formula with 'Flow Schedule' as a type.


Q) How we can extract the changed data from last run date to till date using HCM Extracts?
-> Yes, We can extract the changes only data from last run. We need to select the option "Include changes from last successful run" at the time of defining the HCM extract.

  
Q) What are the different type/attribute for changes only parameter in HCM Extract?
-> There are 6 values for this parameter.

Step by Step Explanation of Changes Only HCM Extracts  Click 

  1. All Attribute
  2. Changed Attributes
  3. Changed and Marked Attributes
  4. Changed and Marked Attributes with previous value
  5. Changed, Marked Attributes under threading group
  6. Changed, Marked Attributes, previous data under threading group

Q) Explain Global Person Model in HCM Fusion.
->  1) Person Records are global, create only once.
      2) Person Records are independent of legal Employer
      3) Person resign from the organization then Work Relationship records are terminated.
      4) Person Record having information like Name, Date of Birth, National ID etc.

   
Q)How to create dependent parameter for BI Publisher report in HCM Fusion?
-> We will take one simple example of dependent parameter for BIP report in HCM Fusion.

   1st Parameter  - Person Id 

This is the independent parameter. We will fetch person_id from per_all_people_f
table.

Define the parameter-






Define the List of Value -




2nd Parameter - Assignment Id Based on Person Id

Define Parameter -





Define List of Value -





Use this parameters in Data Set SQL.


Q) How can you purge Future assignment record using Data Loader?
-> Yes we can purge future changes.
     SET PURGE_FUTURE_CHANGES Y
     It will purge the future changes.


Q) How you will assign multiple assignment for a single work relationship?
-> You can assign multiple assignments for single work relationship using PrimaryAssignmentFlag.
     For primary assignment, set  PrimaryAssignmentFlag to Y.

Q) Explain Global Transfer Case?
-> Transfer the Person from one legal employer to another legal employer. In this current Work Relationship record got terminated and create new one record with another legal employer as Active.

Navigation - > Person Management  -> Employment Task

Impacted Tables
per_all_assignments_m
per_periods_of_service.


Q) Significance of Key Attribute field in HCM Extract?
-> We need to configure Key Attribute which is uniquely identify each row return by the data group.
     For Changes only mode, you must select at least one attribute in the block as key attribute.
     e.g. Person id for person details

Q) Advantages of HCM Extract Vs BIP Reports ?
->
BIP Reporting Tool - It is a simple reporting tool. You can write your own SQL and get data. You should have knowledge on joins between the tables. You can use BIP reporting tool for formatted output.
HCM Extract - For the complex reporting you can use HCM Extracts. Using Extract you can derived the data from different sources or modules, you can easily use hierarchy or parent-child relationship. You Can work at a level above the BI/SQL where you don't  worry about tables,joins.
You can extract in Full Mode or schedule interface to provide you the changes only data since last successful run.

Q)How you will validate data files are correctly formatted?
-> You can use Data File Validator tool to validate the format of data files including flexfield configuration.

Q) Can I use DELETE and MERGE metadata in the same data file during data load?
-> No, you can not use DELETE metadata for an object has the MERGE metadata in data file.
Q) How to load NULL values using HDL?
 -> Use #NULL to load the null values for any attribute in MERGE metadata.

Q) How to use the Source Keys in HCM Data Load?
-> To use the Source Key in HCM Load you have to configured it in
         HRC_SOURCE_SYSTEM_OWNER lookup in system. If it is not configured then by default system will use FUSION as a source system owner.

Q) What are the output format of HCM Extracts?
-> Output Format - CSV,XML,Excel,HTML,RTF,PDF

Q) What are the different types of  HCM Extracts?
-> Full Profile , Payroll Interface, Payments, Benefit Carrier, Archive Retrieval, HR Archive, Payroll Archive.    

Q) Delivery Type in HCM Extracts?
-> Document of Record,Email, FTP, FAX, File System, HCM Connect, HTTP, Printer.
Detailed Component :-
Email            Start Date,End Date, Delivery option name, Output Type (PDF,RTF),
                      Report (Path), Output Name(Template Name), Delivery Type(Email), 
                      CC, Email, BCC,Attachment(Y), Message Body,Subject
-----------------------------------------------------------------------------------------------------------------------
FTP              Start Date,End Date, Delivery option name, Output Type (EFT),
                     Report (Path), Output Name(Template Name), Delivery Type
                     (FTP),Secure FTP(Y), Remote Directory, password, user Name, 
                     server name.
-----------------------------------------------------------------------------------------------------------------------
  

Q) Root Data Group is mandatory in HCM Extracts?
->  Yes, at least one of the data group must be declared as Root Data Group and other data groups have to be linked appropriately. 

Q) Explain threading database item in HCM Extracts?
-> Threading Database Item is required for implementing the changes only feature. It is the unique ID for that User Entity. You can declare the threading database item at root data group or child data group level where you required changes only data.

Q) How you can use BIP report in HCM Extracts?
->  You can launch BI Publisher from Report and Analytics Work Area. Install the BI Publisher plugin. You can develop RTF template in MS word using BI Publisher Plugin using Load XML Schema.
Now you have to define the report . For this use existing standard model. (/Human Capital Management/Payroll/Data Models/globalReportsDataModel). Save the report.Latest Datamodel have two parameters Payroll action id and Flow instance name. Flow instance name will be the flow pattern run given earlier when submitting the extract.

Q) How to schedule the HCM Extracts?
->  Yes, We can schedule the HCM Extract recursively like Daily, Weekly,Monthly.
     If you want to create custom schedule you need to create fast formula with type as Flow Schedule.


Q) Standard BIP Report in HCM
->  Person Enrollment Summary Report, Compensation Workbench Print Statement, Performance Document Rating Report, Total Compensation Statement report etc.

Q) How to Filter the Data in Template while developing the BIP Report?
->  You can filter the data using filter condition based on the Data Field, Operator and Value.
     You can filter the data for Chart view, table view.

Q) Different Delivery Option in BIP Report
->  Printer,Fax,Email,HTTP,FTP.
    You can define these delivery option using following navigation:
Administrator -> Manage BI -> Delivery -> Type of Delivery option 

Q) How to Schedule the BIP Report?
->  You can Schedule the report using following methods:
1) In report and analytics -> New -> Report Job
2) In Create Section -> Published Reporting -> Report Job
3) In Catalog -> Select Report -> More-> Schedule

You have to set Frequency like Once, Hourly, Daily, Weekly, Monthly, Annual, Specific Dates.

Q) How to Burst BIP report in Fusion HCM?
->  Using Bursting option you can split your Report into multiple documents and deliver it to one or more destination.
E.g. Report output having 3 columns Business Unit, Department,Location
You can split the report based on Business unit column with resp department and location for that Business unit.


Business unit
Department
Location
Progress US BU
Support PRG
Main Campus
UK BU
Support PRG UK
London
US1 BU
Finance PRG
RF Hospital
Progress US BU
Biology US
Main Campus
UK BU
Finance PRG UK
London
US1 BU
Biology US FN1
RF Hospital
UK BU
Facilities PRG UK
London
US1 BU
Facilities PRG US
RF Hospital

Split by BU
Business unit
Department
Location
Business unit
Department
Location
Progress US BU
Support PRG
Main Campus
UK BU
Support PRG UK
London
Progress US BU
Biology US
Main Campus
UK BU
Finance PRG UK
London
UK BU
Facilities PRG UK
London
Business unit
Department
Location
US1 BU
Finance PRG
RF Hospital
US1 BU
Biology US FN1
RF Hospital
US1 BU
Facilities PRG US
RF Hospital

Create Bursting Definition.
Name , Type,Data Source Name, Split by , deliver By, SQL Query.

Split By On the basis of BU
Deliver By BU

In SQL Query you have to mention Template,Output Format, Delivery Channel.

Enable the Bursting output in report properties.

Q) Can we update Source Keys?
->  Yes, We can update it using SourceKey.dat.

Q) How to change hire date of existing Worker/Employee?
->  

SET PURGE_FUTURE_CHANGES N

METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|NewStartDate
MERGE|WorkRelationship|XXTEST|XXTEST_HIREDATE1|100009|India Legal Entity|2002/02/10


For more Oracle Fusion BIP Report Questions with Answers  please click here
For more Oracle Fusion HDL Videos  please click here

How to sort data in rtf template

  How to sort data in rtf template Sort the data in Data model is the recommended approach. But if you want to sort the data in rtf template...