Collapse
Submit a Service Request
Contact Information for Technical Support
My Service Notifications
Audit logs for non-transactional records
Answer ID 12722 |
Last Review Date 10/16/2023
What is the mc_trans table?
Environment:
Oracle B2C Service
Resolution:
When looking at a non-transactional record in your Oracle B2C Service application, the audit log lists a series of actions that have affected that record, including when the record was created, events that occurred related to the record, and by whom. Items are listed in reverse chronological order.
Record types that use mc_trans for its audit log:
24 - Accounts 39 - Queues 15 - Custom Fields 38 - Variables 22 - Standard Content 42 - SLAs 30 - Holidays 46 - Response Requirements 26 - Interfaces 28 - Mailboxes 147 - Data Import Templates 141 - Data Imports 96 - Currencies 812 - Exchange Periods 151 - Contact Roles 202 - Label Menus 150 - Sales Periods 100 - Price Schedules 93 - Product Catalog 149 - Sales Territories 88 - Strategies 176 - Topic Words 19 - Statuses 31 - Billable Tasks 363 - Channel Types 40 - Contact Types 49 - Countries 50 - Organization Address Types 11 - Answer Access 65 - Hierarchical Menus 32 - Profiles 172 - Client Workflows 104 - Email Lists 119 - Email Addresses 337 - Pending Custom Classes 392 - Service Update Notifications 539 - Pending Object Event Handlers 405 - Configuration Base Entries 411 - Message Base Entries 559 - SSO Service Applications 560 - SSO Service Providers 558 - Certificates & Keys 610 - Skills 258 - Guided Assistance Guides 271 - Add-Ins 21 - Languages 670 - SSO SAML Identity Providers 671 - Event Subscriptions 654 - Pending Permission Set Filters 655 - Pending Permission Sets 658 - Pending Role Sets 659 - Pending Roles 709 - Probes 712 - Resource Pools 711 - Managed Applications 308 - Channels 728 - Oauth Client Applications 729 - Oauth Providers 754 - Data Lifecycle Policy 218 - Navigation Sets 334 - Pending Custom Attributes |
Note:
The mc_trans table does not have analytics visibility, So it is not available to be used in a report. This is the expected product behavior.