120 likes | 235 Vues
This document provides an in-depth overview of the architecture and configuration of Oracle GRC, focusing on the Change Tracker and Snapshot features within the E-Business Suite (EBS) and PeopleSoft setups. It discusses essential elements such as the metadata objects that describe forms and pages, relationships between columns, and filtering mechanisms for snapshot results. Insights into the usage of the Configuration Governor for tracking changes to business tables along with insert, update, and delete audit trails are also included, ensuring effective governance and compliance.
E N D
Configuration Controls GovernorTECHNICAL INTRODUCTION Oracle GRC Strategy – Barry Greenhut May 2009
Architecture User CCG E-BusinessSuite
Architecture CCG Java web application User Web browser EBS Setup data CCG Data repository GRCI PeopleSoft Setup data GRCM Custom Custom Setup data
Architecture Integra Home EBS User OAS OAS WebBrowser IntegraApplication Oracle DB Oracle DB GRCI APPSSchema IntegraHomeSchema GRCM IntegraAgentSchema Custom
Page/Form Change Tracker Configuration Governor - Change Tracker Insert Update Delete Audit Trail
Page/Form Change Tracker Configuration Governor - Change Tracker Insert Update Delete Business Table Audit Trail Trigger IntegraHomeSchema IntegraAgentSchema
Snapshot Snapshot Page/Form
Snapshot Child Snapshot Page/Form
Comparison Snapshot 1 Snapshot 2
Metadata • Each metadata object describes one form/page and its children (e.g., popups) • Each object tells CCG: • Columnsused by the form/page, and relationshipsbetween columns • How to translatecolumns’ native values to the field values seen in the business application • Fields that users can use to filterSnapshot results