Skip Navigation
Expand
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.