Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Customer Audit Report - Extension Request

21
Views
1
Comments

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Johnson Controls Inc

Description (Required):

We have an Audit Requirement specific to Customer Master Data Changes wherein Compliance team would like to trace list of all changes done at the Customer master level

Pertaining to that we have reviewed the Seeded Out of Box Report (Generate Audit Report) and feedback from compliance team is that they would like to request for two More Additional Columns to that report

1) Customer Number

2) Customer Name

Currently we have party Number in Description Field but that's not deemed efficient as per Business feedback and ask is to have it as individual additional columns

This will give business flexibility to filter , analyze and report efficiently . We would highly appreciate if the report can be extended to include those two fields

Use Case and Business Need (Required):

Problem Statement :

Seeded 'Generate Audit Report' For Product Family Receivables doesn't contain Customer Number & Name as an individual columns

User Story :

As a compliance team specialist we have to ensure that we monitor and efficiently report all the changes done at the customer master level as per SOX Governance Process . Currently unable to do that since the Audit Report doesn't contain customer Number & Name and its causing significant inconvenience to report and adhere to compliance process

Workaround :

We are doing text delimited separation for the Field 'Description' to separate the Party Number and doing VLOOKUP with Master data to retrieve the Customer Name and its really cumbersome

Ask :

Add below fields to the existing report

1) Customer Number

2) Customer Name

Enhancement Request / Service Request: g

3-28503302471 ,3-28400381001,3-28466196751

2
2 votes

Submitted · Last Updated

Comments

  • User_YFX37
    User_YFX37 Rank 1 - Community Starter

    Hi Team,

    we have business requirement to modify customer audit report to add below columns

    1. Stamping: Who downloaded, time, date, and User ID
    2. Customer Name
    3. Customer Number
    4. SFDC ID; if Applicable
    5. Customer Class
    6. Site Number

    if anyone know how to modify/enhance audit reports please help us.