Search Results cs_system_audit_pk

Overview

CS_SYSTEM_AUDIT is a Service (CS) module table in the Oracle E-Business Suite that stores historical audit information for system attributes maintained in the Oracle Install Base. Each row captures a before-and-after image of selected attributes on a customer system (an installed product instance) following an auditable change, enabling change tracking, reconciliation, and reporting of system record modifications. The table resides in the CS schema, is documented as VALID in ETRM for both 12.1.1 and 12.2.2, and contains 64 columns.

The record represents a controlled audit trail against the parent system definition in CS_SYSTEMS_ALL_B. The heuristic Data Vault classification mined from the foreign key structure is link. Under that modeling suggestion, CS_SYSTEM_AUDIT behaves as a connecting construct that ties an audited event to a system, a customer, various site-use and party references, and the security context in which the change occurred, rather than a pure descriptive hub or satellite.

Key Information Stored

The surrogate primary key is CS_SYSTEM_AUDIT_ID, enforced by the CS_SYSTEM_AUDIT_PK constraint. The principal business-context columns and their contents are:

• SYSTEM_ID — foreign key to CS_SYSTEMS_ALL_B, identifying the installed system whose attributes were audited.
• SYS_AUD_SYSTEM_ID — additional reference to CS_SYSTEMS_ALL_B, used to link the audit record to the audited system context.
• OLD_CUSTOMER_ID and CURRENT_CUSTOMER_ID — prior and new customer account references against HZ_CUST_ACCOUNTS.
• OLD_PARENT_SYSTEM_ID and CURR_PARENT_SYSTEM_ID — prior and new parent system references in CS_SYSTEMS_ALL_B, supporting hierarchy change tracking.
• OLD_SYSTEM_TYPE_CODE and CURR_SYSTEM_TYPE_CODE — previous and current system type classification.
• OLD_SERIAL_NUMBER and CURR_SERIAL_NUMBER — serial number before and after the change.
• OLD_TECHNICAL_CONTACT_ID / CURR_TECHNICAL_CONTACT_ID, OLD_SERVICE_ADMIN_CONTACT_ID / CURR_SERVICE_ADMIN_CONTACT_ID — party references in HZ_PARTIES for technical and service administration contacts.
• OLD_INSTALL_SITE_USE_ID / CURR_INSTALL_SITE_USE_ID, and the bill-to and ship-to site-use pairs — site references against HZ_PARTY_SITES and HZ_CUST_ACCT_SITES_ALL.
• OLD_START_DATE_ACTIVE / CURR_START_DATE_ACTIVE and OLD_END_DATE_ACTIVE / CURR_END_DATE_ACTIVE — effective-date changes on the system.
• AUDIT_COMMENTS — free-text explanation recorded with the audit event.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, controlling multi-org style data access.
• Standard WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — plus OBJECT_VERSION_NUMBER for optimistic locking.

Common Use Cases and Queries

Typical uses include reconstructing the history of a customer system for dispute resolution, reporting on customer or site reassignments, and validating data migration or upgrade activity. The upgrade and migration flags UPGRADED_STATUS_FLAG, VALID_FOR_CSI_MIGRATION and MIGRATED_STATUS_FLAG support audit of bulk conversion runs.

A representative change-history query joins the audit rows to the system master:

• SELECT a.cs_system_audit_id, a.system_id, a.old_customer_id, a.current_customer_id, a.old_serial_number, a.curr_serial_number, a.audit_comments, a.last_update_date FROM cs_system_audit a WHERE a.system_id = :p_system_id ORDER BY a.last_update_date DESC;
• SELECT a.system_id, a.old_parent_system_id, a.curr_parent_system_id, a.old_system_type_code, a.curr_system_type_code FROM cs_system_audit a WHERE a.last_update_date >= :p_from_date;

Because SECURITY_GROUP_ID drives access, reports should be run with the correct security profile, or filtered explicitly when querying across operating units.

Related Objects

• CS_SYSTEMS_ALL_B — referenced through SYSTEM_ID, SYS_AUD_SYSTEM_ID, OLD_PARENT_SYSTEM_ID and CURR_PARENT_SYSTEM_ID; the master system definition.
• HZ_CUST_ACCOUNTS — referenced through OLD_CUSTOMER_ID and CURRENT_CUSTOMER_ID.
• HZ_PARTIES — referenced by the technical, service administration, bill-to and ship-to contact ID columns.
• HZ_PARTY_SITES — referenced by install, ship-to and related site-use columns.
• HZ_CUST_ACCT_SITES_ALL — referenced by the bill-to site-use columns.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID.