How to show text format output in Excel in Oracle Applications

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

How to get entry value of an element when retro pay has already been run in Oracle HRMS Payroll

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

Writing a Skip Rule Formula in Oracle HRMS Payroll

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

How to call procedure with parameters in a trigger Oracle PL/SQL

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