OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » sysdate (form 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sysdate [message #476885]

Mon, 27 September 2010 03:58

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

i designed the custom form
in that i want store sysdate to creation_date column
it store only date
i want to store date with time.....

i try as to set format mask as MM/DD/YYYY HH24:MI:SS to creation_date column

column data type is date

then on pre form i set as

forms_ddl('alter session set NLS_DATE_FORMAT = ''DD-MON-YYYY HH:MI:SS ''');

but still in db i am getting date only

how to resolve this..?

Report message to a moderator

Re: sysdate [message #476891 is a reply to message #476885]

Mon, 27 September 2010 04:25

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you try to change item's datatype from DATE to DATETIME?

Report message to a moderator

Re: sysdate [message #476907 is a reply to message #476891]

Mon, 27 September 2010 05:57

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

yes i alter column and set to datetime datatype still i am getting date only.........

Report message to a moderator

Re: sysdate [message #476913 is a reply to message #476907]

Mon, 27 September 2010 06:15

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Strange.

Quote:

but still in db i am getting date only

How did you check that? In SQL*Plus? Did you ALTER SESSION so that query returns both date and time?

Report message to a moderator

Re: sysdate [message #476928 is a reply to message #476913]

Mon, 27 September 2010 06:39

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

if i write
select sysdate from dual
then it showing date and time both
but as i
select creation_date from custom_table
it show only date

now i change data type of column to datetime
still i get date in my custom table

Report message to a moderator

Re: sysdate [message #476931 is a reply to message #476928]

Mon, 27 September 2010 06:42

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

i tried by alter seesion as well but still time not get store in custom table

Report message to a moderator

Re: sysdate [message #476943 is a reply to message #476931]

Mon, 27 September 2010 07:02

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't have Forms 6i so I did a test on my Forms 10g (9.0.4) connected to 10g XE database.

I created a table:

SQL> create table test (col date);

and used Data Block Wizard to create a default form. This is item's Data property palette:

/forum/fa/8301/0/

I ran the form and entered a value:

/forum/fa/8302/0/

Then I saved changes and went to SQL*Plus:

SQL> alter session set nls_date_format = 'dd.mm.yyyy hh24:mi:ss';

Session altered.

SQL> select * from test;

COL
-------------------
30.09.2010 09:45:00

SQL>

It seems that everything is fine. I really wouldn't know what went wrong in your case (unless Forms version difference makes such a difference).

Attachment: forms_date.PNG
(Size: 7.21KB, Downloaded 1833 times)
Attachment: forms_date_2.PNG
(Size: 2.82KB, Downloaded 1838 times)

Report message to a moderator

Re: sysdate [message #476971 is a reply to message #476885]

Mon, 27 September 2010 09:51

eric62
Messages: 24
Registered: January 2009

Junior Member

Hello.

Do you use FND_STANDARD.SET_WHO ?

Report message to a moderator

Re: sysdate [message #477024 is a reply to message #476971]

Tue, 28 September 2010 00:06

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

@eric62
no i am not using that...
because the form design in 6i and same form will working on oracle apps server as well as chinab server so
on other server it fails

Report message to a moderator

Re: sysdate [message #477654 is a reply to message #476885]

Sun, 03 October 2010 02:05

aheli
Messages: 10
Registered: August 2008
Location: India

Junior Member

Go to the Property of the field in the customized form in Forms 6i -> Change Datatype of the Field from Date to Datetime and then give the Date Format.
then run the form and it will insert Date as your desired format.

Report message to a moderator

Re: sysdate [message #477657 is a reply to message #477654]

Sun, 03 October 2010 02:37

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, that was the very first suggestion here (which, as it appears, didn't help). Any other idea, perhaps?

Report message to a moderator

Previous Topic:	HR Person API Update
Next Topic:	Payables transfer to GL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 13:01:39 CST 2024