Oracle Database Discussions

Hi All

My environment is EBS since doubt in database audit am raising the discussion here.

Db:11.2.0.3

EBS:R12.1.3

I have enable the audit for database level with parameter audit_trail=db

now i can see the entries in sys.aud$ table

below is the query to fetch the data and showing to client on daily basis

SELECT OS_USERNAME,USERNAME,USERHOST,

EXTENDED_TIMESTAMP,OWNER,OBJ_NAME,ACTION_NAME,Sql_Text

FROM DBA_AUDIT_TRAIL

WHERE USERNAME IN ('APPS','SYSTEM','SYS')

AND TRUNC(EXTENDED_TIMESTAMP) = TRUNC(SYSDATE -1)

AND USERHOST NOT IN ('DB001','APP001')

ORDER BY TIMESTAMP DESC

Now what i observed is object name is missing in report

I have executed a procedure with name XX% but in report i can see obj_name is different

Please suggest how i can get the exact object name which i have executed.

Regards

Shaik