Sunday, July 07, 2013
While defining any concurrent program, the default output format is ‘Text’ as shown below, so the program will open the report output in browser. If we want to take the report output in Excel format, though the output format is 'Text', we need to do the following steps. Go to System Administrator à Profile à System Query for ‘Viewer%’ Go to Install à Viewer Options Click on Text...
Read more
Saturday, July 06, 2013
Let me explain, why i am creating this post. Usually we call ENTRY_VALUE of an element like this in our formula ELEMENT_NAME_INPUT_NAME_ENTRY_VALUE What if Retropay has already been run and it has created retro entries in element entries window. In that case, if we would try to call ENTRY_VALUE of an element for which retro entry exists, it will sum up entry values of Standard and Retro Entries...
Read more
Saturday, July 06, 2013
Sometimes it is a requirement that a formula is processed when a certain condition is met. For instance, your company would pay an allowance every quarter. So to achieve this goal, there a functionality available of writing Skip Rule Formula. Here is the element window and where we specify the Skip Rule. Navigation: Global HRMS Manager -> Total Compensation -> Basic-> Element Description Now Let's write the Skip...
Read more
Monday, June 17, 2013
Requirement: When an absence is entered into System, an SIT should be auto filled based on data available on Absence form. Here is the procedure to upload data into SIT(Special Information Type) How to create SIT in Oracle HRMS CREATE OR REPLACE PROCEDURE APPS.DEV_CREATE_SPECIAL_INFO(P_PERSON_ID IN NUMBER,P_DATE_START IN DATE,P_DATE_END IN DATE) IS L_ID_FLEX_NUM NUMBER; L_PERSON_ID NUMBER; L_NAME VARCHAR2 (240); ERROR_DESC VARCHAR2 (240); LV_SIT_FLAG CHAR...
Read more