Follow Shivmohan Purohit's Oracle ERP blog on Feedspot

Continue with Google
Continue with Facebook


Oracle cloud is a cloud computing service which is provisioned on demand over the internet. Oracle Cloud provides Infrastructure as a Service (IaaS), Platform as a Service(PaaS), Software as a Service (SaaS), and Data as a Service (DaaS).

These services which are provided are used to build, deploy, integrate, and extend applications in the cloud. Oracle cloud helps business to get started, expand and grow tremendously.

Companies using Oracle Cloud can innovative faster, lower cost, increase productivity and efficiency which includes the security aspect as well.

The main Advantages of using Oracle Cloud are:

  • 24 X 7 Availability

Oracle’s complete cloud application suite allows businesses of all sizes to connect their companywide operations anytime, anywhere, and from any device. The customers and the provider both can access it from any specific place and make the most out of it.

  • Lower costs

Oracle Cloud gets you more than subscription pricing, it also provides increased business flexibility, and hardware cost savings, greater efficiencies in the short and long term. You can migrate your ERP and other software as well without facing any downtime, system upgrades or software issues.

  • Support

Oracle’s enterprise application support all types of cloud scenarios, allowing customers to connect to other cloud services and integrate with existing systems.

  • Emerging Technologies for Business

Oracle is developing day by day. Capabilities in AI, machine learning, augmented reality, block chain, IoT, and human interface technologies, all of which are designed to let customers take advantage of the latest technology advances and develop their own innovative products and services.

  • Innovative Agility

Oracle cloud provides development capabilities, hardware, scalable infrastructure and software options that support your business to create and utilize the agile innovation you need to keep your company competitive for years to come.

If you want to boost your business and looking for the best Oracle consultant that can manage your workload migration to IaaS to ensure cost savings, time savings, and increased efficiency and agility—without having to re-architect your solutions—your search is over.

Take advantages of oracle cloud benefits immediately by visiting our website – cltcs.com Contact us today for more information – 7028476376

  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

It has been 10+ year , I started KnowOracle Blog. a long journey and lot of things changed from 11i to R12 to Cloud and more …..

Now thinking to bring up new energy and new flavor on KnowOracle. Like to make a team of technology and ERP enthusiasts , who can use KnowOracle platform to share their knowledge and skills.

Like you to join KnowOracle team if you are interested and having following 1. Willingness to share your knowledge using blog/ Video/ Articles/ Documents

2. Available to join or conduct online webinar – 1 Each Quarter ( I will help you )

3. Like to explore and research on new topics and solve Queries from different professionals in your area.

Please fill your information and i will get in touch with you. https://goo.gl/forms/vl3Fq59hP1aqDV2C3

Thanks – Shivmohan Purohit

  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Oracle HCM Fusion Cloud course that teaches your Hire to Retire busines process, how to configure Workforce deployment, Workforce development and Compensation modules in Oracle cloud HCM.

For a limited time, avail 90% discount on the Oracle Fusion HCM Training on Udemy.

Get this $94.99 course for only $14.99 – Special Discount for KnowOracle visitors.

Click Here to get the discounted price. This price is available to limited users, for a limited time.

  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Oracle ERP – KnowOracle Facebook Group
Facebook Group · 1,101 members

Join Group
KnowOracle – Group for Professional working in Oracle ERP.   Join to Learn Oracle Cloud ERP , EBS — Functional & Technical , Interview Questions, How-to ,  Certification help,  Training videos ,  Day-2-day topics.

Link here – https://www.facebook.com/groups/KnowOracle/

  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Facebook Group · 1,101 members

Join Group
KnowOracle – Group for Professional working in Oracle ERP.   Join to Learn Oracle Cloud ERP , EBS — Functional & Technical , Interview Questions, How-to ,  Certification help,  Training videos ,  Day-2-day topics.
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 ?


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 secanrio we can assusem 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.

Other interview questions will follow in next article ..    thanks..

  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 


Oracle Fusion HCM online training

  • Fusion Global HR
    • Fusion Payroll
    • Fusion Absence Management
    • Workflows, approvals and Notifications
    • Fusion Talent Management
    1. Profile Management
    2. Goal Management
    3. Career Development
    4. Performance Management
    5. Succession ,Talent Pools and Talent Review
  • fusion compensation management
  • fusion hcm benefits
  • fusion time and labor 

In detail……as under…

Oracle Cloud Global HR

  • Oracle Fusion Applications Overview
  • Oracle Fusion HCM Overview
  • Oracle Fusion Deployment Options
  • Oracle’s Cloud Architecture

Introducing Oracle Fusion Setup Manager

  • Application Implementation Lifecycle
  • Planning an Implementation
  • Configuring Offerings
  • Generating Setup Task Lists
  • Assigning Tasks to Users
  • Maintaining Setup Data: Using Implementation Projects

Define Geographies

  • Geography Model
  • Geography Structure
  • File-Based Import Process

Define Enterprise Structures

  • Establishing Enterprise Structures
  • Manage Enterprise
  • Creating Legal Entities
  • Creating Business Units
  • Establishing Job and Position Structures
  • Review and Load Configuration
  • Define Enterprise HCM Information
  • Define Legal Entities for HCM

Define Workforce Structures

  • Employment Model
  • Actions and Reasons
  • Defining Locations
  • Defining Organizations

Define Grades, Jobs, and Positions

  • Define Grades, Rates, and Ladders
  • Define Jobs, Job Families, and Positions
  • Define Flexfields

Manage Workforce Lifecycle

  • Add Person
  • Manage Employment Information
  • Transfer, Promote, and Terminate Workers

Maintain Worker Directories

  • Person Gallery and Portrait
  • Managing Gallery Portrait
  • Defining Worker Directory

Define Workforce Profiles

  • Configure Talent Profile Settings
  • Set Up Talent Profile Content
  • Set Up Talent Profiles

Define Security for HCM

  • Role-Based Access Control
  • Data Security
  • Users and Role Provisioning

Define Approval Management for HCM

  • Manage Approval Rules and Notifications
  • Creating an Approval Policy
  • Oracle BPM Worklist

Define Workforce Records

  • Defining Availability
  • Defining Person Record Values
  • Defining Employment Record Values
  • Defining Documents

Define Checklists and Workforce Predictions

  • Checklist Components
  • Predictive Models

Oracle Cloud Global Payroll


  • Implementing Global Payroll
  • Payroll Data Loading: Overview

Payroll Task Lists

  • Prerequisite Tasks for Payroll Setup
  • Payroll Setup Tasks for Financial
  • Payroll Setup Tasks for Banks and Cash Management
  • Define Payroll
  • Define Earning and Deduction Definitions

Payroll Product Usage

  • Payroll Product Usage
  • Setting Payroll Product Usage

Profile Options

  • Payroll Employment Hierarchy Profile Option
  • Viewing and Editing Profile Option Values

Pay Frequency

  • Pay Frequency Components
  • Consolidation Group Usage
  • Payroll Definitions
  • Managing Payroll Definitions
  • Creating Payroll Definitions
  • Using Time Definitions for Severance Pay
  • Restricting Payroll Processing
  • Object Groups

User-Defined Tables

  • Creating a User-Defined Table for Matched Row Values
  • Creating a User-Defined Table for a Range of Row Values
  • User Table Validation Formula Type

Fast Formulas

  • Using Formulas
  • Writing a Fast Formula Using Formula Text
  • Writing a Fast Formula Using Expression Editor
  • Formula Compilation Errors

Balance Definitions

  • Payroll Balance Definitions
  • Balance Dimensions
  • Balance Feeds
  • Balances in Net-to-Gross Calculations
  • Balance Exceptions
  • Creating a Balance Exception Report


  • Element Classifications
  • Elements
  • Element Eligibility

Earnings and Absence Elements

  • Creating Earnings Elements for Payroll
  • Creating Payroll Elements for Absence Management
  • Creating Elements for Time Card Entries
  • Net-to-Gross Earnings
  • Creating a Net-to-Gross Earnings Element


  • Creating Voluntary and Pre-statutory Deductions
  • Creating Elements for Pension Deductions
  • Entering Calculation Values for Pensions
  • Adding Involuntary Deductions to a Calculation Card
  • Fee and Proration Rules for Involuntary Deductions
  • Involuntary Deduction Processing

Proration and Retroactive Pay

  • Payroll Event Groups
  • Setting Up Element Proration
  • Prorated Earnings and Deductions
  • Creating a Proration Formula
  • Retroactive Pay
  • Adding a Retroactive Event Manually

Calculation Information

  • Payroll Calculation Information
  • Payroll Calculation Information at the Legislative Level
  • Calculation Cards
  • Calculation Value Definitions
  • Wage Basis Rules
  • Calculation Factors

Rate Definitions

  • Rate Definitions
  • Creating Rate Definitions
  • Using the Rate Calculation Formula

Payment Methods

  • Bank, Branch, and Account Components
  • Creating Account
  • Entering Bank Information for Personal Payment Methods
  • Organization Payment Methods
  • Payment Methods and Payroll Definitions
  • Setting Up Payment Sources in Organization Payment Methods
  • Third-Party Payment Methods

Payroll Costing

  • Payroll Cost Allocation Key Flexfield Setup
  • Cost Hierarchy
  • Setting Up the Cost Allocation Key Flexfield
  • Payroll Costing Components
  • Payroll Setup Tasks for Sub ledger Accounting
  • Payroll Setup Tasks for Costing Accounts
  • Payroll Setup Tasks for Transferring Costs to General Ledger
  • Payroll Costing of Elements
  • Payroll Cost Results
  • Cost Allocation
  • Costing for a Person
  • Distributed Costing

Payroll Flow Patterns

  • Creating Payroll Flow Patterns
  • Payroll Flow Pattern Parameters
  • Payroll Flow Pattern Tasks Start and Due Dates
  • Managing Corrective Tasks in a Payroll Flow Pattern
  • Payroll Flow Checklist and Flow Tasks
  • Creating a Payroll Flow Pattern to Reissue a Check
  • Editing Payroll Flow Patterns
  • Editing Payroll Flow Patterns
  • Editing a Payroll Flow Pattern

Payroll Process Configuration

  • Payroll Process Configuration Groups
  • Payroll Process Configuration Group Parameters
  • Payroll Logging Parameters
  • Parallel Processing Parameters

Security Profiles

  • Creating Payroll Security Profiles
  • Payroll Flow Security and Flow Owners
  • Creating Payroll Flow Security Profiles

Oracle Cloud Absence Management


  • Implementing Absence Management
  • Absence Management Components
  • Worker Availability

Lookups, Value Sets, and Flexfields

  • Lookups
  • Flexfields and Value Sets
  • Flexfields


  • Using Formulas
  • Formulas for Absence Type Rules
  • Formulas for Accrual Plan Rules
  • Formulas for Qualification Plan Rules
  • Writing a Fast Formula Using Formula Text
  • Formula Performance Improvements
  • Formula Compilation Errors
  • Formula Execution Errors

Eligibility Profiles

  • Eligibility Components
  • Derived Factors
  • Derived Factors
  • Range of Scheduled Hours
  • Eligibility Profiles
  • Eligibility Profiles
  • Combining Eligibility Criteria or Creating Separate Profiles
  • Creating an Eligibility Profile

Rate Definitions

  • Rate Definitions
  • Creating Rate Definitions


  • Define Elements, Balances, and Formulas
  • Elements: How They Work in Salary, Absence, Benefits, and Payroll

Date Effectivity

  • Date-Effective Objects in Absence Management
  • Date Effectivity
  • Correcting Date-Effective Objects
  • Updating Date-Effective Objects

Absence Plans

  • Absence Plan Types
  • Accrual Absence Plans
  • Qualification Absence Plans

Absence Types, Reasons, and Categories

  • Absence Management Components
  • Absence Display and Processing Rules
  • Absence Start Date Validation Rule
  • Absence Late Notification Assessment Rule
  • Associating Concurrent Absence Plans with an Absence Type
  • Prioritizing Absence Plans for an Absence Type
  • Creating an Absence Type for Scheduling Vacation Time

Oracle Cloud Talent Management

Implementing Goal Management

  • Overview and Integrations
  • Define Worker Goal Setting
  • Social Networking with Goals
  • Using Development Goals in Talent Pools
  • Goals: How They Work with Profiles

Descriptive Flexfields

  • Descriptive Flexfields for Oracle Fusion Goal Management

Profile Options

  • Oracle Fusion Goal Management Profile Options


  • Oracle Fusion Goal Management Lookups

Date Format for Goals

  • Changing the Date Format Used for Goals

Goal Management Integrity Validations

  • Oracle Fusion Goal Management Data Diagnostic Test

Spreadsheets for Uploading Goals

  • Uploading and Updating Worker Goals Using a Spreadsheet
  • Using the Worker Goals Update Worksheet
  • Uploading and Assigning Organization Goals Using a Spreadsheet
  • Using the Organization Goal Assignment Worksheet
  • Using the Organization Goals Upload Worksheet

Mass Assignment of Goals

  • Mass Assignment of Goals
  • Creating a Request for Mass Assignment of Goals

Eligibility Profiles

  • Using Eligibility Profiles for Goals Assignment

Goal Plans

  • Creating Goal Plans
  • Adding and Removing Goals in a Goal Plan

Implementing Performance Management

  • Overview and Integrations
  • Define Worker Performance
  • Performance Document Component
  • Performance Documents- Profiles and Goals


  • Questionnaire Templates
  • Questionnaire Question and Response Types
  • Creating a Questionnaire
  • Using Questionnaires in Performance Documents

Descriptive Flexfields

  • Descriptive Flexfields for Oracle Fusion Performance Management

Performance Roles

  • Performance Roles
  • Participant Feedback

Matrix Management

  • Using Matrix Management with Performance Evaluations
  • Configuring Matrix Management for Performance Documents

Eligibility Profiles

  • Using Eligibility Profiles with Performance Documents
  • Using Eligibility Profiles with Performance Documents
  • Eligibility Profiles and Performance Analytics

Eligibility Batch Process

  • Performance Document Eligibility Batch Process

Performance Process Flows

  • Performance Process Flow Setup
  • Performance Process Flows
  • Concurrent Worker Evaluation Tasks
  • Participant Feedback Task Options
  • Configuring Performance Documents to Display Performance Ratings to Workers
  • Performance Document Completion Status
  • Performance Document Approvals

Performance Template Sections

  • Performance Template Section: Critical Choices
  • Performance Template Section Calculation Rules
  • Item Processing in a Performance Template Section

Performance Ratings Using the Average Method

  • Performance Ratings Using the Sum and Band Methods
  • Writing Assistant
  • Uploading Writing Assistant Data Using a Spreadsheet
  • Setting Up Writing Assistant for Performance Documents
  • Creating a Profile Content Performance Template Section
  • Creating a Goals Performance Template Section

Performance Templates

  • Setting Up the Performance Template
  • Defining Processing Roles for Performance Template Sections
  • Calculated Ratings
  • Setting Up Calculated Ratings in a Performance Template
  • Associating Eligibility Profiles with Performance Templates

Data loader like HDL. FBL..SPREADSHEED LOADER,  personalization …..data extract..many more…

  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

ERP Technology Trends – Now & Future
for more updates, & Topics https://www.facebook.com/groups/KnowOracle/


Technology Trends in Oracle ERP – Now & Future

Topics : What’s new in ERP Technology
Impact of new technology on projects, business and on career
How to prepare yourself for future.
Date : 16 Aug , Thursday , Time 7 PM India, 9.30 US EST
How to join – will update more details soon.
Submit your queries/ question before hand to take them during Webinar.

  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Oracle ERP - Webinar - Current & Future Trends - Business Factors & Project Execution - YouTube

Youtube URL – https://youtu.be/PKqEkfpkMqw

Here is recording from our Webinar – on Oracle ERP – Trends in business factors and project execution. Do share with your friends and subscribe KnowOracle youtube channel and Facebook group to get updates on upcoming webinars and interaction.

  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

KnowOracle ( Online Learning & Sharing community on Oracle ERP ) along with Oracle ERP Experts’ from different domains and regions coming together to present their perspective on current and future trends on Oracle ERP’s technology shift, business factors, consulting approach and career guidance.

Expected Audience : professional transitioning or about to transition to cloud erp

Dial-in number (US): (641) 715-3580
India+91 172 519 9056
Access code: 230-868-884
International dial-in numbers: https://fccdl.in/i/230-868-884
Online meeting ID: 230-868-884
Join the online meeting: https://join.freeconferencecall.com/230-868-884
For 24/7 Customer Care, call (844) 844-1322

Submit your Questions / Queries here :
Try to join 5-10 minute earlier to avoid any technical or connectivity issues :
Moderator : Shivmohan Purohit / email – shivmohan.purohit@gmail.com / phone-whatsapp +91 70284 76376

Expert Panet memebers’ name and detail will be posted soon

Read for later

Articles marked as Favorite are saved for later viewing.
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview