Mapping Audit Report — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Mapping Audit Report

edited Jun 9, 2025 6:17PM in Financial Consolidation and Close 2 comments

In FDM we used to have custom reports for audit mappings. How do we create custom reports in FCCS? The standard mapping audit report in data management is formatted in a way that is unusable. The data needs to be in a table format to allow for analysis. I have attached a file with the report script that we used to have in FDM that produced the following:

  • Output was table format by log event
  • User selectable starting and ending date for changes
  • User selectable location. It could be all (including both active and inactive location), a specific location only, or a custom view that was called "All Active Locations". We would rename locations to have a leading "zzz_" when a location became inactive and this report would exclude querying anything starting with" zzz_" if we pulled on only all active. Even if that is not possible the main goal is to get a table format output since the current standard report layout is unusable.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!