anu radha
can anyone plz help with of how to,Created a process to load one time deductions for payroll using Application engine and component interface

Thank you for posting your question

Answer

Please find out the underlying component definition for One time deductions and then create a CI for the same. Now drag and drop this CI into an App Engine so that the code will be generated automatically. In this code you will have to give the filename/ filepath as the name and path of the excel sheet (.csv or if text file, .txt) where you have consolidated One time deductions. You will also have to create a filelayout corresponding to the fields you have included in the excel sheet and create rowset for the same. Then in the code, you will have to give the CI name and involved record names at different levels to create collections to insert data. Also you will have to give the filelayout’s recordname.fieldname value so that you can assign values for different fields in Database.

In case of any further issues/ doubts, please let us know.

Bhaskar :
January 23rd, 2010 at 9:48 pm

Hi Experts,

I have a small design issue.i need to buid a page using a existing record with out adding any fields and not to change any existing key structure.
**we can use any newly created records,views****
existing Record fields :-
1)source — Key
2)Run_dt — Key (MM-DD-YYYY)
3)Descr

design should be user can search based on the year(YYYY).
Add mode user should see two fileds (source,year) and in the below grid he can enter run_dt for that year and can save/update/inser

Thank you for posting your question

Answer

For your issue create a view using
a) Source
b) year(part of run date)

(Select distinct Source, year(run_date) from

Mark year as the search key and both source and year as the list, Use this view as search record. Hope this solves the issue.

Thanks

Gautam S

To add on to the below point,

The Oracle equivalent of “year” function is “Extract”.

e.g. SELECT DISTINCT SOURCE, EXTRACT(YEAR FROM RUN_DT) FROM TABLE

Thanks

Shanmugavel

Posted by Senthil Kumar Theagarajan
Comments (0)
February 7th, 2010

Comments (0)