Answer Detail: RE: How do i recover the responsibility in apps if it ...

GeekInterview.com > Interview Questions > Oracle Apps > AOL

Print |

Question: How do i recover the responsibility in apps if it is disabled?

Answer: post your answer

February 02, 2006 02:59:08	#3
geocove	Oracle Expert Member Since: February 2006 Total Comments: 2
RE: How do i recover the responsibility in apps if it ...
Hi,Try the following:step 1:SELECT RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL, FND_RESPONSIBILITY WHERE FND_RESPONSIBILITY.END_DATE > SYSDATEAND FND_RESPONSIBILITY_VL.RESPONSIBILITY_ID = FND_RESPONSIBILITY.RESPONSIBILITY_ID;step 2:update the end_date fields for your responsibilities (query by ID in the fnd_responsibility table).good luck!