Category Archives: Uncategorized

Zoom Functionality through Forms Personalization

By | September 25, 2016

Table of Contents Business Requirement Solution Concept Find the form name to be called Create Source Form’s Personalization Create Personalization in Destination Form Test the Forms Personalization Business Requirement It is a very common requirement to open a form from another form to see any further details of parent form. In this example we have… Read More »

Steps to Develop Report in Oracle Apps

By | September 20, 2016

Table of Contents Develop RDF Report Generate XML File Create RTF Template Create Value Sets Create Executable Create Concurrent Program Create Data Definition Create Template Definition Add Concurrent Program in Request Group Transfer RDF Report to Server Run the Report Develop RDF Report Open the report builder Select the Report menu option Select using wizard… Read More »

Steps to Create Alert in Oracle HRMS

By | September 1, 2016

In this post, you will find the steps to create the alerts in oracle hrms. By default when you install Vision instance, Only few application are licensed. You need to license the required products in order to use it. If you are working on vision instance, Please find the steps to enable alerts license mentioned… Read More »

How to Enable Oracle Alerts License on Vision Instance

By | August 21, 2016

This article is written for those who are working on their vision instance and want to use the alert functionality first time on vision instance. By default when you install Vision instance, Only few application are licensed. You need to license the required products in order to use it. It is very easy to license… Read More »

Steps to Implement Zoom Functionality through Custom.PLL

By | August 15, 2016

Table of Contents Business Requirenment Solution concept Find the form name and block name Copy Custom.PLL from Server to your Development Machine Modify Zoom function Identify the Executables Function Name Modify Event Procedure Migrate and Compile the CUSTOM.PLL Test the Form Business Requirnment It is a very common requirement to open a form from another… Read More »

Steps to Create SQL Loader Based Program in EBS

By | August 10, 2016

Table of Contents Business Requirment Solution concept Prepare data in Excel Create data in CSV Format Create Staging Table in database Create SQL Loader Control File Create Execution File Create Concurrent Program Add to Request Group Submit the Program in staging table. Business Requirement: HR department has created an EIT for storing passport information in… Read More »

Step By Step Guide to Create EIT in Oracle HRMS

By | March 31, 2016

Extra Information Types Oracle defines EIT in following words. Extra Information Types (EITs) is a descriptive flexfield that facilitates us to add an unlimited number of information types to six available important entities in Oracle HRMS. EITs do not appear automatically in any responsibility. You must set up responsibility-level access for EITs. Extra Information types… Read More »


By | February 14, 2016

API to Update People Group Field in Employee Assignment  declare l_effective_start_date DATE; l_effective_end_date DATE; l_people_group_id NUMBER := 62; — 2; –2067; l_group_name VARCHAR2 (500); l_org_now_no_manager_warning BOOLEAN; l_other_manager_warning BOOLEAN; l_spp_delete_warning BOOLEAN; l_entries_changed_warning VARCHAR2 (500); l_tax_district_changed_warning BOOLEAN; l_special_ceiling_step_id NUMBER; l_object_version_number NUMBER; l_soft_coding_keyflex_id NUMBER; ——————— — Local Variables — ——————— l_concatenated_segments VARCHAR2 (400); l_no_managers_warning BOOLEAN; l_comment_id NUMBER; l_batch_run_number… Read More »

Oracle Payroll Tables and Payroll Queries

By | December 9, 2015

Important Tables There is a big list of oracle payroll tables. But these are main tables which every technical consultant must know in detail. I have categorized these tables into following three categories. Element Entry Related Tables ————————— PAY_ELEMENT_TYPES_F PAY_ELEMENT_ENTRIES_F PAY_INPUT_VALUES_F PAY_ELEMENT_LINKS_F Payroll Run Related Tables ————————- PAY_ALL_PAYROLLS_F PAY_PAYROLL_ACTIONS PAY_ASSIGNMENT_ACTIONS PAY_RUN_RESULTS PAY_RUN_RESULT_VALUES Costing & Pre… Read More »

Get Columns Values in Row in SQL Query

By | December 8, 2015

Requirement: We have two columns in a table. One column having test name and other column having defect names against one test. We need to write a query to bring all defects against the test. Creating Scenario & its Solutions Tables Creation Script create table testcase(testname varchar2(100),defname varchar2(100)) Function to get the list in a… Read More »