Category Archives: Apps Interview Questions

Useful Apps Technical SQL Queries

By | January 20, 2015

Summary Following is the list of SQL Queries that i have mentioned on this post. These are requirement that we often come across while we are on some support or implementation project. Therefore i decided to compile them in one place in ready to use format. Flashback Query to get old state of Data Get… Read More »

Introduction to Oracle EBS History

By | January 17, 2015

Introduction to Oracle EBS – (Oracle e Business Suite) Oracle (EBS) e Business Suite is one of the renowned ERP (Enterprise Resource Planning) Applications in the world. It covers a variety of applications which have strong integrations through which data  flows  across application of e Business  Suite. Oracle has combined different products families and named… Read More »

Oracle Learning Management – OLM Tables

By | December 16, 2014

Summary of Article Introduction Big List of OTA Tables ER Diagram Sample Catalog Objects Hierarchy Explanation with Sample Data Links SQL Queries for Catalog Objects SQL Queries for External Learning Download PDF Version of this Article Oracle Learning Management – OLM Tables In Oracle HRMS Overview Series of Articles, This is the first to one… Read More »

Delete Payroll Element Entry – pay_element_entry_api

By | December 15, 2014

Background of Payroll Element Entry API In Oracle HRMS, elements are created in a persons’ assignments to make them eligible to be processed in a payroll run. Sometimes we need to create/ delete the element. This can be done by Application or by use of API. Here is the API to Create / Delete the… Read More »

API to Create External Learning – OTA_NHS_API

By | December 14, 2014

Background of External Learning Create API In previous article we covered to create the courses through API and in this article we shall cover external learning for an employee. In OLM when an employees attends a course or training from outside of the organization, it is called external learning. We can use following API to… Read More »

Functions Used in Oracle HRMS Fast Formula

By | December 2, 2014

Functions Used in Oracle HRMS In previous article of Fast Formula, we understood the concept, its usage and different types of Fast Formulas in Oracle HRMS. In this article i am going to explain the functions that we can use in Fast formula to make the desired logic. Following are different types of functions that… Read More »

Data Types for Constants and Variables in Oracle HRMS Fast Formula

By | December 1, 2014

Constants There are three types of constants that can be used in fast formula • numeric • text • date Numeric Constants Do not use commas or spaces in a number. So, for example, you cannot use 10,000 or 10 000.00 numeric constants. Examples of valid numeric constants are: • 83 • 6.55 • -7.3… Read More »

API to Create Course in OLM (ota_activity_category_api)

By | November 19, 2014

API to Upload Courses as Cataloge Objects in OLM ota_activity_version_api Purpose of this API is to create the master list of courses in OLM as Course Calaoge Objects. First API Creates Course and API called below includes it under a category.   declare errbuf VARCHAR2(200); retcode VARCHAR2(200); p_business_group_id NUMBER:= 83; p_validate VARCHAR2(10):= ‘FALSE’; l_activity_version_id NUMBER;… Read More »

2 Simple Steps to make a Responsibility Read Only in Oracle Apps.

By | October 31, 2014

How to make a Responsibility Read Only in Oracle Apps? Solution Concept: By setting the profile option HR:Query Only Mode at responsibility level, you can make a responsibility read only. Step by Step solution: Login with System Administrator responsibility and navigate to Profile-> System menu as shown below in the picture Form for profile option… Read More »

Enable Diagnostic Examine Option in Oracle Apps

By | October 26, 2014

Problem Statement: While working in oracle, you might want to know the detail through Diagnostic->Examine option, but when you try to open the examine form, you end up with following message. Function not available to this responsibility: Change responsibilities or contact your system  Following is the error screen.. Cause: This error comes because, you don’t have… Read More »