Monday, September 5, 2011

Oracle Apps: HRMS - Set Effective Date for a Session through database

-- Following query can be used to set Effective Date for a session . This is particularly required while you are working with Oracle HRMS related tables.

INSERT INTO fnd_sessions
  (session_id
  ,effective_date)
  (SELECT userenv('sessionid')
         ,SYSDATE
   FROM dual
   WHERE NOT EXISTS (SELECT 'c'
          FROM fnd_sessions s1
           WHERE userenv('sessionid') = s1.session_id));

No comments:

Post a Comment