This discussion is archived
10 Replies Latest reply: Jun 12, 2008 8:43 AM by 586629 RSS

HRMS APIs -- How to Load Monthly Deductions

586629 Newbie
Currently Being Moderated
Hi there
I have to developed the interface from other systems to HRMS which extract the data from csv file to Oracle HRMS/Payroll.
This is a monthly process, should update the deductions in Oracle.

Does any one know which HRMS API I should use to populate the Oracle HRMS/Payroll.

Any help appreciated
Thanks
JOJI
  • 1. Re: HRMS APIs -- How to Load Monthly Deductions
    473096 Newbie
    Currently Being Moderated
    Hi JOJI
    If you setup your deduction as an Element, you can use PAY_ELEMENT_ENTRY_API to create element entries.

    Some Meta Link Notes:

    72310.1 Understanding and Using APIs in Oracle HRMS
    72564.1 Understanding and Using the HRMS Data Pump
    73170.1 Understanding and Using API User Hooks
    134726.1 How To Enter Data into Oracle HRMS with the Application Programming Interface (API)
    152028.1 HR Foundation (Shared HR) and APIs
    223987.1 Oracle OTL HXC TimeStore Deposit API
    276825.1 Creating Enrollment Results Using Life Events for Oracle Advanced Benefits APIs
    152284.1 Troubleshooting
    152284.1 Frequently Asked Questions


    Regards.
    ASIM
  • 2. Re: HRMS APIs -- How to Load Monthly Deductions
    489517 Newbie
    Currently Being Moderated
    You can use HR Data Pump functionality to load the deductions. Refer Data Pump functionality on metalink further details.
  • 3. Re: HRMS APIs -- How to Load Monthly Deductions
    586629 Newbie
    Currently Being Moderated
    Hi Ram
    Can you please send me the Meta link Document Number with example too?

    Thanks
    JOJI
  • 4. Re: HRMS APIs -- How to Load Monthly Deductions
    user539616 Explorer
    Currently Being Moderated
    PAY_ELEMENT_ENTRY_API should work.
    Check in the eTRM for the API functionality and how to use it.

    Thanks
    Kumar
  • 5. Re: HRMS APIs -- How to Load Monthly Deductions
    GauravSehgal Journeyer
    Currently Being Moderated
    Hi Joji
    If it is a repeated process then you may look at Web ADI functionality.
    You can upload a spreadsheet in a given format and it is less error prone especially when you are reading a data from a flat file.

    If you are only looking for uploading element entries then you can look at Batch Element Entry process (BEE) for that. You can refer the following note for BEE spread sheet interface already available.

    USING Bee Spread Sheet Interface
    https://metalink.oracle.com/metalink/plsql/f?p=130:14:6196489406080037734::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,454049.1,1,1,1,helvetica
  • 6. Re: HRMS APIs -- How to Load Monthly Deductions
    586629 Newbie
    Currently Being Moderated
    Kumar
    Thanks for Your Tip.
    Now I have used this API and I am able to create the Element for Specific Period, but I am not able to insert any Amount or Period Type.

    How I am going to update those values?
    Name---Units---Sequence—Required---User Enterable—Database Item
    Pay Value Money –1—Not Click - Not Click – Click
    Amount Money –2—Not Click - Click – Click
    Clear Arrears Character –3—Not Click - Click – Click
    Jurisdiction Character –6—Not Click - Not Click – Not Click
    Period Type Character –7—Not Click - Click – Click

    Result I am looking are
    Amount ==15.56
    Clear Arrears == TEST
    Period Type == Bi-Weekly

    Gaurav
    Thanks for your tip too, I have to build this interface automatic. Your tip is also help full in future

    Highly appreciated
    JOJI
  • 7. Re: HRMS APIs -- How to Load Monthly Deductions
    473096 Newbie
    Currently Being Moderated
    Hi JOJI
    The following is the sample code for Loading Element.


    l_effective_start_date DATE := TO_DATE('19-JAN-2008','DD-MON-RRRR');
    l_effective_end_date DATE := TO_DATE('01-FEB-2008','DD-MON-RRRR');
    l_element_entry_id NUMBER (15);
    l_object_version_number NUMBER (9);
    l_input_value_id2 NUMBER (9) := 15;
    l_create_warning BOOLEAN;
    BEGIN
    ---===============================
    -- Misc Deduction
    -- Buiness Group ID 41
    -- Element Name Misc Deduction
    -- Element Type ID 8683
    -- Priorty 5775
    -- ELEMENT_LINK_ID 1262
    l_object_version_number := 1;
    pay_element_entry_api.create_element_entry
    (p_effective_date => TO_DATE('19-JAN-2008','DD-MON-RRRR'),--TRUNC(SYSDATE),
    p_business_group_id => 41,
    p_assignment_id => 39156,
    p_element_link_id => 1262,
    p_entry_type => 'E',
    p_effective_start_date => l_effective_start_date,
    p_effective_end_date => l_effective_end_date,
    p_element_entry_id => l_element_entry_id,
    p_input_value_id1 => 2532,
    p_entry_value1 => '15.00',
    p_object_version_number => l_object_version_number,
    p_create_warning => l_create_warning
    );
    COMMIT;
    END;


    Thanks
    ASIM
  • 8. Re: HRMS APIs -- How to Load Monthly Deductions
    586629 Newbie
    Currently Being Moderated
    Hi Asim
    Thanks for your reply.
    But I am not able to create Element for my deduction, I also have the following Input values!

    Clear Arrears == TEST
    Period Type == Bi-Weekly


    Thanks
    JOJI
  • 9. Re: HRMS APIs -- How to Load Monthly Deductions
    473096 Newbie
    Currently Being Moderated
    Hi JOJI
    Can you please check at Element --Input Values and see If there is a Lookup defined?

    I think you might have the Lookup there, which may not have defined that values "TEST" at Clear Arrears OR "Bi-Weekly" at Period Type.

    Thanks
    ASIM
  • 10. Re: HRMS APIs -- How to Load Monthly Deductions
    586629 Newbie
    Currently Being Moderated
    Hi Asim
    Now I am able to load element, thanks for your help.

    The correct values are Clear Arrears 'N' AND Period Type 'BI-WEEK'.

    Thanks all for participated this Thread
    JOJI