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
Messages: 87
Registered: September 2005
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.


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
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 ?
Re: Date Stored in a attribute [message #317009 is a reply to message #181102] Tue, 29 April 2008 02:51 Go to previous message
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...
Previous Topic: iProcurement,iExpences,iReceivables,iPayments
Next Topic: Problem with Custom Tables Registration
Goto Forum:

Current Time: Thu Aug 17 03:06:00 CDT 2017

Total time taken to generate the page: 0.14546 seconds