How to do Reclassification in Fixed Assets in R12?

Go to asset work bench, query the asset and click open.

Then directly change the category and click Done.

That's all.

If you want to do unit adjustments then

go to asset work bench and query the asset.

then Click assignments and then in first line give units in minus in units change (to decrease)

then click done.

Same way you can change the location. in same screen just give another location with some units.

How to select the column from Hr_employees table in R12?

Hi All,

HR_EMPLOYEES table have pgb.name column.

But while writing it in select, we are getting error. So How to use it in Select?

If you want answer drop a mail to kommarajashekarreddy@gmail.com

so while querying that column you should write like this only....

select he."PBG.NAME" from hr_employees he

Password Related Profiles in Oracle Applications R12

Hi,

In Oracle applications R12 we have some profile options regarding password. To set password case, length, No Reuse ..etc.

 

Signon Password Case

Signon Password Length

Signon Password No Reuse

Signon Password Hard To Guess

Signon Password Failure Limit

Signon Password Custom

 

These are all system profiles.