How do i know who has called a pl/sql function inside a procedure when i perform a certain action from fontend(Oracle Apps)?

I have a pl/sql package: FND_PROFILE.

I perform some actions from the frontend, which should trigger calls to FND_PROFILE.VALUE_SPECIFIC

I need to find who has made these calls.

There were suggestions to use PL/SQL Debugger in JDeveloper. Can somebody please help me out?

Answers


use audit

audit execute on FND_PROFILE;

To see who ran some function/procedure in the package query dba_audit_trail


Need Your Help

Rails + Paperclip - NoMethodError in Projects#index - undefined method `image' for nil:NilClass

ruby-on-rails paperclip nomethoderror

I have a rails app with a Project model and a nested Pictures model. Im using the Paperclip gem to upload images to the pictures model, and nested_form gem to nest the Picture model within the proj...

Read back texture coordinates from rendered image in OpenGL?

opengl textures

If I render a scene in openGL, is it possible to get back the texture coordinates that were used to paint that pixel?