Yes Sankar, I am able to load the file manually using Web Client.

I did posted on Siements knowledge base community, but no luck for me in getting any insights.

Can you help me out with any siemens community url or any other forum related to siemens team center 11 PLM. Thanks,

Thanks Donald. That worked. Thanks a lot. Increased a character in the AutoNumbers node. and we were able to load the files. Much Appreciated.

Thanks a lot Kevin, much appreciated. I got the logic now, You made my day. Your awesome.
Thanks again.

Thank a lot Kevin, much appreciated. I got the logic now, You made my day. Your awesome.
Thanks again.

I am in Eastern Standard Time.

Sorry Kevin, I tried changing NLS parameter by going to tools preferences database and nls parameters option.
Then I changed the data format.
Then I ran the item history query, it got resolved, it is showing the time values now.

Thanks a lot for your help. Much appreciated.

Yes Kevin, I tried exactly what you said.

select sysdate from dual is showing date with time values. But if i ran the item history query, it is showing date wit time values as 00:00:00

it is not fetching the time values for some reason. not sure what to do

Yes John, I even tried that before, forgot to mention about it.

after setting up the NLS Data format, it is showing up time values but the query is fetching only 00:00:00 values.

It is not showing the correct values what Agile 8.5 front end is showing.

It is becoming really tough to find the time stamp values where it is stored in database (not in item history table – timestamp column).

Can you please help me out with this.

Thanks,

Hello Kevin,

Thanks for your reply.

The query you gave fetches me just the date, not date with time.

Ex: for an item – create part – showing in Front UI is :- 4/10/2018 8:19:16 AM
but in item history table, in timestamp column it is fetching just the 4/10/2018.

I need to fetch the time values too along with date for “create part from” action in Agile 8.5 PLM.

Could you please help me out with this.