Need backend query to fetch audit details of Job profile

Anjana Bharidey

Hi,

We have enabled audit for jobs and trying to fetch the job profile details through BIP Report who, when and what are the changes that are made but somehow we couldn't be able to fetch the details. Can you please confirm if there is any way to fetch these details.

Any inputs or suggestions is appreciated.

Thank you,

Anjana.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/26916/need-backend-query-to-fetch-audit-details-of-job-profile

Welcome to the Oracle Analytics Community, Anjana.

You can audit only the changes for profile items. Enable audit policies. Once done, the audit data will be stored in HRT_PROFILE_ITEMS_ table.

But if you are looking for changes specific to job profile only not related items, then unfortunately, it is not supported.

Thanks.