Skip to content
DigitalEHub

DigitalEHub

Oracle Techno Functional Portal, Technical and Functional Resource

  • Home
  • ERP Implementation/Support
  • Technical Resource
  • Functional Resource
  • Trainings
  • Courses
  • Jobs
  • Tips & Tricks
  • Contact

Find Oracle Event Near You

Posted on October 19, 2015October 19, 2015 by Administrator

Click Here  

Continue reading
Others

Oracle Fusion Document of Records DOR

Posted on January 26, 2025January 27, 2025 by Administrator

Step by Step Guide for Document of Record. We are going to cover following topic in post. Create Document of

Continue reading
Oracle Fusion
Leave a comment

Important Documentations for Oracle Fusion

Posted on September 10, 2024September 10, 2024 by Administrator

HCM Data Loading Business Objects:

Continue reading
Important Documentation Links
Leave a comment

How to Create user and Assign Roles in Oracle Fusion and Post user creation steps.

Posted on August 7, 2024August 7, 2024 by Administrator

2) Click on Users and then “Add User Account”. 3) Select Associated Person type and fill user information. Then Press

Continue reading
Oracle Fusion
Leave a comment

Oracle Cloud Support and Help Resources

Posted on December 6, 2023December 6, 2023 by Administrator

https://docs.oracle.com/ (Free Support). 2) https://support.oracle.com/portal/ (Does required Login, not everyone can login here)

Continue reading
Oracle Fusion
Leave a comment

Oracle Fusion Error message Legal Entity doesn’t exit (PER-1531116)

Posted on November 30, 2023November 30, 2023 by Administrator

If you are getting error message while updating The legal entity doesn’t exist. (PER-1531116) while updating legal entity Information. Solution:

Continue reading
Error Messages in Oracle Fusion, Oracle Fusion
Leave a comment

How to create Alerts or send Auto Email or Notification from Oracle Fusion.

Posted on November 22, 2023 by Administrator

Q: How to create auto Alerts from Oracle fusion. Q: How to send auto Email from Oracle. Ans: Navigate to

Continue reading
Configuring and Administrating Approval Transactions, Oracle Fusion, Uncategorized
Leave a comment

How to Edit Notification in Oracle Fusion.

Posted on November 20, 2023November 20, 2023 by Administrator

Q: How to Edit standard Notifications in Oracle Fusion. Q: How to more lines or Edit contents of any notification.

Continue reading
Configuring and Administrating Approval Transactions, Oracle Fusion, Uncategorized
Leave a comment

Enabling vacation rules and delegating approval responsibilities in Oracle Fusion.

Posted on November 15, 2023November 15, 2023 by Administrator

Q: How set Vacation Rule in Oracle While going on vacation. Q: How can I assign my approval responsibility to

Continue reading
Configuring and Administrating Approval Transactions
Leave a comment

How to Create and Assign an Approval Group in Oracle Fusion to any Transaction Type.

Posted on November 14, 2023November 14, 2023 by Administrator

Navigate to Application Extensions in Setup & Maintenance >> Compensation Management >> Application Extensions >> Manage Approval Groups and Keep

Continue reading
Configuring and Administrating Approval Transactions
Leave a comment

How to setup test approval rules feature on the approval rules page

Posted on November 14, 2023November 14, 2023 by Administrator

How to setup test approval rules feature on the approval rules page. How create Test Approval Rules Enabled Profile Option

Continue reading
Configuring and Administrating Approval Transactions, Oracle Fusion
Leave a comment

Password Policy in Oracle Fusion. How to change Password expiry Days or Complexity parameters?

Posted on September 14, 2023September 14, 2023 by Administrator

Oracle Password policy settings. Oracle Fusion provides a variety of password policy settings that can be configured to meet the

Continue reading
Oracle Fusion
Leave a comment

Oracle Fusion Journeys

Posted on September 14, 2023September 14, 2023 by Administrator

Journeys are the new name for checklists in the Oracle application. They have the same features as checklists, plus some

Continue reading
Oracle Fusion
Leave a comment

Document Types, Adding Document Types, Attaching Document to Employee in Oracle Fusion. Mass Download Document Types in Oracle Fusion.

Posted on September 11, 2023September 11, 2023 by Administrator

Navigate to Setup and Maintenance. Then Workforce Deployment. Search Tasks Document Types Select Create or Duplicate Button to create new

Continue reading
Oracle Fusion
Leave a comment

How to Change Password of any User in Oracle Fusion.

Posted on August 28, 2023August 28, 2023 by Administrator

Navigate to Fusion Navigator. 2) Click on Tools >> Security Console. 3) Click on Users and End User Name initial

Continue reading
Oracle Fusion
Leave a comment

Import English and Arabic data from Excel to MySQL Database table.

Posted on August 3, 2023August 3, 2023 by Administrator

If you are facing issue while importing Arabic data from excel to MYSQL database, Use following procedure. Hope it will

Continue reading
Others
Leave a comment

Oracle Fusion, how to create and manage Position in Oracle Fusion:

Posted on July 23, 2023July 23, 2023 by Administrator

Q: Position Profile Setting. Q: Position Synchronization. Position is an instance of a job in a specific business unit and

Continue reading
Oracle Fusion, Uncategorized
Leave a comment

How to define Grade Rates in Oracle Fusion.

Posted on July 13, 2023July 13, 2023 by Administrator

In this post i am going to explain how to create Grade Rates in Oracle Fusion. A rate is a

Continue reading
Oracle Fusion
Leave a comment

Oracle Fusion, How to set Profile Value

Posted on July 13, 2023July 13, 2023 by Administrator

Q: How to set Profile Option in Oracle Fusion? Q: How to set PER_ENFORCE_VALID_GRADES in Oracle Fusion. Q: How can

Continue reading
Oracle Fusion
Leave a comment

Oracle SSHR How to know and delete/disable Hidden Personalization

Posted on May 1, 2023May 1, 2023 by Administrator

Q: How to take backup of OAQ pages personalization backup up. Q: How to restore personalization which delete or disabled

Continue reading
OAF Personalization, Oracle Framework Personalization
Leave a comment

Changing From and To Name Order in Oracle EBS Purchase Requisition Approval Notification

Posted on March 21, 2023March 21, 2023 by Administrator

Q: How to change Name Order in Oracle EBS Approval Notification in From and to names. Q: How to change

Continue reading
Oracle HRMS / Payroll Setup, Oracle HRMS Technical, Oracle Self-Service Human Resources
Leave a comment

How to make a Line Chart in Excel ?

Posted on March 7, 2023March 7, 2023 by Administrator

Following are some steps to make a line chart in excel. Use can also use this method to make some

Continue reading
Uncategorized
Leave a comment

How to make a Pie Chart in Ms excel ?

Posted on March 6, 2023March 6, 2023 by Administrator

Pie charts are often used in business. Examples include showing percentages of types of customers, percentage of revenue from different products,

Continue reading
Tips & Tricks
Leave a comment

How to automatically append an email signature to every email you send ?

Posted on March 2, 2023March 5, 2023 by Administrator

Email signatures present a fantastic opportunity to promote your website or social media profiles, and also serve as a way

Continue reading
Tips & Tricks
Leave a comment

How to apply Conditional Formatting in Excel ? Part-2!

Posted on February 24, 2023February 24, 2023 by Administrator

Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify.They are grouped into three

Continue reading
Tips & Tricks
Leave a comment

How to apply Conditional Formatting in Excel ?

Posted on February 24, 2023February 24, 2023 by Administrator

Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. It saves our time.

Continue reading
Tips & Tricks
Leave a comment

How to Split/Separate Text in Ms-Excel ?

Posted on February 17, 2023February 17, 2023 by Administrator

Take text in one or more cells and split it into multiple cells using the Convert Text to Columns Wizard.

Continue reading
Tips & Tricks
Leave a comment

How to sort data in Ms Excel ?

Posted on February 16, 2023February 16, 2023 by Administrator

Select the column you want to sort. Then go to Sort & Filter and select the options. You sort data to

Continue reading
Tips & Tricks
Leave a comment

How to Circle Invalid data in Excel ?

Posted on February 15, 2023February 15, 2023 by Administrator

Excel displays a red circle around any cells that contain invalid data. All cells that don’t meet their data validation criteria are

Continue reading
Tips & Tricks, Uncategorized
Leave a comment

How to get desktop notifications? whenever you get a new email.

Posted on February 12, 2023February 14, 2023 by Administrator

Want to be notified whenever you receive a new email? You can do so with Gmail desktop notifications.

Continue reading
Tips & Tricks
Leave a comment

Data Validation in Excel, How to restrict type of Data that user can enter into cells.

Posted on February 10, 2023February 11, 2023 by Administrator

Excel can restrict data entry to certain cells by using data validation, prompt users to enter valid data when a cell is

Continue reading
Tips & Tricks
Leave a comment

Confidential Emails, How to send confidential through Gmail?

Posted on February 9, 2023February 11, 2023 by Administrator

If there is some confidential and sensitive information and you don’t want to get into the wrong hands.This is where

Continue reading
Tips & Tricks
Leave a comment

How to grant someone else access to your Gmail account without revealing your Gmail password.

Posted on February 8, 2023February 8, 2023 by Administrator

It is very simple to grant Gmail access to someone else, you can do so by delegating account access.This is

Continue reading
Tips & Tricks
Leave a comment

How to drag data in Excel

Posted on February 4, 2023February 4, 2023 by Administrator

Don’t copy paste your data, you can also use drag-drop. Simply select the range where you have data and then

Continue reading
Tips & Tricks
Leave a comment

Smart Compose

Posted on February 3, 2023February 3, 2023 by Administrator

Smart compose enable predictive words and phrases to appear when we start typing an email. It also learns how we

Continue reading
Tips & Tricks
Leave a comment

Check spelling

Posted on February 1, 2023February 1, 2023 by Administrator

How to check your spellings? direct to the 3 dots at the bottom right of your email composer and then

Continue reading
Tips & Tricks
Leave a comment

Red Hat and Oracle Expand Collaboration to Bring Red Hat Enterprise Linux to Oracle Cloud Infrastructure

Posted on February 1, 2023February 1, 2023 by Administrator

Red Hat, Inc., the world’s leading provider of open source solutions, and Oracle today announced a multi-stage alliance to offer

Continue reading
News and Articals
Leave a comment

If you want to use multiple Gmail accounts at the same time

Posted on February 1, 2023February 2, 2023 by Administrator

You can log into multiple accounts at the same time: To do this, log into your first email account, and

Continue reading
Tips & Tricks
Leave a comment

Undo or Recall our sent email on Gmail

Posted on February 1, 2023February 1, 2023 by Administrator

Gmail now allowed users to recall a message sent in error up to 30 seconds after they click Send. When

Continue reading
Tips & Tricks
Leave a comment

Gmail Search Option which People not know

Posted on February 1, 2023February 1, 2023 by Administrator

Gmail has more than 20 search operators you can use to find messages or create filters. You can even combine

Continue reading
Tips & Tricks
Leave a comment

Workflow Owned By list not appearing in Administrator Workflow Responsibility.

Posted on July 24, 2022July 26, 2022 by Administrator

Q: Workflow Owned By list not appearing in Administrator Workflow Responsibility. Q: Unable to View ALL workflows from ALL users

Continue reading
Oracle Self-Service Human Resources, System Administration
Leave a comment

Do you want to pass the Oracle Exam on the first attempt

Posted on May 19, 2022May 19, 2022 by Administrator

Do you want to pass the any Oracle Exam on the first attempt? Don’t worry we’ll help you Pass the

Continue reading
Uncategorized
Leave a comment

Oracle HRMS for Saudi Arabia

Posted on April 18, 2022April 18, 2022 by Administrator

This document provides a guide to the Oracle HRMS patch 3221427, and discusses the new HRMS features delivered with the

Continue reading
Uncategorized
Leave a comment

Oracle AME, When final approver times out, keep sending him the reminder notificaiton at a specific interval, till approved

Posted on April 19, 2021 by Administrator

1. When final approver times out, keep sending him the reminder notificaiton at a specific interval, till approved. This requires

Continue reading
Oracle AME Setup
Leave a comment

Oracle Approvals Management (AME) Frequently asked Questions (FAQ)

Posted on April 19, 2021April 19, 2021 by Administrator

    PURPOSE Frequently asked Questions on AME Requirements QUESTIONS AND ANSWERS Do I need to license AME? No, AME

Continue reading
Oracle AME Setup, Oracle HRMS Technical, Oracle Self-Service Human Resources
Leave a comment

How to Change the Timeout for Oracle HRSS Workflow ?

Posted on March 28, 2021 by Administrator

HRSSA workflows timeout after Some days: How to set the Workflow Timeout for Oracle SSHR Approvals.   Solution: Set the timeout

Continue reading
Oracle Self-Service Human Resources
Leave a comment

What Is The Difference Between Delegate And Transfer Notification

Posted on March 28, 2021 by Administrator

When a user creates a Vacation Rule, he can choose between two options when selecting “Reassign”: 1. Delegate your response

Continue reading
Oracle AME Setup, Oracle Self-Service Human Resources
Leave a comment

Oracle SSHR: How to bypass the Delegation/Transfer rules for workflow notifications

Posted on March 28, 2021March 28, 2021 by Administrator

Q: How to bypass the delegation/transfer rules for workflow notifications? Q: For notification in oracle HRSSA Workflow Notifications, we need

Continue reading
Oracle Self-Service Human Resources
Leave a comment

Disable Time Out Notification Functionality

Posted on March 24, 2021 by Administrator

Oracle SSHR  AME , Oracle Workflow  All old notifications are sent to Top Approver. Our requesting how to stop it or

Continue reading
Oracle AME Setup
Leave a comment

What is Oracle APEX, Pros and Cons of Oracle Apex.

Posted on March 24, 2021 by Administrator

Oracle  (APEX) Application Express is a free low-code development platform that enables quickly develop a database-drive application, customize the application’s UI,

Continue reading
Oracle Cloud
Leave a comment

Oracle BI Publisher Tab issue in MS Word.

Posted on September 17, 2020 by Administrator

If you are facing problem in Oracle BI Publisher tab which some time disable or disappear from MS Word, You

Continue reading
Oracle XML / BI Publisher
3 comments

Fee Oracle Cloud Learning / Training

Posted on September 1, 2020September 1, 2020 by Administrator

Oracle Learning Explorer is the best way to start building your functional knowledge of Oracle’s Cloud solutions – solutions used

Continue reading
Oracle Cloud
One comment

Hiding a Table in RTF Template Oracle BI Publisher / XML publisher

Posted on June 11, 2020June 11, 2020 by Administrator

Q : How to Hide a Table based on an IF condition? Q : Can we Hide complete table in

Continue reading
Oracle XML / BI Publisher, Uncategorized
Leave a comment

Oracle R12 OAF / HTML pages LOV Personalization

Posted on June 11, 2020June 11, 2020 by Administrator

Q: How to personalize List of Value in OAF pages? Q: How to personalize Change Manager List of Value in

Continue reading
Forms Personalizations, OAF Personalization, OAFramework R12X Customization, Oracle Framework Personalization, Uncategorized
One comment

Error app-pay-07155 while terminating employee. The HR object which is attempted to be locked is inconsistent. Retry the action with the correct object version number.

Posted on October 17, 2019October 17, 2019 by Administrator

If you are facing subject error while terminating and employee. There are following two solutions for this.   Set the

Continue reading
Oracle HRMS / Payroll, Oracle HRMS Technical, Uncategorized
Leave a comment

Oracle HCM Techno Functional Interview Questions.

Posted on October 9, 2019 by Administrator

(Interview Questions for Oracle HR Payroll Job) Following are the sample interview questions which you can expect during interview for

Continue reading
Others
Leave a comment

Important General Ledger (GL) Tables.

Posted on October 3, 2019October 3, 2019 by Administrator

Important General Ledger (GL) Tables. General Ledger tables can be grossly classified into following 5 categories. Here are few important

Continue reading
Important Tables
One comment

Connect Oracle database without tnsnames.ora

Posted on October 1, 2019 by Administrator

Q: How to connect sqlplus without tnsnames.ora Q: Connect Oracle database without tnsnames.ora Q: Multiple methods to connect oracle database. Q: Connect

Continue reading
Others, System Administration, Toad Tricks and Tips
Leave a comment

Excel Shortcuts

Posted on April 15, 2019April 15, 2019 by Administrator
Continue reading
Other Apps
One comment

How to Enable Approval for SIT and EIT while submitting the transaction using Self Service HRMS.

Posted on January 29, 2019 by Administrator

Goal: How to Enable Approval for SIT and EIT while submitting the transaction using Self Service HRMS.   Bydefault when

Continue reading
Oracle Self-Service Human Resources
Leave a comment

Unable to create an entity object from R12 Jdev . why can’t choose object type under database schema when creating a new entity object(EO)

Posted on January 27, 2019January 27, 2019 by Administrator

Unable to create an entity object from R12 Jdev . why can’t choose object type under database schema when creating

Continue reading
OAFramework R12X Customization
One comment

Creating a New Vacancy Errors: The employee (or contractor) information is invalid. Please enter a value of Y or N

Posted on December 11, 2016December 25, 2016 by Administrator

This post is related to following Error while creating new Vacancy in Oracle Apps Irecruitment module. The employee information is

Continue reading
Oracle I-Recruitment
Leave a comment

Oracle OAF Personalization , Extending an existing Region into a Page

Posted on November 28, 2016December 25, 2016 by Administrator

You must create your region in such a way that you can personalize it later to appear only for your

Continue reading
Oracle Framework Personalization
Leave a comment

Oracle OAF Personalization, Adding Flexfield on OAF / HTML page

Posted on November 3, 2016December 25, 2016 by Administrator

Oracle OAF Personalization, Adding Flexfield on OAF / HTML page  In this task you want to set-up the descriptive flexfield

Continue reading
Oracle Framework Personalization
Leave a comment

Oracle Purchasing (R12) User Practice

Posted on November 2, 2016December 25, 2016 by Administrator

Practice – Create a Supplier with Two Sites Summary Your supervisor has notified you that the company will be purchasing

Continue reading
Oracle Purchasing User Practice
One comment

Oracle EBS Inventory : Define Locators, Organization & SubInventories

Posted on October 26, 2016 by Administrator

Defining Locators Responsibility: Inventory, Vision Operations USA Setting Up Stock Locators 1.    (N) Setup > Organizations > Stock Locators. 2.    Click New.

Continue reading
Oracle Inventory User Practice
Leave a comment

Oracle Apps Inventory – Build a Workday Calendar with Exceptions

Posted on October 26, 2016 by Administrator

Build a Workday Calendar with Exceptions Overview In this practice you will build a workday calendar with exceptions. Assumptions Replace

Continue reading
Oracle Inventory User Practice
Leave a comment

Oracle EBS Inventory- Defining Unit of Measure, catalog and Categories

Posted on October 26, 2016 by Administrator

Defining Units of Measure In this practice, you will: Define unit of measure classes. Define units of measure. Set up

Continue reading
Oracle Inventory User Practice
Leave a comment

Oracle Apps Inventory – Defining Cycle Count, Location and Unit of Measure

Posted on October 26, 2016 by Administrator

Cycle Count Responsibility: Inventory, Vision Operations USA 1.    (N) Counting > Cycle Counting > Cycle Counts 2.    (B) New 3.    Enter the following

Continue reading
Oracle Inventory User Practice
Leave a comment

Oracle EBS Inventory: Setting up Reorder Point Planning, Replenishment Count Using Forms

Posted on October 26, 2016 by Administrator

Setting up Reorder Point Planning Responsibility: Inventory, Vision Operations USA Setting up Reorder Point Planning for an Item 1.    Navigate to

Continue reading
Oracle Inventory User Practice
Leave a comment

Oracle Apps R12 Inventory : Min-Max Planning , Replenishment Count Using the Mobile Application

Posted on October 26, 2016 by Administrator

Performing Min-Max Planning In this lab you will perform min-max planning for an item. Assumptions You completed the define items

Continue reading
Oracle Inventory User Practice
Leave a comment

Oracle Inventory: Performing Kanban Replenishment & Manual Forecast

Posted on October 26, 2016 by Administrator

Performing Kanban Replenishment In this lab you will learn how to generate Kanban Cards. Assumptions You have completed the defining

Continue reading
Oracle Inventory User Practice
Leave a comment

Oracle Inventory : Using Material Workbench, Reservation & Status Control

Posted on October 26, 2016 by Administrator

Practice – Using the Material Workbench Distribution Oracle Inventory Job Title* Ownership The Job Title [list@YourCompany.com?Subject=LABxxxxx] is responsible for ensuring

Continue reading
Oracle Inventory User Practice
Leave a comment

Oracle Inventory: Mover Orders and Receiving Transactions

Posted on October 26, 2016 by Administrator

Guided Demonstration – Transacting Move Orders Responsibility = Inventory, Vision Operations USA Generate Move Order Instructor Note: Verify that enough

Continue reading
Oracle Inventory User Practice
Leave a comment

Oracle Inventory : Performing Mobile Transactions

Posted on October 26, 2016 by Administrator

Mobile Application Inter-organization Transfers 1.    Enter telnet esxxxx.oracle.com 7070 in the Windows Run dialog box, where xxxx is the instance number.

Continue reading
Oracle Inventory User Practice
Leave a comment

Processing Miscellaneous Receipts

Posted on October 26, 2016 by Administrator

Processing Miscellaneous Receipts Overview In this practice you will perform a miscellaneous receipt to receive the items you created in

Continue reading
Oracle Inventory User Practice
Leave a comment

Oracle Inventory – Creating Picking Rules, Accounting Period & Inventory Transfer

Posted on October 26, 2016 by Administrator

Creating Picking Rules Responsibility: Inventory, Vision Operations USA 1.    Navigate to the Inventory Picking Rules window. (N) Setup > Rules >

Continue reading
Oracle Inventory User Practice
Leave a comment

Working with Revision, Lot, and Serial Controls

Posted on October 26, 2016 by Administrator

Working with Revision, Lot, and Serial Controls Responsibility = Inventory, Vision Operations USA Create New Revisions 1.    Verify that you are

Continue reading
Oracle Inventory User Practice
Leave a comment

Oracle EBS R12 – Inventory Setting Up Organizations

Posted on October 26, 2016October 26, 2016 by Administrator

Setting Up Organizations Responsibility: Inventory, Vision Operations USA 1.    Navigate to the Organizations window. (N) > Setup > Organizations > Organizations.

Continue reading
Oracle Inventory User Practice
Leave a comment

Maintaining Grades and Lots

Posted on October 26, 2016October 26, 2016 by Administrator

Maintaining Grades   Responsibility: Inventory, Vision Operations USA 1.    Navigate to the Maintain Grades window. (N) Setup > Grades 2.    (M) File

Continue reading
Oracle Inventory User Practice
Leave a comment

Oracle R12 – How to query or view Item

Posted on October 26, 2016 by Administrator

Viewing Item Attributes Overview In this practice, you will learn how to view item attributes. Viewing Item Attributes 1.    Find item

Continue reading
Oracle Inventory User Practice
Leave a comment

Oracle R12- Define Inventory Item.

Posted on October 26, 2016October 26, 2016 by Administrator

Oracle EBS- Inventory Setup- How to create or define Item. Following post  will enable you to learn how to define

Continue reading
Oracle Inventory User Practice
Leave a comment

Approvals Management Responsibilities and Setups in AME

Posted on May 22, 2016May 22, 2016 by Administrator

Approvals Management Responsibilities and Setups in AME.B   Document Overview The purpose of this White Paper is to discuss the

Continue reading
Oracle AME Setup, Oracle HRMS / Payroll, Oracle Self-Service Human Resources
One comment

Debugging Fast Formulae – ISOLATING FORMULA FROM THE CALLING APPLICATION

Posted on March 9, 2016 by Administrator

Sometimes when debugging formulae it is convenient to isolate the formula and run it separately. It can also be useful to

Continue reading
Oracle HR Fast Formual
Leave a comment

ORACLE HRMS FOR SAUDI ARABIA

Posted on March 1, 2016 by Administrator

Oracle HRMS for Saudi Arabia This document provides a guide to the Oracle HRMS patch 3221427, and discusses the new

Continue reading
Oracle HRMS / Payroll, Oracle HRMS / Payroll Setup
Leave a comment

How to restrict the absence type list of values in Oracle Self-Service Human Resources.

Posted on December 22, 2015 by Administrator

Q: How to restrict the absence type list of values in Oracle Self-Service Human Resources. Q: Steps to restrict Absence

Continue reading
Oracle HRMS / Payroll, Oracle Self-Service Human Resources, Self Service
Leave a comment

Formula Results Rules- Indirect type does not showing the element

Posted on November 17, 2015 by Administrator

I have faced following glitch while passing indirect Value to one of information Element. Case: I have setup two elements “Basic Salary”

Continue reading
Oracle HR Fast Formual, Oracle HRMS / Payroll, Others
Leave a comment

Oacle HR/Payroll Fast Formula Introdouction

Posted on November 15, 2015 by Administrator

Introduction Oracle E-Biz is a huge set of programs, combined together in a way that the data across modules are

Continue reading
Oracle HR Fast Formual
Leave a comment

Oracle University Self-Study courses

Posted on November 4, 2015 by Administrator

Oracle Database 11g Oracle Database 11g: Performance Tuning Oracle Database 11g: Administration Workshop I Oracle Database 11g: SQL and PL/SQL

Continue reading
Oracle Trainings
Leave a comment

R12.x Oracle HRMS Learning Management Fundamentals

Posted on October 2, 2015 by Administrator

This course offers a complete introduction to the implementation and use of Oracle Learning Management. Participants familiarize themselves with what

Continue reading
Uncategorized
Leave a comment

How to store images into the database through forms

Posted on October 2, 2015October 2, 2015 by Administrator

This is pretty easy. The answer is READ_IMAGE_FILE. The will read a file stored on the machine with the form

Continue reading
Uncategorized
Leave a comment

Oracle SSHR Absence Transactions, Selfservice transactions – where did my data go?

Posted on May 19, 2015August 26, 2019 by Administrator

When Oracle build Self Service they treated it as a new front-end of the system. To be able to use

Continue reading
Impratant Queries, Oracle HRMS Technical, Self Service
2 comments

Query to get Absence Detail Employee wise

Posted on May 19, 2015October 2, 2015 by Administrator

Query to get Absence Detail Employee wise. Approved Absence details. SELECT papf.EMPLOYEE_NUMBER,papf.FULL_NAME,pat.NAME absence_type, paa.date_start leave_start_date, paa.date_end leave_end_date, paa.absence_days, paa.abs_information_category, paa.abs_information2,

Continue reading
HR / Payroll Related Queries
2 comments

Oracle Apps, How to Clear/Delete cache of Oracle EBS R12

Posted on March 2, 2015October 2, 2015 by Administrator

Oracle Apps, How to Clear/Delete cache of Oracle EBS R12 Step1: Select Functional Administrator responsibility – then choose Home as per

Continue reading
Oracle Apps Basics, System Administration
One comment

Error: “Recalculate Salary from the Components before applying the new salary proposal” while updating / Deleting Salary

Posted on February 10, 2015 by Administrator

If you are facing following Error: “Recalculate Salary from the Components before applying the new salary proposal”  while updating or deleting

Continue reading
Oracle HRMS / Payroll, Oracle HRMS Technical
Leave a comment

Oracle OpenWorld highlight, Opening keynotes by CEO Larry Elison

Posted on November 7, 2014 by Administrator

  Oracle CEO Larry Ellison Addressing opening notes in Oracle Open world. Opening Keynote Larry Ellison, Executive Chairman and Chief

Continue reading
News and Articals
Leave a comment

How to Send Notification in Worklist of User through PL-SQL

Posted on October 13, 2014 by Administrator

Q: How to send HTML Based Notification by a mere PL/SQL Call? Q: Oracle EBS/APPS how to send Email and

Continue reading
Alerts and WorkFlows in Oracle Apps, Oracle EBS Standard APIs and Interfaces
Leave a comment

Customizing Forms in Oracle HRMS

Posted on June 1, 2014 by Administrator

We get the requirements for restricting access and fuctionalites in form which is normally done either by formspersonalization or custom.pll

Continue reading
Forms Personalizations
4 comments

Oracel HR Payroll SEO Statement Setup

Posted on April 3, 2014May 25, 2015 by Administrator
Continue reading
Oracle HRMS Technical
Leave a comment

Uploading Data to Batch Element Entries using API

Posted on January 22, 2014October 2, 2015 by Administrator

  Oracle Payroll: Example to Upload Data in Batch Element Entries Using API.  PAY_BATCH_ELEMENT_ENTRY_API Following are the API’s to create

Continue reading
Uncategorized
Leave a comment

Extra Person Information (EIT) Upload API — Procedure

Posted on November 7, 2013 by Administrator

Following Procedure used for uploading data in Extra Person Information.   1) Create a EIT using System Administrator Responsibility. Application>>Flexfield>>Descriptive>>Segments

Continue reading
Understanding and Using API User Hooks
5 comments

Enable / Disable Personalization option in Forms and SSHR

Posted on August 27, 2013May 1, 2024 by Administrator

If you are getting message to enter Oracle Password  to Personalize a Form. Function not available to this responsibility. Change

Continue reading
Uncategorized
Leave a comment

BI Publisher OPP Service failed for XML/Rtf in Oracle Apps Warning Message

Posted on April 20, 2013 by Administrator

Q: I am using Microsoft Office 2013. I can see the BI Publisher at the end when I open Microsoft

Continue reading
Oracle XML / BI Publisher
6 comments

Oracle6i Forms/Reports Builder Cannot Connect To Any Database (ORA-12222) TNS No Such Protocol adaptor …..

Posted on March 6, 2013 by Administrator

Applies to: Oracle Net Services – Version: 8.0.6.0.0 to 8.0.6.3.0 Microsoft Windows 2000 Microsoft Windows XP Microsoft Windows Server 2003

Continue reading
Uncategorized
Leave a comment

API with Example to Update Basic Salary

Posted on January 20, 2013 by Administrator

API with Example to Update Basic Salary. CREATE OR REPLACE PROCEDURE APPS.xxdm_basic_sal_proc ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_emp_no

Continue reading
Uncategorized
Leave a comment

Installing and Setting UP JDeveloper for OAF Customization R12x

Posted on September 17, 2012September 17, 2012 by Administrator

Installing and Setting UP JDeveloper for OAF Customization R12x   1)  Refer to Metalink note 416708.1 to obtain the proper

Continue reading
OAFramework R12X Customization
2 comments

OA Framework – How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x

Posted on September 17, 2012September 17, 2012 by Administrator

Identify the OA Framework version in your instance by activating diagnostics and click the “About This Page” from any OAF

Continue reading
OAFramework R12X Customization
Leave a comment

Configuring / Creating Descriptive Flexfield

Posted on January 30, 2012 by Administrator

Descriptive FlexField: In this post I am going to Answer following Questions. But the Major topic is regarding Configuring  a

Continue reading
FlexFields
3 comments

Oracle HRMS API to Upload Competencies

Posted on January 9, 2012January 9, 2012 by Administrator

Oracle Apps R12. API to Upload Competencies in Oracle HRMS This post will help you to upload competencies against each

Continue reading
Uncategorized
Leave a comment

Using Data Loader

Posted on December 28, 2011December 28, 2011 by Administrator

INTRODUCTION to Data Loader. Q: How to transfer Data from Excel to Oracle EBS using Data Loader. Q:What is Data

Continue reading
Uncategorized
Leave a comment

Oracle Apps AME

Posted on November 16, 2011 by Administrator

  What is AME?   AME is a web application providing the following services to calling applications: A ceteralized rules

Continue reading
Uncategorized
6 comments

Email From Oracle PL/SQL (UTL_SMTP)

Posted on November 16, 2011 by Administrator

The UTL_SMTP package was introduced in Oracle 8i and can be used to send emails from PL/SQL. Simple Emails In it’s simplest

Continue reading
Uncategorized
Leave a comment

Oracle R12 HR Payroll “Using Oracle FastFormual For Payroll Calculatins

Posted on November 1, 2011November 1, 2011 by Administrator

  Using Oracle FastFormula for Payroll Calculations                       You use

Continue reading
Oracle HRMS / Payroll
21 comments

Using Oracle FastFormula for Validation

Posted on November 1, 2011November 1, 2011 by Administrator

Using Oracle FastFormula for Validation                         You can use

Continue reading
Oracle HRMS / Payroll

Oracle HR / Payroll “Defining Element Links”

Posted on November 1, 2011November 1, 2011 by Administrator

Oracle EBS R12 HR Payroll Defining Element Links Element Link window                  

Continue reading
Oracle HRMS / Payroll

Oracle R12 HR Payroll. Creating Element

Posted on November 1, 2011November 1, 2011 by Administrator

  Element window – R12                              

Continue reading
Oracle HRMS / Payroll
Leave a comment

Can’t initialize OCI error occured during the login process using TOAD

Posted on September 28, 2011 by Administrator

You are using TOAD, and you are getting following message when trying to connect to the database: Can’t initialize OCI

Continue reading
Toad Tricks and Tips
2 comments

Oracle Concurrent Program – Passing UserName

Posted on September 27, 2011 by Administrator

Oracle Concurrent program. Passing User Name to PL-SQL through Parameter. (Oracle APPS , Oracle EBS) In this post,  I will

Continue reading
Concurrent Programs Related
Leave a comment

Understanding and Using API User Hooks

Posted on September 10, 2011September 10, 2011 by Administrator

Understanding and Using Oracle HR API User Hooks PURPOSE To explain how to add extra logic to the Business APIs

Continue reading
Understanding and Using API User Hooks
2 comments

Framework Personalization

Posted on April 27, 2011 by Administrator

Oracle e-Business Suite R12 Framework Personalization To do OA Framework Personalization please enable the following Profiles     1. Personalize Self-Service

Continue reading
Oracle Framework Personalization
9 comments

Work Structure KFF Definitions

Posted on April 24, 2011 by Administrator

Oracle EBS R12 HR/Payroll Setup. Work Structure Grade Key Flexfield Definition   1.    Open the Key Flexfield Segments form,

Continue reading
Grade Key Flexfield Definition
3 comments

Define HRMS Responsibility

Posted on April 24, 2011 by Administrator

Oracle EBS R12 HR / Payroll Setup. Define HRMS Responsibility 1    To define HRMS responsibility open the Responsibilities screen, Sys

Continue reading
Defining HR Responsibility, Oracle HRMS / Payroll Setup
One comment

Oracle HRMS and Payroll Key Flexfields

Posted on April 17, 2011April 25, 2011 by Administrator

  Oracle EBS HRMS and Payroll Key Flexfields   In this document I will try to propose  the best way

Continue reading
Oracle HRMS / Payroll
Leave a comment

Alerts in Oracle Apps

Posted on April 11, 2011January 9, 2012 by Administrator

Oracle EBS / Oracle Apps Alerts and Work Flows What are Oracle Alerts? A: Oracle Alerts monitor your Database information

Continue reading
Alerts and WorkFlows in Oracle Apps
13 comments

Profile Options in Oracle Apps / EBS

Posted on March 25, 2011March 29, 2011 by Administrator

What is Profile Options in Oracle  Apps/EBS: In Oracle EBS System Administrators control various profile options in Oracle Application that determine

Continue reading
System Administration
5 comments

Oracle APIs and Interfaces

Posted on January 16, 2011November 12, 2012 by Administrator

Oracle EBS R12/R11   Oracle APIs and Interfaces Q:  What is API? and what is open interface?what is the difference

Continue reading
Oracle EBS Standard APIs and Interfaces
3 comments

Oracle HRMS Payroll Tables Overview

Posted on January 2, 2011January 2, 2011 by Administrator

Oracle HRMS Payroll Tables Overview / Important Tables and details. Oracle HRMS Payroll Table Overview View more presentations from Chris

Continue reading
HR / Payroll Important Tables, Uncategorized
2 comments

Oracle HR / Payroll Important Tables

Posted on November 12, 2010November 20, 2015 by Administrator

Macy’s is coach black friday 2015 my black friday coach continue to coach handbags cyber monday keep. I consistently go

Continue reading
HR / Payroll Important Tables
2 comments

What are RICE Components

Posted on November 3, 2010August 6, 2012 by Administrator

 Oracle Apps / EBS  RICE Components  What are RICE Components The acronym, RICE, stands for Reports, Interfaces, Conversions, and Enhancements

Continue reading
What are RICE Components
10 comments

Enable Arabic for Reports

Posted on November 2, 2010 by Administrator

 Q:   I have Toad for Oracle 9.5  installed on XP professional and have Oracle 10.2.0.3.0. I have Arabian characters in my

Continue reading
Enable Arabic for Reports
Leave a comment

Oracle BI Publisher / BI publisher and Office 2007 & 2010

Posted on October 31, 2010October 31, 2010 by Administrator

Oracle BI Publisher / BI publisher and Office 2007 & 2010 Connection Problem with MS Word 2010 / 2007 Question:

Continue reading
Oracle XML / BI Publisher
13 comments

Oracle HR and Payroll Related Queries

Posted on October 26, 2010October 19, 2015 by Administrator

Oracle EBS/Apps R12. ( Oracle HR / Payroll ) Important Queries Note: All following queries are customized and may not

Continue reading
HR / Payroll Related Queries
19 comments

Difference between Discrete & Process Manufacturing

Posted on September 28, 2010 by Administrator

Difference between Discrete & Process manufacturing In this article i will try explain basic difference between  in two manufacturing operations

Continue reading
Manufacturing
One comment

Query to find out info from PR to PO

Posted on September 28, 2010 by Administrator

Oracle EBS R12 Query to find out info from PR to PO select distinct u.description “Requestor”, porh.segment1 as “Req Number”,

Continue reading
SCM Related Queries
Leave a comment

Query to find out PR and PO linked

Posted on September 28, 2010 by Administrator

Oracle EBS R12 Query to find out PR and PO linked (Find PO information Against PR) select req.segment1,req.DESCRIPTION req_,req.APPROVED_DATE,po.segment1,po.CREATION_DATE,po.APPROVED_FLAG from po_headers_all

Continue reading
SCM Related Queries
Leave a comment

Oracle OPM Manufacturing Accounting Cycle

Posted on September 21, 2010 by Administrator

Oracle OPM Manufacturing Accounting Cycle 1. Batch Release DR :   WIP       CR :Inventory 2. Step certification DR :  WIP    

Continue reading
Oracle OPM Accounting Cycle
Leave a comment

Accounting Concepts

Posted on September 21, 2010 by Administrator

Accounting Concepts Indeed, this is one of good area, where most of techies have lot of confusion and illusion about

Continue reading
1- Accounting Concepts
2 comments

Encumbrance Accounting

Posted on September 21, 2010September 21, 2010 by Administrator

Encumbrance Accounting Before start of this topic you should be clear on these term; Encumbrance This is your any pre-expenditure,

Continue reading
Encumbrance : Accounting Concept Oracle
One comment

Oracle EBS R12 Administrator and Concurrent Related

Posted on September 19, 2010September 19, 2010 by Administrator

Oracle EBS R12 Administrator and Concurrent Related Query to Find Responsibilities assigned to particular user. SELECT b.responsibility_name NAME FROM apps.fnd_user_resp_groups

Continue reading
Administrator n Concurrent
Leave a comment

SCM Queries

Posted on September 19, 2010 by Administrator

Oracle  EBS R12 Purchasing, Inventory, Order Management Qureies To Find Duplicate Item Category Code SELECT category_set_name, category_concat_segments, COUNT (*) FROM

Continue reading
SCM Related Queries
2 comments

Populating Flexfiled Value Set

Posted on September 14, 2010September 16, 2010 by Administrator

Populating Flexfiled Value Set 1. Company Segment Values 1.  Open the segment Values window. General Ledger :  Setup > Financials

Continue reading
1.1.5 Accounting Flex Field Value Set
14 comments

Oracle EBS Documentation Library

Posted on August 24, 2010August 24, 2010 by Administrator

Oracle E-Business Suite Online Documentation Library Release 12.1.3 Link Download Oracle E-Business Suite Online Documentation Library Release 12.1.3 Download (560.23

Continue reading
Oracle EBS Documentation Library
One comment

Fnd_sessions, Oracle HR Date Tracking

Posted on August 10, 2010August 16, 2010 by Administrator

oracle EBS HRMS R12 Fnd_Session, Oracle HR Date Tracking In this article I am going to explain Fnd_Session and cover

Continue reading
Oracle HRMS Technical
One comment

Mo_Global.Set_policy_Context

Posted on July 28, 2010July 28, 2010 by Administrator

 MO_GLOBAL.SET_POLICY_CONTEXT   /   MO_GLOBAL.ORG_SECURITY In this article i will try to give the answer of follwoing questions.   1) What is

Continue reading
MO_Global.Set_Policy_Context
5 comments

Oracle EBS Shut Down Script for Windows

Posted on July 17, 2010 by Administrator

To Shut Down Application Server. I am assuming oracle install on c:\oracle navigate to Command prompt   Star>Run>Cmd C: cd\ cd

Continue reading
Oracle EBS Shut Down Script for Windows
Leave a comment

Business Group/Calendar/Inv Org Creation

Posted on July 15, 2010September 19, 2010 by Administrator

Oracle EBS Financial Account Payable Setup Business Group Assignment 1) Switch to System administrator responsibility. Sys Admin: Profile > System

Continue reading
1.2 Payable Setup, 1.2.1 Business Group/Calendar/Inv Org Creation
Leave a comment

Define/Enable Currency

Posted on July 6, 2010July 28, 2010 by Administrator

Oracle EBS R12 Financial Setup Define/Enable Currency In this article I will explain you how to define or enable currency. Define Currency 

Continue reading
1.1.4 Define/Enable Currency
One comment

Accounting Calendar

Posted on July 6, 2010 by Administrator

Oracle EBS R12 Financial setup. Defining Accounting Calendar In this article i will expaline you that how to defince Accounting

Continue reading
1.1.4 Accounting Calendar
Leave a comment

1.1.3 Accounting Flexfield

Posted on July 5, 2010 by Administrator

Oracle EBS R12 Finanical Setup Accounting Flexfield Defining the flexfield  1)   Open the Key Flexfield segments window.            General Ledger

Continue reading
1.1.3 Accounting Flexfield
Leave a comment

Setting Item Mandatory

Posted on July 4, 2010May 2, 2016 by Administrator

Setting Item Mandatory In this article I will explain you how you can set any field mandatory through personalization In

Continue reading
Setting Item Mandatory
One comment

Posts pagination

1 2 Next Posts»

Categories

  • 1- Accounting Concepts
  • 1- Oracle R12 Financial Setup
  • 1.1 General Ledger Setup
  • 1.1.1 User Creation and Assign Responsibility
  • 1.1.2 Chart of Account and Segments Lists
  • 1.1.3 Accounting Flexfield
  • 1.1.4 Accounting Calendar
  • 1.1.4 Define/Enable Currency
  • 1.1.5 Accounting Flex Field Value Set
  • 1.2 Payable Setup
  • 1.2.1 Business Group/Calendar/Inv Org Creation
  • Administrator n Concurrent
  • Alerts and WorkFlows in Oracle Apps
  • Concurrent Programs Related
  • Configuring and Administrating Approval Transactions
  • Defining HR Responsibility
  • Enable Arabic for Reports
  • Encumbrance : Accounting Concept Oracle
  • Error Messages in Oracle Fusion
  • FlexFields
  • Forms Personalizations
  • Grade Key Flexfield Definition
  • HR / Payroll Important Tables
  • HR / Payroll Related Queries
  • Important Documentation Links
  • Important Tables
  • Impratant Queries
  • Installing GNU Make For EBS
  • Jobs
  • Manufacturing
  • MO_Global.Set_Policy_Context
  • News and Articals
  • OAF Personalization
  • OAFramework R12X Customization
  • OPM Related Queries
  • Oracle AME Setup
  • Oracle Apps Basics
  • Oracle Cloud
  • Oracle EBS Documentation Library
  • Oracle EBS Shut Down Script for Windows
  • Oracle EBS Standard APIs and Interfaces
  • Oracle Framework Personalization
  • Oracle Fusion
  • Oracle HR Fast Formual
  • Oracle HRMS / Payroll
  • Oracle HRMS / Payroll Setup
  • Oracle HRMS Technical
  • Oracle I-Recruitment
  • Oracle Inventory User Practice
  • Oracle OPM Accounting Cycle
  • Oracle Purchasing User Practice
  • Oracle R12 Form Customiztion
  • Oracle R12 Installation on Windows
  • Oracle Self-Service Human Resources
  • Oracle Trainings
  • Oracle XML / BI Publisher
  • Other Apps
  • Others
  • Report Customization Oracle EBS
  • SCM Related Queries
  • Self Service
  • Setting Item Mandatory
  • System Administration
  • Tips & Tricks
  • Toad Tricks and Tips
  • Uncategorized
  • Understanding and Using API User Hooks
  • What are RICE Components

Recent Comments

  • Siri on Fee Oracle Cloud Learning / Training
  • Amin on •Oracle Application Framework (OAF) Training
  • sudeepthi on What are RICE Components
  • Arun on Oracle BI Publisher Tab issue in MS Word.
  • Leo Caipei Chen on Report Customization Oracle R12

Recent Posts

  • Oracle Fusion Document of Records DOR
  • Important Documentations for Oracle Fusion
  • How to Create user and Assign Roles in Oracle Fusion and Post user creation steps.
  • Oracle Cloud Support and Help Resources
  • Oracle Fusion Error message Legal Entity doesn’t exit (PER-1531116)

Tags

API to Create EIT Extra Information API with Example to Update Basic Salary. Conditional Formatting Connect oracle database without tnsnames.ora Creating a New Vacancy Errors data bars Defining HR Responsibility Error while creating New Vacancy Excel Shortcuts Gmail Tricks how to add flexfield in oracle oaf page how to create blanket purchase order in oracle apps r12 how to create buyer in oracle purchasing how to create dff in oracle apps how to create purchase order in oracle how to create purchase order in oracle Apps how to create standard purchase order in oracle apps how to create unit of measure in oracle how to personalize oracle oaf page lease enter a value of Y or N location of tnsnames.ora Ms Excel oaf form personalization steps oaf personalization in oracle apps r12 oaf personalization tutorial Oracle API Oracle EIT upload Data Oracle Framework Personalization Oracle Fusion Oracle Fusion Profile oracle IRecruitment oracle kanban process flow oracle oaf personalization oracle oaf personalization examples oracle purchase order types oracle purchasing categories oracle purchasing create supplier oracle purchasing module oracle purchasing setups oracle purchasing user guide oracle purchasing user manual The employee (or contractor) information is invalid. tips and tricks tnsnames.ora what is kanban in oracle apps
www.oracleport.com