www.oracleport.com
Open in
urlscan Pro
50.87.153.96
Public Scan
Submitted URL: http://www.oracleport.com/
Effective URL: https://www.oracleport.com/
Submission: On May 09 via manual from US — Scanned from DE
Effective URL: https://www.oracleport.com/
Submission: On May 09 via manual from US — Scanned from DE
Form analysis
0 forms found in the DOMText Content
Skip to content ORACLEPORT.COM Oracle Techno Functional Portal, Technical and Functional Resource Menu * 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 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 Leave a 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, 2013March 16, 2020 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 9 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 FORMS PERSONALIZATIONS Posted on July 3, 2010May 2, 2016 by Administrator Forms Personalization Using the Form Personalization you have option to alter Oracle code at runtime bypassing important validation logic. Form Continue reading Forms Personalizations 2 comments XML / BI PUUBLISHER ISSUES Posted on June 30, 2010August 2, 2010 by Administrator Location of XML Publisher (rtf,XDO) files on server This article is for those who are looking for answer of following Questions. What Continue reading Oracle XML / BI Publisher Leave a comment 1.1.2 CHART OF ACCOUNT AND SEGMENTS LISTS Posted on June 28, 2010 by Administrator Oracle EBS R12. Financial Setup Chart of Account Multiple charts of accounts can be defined per installation or single chart Continue reading 1- Oracle R12 Financial Setup, 1.1 General Ledger Setup, 1.1.2 Chart of Account and Segments Lists 2 comments CREATING USER AND ASSIGNING RESPONSIBILITIES Posted on June 28, 2010 by Administrator Oracle EBS R12.1 Oracle Financial User Creation and Assigning responsibilities In this Article i will explain the first step of Oracle Financial Setup. First of Continue reading 1- Oracle R12 Financial Setup, 1.1 General Ledger Setup, 1.1.1 User Creation and Assign Responsibility One comment FORMULA DETAILS Posted on June 27, 2010May 2, 2016 by Administrator Oracle Apss R12 OPM (Oracle Process manufacturing) Formula Base Tables and Detail of Products and Ingredients select a.FORMULA_ID,a.formula_no,a.FORMULA_DESC1,b.INVENTORY_ITEM_ID,c.description,b.organization_id,decode(b.line_type,-1,’Ingredient’,’Product’) Type from Continue reading OPM Related Queries Leave a comment QUANTITY OF INGREDIENTS AND PRODUCTS Posted on June 27, 2010 by Administrator Oracle Apps R12. OPM Query to Find out Quantity of Products and Ingredients of all Batches in particular Month. Continue reading Impratant Queries, OPM Related Queries One comment INSTALLING GNU MAKE FOR EBS Posted on June 25, 2010 by Administrator Installing GNU Make for use with E-Business suite R11 R12. Download it from the GNU FTP site Download make-3.79.tar.gz or Continue reading Installing GNU Make For EBS Leave a comment HOW TO INSTALL ORACLE EBS R12 IN PC (WINDOWS) Posted on June 23, 2010September 14, 2012 by Administrator Install Oracle E-Business Suite Release 12 on MS Windows In this article i will explain how to install Oracle Continue reading Oracle R12 Installation on Windows 27 comments PRINTING REPORTS IN PDF FORMAT WITH ORACLE APPLICATIONS Posted on June 22, 2010 by Administrator Printing Reports in PDF format with Oracle Applications This post explains how you can modify an Oracle Applications report output Continue reading Report Customization Oracle EBS Leave a comment REPORT CUSTOMIZATION ORACLE R12 Posted on June 22, 2010 by Administrator In this article I will explain that How to Develop/Customize a Report in Oracle EBS R12 using Oracle Report Builder 10.1.2.0.2. One thing I Continue reading Report Customization Oracle EBS 37 comments FORM CUSTOMIZATION R12 Posted on June 21, 2010November 15, 2011 by Administrator Oracle R12 Form 10G Customization: This article describe you in brief the steps of Form Customization and Registration with Oracle Apps Continue reading Oracle R12 Form Customiztion 3 comments CONVERT NUMBER INTO WORDS Posted on June 21, 2010 by Administrator Convert Number into Words select ename,sal,to_char(to_date(sal,’J’), ‘JSP’) as converted_form from scott.emp ENAME SAL CONVERTED_FORM SMITH 800 EIGHT HUNDRED ALLEN 1600 Continue reading Impratant Queries One comment ORACLE R11, R12 IMPORTANT QUERIES Posted on June 21, 2010 by Administrator Oracle R11, R12 Important Queries (Concurrent , Inventory, Purchaing , HR, Payrol , OPM) To Find Duplicate Item Category Code Continue reading Impratant Queries Leave a comment ORACLE APPS TECHNICAL TERMS Posted on June 19, 2010 by Administrator DFF: Descriptive Flex Field Descriptive Flex Fields are used to gather additional information about your business entities beyond the Continue reading Oracle Apps Basics 4 comments HR / PAYROLL IMPORTANT TABLES Posted on May 16, 2010May 16, 2011 by Administrator PAY_ACCRUAL_BANDS Length of service bands used in calculating accrual of paid time off. PAY_ACCRUAL_PLANS PTO accrual plan definitions, (Paid time Continue reading HR / Payroll Important Tables One comment 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 * Defining HR Responsibility * Enable Arabic for Reports * Encumbrance : Accounting Concept Oracle * FlexFields * Forms Personalizations * Grade Key Flexfield Definition * HR / Payroll Important Tables * HR / Payroll Related Queries * 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 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 * Arun on Oracle BI Publisher Tab issue in MS Word. * Leo Caipei Chen on Report Customization Oracle R12 * Kavitha Shivaiah on Oracle BI Publisher Tab issue in MS Word. * ZAFAR IMAM on Oracle SCM Techno Functional Training * Zafar Imam on Oracle SCM Techno Functional Training RECENT POSTS * Oracle SSHR How to know and delete/disable Hidden Personalization * Changing From and To Name Order in Oracle EBS Purchase Requisition Approval Notification * How to make a Line Chart in Excel ? * How to make a Pie Chart in Ms excel ? * How to automatically append an email signature to every email you send ? 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 app-pay-07155 while terminating employee. Error while creating New Vacancy Excel Shortcuts Gmail Tricks how to add flexfield in oracle oaf page how to connect with oracle database 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 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