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 Frequently Asked Questions
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
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
Clear Arrears == TEST
Period Type == Bi-Weekly
Thanks for your tip too, I have to build this interface automatic. Your tip is also help full in future