1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Timestamp on Termination Form for Employee

Discussion in 'Oracle HRMS & Payroll' started by Bharat, May 13, 2013.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi all,

    how to terminate an Employee or User with Time stamp. When We terminate an Employee or user its not allowing us to enter Time. Is there any solution to terminate an User/Employee with time like (10-may-13 05:00:00)?
     
  2. a_kamalraj

    a_kamalraj Forum Advisor

    Messages:
    121
    Likes Received:
    23
    Trophy Points:
    280
    Hero,

    What is the need for Timestamp for you...?

    Cheers
    Kamal
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Love,

    If we End-date an user with some timestamp like (14-may-2013 05:00:00), then that particular user can access oracle till 5 on that day. For this purpose I want to provide End-Date field with Timestamp
     
  4. sivaramakrishna.d

    sivaramakrishna.d Active Member

    Messages:
    61
    Likes Received:
    6
    Trophy Points:
    160
    Dear Bharat,

    If you want to change your date to capture along with time stamp.
    better change the format mask of that item through application.
    Navigation : Help --> Diagnstics --> Properties --> Item

    I didnt tried this but u can check it.I hope this will work out.

    Siva Ram
     
  5. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Sivaram,

    Its not allowing to change the Datatype property. And Update Button is Grayed out.
     
  6. sivaramakrishna.d

    sivaramakrishna.d Active Member

    Messages:
    61
    Likes Received:
    6
    Trophy Points:
    160
    Dear Bharat,

    I have tested it. Its working fine.
    Change the format mask of the Actual Termination date.
    I asked you to change the format mask not datatype.

    Siva Ram
     
  7. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Sivaram,

    Its working fine when form is opened and trying to enter timestamp. But after closing the form and again when re-opening the form its not allowing me to enter timestamp.

    Please suggest how to set this property permanently.
     
  8. sivaramakrishna.d

    sivaramakrishna.d Active Member

    Messages:
    61
    Likes Received:
    6
    Trophy Points:
    160
    Dear,

    Do the same through Form personalization.In when new form Instance trigger

    Siva Ram
     
    Bharat likes this.
  9. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Sivaram,

    Working fine with Personalization. Done as suggested by providing Format_Mask as DD-MON-YYYY HH24:MI:SS.
     
  10. sivaramakrishna.d

    sivaramakrishna.d Active Member

    Messages:
    61
    Likes Received:
    6
    Trophy Points:
    160
    Good dear...

    keep on posting your challenging issues,It will be a good learning for every one.

    Siva Ram
     
    sambuduk and Bharat like this.
  11. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Siva Ram,

    As your suggestion user end date field is personalized and working fine.

    When we trying to do the same for user responsibilities to end date with time stamp, its allowing us to enter with timestamp and record got saved fine. After requerying the record again its showing as 00:00:00.

    Can you please suggest on this to end date user responsibilities ?