Sunday, October 26, 2008

display date oracle environment refreshed

Dispaly date oracle environment refreshed

After refershing the clone a date can be displayed on the form by adding the date in the site name. This can be achieved by editing the profile option 'site name'. This can be done thru front end or backend.

Changing thru front end:

Navigation: Responsibility---Sytem Administrator

Profile--->System

In system profile option find the profile 'site name'. See the value here and add the refreshed date in the text.

Example:

Original value in the site name profile is
It is changed to



save.

Logout and login again and see the title on any form.

Changing thru back end:

Run the below query


UPDATE apps.FND_PROFILE_OPTION_VALUES SET
profile_option_value = 'TEST:'||' Refreshed from '||'Production: '||SYSDATE
WHERE profile_option_id = 125


Example:


UPDATE apps.FND_PROFILE_OPTION_VALUES SET
profile_option_value = 'Clone XXX'||SYSDATE
WHERE profile_option_id = 125



After update

Clone XXX Refreshed on 24-Oct-08

Thanks.

Happy learning.
Kutub

2 comments:

Anonymous said...

Hello. And Bye.

Anonymous said...

I {have|own|get} {a lot of|many|a great many} itunes {m4p {files|documents}|files of m4p|files in m4p} i {want to|would like to|desire to} {play|run|operate} on windows {media|medium} {player|runner|operator}, {however|but|otherwise} i {want to|desire to|wish to} {change|move|transfer} them {without|not} {downloading|loading} a {converter|converting tool|transferer}! Is there {any other {way|tool|method}|other way}? And is [url=http://www.topvideoconverter.com/m4p-converter/]{m4p converter|convert m4p tool|tool to convert m4p}[/url] {useful|?{Thanks for your {help|assistance}|Thanks for any help|Thank you for all help}!