Home » Applications » Oracle Fusion Apps & E-Business Suite » Date Stored in a attribute
Date Stored in a attribute [message #181102] Thu, 06 July 2006 15:10 Go to next message
mchittib
Messages: 87
Registered: September 2005
Member
I am having a dff and the value set defined for this attribute is of Standard date type format.

I am updating DFF using API.

When I insert a date into this field its storing in the table as YYYY/MM/DD and
if i insert 05-JUL-2006, it is stored as 2005/07/06 and when i go to front end i see the DFF its display as 06-JUL-2005.

How can i correct this.

Thanks,
Mchittib.

Report message to a moderator

Re: Date Stored in a attribute [message #181215 is a reply to message #181102] Fri, 07 July 2006 08:16 Go to previous messageGo to next message
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
Are you using FND_STANDARD_DATE value set ?
How are you inserting/updating this field ? Which API are you using ? How are you calling that API ?

Report message to a moderator

Re: Date Stored in a attribute [message #317009 is a reply to message #181102] Tue, 29 April 2008 02:51 Go to previous message
unthirudan
Messages: 3
Registered: July 2007
Location: India
Junior Member
Hi all,

I too am facing the similar problem... Here i have something like Special Information Type defined like Rewards. I have a segment with FND_STANDARD_DATE type, I faced the similar problem like the one above..

I used hr_sit_api.create_sit api, where i passed the sysdate for the corresponding segment defined as FND_STANDARD_DATE..

Can anyone give us a clear view on how to correct this problem...

Report message to a moderator

Previous Topic: iProcurement,iExpences,iReceivables,iPayments
Next Topic: Problem with Custom Tables Registration
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 19:07:07 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.