Oracle HRMS Interview Questions & Answers

  1. Question 1. What Is Element Entry? What Is The Purpose Of Element Entry?

    Answer :

    Element entry is to define element yet here enter that is Earning element or deduction element then calculate net pay.

  2. Question 2. What Are Basic Set Ups Of Oracle Hrms?

    Answer :

    In oracle HRMS there are so many modules like Core HR, Payroll, Self Service HR, Oracle learning management, iRecruitment, Time and Labour, Compensation Work bench, Oracle Advanced Benefits, Performance Management System etc., Core HR and System Administrator are the Heart of Oracle HRMS.

    All basic set ups will do in Core HR with the help of System Administrator.

    In system administrator we will create all the Users and Responsibilities, Flex fields, Profile values etc., In core HR we will create Organizations, Locations, Jobs, Positions, Grades, Organization Hierarchy, position Hierarchy, We will create all the employees also. These are the Basic setups in HRMS.

  3. HR Management Interview Questions

  4. Question 3. What Are List Types?

    Answer :

    List types are:

    • List of Values
    • Long list of Values
    • Pop list
  5. Question 4. What Are Six Validation Types?

    Answer :

    Validation types:

    • Dependent
    • Independent
    • None
    • Pair
    • Special
    • Table
  6. HR Management Tutorial

  7. Question 5. What Are Two Modes Of Date Track And What Is Date Track?

    Answer :

    Date Track modes are:

    • Update
    • Correction
  8. Oracle 10g Interview Questions

  9. Question 6. What Are Core Flexfield?

    Answer :

    Core flexfields are:

    • Job
    • Position
    • Grade
    • Competency
  10. Question 7. Can We Name Certain Dffs (description Flexfiled) And Their Location?

    Answer :

    Yes we can name certain DFF’s and their location.

  11. Oracle 10g Tutorial
    Oracle 9i Interview Questions

  12. Question 8. What Are Costing Types?

    Answer :

    Costing types are:

    • Fixed costed
    • Costed
    • Distributed
  13. Question 9. What Is Costing?

    Answer :

    Costing: Recording the costs of an assignment for accounting or reporting purposes. Using Oracle Payroll, you can calculate and transfer costing information to your general ledger and into systems for project management or labor distribution.

  14. Oracle 8i Interview Questions

  15. Question 10. What Are Termination Roles Of An Element?

    Answer :

    Termination Rules of an Element:

    • Actual Termination: For a nonrecurring element, select Actual Termination if you want the entries to close down at the end of the pay period in which the employee leaves.
    • Final Close: if you want the entries to stay open beyond the employee’s leaving date so that you can continue to pay the employee.
    • The Last Standard Process date defaults to the last day of the pay period in which the employee is terminated, but you can set it to a later period when you terminate an employee.
  16. Oracle 9i Tutorial

  17. Question 11. What Are Processing Types Of Element?

    Answer :

    Elements are nothing but the components of the salary.

    Eg. Basic, HRA, TA, BONUS, Loans etc., There are 2 types of Processing

    • Recurring: if an entry of this element applies in every period until the entry is ended
    • Non Recurring: if an entry applies in one pay period only.
  18. SAP HR Interview Questions

  19. Question 12. How To Restrict The Users To See The Payroll Data Employee Wise, They Only Can Setup The Basic Elements And Pay Bonuses But Cannot See The Gross Salaries Of Employees?

    Answer :

    • Define taskflow for your screen
    • Define the Profile scurity for his employee
  20. HR Management Interview Questions

  21. Question 13. What Is The Role Of Document Manager In Oracle Purchasing?

    Answer :

    POXCON is an immediate concurrent program. It receives pipe signal from the application when a request is made for approval/reservations/receipts.

  22. Oracle 8i Tutorial

  23. Question 14. What Else Can You Suggest To Restrict The Access To Screens From External Web Tiers?

    Answer :

    You may use URL filtering within Apache.

  24. Question 15. What Is The Significance Of Profile Option Responsibility Trust Level?

    Answer :

    In order to make a responsibility accessible from an external web tier, you must setprofile option Responsibility Trust Level at responsibility level to External. Onlythose responsibilities that have this profile option against them will beaccessible from ExternalMiddle tiers.

  25. Oracle 11g Interview Questions

  26. Question 16. What Is The Significance Of Profile Option Node Trust Level In Oracle Apps?

    Answer :

    If this profile option is set to a value of external against a server, then it signifies thatthe specific mid-tier is External i.e. it will be exposed to the www. In other words this server isnot within the firewall of your client. The idea behind this profile option is to flag such middle-tierso that special restrictions can be applied against its security, which means a very restricted setof responsibilities will be available from such Middle-Tier.

  27. SAP HR Tutorial

  28. Question 17. Can You Use Concurrent Program “gather Schema Statistics” To Gather Stats On Sys Schema In Oracle Apps?

    Answer :

    No, “Gather Schema Statistics” has no parameters for SYS schema. Please usedbms_job.

  29. Recruitment Interview Questions

  30. Question 18. Which Table Is Used To Provide Drill Down From Oracle Gl Into Sub-ledger?

    Answer :


  31. Oracle 10g Interview Questions

  32. Question 19. Does Oracle Support Running Of Gather States On Sys Schema In Oracle Apps?

    Answer :

    If your Oracle Applications instance is on 10g, then you can decide to run stats forSYS schema. This can be done by exec dbms_stats.gather_schema_stats(‘SYS’);Alternately using commanddbms_stats.gather_schema_stats(‘SYS’,cascade=>TRUE,degree=>20);I will prefer the former with default values.If you wish to delete the stats for SYS use exec dbms_stats.delete_schema_stats(‘SYS’);You can schedule a dbms_job for running stats for SYS schema.

  33. Oracle 11g Tutorial

  34. Question 20. What Will Be Your Partitioning Strategy On Gl_balances? Your Views Please?

    Answer :

    This really depends upon how many periods are regularly reported upon, how many periods are left open etc. You can then decide to partition on period_name, or period ranges, oron the status of the GL Period.

  35. Oracle apps Interview Questions

  36. Question 21. Does Oracle Support Partitioning Of Tables In Oracle Apps?

    Answer :

    Yes, Oracle does support partitioning of tables in Oracle Applications. There are several implementations that partition on GL_BALANCES. However your client must buy licenses to if they desire to partition tables. To avoid the cost of licensing you may suggest the clients may decide to permanently close their older GL Periods, such that historical records canbe archived. Note: Before running the archival process the second time, you must clear down the archive table GL_ARCHIVE_BALANCES (don’t forget to export archive data to a tape).

  37. Question 22. Does Oracle 10g Support Rule Based Optimization?

    Answer :

    The official stance is that RBO is no longer supported by 10g.

  38. Question 23. You Have Just Created Two Concurrent Programs Namely “xx Po Prog1” & “xx Poprog2”. Now You Wish To Create A Menu For Concurrent Request Submission Such That Only These Two Concurrent Programs Are Visible From That Run Request Menu. Please Explain The Steps To Implement This?

    Answer :

    • Define a request group, lets say with name “XX_PO_PROGS”
    • Add these two concurrent programs to the request group “XX_PO_PROGS”
    • Define a new Form Function that is attached to Form “Run Reports”
    • In the parameter field of Form Function screen, enterREQUEST_GROUP_CODE= “XX_PO_PROGS” REQUEST_GROUP_ APPL_SHORT_NAME=”XXPO” TITLE=”XXPO:XX_PO_PROGS”
    • Attach this form function to the desired menu.
  39. Oracle Apps ERP Interview Questions

  40. Question 24. Can You List Any One Single Limitation Of Forms Personalization Feature That Was Delivered With 11.5.10?

    Answer :

    You can not implement interactive messages, i.e. a message will give multiple options for Response. The best you can get from Forms Personalization to do is popup up Message with OK option.

  41. Oracle 9i Interview Questions

  42. Question 25. This Is A Very Tough One, Almost Impossible To Answer, But Yet I Will Ask. Which Formin Oracle Applications Has Most Number Of Form Functions?

    Answer :

    “Run Reports”. And why not, the Form Function for this screen has a parameter towhich we pass name of the “Request Group”, hence securing the list of Concurrent Programsthat are visible in “Run Request” Form. Just so that you know, there are over 600 form functionsfor “Run Reports”

  43. Question 26. Which Responsibility Do You Need To Extract Self Service Personalizations?

    Answer :

    Functional Administrator.

  44. Oracle 7.3 Interview Questions

  45. Question 27. How Will You Migrate Oracle General Ledger Currencies And Sets Of Books Definitions From One Environment To Another Without Rekeying? Will You Use Fndload?

    Answer :

    FNDLOAD can not be used in the scenario. You can use migrator available in “OracleiSetup” Responsibility

  46. Oracle 8i Interview Questions

  47. Question 28. Can You Do Fnd_request.submit_request From Sql Plus In Oracle?

    Answer :

     You will need to initialize the global variables first using fnd_global.initialize
    v_session_id INTEGER := userenv(‘sessionid’) ;

    SESSION_ID        =>    v_session_id
    ,USER_ID                =>    |
    ,RESP_ID                =>    
    ,RESP_APPL_ID           =>    
    ,SECURITY_GROUP_ID      =>    0
    ,SITE_ID                =>    NULL
    ,LOGIN_ID               =>    3115003–Any number here
    ,CONC_LOGIN_ID          =>    NULL
    ,PROG_APPL_ID           =>    NULL
    ,CONC_PROGRAM_ID        =>    NULL
    ,CONC_REQUEST_ID        =>    NULL
    ) ;
    commit ;
    END ;
    Optionally you may use fnd_global.apps_initialize, which internally calls fnd_global.initialize
      fnd_global.apps_initialize(user_id => :user_id,
    resp_id => :resp_id,
    resp_appl_id => :resp_appl_id,
    security_group_id => :security_group_id,
    server_id => :server_id);

  48. Question 29. How Will You Add A New Column To A List Of Values ( Lov ) In Oracle Applications Framework? Can This Be Done Without Customization?

    Answer :

    Yes, this can be done without customization, i.e. by using OA Framework Extension coupled with Personalization.

    Implement the following Steps :-

    1. Extend the VO ( View Object ), to implement the new SQL required to support the LOV.
    2. Substitute the base VO, by using jpximport [ similar to as explained in LINK ]
    3. Personalize the LOV Region, by clicking on Add New Item. While adding the new Item, you will cross reference the newly added column to VO.
  49. Oracle Access Manager Interview Questions

  50. Question 30. How Will You Configure Apache To Run In Debug Mode, Specifically Usefull When Debugging Iprocurement ( Prior To 11.5.10)?

    Answer :

    After 11.5.10, FND Logging  can be used for debugging Oracle iProcurement.
    Prior to 11.5.10
    cd $ORACLE_HOME/../iAS/Apache
    vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/ssp_init.txt
    vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/jserv.conf
    ApJServLogLevel debug
    vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/

  51. Question 31. On 10g, How Will You Use Awr?

    Answer :

    By running below scripts. These are both the same scripts, but with differing parameters.

    • $ORACLE_HOME/rdbms/admin/awrrpt.sql
    • $ORACLE_HOME/rdbms/admin/awrrpti.sql
  52. Question 32. What Are The Various Ways To Kick-off A Workflow You Can Either Use Wf_engine.start_process Or You Can Attach A Runnable Process Such Ghat It Subscribes To A Workflow Event.when Starting (kicking Off) An Oracle Workflow Process, How Do You Ensure That It Happens In A Background Mode?

    Answer :

    •  if initiating the process using start_process, do the below

                   wf_engine.threshold := -1;
                    wf_engine.startprocess(l_itemtype, l_itemkey)

    • When initiating the workflow process through an event subscription, set the Execution Condition Phase to be equal to or above 100 for it to be executed by background process.
  53. HR Interview Questions

  54. Question 33. How Do You Send A Particular Oracle Apps Workflow Activity/function Within A Workflow Process Into Background Mode?

    Answer :

    If cost of the workflow activity is greater than 50, then the workflow activity will be processed in background mode only, and it won’t be processed in online mode.

  55. SAP HR Interview Questions

  56. Question 34. How Do You Know If A Specific Oracle Patch Has Been Applied In Apps To Your Environment?

    Answer :

    Use table ad_bugs, in which column bug_number is the patch number.

    SELECT bug_number
    ,to_char(creation_date, ‘DD-MON-YYYY HH24:MI:SS’) dated
    FROM   apps.ad_bugs
    WHERE  bug_number = TRIM(‘&bug_number’) ;

  57. Question 35. How Do You Link A Host Type Concurrent Program To Concurrent Manager?

    Answer :

    Assuming your executable script is LOADPO.prog, then use the commands below

    cd $XXPO_TOP/bin
    ln -s $FND_TOP/bin/fndcpesr $XXPO_TOP/bin/LOADPO

  58. Question 36. How To Make Concurrent Program End With Warning?

    Answer :

    If the concurrent program is of type PL/SQL, you can assign a value of 1 to the “retcode” OUT Parameter.

    For a Java Concurrent program, use the code similar to below
    ReqCompletion lRC;
    //get handle on request completion object for reporting status
    lRC = pCpContext.getReqCompletion();
    lRC.setCompletion(ReqCompletion.WARNING, “WARNING”);

  59. Oracle 11g Interview Questions

  60. Question 37. Can You Extend And Substitute A Root Am ( Application Module) In Oa Framework Using Jdeveloper?

    Answer :

    You can extend the AM in jDeveloper, but it doesn’t work( at least it didn’t work in 11.5.9).

  61. Question 38. Framework Screens To Meet Your Corporate Standards. How Will You Do It?

    Answer :

    You will need to do the below steps:

    • Go to Mid Tier, and open $OA_HTML/cabo/styles/custom.xss
    • Enter below text( change colours as needed)

    • cd $OA_HTML/cabo/styles/cache
    • Take a backup of all the css files.
    • Delete all the files of following pattern oracle-desktop*.css

    The idea here is to delete the cache. Next time when you logon to Oracle Apps Self Service, the Framework will rebuild the css file if found missing for your browser.

  62. Question 39. In Oa Framework Self-service Screen, You Wish To Disable A Tab. How Will You Do It?

    Answer :

    Generally speaking, the tabs on a OA Framework page are nothing but the SubMenus. By entering menu exclusion against the responsibility, you can remove the tab from self service page.

    In self service, you wish to change the background color and the foreground text of the OA

  63. Question 40. How Will You Open A Bc4j Package In Jdeveloper?

    Answer :

    Oracle ships a file named server.xml with each bc4j package. You will need to ftp that file alongside other bc4j objects(VO’s, EO’s, AM, Classes etc).

    Opening the server.xml will load the complete package starting from AM(application module). This is a mandatory step when building Extensions to framework.

  64. Recruitment Interview Questions

  65. Question 41. You Have Written A Java Concurrent Program In Oracle Apps. You Want To Modify The Classpath Such That New Class Classpath Is Effective Just For This Program?

    Answer :

     In the options field of the concurrent program you can enter something similar to below.

    -cp :/home/xxvisiondev/XXDEVDB/comn/java/appsborg. zip:/home/xxvisiondev/XXDEVDB/comn/java

  66. Question 42. How To Debug A Document Manager In Oracle Apps?

    Answer :

    Document manger runs within the concurrent manager in Oracle Applications.  When an application uses a Document Manager, it sends a pipe signal which is picked up by the document manager.

    There are two mechanisms by which to trace the document manager

    • Set the debugging on by using profile option
      • STEP 1. Set profile option “Concurrent:Debug Flags” to TCTM1

    This profile should only generate debugs when set at Site level(I think, as I have only tried site), because Document Manager runs     in a different session.

      • STEP 2. Bounce the Document Managers
      • STEP 3. Retry the Workflow to generate debugs.
      • STEP 4. Reset profile option “Concurrent:Debug Flags” to blank
      • STEP 5. have a look at debug information in table fnd_concurrent_debug_info
    • Enable tracing for the document managers

    This can be done by setting profile option “Initialization SQL Statement – Custom” against your username before reproducing the issue. The value of this profile will be set so as to enable trace using event 10046, level 12.

  67. Oracle apps Interview Questions