Author Archives: Narmeen Wajid

Vacancy Update API (PER_VACANCY_API.update_vacancy)

By | December 20, 2016

declare P_ASSIGNMENT_CHANGED boolean; p_inv_pos_grade_warning boolean; p_inv_job_grade_warning boolean; err_msg varchar2(500); cursor c1 is select vacancy_id,object_version_number,status,name from PER_ALL_VACANCIES where name = ‘IRC10377’; begin for r in c1 loop dbms_output.put_line(‘start’); begin PER_VACANCY_API.update_vacancy ( P_VALIDATE => FALSE , P_EFFECTIVE_DATE => TRUNC(SYSDATE) , P_VACANCY_ID =>r.vacancy_id , P_OBJECT_VERSION_NUMBER =>r.OBJECT_VERSION_NUMBER , P_DATE_TO => TRUNC(SYSDATE) , P_STATUS => ‘CLOSED’ , P_ASSIGNMENT_CHANGED => P_ASSIGNMENT_CHANGED… Read More »

Steps to Compile a Fast Formula

By | December 20, 2016

How to Compile a Fast Formula Following are the steps to compile a fast formula from Oracle HRMS application Go to following navigation Open the form Find the Formula Click on Edit Button Following screen will open. Click on Verify button. Once formula is verified. Message for successful compilation will be displayed in the bottom… Read More »

HR Security Profiles Data through SQL Query

By | December 17, 2016

Following is the full list of all HR Security Profiles Query to get Full List of Security Profiles Query to get Organization Based Security Profiles List Query to get Payroll Based Security Profiles List Query to get Custom Security Based Security Profiles List –Query to get Others Security Profiles List Oracle HRMS provides an option… Read More »

Workflow Customization in Oracle HRMS

By | November 22, 2016

In this article, we are going to cover how we can modify the workflow to change the notification. While you are working for oracle hrms in your environment. You may come across such requirement. so here are the stops to achieve this requirement. Contents Business Requirement Solution Steps —Identify the Item Key —Find the Process… Read More »

Steps for Developing Custom Form in Oracle Apps

By | October 4, 2016

In this article of oracle hrms overview, you will find the steps for development of custom forms (using oracle developer suite 10g). This article covers the end to end process starting from developing a form and running on oracle apps. Custom form in oracle apps is developed based on TEMPLATE.FMB which is available in resources… Read More »

Flexfields in Oracle HRMS

By | October 2, 2016

In this article, We have explained the flexfields in oracle hrms, its types and usages. What is Flex Field Types of Flex Field –Key Flexfields –Descriptive Flexfields Key Flexfields in Oracle HRMS –Job Key Flexfield –Grade Key Flexfield –Position Key Flexfield –Cost Allocation Key Flexfield –Competence Key Flexfield –Soft Coded Key Flex field –Bank Details… Read More »

Configure WEB ADI in Vision Instance

By | September 28, 2016

Configure WEB ADI in Vision Instance When you start working with Web ADI in vision instance. It gives an error and you are not able to use this feature. In this article of Oracle HRMS, i have mentioned the step to fix this issue. Following is the error (BNE_UIX_PHYSICAL_DIRECTORY is not configured) occurred when i… Read More »

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 »