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.
Hi @User_BXJIB,
Can you please provide some more information like:
It'll help to investigate and finding resolution.
Thank You!
Cheers,
Can you please confirm the exact details for what modules you need or your are looking for a specific object?
Thanks.
Hi @Bhaskar Konar ,
I'm looking for the product payables and the business object type and invoices.
Hi MandeepGupta,
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.
AP_INVOICES_ALL_
Based on below three columns you can design your custom report.
AUDIT_ACTION_TYPE_
AUDIT_CHANGE_BIT_MAP_
AUDIT_IMPERSONATOR_
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.
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
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.
Hi, I'm new to OTBI & FDI and need your help. Is it possible to do a report to identify missing default expense account in FDI or OTBI? Thanks for your help.
Hi Team We are using SCM- Maintenance subject areas for reporting . We enabled the Asset related DFFs (CSE_ASSETS_B) under Data Configuration successfully but the Asset DFFs are not reflecting under Descriptive Flexfield Folder . We do not see any Asset folder even under the Descriptive Flexfield folder . Please advise if…
We made some changes in the Fusion UI, and those changes were reflected correctly in OTBI but not in FDI. To refresh the data in FDI, the Oracle support team advised me to reload the relevant functional area (Absence Management). I navigated to Application Administration → Human Capital Management, selected Absence…
Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past. If I add any assignment information I find no records, why?
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…
