Oracle HCM Cloud 26C: Transforming Data Loading with the AI-Powered Spreadsheet Data Loader Advisor

-

 

Introduction

Data loading is a critical activity for every Oracle HCM implementation. Whether onboarding new employees, updating worker information, managing organizational changes, or performing mass data corrections, organizations rely heavily on HCM Spreadsheet Data Loader (HSDL) to efficiently process large volumes of HR data.

While HSDL has long been a powerful data management tool, users often face challenges such as selecting the correct template, mapping columns accurately, validating file structures, and troubleshooting upload errors. These tasks can be complex, especially for occasional users or organizations with numerous business objects and templates.

To simplify and modernize the data loading experience, Oracle HCM Cloud 26C introduces the AI-Powered Spreadsheet Data Loader Advisor, an intelligent assistant that guides users through the entire HSDL process using natural language interactions and automated file processing capabilities.

What is the Spreadsheet Data Loader Advisor?

The Spreadsheet Data Loader (HSDL) Advisor is an AI-powered assistant designed to streamline spreadsheet-based data loading in Oracle Fusion Cloud HCM. Instead of requiring users to manually identify business objects, select templates, map columns, and initiate loads, the advisor automates much of the process through a guided conversational experience.

Users simply upload a CSV file and allow the advisor to analyze the file structure, identify the appropriate business object, recommend available templates, prepare the file, and initiate the load process.

The advisor also serves as a knowledge assistant, providing answers to questions related to HSDL templates, documentation, setup, and configuration.

Key Features of the HSDL Advisor

CSV-Based Upload Initiation

The advisor allows users to upload CSV files directly through the AI interface and initiate HSDL processing without manually creating spreadsheet templates.

Users can optionally provide a template code, but the advisor can also determine the appropriate template automatically based on the uploaded data structure.

Automatic Business Object Identification

One of the most valuable capabilities is the advisor’s ability to analyze CSV column headers and automatically identify the associated HSDL business object.

For example, if a CSV file contains worker-related attributes such as person number, assignment information, and employment details, the advisor can recognize that the file is intended for the Worker business object.

This eliminates guesswork and reduces setup errors.

Active Template Discovery

After identifying the business object, the advisor displays all active spreadsheet templates available to the user.

Instead of searching through multiple templates manually, users receive a curated list of applicable options and can easily select the appropriate template for processing.

Cross-Platform Support

Historically, spreadsheet uploads often depended on Oracle Desktop Integration, which primarily supported Windows environments.

The HSDL Advisor removes this dependency by supporting direct CSV uploads through the browser.

This enhancement allows users working on:

  • macOS
  • Linux
  • Windows
  • Virtual environments

to perform spreadsheet data loads without requiring desktop integration tools.

Intelligent Column Mapping and Validation

One of the most common causes of data load failures is incorrect column mapping.

The advisor automatically:

  • Analyzes uploaded CSV headers
  • Validates template structures
  • Maps source columns to target template fields
  • Reorganizes data as required

By automating these activities, the advisor significantly reduces formatting errors and load failures.

Automated File Preparation and Processing

Once validation is complete, the advisor:

  • Generates the required HSDL file format
  • Uploads the transformed file to Oracle WebCenter
  • Initiates the Spreadsheet Data Loader process automatically

Users no longer need to manually prepare spreadsheets or navigate multiple pages to complete the upload.

Real-Time Load Monitoring

After processing begins, the advisor provides a direct link to the Recent Spreadsheet Loads page.

Users can monitor:

  • Load progress
  • Validation status
  • Processing results
  • Error messages

This provides complete visibility into the upload lifecycle from a single guided experience.

Conversational Documentation Assistance

Beyond file processing, the HSDL Advisor functions as an intelligent support assistant.

Users can ask questions such as:

  • How do I install the HSDL extension?
  • Which template should I use for loading new hires?
  • What active templates are available for the Worker business object?
  • How do I configure HSDL templates?

The advisor responds with contextual guidance, reducing dependency on documentation searches and support requests.

Business Benefits

Simplified User Experience

The advisor removes much of the technical complexity traditionally associated with spreadsheet data loading.

Even occasional users can confidently initiate and manage data loads.

Faster Data Processing

Automated business object identification, template selection, and file preparation significantly reduce the time required to process data.

Reduced Upload Errors

By validating templates and automatically mapping columns, the advisor minimizes common formatting and configuration mistakes.

Improved Accessibility

Browser-based CSV uploads eliminate dependency on Windows-only desktop tools, making HSDL accessible across multiple operating systems.

Increased Productivity

HR administrators and data management teams spend less time troubleshooting uploads and more time focusing on business-critical activities.

Enabling the HSDL Advisor

Organizations must complete several configuration steps before using the advisor.

Step 1: Prepare Agent Documents

Run the following scheduled processes:

  1. Prepare the HCM Spreadsheet Data Loader AI Agent
  2. Process Agent Documents

These processes prepare and index the supporting documentation used by the advisor for knowledge-based interactions.

Step 2: Enable Required Profile Options

Administrators must enable the following profile values:

  • ORA_PER_GUIDED_JOURNEYS_ENABLED
  • ORA_PER_GUIDED_JOURNEYS_SETUP_REDWOOD_ENABLED
  • ORA_ASE_SAS_INTEGRATION_ENABLED
  • ORA_HCM_VBCS_PWA_ENABLED

These profiles activate Guided Journeys, Redwood integration, AI services, and Visual Builder Studio capabilities required by the advisor.

Step 3: Configure the AI Advisor Guided Journey

Create a Guided Journey and configure the following settings:

Task Name
HCM Spreadsheet Data Loader AI Agent

Task Description
Upload CSV files and initiate HSDL

Task Type
Agent

Agent Type
Workflow Agent

Workflow Agent
HCM Spreadsheet Data Loader Advisor

After configuration, record the generated Guided Journey Code and Guided Journey Task Code for Visual Builder Studio configuration.

Step 4: Configure Visual Builder Studio

Navigate to the Run Spreadsheet Data Loader page and open the page in Visual Builder Studio.

Configure the following page properties:

  • guidedJourneyCode
  • guidedJourneyTaskCodes

Preview the configuration, validate advisor interactions, and publish the page according to your organization's deployment process.

Practical Use Case

Imagine an HR administrator needs to load 500 new employee records.

Traditionally, the administrator would:

  • Identify the Worker business object
  • Locate the correct spreadsheet template
  • Download and populate the spreadsheet
  • Validate formatting requirements
  • Upload the file
  • Monitor processing manually

With the HSDL Advisor, the administrator simply uploads a CSV file containing employee information.

The advisor automatically:

  • Identifies the Worker business object
  • Displays available Worker templates
  • Maps columns
  • Validates data
  • Prepares the file
  • Initiates the load

The administrator can then monitor progress directly from the advisor-provided link.

What previously required multiple manual steps is transformed into a guided, intelligent workflow.

Conclusion

The AI-Powered Spreadsheet Data Loader Advisor represents a major advancement in Oracle HCM's data loading capabilities. By combining artificial intelligence, automated template discovery, intelligent mapping, validation, and conversational guidance, Oracle significantly simplifies the spreadsheet data loading experience.

For organizations that regularly perform mass data uploads, the HSDL Advisor offers a faster, more accurate, and user-friendly approach to data management. As Oracle continues to embed AI across Fusion Applications, this enhancement demonstrates how intelligent assistants can improve efficiency, reduce errors, and make complex administrative processes accessible to a broader range of users.







Comments

Post a Comment

Popular posts from this blog

Oracle Fusion HCM - Enhancements to Summary of Changes and History Sections in Redwood Workforce Structures Pages

-
Image
 The  Summary of Changes  and  History  sections on Redwood  Workforce Structures  pages now display  additional attributes , providing a more detailed view of historical and recent changes to your workforce data. These enhancements apply to the following Redwood pages: Redwood Page New Attributes in Summary of Changes and History Sections Departments Status Divisions Status Disability Organizations Status Enterprise HCM Information Status Jobs Annual Working Duration Scheduling Group Standard Annual Working Duration Standard Working Hours Standard Working Frequency Locations Annual Working Duration Standard Annual Working Duration Standard Working Hours Standard Working Frequency Reporting Establishments Status Worker Unions Status These additional attributes are now visible in both the  Summary of Changes  and  History  sections, enabling users to quickly access and review key data points related to structural and job-related...
Read more

Query to get Salary Change details in Fusion HCM

-
 SELECT papf.person_number PERSON_NUMBER, (select full_name from per_person_names_f ppnf where ppnf.person_id = papf.person_id and name_type = 'GLOBAL' and trunc(sysdate) between ppnf.effective_start_date and ppnf.effective_end_date) person_name, ple.name LEGAL_EMPLOYE, (CASE  when cs.SALARY_BASIS_CODE = 'ANNUAL' THEN 'Salary Change'  else  'Hourly Rate Change' end)  ACTION_NAME, to_char(cs_old.salary_amount) OLD_DATA,  to_char(CS.salary_amount) NEW_DATA    ,TO_CHAR(cs.date_from, 'MM/DD/YYYY') EFFECTIVE_DATE    ,  TO_CHAR(cs.creation_date, 'MM/DD/YYYY') CHANGED_DATE    , cs.LAST_UPDATED_BY CHANGED_BY           from  fusion.CMP_SALARY cs,           CMP_SALARY cs_old,   PER_ALL_ASSIGNMENTS_M  PAAM,   PER_ALL_PEOPLE_F PAPF   ,per_legal_employers ple          where 1 = 1    AND PAPF.PERSON_ID = P...
Read more

🤖 Benefits Analyst: Oracle’s AI Assistant for Employee Benefits Clarity

-
Managing employee benefits shouldn't be complicated—and with Oracle’s  Benefits Analyst AI Agent , it no longer is. Built on Oracle’s robust  AI Agent framework , this intelligent digital assistant is redefining how employees interact with their benefits data. Whether it's health coverage, dental plans, or retirement options, the Benefits Analyst empowers employees to  instantly access, understand, and act on their benefits information —all through a secure, conversational interface. 🌟 What is the Benefits Analyst? The  Benefits Analyst  is an AI-powered digital assistant that helps employees: 💡 Understand what benefits they’re enrolled in 🔍 Get policy details and provider contact information 🧾 Access enrollment status, coverage tiers, and dependents ✅ Find accurate, up-to-date info without contacting HR or navigating multiple systems And it all happens through  natural language interactions —just ask, and get what you need. 🛠️ Key Features ⚡ Instant A...
Read more