Showing posts with label Chandru. Show all posts
Showing posts with label Chandru. Show all posts

Monday 2 November 2015

Fusion HCM Data Loader-Seamless On-Premise to Cloud Transition

Fusion HCM Data Loader – Seamless On-Premise to Cloud Transition


HCM Data Loader (HDL) is a powerful and High Powered tool for mass-loading of data from any ERP source to Oracle Fusion HCM. We can Operate HDL as a main tool for building integration scenarios between On-Premise Third-Party Systems and Oracle HCM Cloud. So the On-Premise to Cloud Transition become much more Trouble free than ever.



What’s Hot in HDL?
Several reasons why customers would prefer choosing the Oracle Fusion HDL Tool over the other Data Loaders. 
  1. Automate the Data Load – HDL can be initiated using a web service call, which enables you to automate the data upload.
  2. Universal Data Loader - It will help us to upload Bulk load of data from any ERP source to Oracle Fusion HCM.
  3. Service Presence - HDL available in cloud, on-premises, and on-demand environments
  4. Companionable UI - Provides a comprehensive user interface for initiating data upload, monitoring progress, and reviewing errors, with real-time information provided for both the import and load stages of its processing.
  5. Consume Less Duration - Supports multithreaded processing, which enables you to upload complete system extracts without severe performance impacts. HCM Data Loader manages references among objects that are processed on separate threads.
  6.  Smart and Function Rich – For example, You can Filter and upload
    •     Current and historical records for date-effective objects. You determine the amount of history to load.
    •     End-dated, terminated, or inactive records.
    •     Hierarchical tree data, such as Organization and Department Trees.
    • Attachments and pictures.
  • 71.   Business Objects Oriented Migration - Supports important business objects belonging to key Oracle Fusion HCM products like Entity, Location, Business Unit, Job Family, Job, Department, Position, Person, Work Relationship and Profile
This figure summarizes the process of loading data using HCM Data Loader.

How HDL Works?

1. You place a zip file containing your data on the WebCenter Content server.
2. You submit a request to HCM Data Loader to import and load the zip file of data. For this step, you can use either the HCM Data Loader interface or the HCM Common Data Loader web service.
3. HCM Data Loader decompresses the zip file and imports individual data lines to its stage tables, grouping those distinct file lines into Oracle Fusion HCM business objects.
4. It calls the relevant logical object interface method (delivered in product services) to load objects to the Oracle Fusion application tables.
5. Any errors that occur during the import or load phase are reported in the HCM Data Loader interface.
6. Having reviewed import and load errors in the HCM Data Loader interface or via the Data Set Summary extract, you correct them in your source data. You load a new zip file containing the corrected data to the WebCenter Content server.


Thanks for reading Our Article on Fusion HCM Data Loader. If you want further details you can drop an email at anytime to the below Email ID.     

Authored By,

Chandru A
Kovaion Cloud Practice
Email: chandru.asokan@kovaion.com

Tuesday 12 May 2015

Peoplesoft - Drill Down PS Query

1. Introduction

How often  users run queries and write  down values returned to navigate to the appropriate page and view the underlying details of those vouchers, journals, vendors, etc?Wouldn't it be nice if  just on a click of  a hyperlink embedded within the query results ,have a page pop up in a separate browser window instead. As a solution to this,Drill down PS query can be used .

Drill down PS Query is a type of expression which returns the respective URL for the column along with the PS Query Search Results.By clicking the URL or Mapped Fields users are redirected to the respective peoplesoft page.

2. Business Benefits

Eliminates the need of noting down the value and navigating to the component manually to enter the data and open up the page for editing, resulting in a time saver

3. Types of  Drill down PS Query

  • Query URL 
  • Component URL
  • External URL     
  • Attachment URL 
  • Free Form URL

           4. Development of a  Drill Down PS Query

        A Drill Down PS Query can be developed in few simple steps:
       Step1Once the query is created, Click Expression -> Add Expression Button.


         Step2: Select the expression type as Drilling URL.


       Step3: Once Drilling URL is selected as the Expression type, types will be      highlighted.Choose anyone URL type based on the requirement.



         Step4: After all the fields were entered, click the search keys button to populate all the search keys which is in record.



       Step5: After search keys are populated, provide the respective key value. The Selection flag for the particular field name should be selected to fill their key value.These values will be used to By-pass the search key values while the component is redirected.
       


      Step6: Click the Map column button to populate all the fields from the query record.
      Select the field that needs to be mapped. While the query is executed, on clicking a mapped field the component will be redirected in a separate tab .


       
     Step7 (optional):“Use as field” hyperlink will be used to make the drilling URL expression as a new field .

<     


      Step8: Click the mapped fields or drilling URL hyperlink to redirecting the respective component in a new tab in our browser. 

<



    Author,
   Chandru Asokan
   Kovaion-Peoplesoft Consulting Practice
   Email:chandru.asokan@kovaion.com

Friday 11 July 2014

PeopleSoft HR Notification – Announcements Made Easy

HR Notification is available from PeopleSoft HCM 9.2. It is a simple and powerful communication tool,
  • It allows HR administrators to send out rich text announcements or personalized email to group of employees or a person with the support of PeopleSoft.
  • In today’s hyper connected world, having this integrated communication tool can be a game changer, as everything is shared on the go.
A small play to understand the benefits of HR Announcements,
hr_notification.png
And Jane’s Announcement goes as,
C:\Users\KOVAION\Downloads\Desktop\HR Notification PPT\9.png     C:\Users\KOVAION\Downloads\Desktop\HR Notification PPT\7.png                   
HR Notification can also be used for cases like,

  • Announcement to employees on updating personal details.
  • Request employee to utilize leave balance prior to the closure.
  • Request a recruiter to prioratize and work on a specific job opening.
  • Monthly news letter release.
The notification can be sent to a target group like a specific department, location, organizational manager level, etc


The process flow is user friendly
C:\Users\KOVAION\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png
The whole activity can be achieved pretty easily. We did the whole configuration in less than 30 mins.

Configuration of HR Notification

  1. Installation Settings
Navigation: Main Menu > Setup HCM > Common Definitions > HR Notifications > Installation Settings
C:\Users\KOVAION\Downloads\Desktop\HR Notification PPT\10.png
Check ON 'Enable HR Notifications' to enable the HR Notification functionality.
Enter the user role to limit the rights to publish announcements only to users with that user role. If no roles are selected, all users are able publish announcements.
  1. Notification Recipient Setup.
Navigation: Main Menu > Set Up HCM > Common Definitions > HR Notification > Installation Settings.
Specify the Recipient which you want to add. E.g., Company, Employee, Department.
  1. Configure and Assign Embedded Links.
Navigation: Main Menu  >  Set Up HCM  >  Common Definitions  >  HR Notification  >  Configure Embedded Link/Assign Embedded Link.
Use the Configure Embedded Link page to set up links that can be included in notifications.
Use the Assign Embedded Links page to associate embedded links to application components.
  1. Publish the Announcements.
Navigation: Main Menu  >  Set Up HCM   >  Common Def   >  HR Notification   >  HR Notification or to the application component where this feature is enabled.
Select the Delivery method as Announcement, Mail or Both.
Click Add link to attach any configured link and click Add attachments if you want to attach any file.
Click Advanced Options to change the posting Options and Recurring options.
Posting Options – Give Posting date and Expiration date if needed. User can delete this Announcement from their list if you check “User may delete this announcement” checkbox.
Recurring Options – Check Recurring Checkbox if you want to schedule the Announcement.
Click Send.
Note: Run the ‘Process Notification’ Process in order to send the Recurring pending announcements.
Navigation: Main Menu > Set Up HCM > Common Def > HR Notification > Process Notification.

How to Achieve this for any PeopleSoft Component? – How!!!

PeopleTools provides notification capabilities on every PIA page through the Notify button that appears at the bottom of the page. Clicking the button sends email notifications to the interested parties. But, this can be replaced with HR Notifications and take advantage of the additional features it offers, such as sending announcements that show on Workcenter or Dashboard pages, or sending delayed notifications.
  1. Disable Notify option in Component Level.
Make sure Notify option is disabled under internet tab.
  1. Add a Sub Page.
Add the “HCSC_ADHOC_NFY_SBP” subpage to the component page where the HR Notifications feature needs to be enabled.
The subpage must be at level 0. With that, the standard People Tools Notify button is overridden and the notification functionality is now being redirected and handled by the HR Notifications feature.
Make sure that by this time, the Enable HR Notification check box is enabled on Installation Setting Page.
  1. Some PeopleCode Tricks – Finally!!!
Declare this peoplecode in HCSC_ADHOC_NFN.HCSC_ADHOC_NFY (Component level Rec Field Change).
import HCSC_NOTIFICATION:RecipientList;
Component HCSC_NOTIFICATION:RecipientList &Recipients;
&Recipients.AdhocNotify();

Archive HR Notification Data – PeopleSoft Data Archive Manager:

Notification data can grow out of proportion over time.  To keep the amount of data manageable, the system delivers an archive object, two archive queries and an archive template that are used to archive notification data through PeopleSoft Data Archive Manager.
The HR Notification Announcements can be archived based on 

  • Posting date - All announcements posted before a certain date will be archived.
  • Expiration date - All announcements which are expired before a certain date will be archived.
How to Achieve?

Navigation: Main Menu  >  People tools  > Data Archive Manager  > Archive Data to history
Select HCSC_NOT as Archive Template and select the Process type.
Click RUN to select the process and run it.
Once the process goes to success, data is archived.

Pain Relievers:

  • Frame an announcement to a group.
  • Maintain the Security for each publish, based on the character.
  • Archive the old announcements for future.
  • Can attach the relative link to the component in the announcement.
  • Report the error on the go by attaching the screenshots, if needed.
  • Download the output of a report and attach it for further analytics.
  • Edit the announcement even if it is sent.
  • Publish the announcement on recurring basis.

Limitations:

  • HR notifications can’t be Embed and auto-populate the link for a particular transaction.
  • Customization needed, if we want to achieve it for any PeopleSoft component.
  • Can’t publish the announcement if Process Scheduler is down.
Author: Chandru Asokan (chandru.asokan@kovaion.com)