Take FREE!! Online Mettl Mock Test to Crack TechM and Other Companies Written Exams.
Get Off-Campus Placement Jobs Info !!!
Practice Tech Mahindra Essay Topics

Technical Interview Questions and Answers :: Oracle Apps HRMS

    91 / 106

    How to use an API to upload the data?
    Answer:



    • API package contains many procedures to insert/update/delete the application data.



    • The API is not executed on its own, the API must be called or executed by other pl/sql program.



    • The API package should never be modified for custom use, if modified Oracle will not be able to support them.



    • None of the HRMS APIs issue commit, the calling module should manage the commit of the transaction.


    Please Login First :

    92 / 106

    How to identify the Package name and version of the API?
    Answer:

    SELECT text FROM all_source WHERE name like ‘HR_EMPLOYEE_API%’ AND text LIKE ‘%Header%’;

    Please Login First :

    93 / 106

    Where can you find information on an API and its parameters?
    Answer:

    Review the package header file for the particular API file (.pkh).

    Please Login First :

    94 / 106

    What is Object version number and how do you assign values for it in an API?
    Answer:


    • Object Version number is an assigned number to a row in a database table.

    • When a new row inserted its number is set to 1

    • If any updates performed on the row then the Object version number is incremented.

    • Every API has the p_object_version_number control parameters.

    • For create APIs this parameter is defined as an OUT parameter the API assigns the Object version number to be 1 for row inserts.

    • For update APIs the parameter is defined as IN OUT, for update API the object version number is mandatory.

    Please Login First :

    95 / 106

    When the HR_7155_OBJECT_LOCKED raised?
    Answer:

    The current value of object_version_number must be passed in the API call and it is compared to the version on the row in the table.


    If the versions are different then the HR_7155_OBJECT_LOCKED is raised.

    Please Login First :

    96 / 106

    What is the p_validate control parameter?
    Answer:

    Every API has a "p_validate control" parameter.

    When the parameter is set to FALSE then all the business function validation is performed.

    If every thing is validated then row can be Inserted/Updated/Deleted.

    If p_validate is set to TRUE then only the actual operation is validated.

    A savepoint is issued at the start of the call and a rollback is done at the end of the call.

     

    Please Login First :

    97 / 106

    Can you use an API on an application table on which an event-based alert is defined?
    Answer:


    • No, if an event-based alert defined on an application table then the API will give error.

    • To run API the alert has to be disabled and re-enabled after the API has been executed.

    Please Login First :

    98 / 106

    What are the types of Element Entry?
    Answer:

    There are four types




    • Normal Entry



    • Override Entry



    • Additional Entry



    • Adjustment Entry



      • Additive Adjustment

      • Replacement Adjustment

      • Balance Adjustment



    Please Login First :

    99 / 106

    What are the Important Tables in HRMS?
    Answer:

    1. per_all_people_f: This table will provide us the very basic information about the employee. The very data from the first screen we see when we open the "People -> Enter and Maintain" form goes into this table.
    2. per_all_assignments_f: This table will store all the information which is been entered in the employee assignment form.
    3. per_addresses: This table will store all the information which is been entered in the employee address form.
    4. per_pay_proposals: This table will store all the information which is been entered in the employee salary form.
    5. per_person_types_tl: This table is used to find the type of the employee. This table is linked with the per_all_people_f with the person_type_id to find out the type of person.
    6. per_jobs_tl: This table will contain the various types of JOBS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct job name from the employee.
    7. per_grades_tl: This table will contain the various types of GRADES in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct grade name from the employee.
    8. hr_locations_all: This table will contain the various LOCATIONS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct location name from the employee.
    9. pay_all_payrolls_f: This table will contain the various types of PAYROLLS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct payroll name from the employee.
    10. per_pay_bases: This table will contain the various types of PAY BASES in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct pay basis name from the employee.
    11. per_assignment_status_types_tl: This table will contain the various types of assignment types in oracle. The assignment types generally would be "Active Assignment" etc. This table is been linked with the per_all_assignments_f table to retrieve the correct job name from the employee.
    12. per_person_type_usages_f: This table will store the correct person type of the particluar employee. We should never depend on the person type present in the per_all_people_f table. Instead, we need to link the person_id with this table and get the correct person type.

    Please Login First :

    100 / 106

    What are Date Track Tables?
    Answer:

    Every update in the Table, we will save the change in the form of a Record to provide the facility to find the information at any point of time.
    These tables are post fixed by _F

    Please Login First :



Go through the frequently asked Oracle HRMS Interview Questions and Answers at Freshers & Experienced Level by Interviewers. Multiply your selection chance by going through the Oracle HRMS Interview Questions with Answers by expert members with experience in Oracle HRMS, which will Help the job seeker at Freshers and Experienced level to get a better job.

You can check latest and updated Oracle apps HRMS Technical Interview Questions and Answers for Experienced on this page. you can be filtered the questions by companies name or can be saved to the Reading List using TO READING LIST, and see through them anytime anywhere you want.