Categories
I want to build audit report but i can't able to find auitable code or tables for reference
or else any suggestion for reference please it will be helpful
needed fields
Date,
User,
Event Type,
Bussiness Object Type,
Description,
Attribute,
Old Value,
New Value.
Answers
-
Hi @User_BXJIB,
Can you please provide some more information like:
- Which product / area are you using here?
- Have you tried OOTB audit reports?
- Is audit already enabled for the areas that your are looking for the report?
It'll help to investigate and finding resolution.
Thank You!
Cheers,
0 -
Can you please confirm the exact details for what modules you need or your are looking for a specific object?
Thanks.
0 -
Hi @Bhaskar Konar ,
I'm looking for the product payables and the business object type and invoices.
0 -
Hi MandeepGupta,
I'm looking for the product payables and the business object type and invoices.
0 -
Hi,
If you are looking for an exact replica of audit information that you see from UI audit reports, that is difficult to get. Are you facing any challenges with seeded audit reports?
You can however build your custom logic. For all objects where audit is available, a corresponding shadow table exists (with same name as database table but end with an underscore). In your case, the table will be AP_INVOICES_ALL_ . So, if audit is enabled, you will see data in this table.
Based on below three columns you can design your custom report.
AUDIT_ACTION_TYPE_
AUDIT_CHANGE_BIT_MAP_
AUDIT_IMPERSONATOR_
Thanks.
0 -
Hi MandeepGupta,
How we are going to extract the the fields that are changed this is not the case i think here we have to use audit tables.
By this process we need to compare each and every column of two tables how we are going to do that.
0 -
As per my knowledge, there is no direct way to extract that data from a single table. Please check similar thread:
Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A — Oracle Analytics
Thanks.
0 -
Hi @User_BXJIB,
Please take a look into the following post where '' has outlined few details which might be helpful for your understanding and as a starting point.
Audit trail - Supplier, Invoices and Payments in Oracle Fusion — Cloud Customer Connect
Hope this help.
Cheers,
0
