Skip to Main Content
  • Questions
  • Last run date of a function on a menu

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Beth.

Asked: October 23, 2019 - 4:38 pm UTC

Last updated: October 25, 2019 - 5:48 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Is it possible extract the last run time of a function run on a menu from the Oracle database?

and Connor said...

Only if you store that artefact yourself.

If it just to see if that function is NOT being run, you could turn on auditing for that function (assuming it lives in the database), but be aware that we would then be tracking *every* execution of it.

There are various V$ views that might let you get a (rough) approximation, see v$sql and v$db_object_cache, but there are no guarantees in there.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Is this an EBS question?

John Keymer, October 24, 2019 - 7:34 am UTC

I might be wrong, however the wording of this question sounds like it might be E-Business Suite related, whereby you have "functions" (forms/web pages etc, not database functions) attached to a menu.

iif that is the case - then providing the "Sign-On:Audit Level" profile value is set to "FORM", this information is available in the table fnd_login_resp_forms for Forms accesses only.
Connor McDonald
October 25, 2019 - 5:48 am UTC

Thanks for the addenda

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.