in oracle hrms.there are some mandetary field.how to change
mndatory field to non-mandetory field.exmp-in people enter
table sss num is mndatory field .how to change it non-
mandetory?

Answer Posted / balakrishnaraothota

select newtable as create col3,col2,col1 from oldtable

then rename the table
ex:if oldtable is table1 having c1,c2,c3 now we want
c3,c2,c1 then u need to use above query

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are 2 modes of date track in Oracle APPS?

731


can you do fnd_request.submit_request from sql plus in oracle?

756


What is soft coded key flexfield in oracle hrms?

1045


What are the various levels where you can Set up Payroll Costing Accounts? Which levels take the highest precedence?

709


Dear Professionals, Please mention & explain about the forms which we are using against the requirement Ex:RD010,RD0100,MD05O,MDO7O....etc Kindly explain the purpose & the importance above mentioned docs. Please mentioned other docs which we are using I would be grateful for your valuable comments Regards, Rahul G

2290






How many types of payrolls are there?

749


What is bus group id? Explain its importance.

698


Explain the steps involved in implementation of oracle hrms.

707


What is advanced benefits module in Oracle HRMS?

736


how to restrict the users to see the payroll data employee wise, they only can setup the basic elements and pay bonuses but cannot see the gross salaries of employees?

691


Explain its importance of bus group id?

660


Can you run payroll processes and reports multi-lingually?

711


How does date tracking happens in hrms?

703


How do you define B.G?

736


Hi... I have completed my M.B.A in 2012 but I've not any domain experience. I want to learn oracle HRMS is it good for me.How is market for this technology? pls suggest me.

1290