10 Replies Latest reply on Jun 12, 2008 3:43 PM by Discoverer2

    HRMS APIs -- How to Load Monthly Deductions

    Discoverer2
      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
          asimshafi
          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
            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
              Discoverer2
              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
                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
                  628919
                  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
                    Discoverer2
                    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
                      asimshafi
                      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
                        Discoverer2
                        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
                          asimshafi
                          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
                            Discoverer2
                            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