Who's Online
1 registered (Chris Abraham), 2 Guests and 7 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
P11d's
by Chris Abraham
0 seconds ago
Oracle eBsuiness HRMS Trusted Recon Query Help
by CT
Today at 02:24 PM
Concurrent Request - running slow
by CT
Today at 12:48 PM
Pension Auto Enrolment
by delboy
Today at 12:13 PM
Oracle eBsuiness HRMS Trusted Reconcilaition Help
by Mani
Today at 07:35 AM
Element to recover value in balance on leaving
by jkavia
Yesterday at 11:04 AM
Assignment EIT not displaying in Self Service
by CT
Yesterday at 06:45 AM
Vehicle Mileage Setup
by Chris Abraham
21/05/12 12:24 PM
In which table is external learning data stored
by DMC
21/05/12 08:45 AM
Oracle Payroll and Cash Management
by Gus
20/05/12 11:27 AM
Top Posters (30 Days)
CT 40
delboy 39
Vigneswar Battu 15
pat.woodall 10
Mani 6
Gus 4
bcooper 4
Ryan 3
Jan 3
DMC 3
(Views)Popular Topics
Family Pack K issues thread 20170
CREATE_GRADE api returns:PLS-00306: wrong number o 15200
Still trying to locate... 13855
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 11907
Viewing Output of another user 10324
HR_PF.K RUP4 10298
Review of my Release 12 laptop 9747
Enhanced Retro & Release 12 9402
Adding a taskflow button to a form 9140
Family Pack K 7910
Topic Options
Rate This Topic
#7059 - 10/11/11 04:31 PM Salary Data Migration
Vizay Offline
regular

Registered: 01/03/11
Posts: 27
Loc: Hyderabad
All ,

Please clarify me the below doubts

1. Is it possible to create salary components with out base salary ?

If yes what is the API that needs to used?

Currently we are using the API -> hr_upload_proposal_api.upload_salary_proposal

Clarify pls.

Thanks
VJ--
_________________________
Vijay--

Top
#7060 - 11/11/11 10:09 AM Re: Salary Data Migration [Re: Vizay]
CT Offline
Guru
***

Registered: 11/03/05
Posts: 1188
Loc: Bath
If I have understood you correctly, you are looking to create a salary proposal without a 'total' salary figure, but then want to create one or more proposal components that then sum together to make up the total?

There are parameters in that API that allow you to specify components - however, these cannot be set if it is the first proposal for an employee. I believe you don't have to provide an actual proposal figure if you are specifying one or more components; however, you do need to include the parameter. So I would guess that supplying the 'total' salary parameter with a null and then supplying one or more components should do the work for you. Having said that, even if it didn't, it shouldn't be too difficult a task to come up with the sum of the component figures ahead of the API call, and then supplying that figure as well.
_________________________
L&K
CT

Remember: A dog is for life, not just for Christmas... unless you're in Korea

Top
#7061 - 11/11/11 12:41 PM Re: Salary Data Migration [Re: Vizay]
CT Offline
Guru
***

Registered: 11/03/05
Posts: 1188
Loc: Bath
As an aside, there is another API you can use: HR_MAINTAIN_PROPOSAL_API. This has the procedure insert_salary_proposal; also, it has the procedure cre_or_upd_salary_proposal, which gives you further options.

Historically, the API you are using was for spreadsheet uploads (mass salary updates etc) via what was then called ADE (now Web-ADI)

One disadvantage in your case with this alternative API, is that you will need a separate API call to do the component loading - the procedure insert_proposal_component in the same package. Having said that, you won't need to explicitly set up 10 lots of component-related parameters, most of which probably won't be needed. So pay your money, take your choice!
_________________________
L&K
CT

Remember: A dog is for life, not just for Christmas... unless you're in Korea

Top



Moderator:  bcooper, CT 
Forum Stats
792 Members
48 Forums
1584 Topics
7663 Posts

Max Online: 67 @ 14/04/12 05:38 PM
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters
CT 1188
bcooper 1112
delboy 597
Geoff Dixon 369
SBi 356
vkumar 223
kp_rapolu 213
cbrookes 197
Gavin Harris 163
Gus 146
May
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31