Search Results contacts

The CS_SR_CONTACTS_EXT_AUDIT table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical audit table within the Customer Support (CS) module, specifically designed to track changes made to extended contact information associated with service requests (SRs). This table plays a pivotal role in maintaining data integrity, compliance, and auditability by logging historical modifications to contact details beyond the standard service request contact records. Below is a detailed analysis of its structure, purpose, and functional significance in Oracle EBS. ### **Purpose and Functional Context** The CS_SR_CONTACTS_EXT_AUDIT table stores audit trails for changes made to the CS_SR_CONTACTS_EXT table, which holds extended contact information for service requests. This includes supplementary data such as secondary contact methods, custom attributes, or additional metadata not captured in the primary CS_INCIDENTS_ALL_B or CS_SR_CONTACTS tables. The audit table ensures traceability for regulatory compliance (e.g., SOX, GDPR) and supports troubleshooting by preserving a record of who modified what data and when. ### **Key Columns and Structure** The table typically includes the following columns: 1. **AUDIT_ID**: Primary key, uniquely identifying each audit record. 2. **SR_CONTACT_EXT_ID**: Foreign key referencing the CS_SR_CONTACTS_EXT table. 3. **INCIDENT_ID**: Links to the service request (CS_INCIDENTS_ALL_B). 4. **CONTACT_ID**: References the contact person (HZ_CONTACT_POINTS or JTF_CONTACTS). 5. **ATTRIBUTE_* columns**: Capture extended attributes (e.g., ATTRIBUTE1–ATTRIBUTE15 for flexfields). 6. **CREATION_DATE**, **CREATED_BY**, **LAST_UPDATE_DATE**, **LAST_UPDATED_BY**: Standard Oracle audit columns. 7. **OPERATION_TYPE**: Indicates the action (INSERT, UPDATE, DELETE). 8. **OLD_VALUE**/**NEW_VALUE**: Optional columns storing before-and-after values for critical fields. ### **Integration with Oracle EBS Modules** - **Customer Support (CS)**: Tied to service request lifecycle management, ensuring contact details are auditable. - **Trading Community Architecture (TCA)**: Links to HZ_PARTIES and HZ_CONTACT_POINTS for customer/contact data. - **Audit Framework**: Part of Oracle’s standard auditing mechanisms, often leveraged by tools like Oracle Audit Vault. ### **Technical Workflow** 1. **Trigger-Based Auditing**: Changes to CS_SR_CONTACTS_EXT are captured via database triggers, which insert records into CS_SR_CONTACTS_EXT_AUDIT. 2. **Data Retention**: Audit records are retained per retention policies, often archived or purged via concurrent programs. 3. **Reporting**: Used in audit reports, SOX compliance checks, or conflict resolution. ### **Customization Considerations** - **Flexfields**: Custom attributes in CS_SR_CONTACTS_EXT must be mirrored in the audit table. - **Performance**: Indexing INCIDENT_ID or SR_CONTACT_EXT_ID is recommended for large datasets. - **Extensions**: Customers may add columns to track specific business needs. ### **Version-Specific Notes** - **12.1.1**: Requires manual setup of audit triggers if not OOTB. - **12.2.2**: Enhanced integration with Oracle’s Audit Vault and Data Masking for security. ### **Conclusion** The CS_SR_CONTACTS_EXT_AUDIT table is indispensable for maintaining a secure, compliant, and transparent service request process in Oracle EBS. Its design ensures granular tracking of contact-related changes, aligning with Oracle’s broader audit framework while supporting customization for enterprise needs.

Lookup Type: INCIDENT_CONTACT_TYPE 12.1.1
product: CS - Service , meaning: INCIDENT_CONTACT_TYPE , description: Type of contact allowed in incident entry form ,
Lookup Type: INCIDENT_CONTACT_TYPE 12.2.2
product: CS - Service , meaning: INCIDENT_CONTACT_TYPE , description: Type of contact allowed in incident entry form ,
Lookup Type: CS_SR_DEFAULT_TAB 12.1.1
product: CS - Service , meaning: Service Request Default Tab , description: Tab page to be defaulted for Service Request ,
Lookup Type: CS_SR_DEFAULT_TAB 12.2.2
product: CS - Service , meaning: Service Request Default Tab , description: Tab page to be defaulted for Service Request ,
Lookup Type: NXTOPT_TRS_SYS 12.2.2
product: CS - Service , meaning: NXTOPT_TRS_SYS , description: Next option choice of Transfer System Form ,
Lookup Type: NXTOPT_TRS_SYS 12.1.1
product: CS - Service , meaning: NXTOPT_TRS_SYS , description: Next option choice of Transfer System Form ,
Lookup Type: OPTIONS_MORE_TRANSFER_CP 12.2.2
product: CS - Service , meaning: OPTIONS_MORE_TRANSFER_CP , description: More field options for Transfer CP form ,
Lookup Type: OPTIONS_MORE_TRANSFER_CP 12.1.1
product: CS - Service , meaning: OPTIONS_MORE_TRANSFER_CP , description: More field options for Transfer CP form ,
Lookup Type: CSZ_SRCH_ACTIONS_SAGT 12.2.2
product: CS - Service , meaning: Customer Support Agent Customer Search Contacts Table Actions , description: Customer Support Agent Customer Search Contacts Table Actions ,
Lookup Type: CSZ_SRCH_ACTIONS_SAGT 12.1.1
product: CS - Service , meaning: Customer Support Agent Customer Search Contacts Table Actions , description: Customer Support Agent Customer Search Contacts Table Actions ,
Lookup Type: OPTIONS_ACCESS_TEMPLATE_VIEW 12.1.1
product: CS - Service , meaning: OPTIONS_ACCESS_TEMPLATE_VIEW , description: View Access Template Options ,
Lookup Type: OPTIONS_ACCESS_TEMPLATE_VIEW 12.2.2
product: CS - Service , meaning: OPTIONS_ACCESS_TEMPLATE_VIEW , description: View Access Template Options ,
Table: CS_SR_CONTACTS_EXT_AUDIT 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_CONTACTS_EXT_AUDIT, object_name:CS_SR_CONTACTS_EXT_AUDIT, status:VALID, product: CS - Service , description: This is an audit table and will track all changes made to the party role contacts extensible attributes. , implementation_dba_data: CS.CS_SR_CONTACTS_EXT_AUDIT ,
Table: CS_SR_CONTACTS_EXT_AUDIT 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_SR_CONTACTS_EXT_AUDIT, object_name:CS_SR_CONTACTS_EXT_AUDIT, status:VALID, product: CS - Service , description: This is an audit table and will track all changes made to the party role contacts extensible attributes. , implementation_dba_data: CS.CS_SR_CONTACTS_EXT_AUDIT ,
View: CS_INST_CONTACT_DTLS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_INST_CONTACT_DTLS_V, object_name:CS_INST_CONTACT_DTLS_V, status:VALID, product: CS - Service , description: This view lists the details of the contacts pertaining to Installation Details , implementation_dba_data: APPS.CS_INST_CONTACT_DTLS_V ,
View: CS_INST_CONTACT_DTLS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_INST_CONTACT_DTLS_V, object_name:CS_INST_CONTACT_DTLS_V, status:VALID, product: CS - Service , description: This view lists the details of the contacts pertaining to Installation Details , implementation_dba_data: APPS.CS_INST_CONTACT_DTLS_V ,
View: CS_SR_INCIDENT_ADDRESS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_INCIDENT_ADDRESS_V, object_name:CS_SR_INCIDENT_ADDRESS_V, status:VALID, product: CS - Service , description: This view has the address of the contacts for a service request. , implementation_dba_data: APPS.CS_SR_INCIDENT_ADDRESS_V ,
View: CS_SR_INCIDENT_ADDRESS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_INCIDENT_ADDRESS_V, object_name:CS_SR_INCIDENT_ADDRESS_V, status:VALID, product: CS - Service , description: This view has the address of the contacts for a service request. , implementation_dba_data: APPS.CS_SR_INCIDENT_ADDRESS_V ,
View: CS_SR_HZ_CUST_CONT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_HZ_CUST_CONT_V, object_name:CS_SR_HZ_CUST_CONT_V, status:VALID, product: CS - Service , description: This view lists all the customer contacts for party types PARTY_RELATIONSHIP and PERSON. , implementation_dba_data: APPS.CS_SR_HZ_CUST_CONT_V ,
View: CS_SR_HZ_CUST_CONT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_HZ_CUST_CONT_V, object_name:CS_SR_HZ_CUST_CONT_V, status:VALID, product: CS - Service , description: This view lists all the customer contacts for party types PARTY_RELATIONSHIP and PERSON. , implementation_dba_data: APPS.CS_SR_HZ_CUST_CONT_V ,
View: CS_SR_CONTACT_DETAILS_V 12.1.1
product: CS - Service , description: This view obtains the contact information such as Job Title, Address etc. for each of the contacts pertaining to a service request depending on the Caller Type i,e. ORGANIZATION / PERSON. , implementation_dba_data: Not implemented in this database ,
View: CS_SR_CONTACT_DETAILS_V 12.2.2
product: CS - Service , description: This view obtains the contact information such as Job Title, Address etc. for each of the contacts pertaining to a service request depending on the Caller Type i,e. ORGANIZATION / PERSON. , implementation_dba_data: Not implemented in this database ,
View: CS_SR_CONTACT_POINTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_CONTACT_POINTS_V, object_name:CS_SR_CONTACT_POINTS_V, status:VALID, product: CS - Service , description: This view corresponds to the contact point type information such as PHONE/FAX/EMAIL & numbers of the individual contacts. , implementation_dba_data: APPS.CS_SR_CONTACT_POINTS_V ,
View: CS_SR_CONTACT_POINTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_CONTACT_POINTS_V, object_name:CS_SR_CONTACT_POINTS_V, status:VALID, product: CS - Service , description: This view corresponds to the contact point type information such as PHONE/FAX/EMAIL & numbers of the individual contacts. , implementation_dba_data: APPS.CS_SR_CONTACT_POINTS_V ,
View: CS_CONTACTS_V 12.1.1
product: CS - Service , description: Information regarding the Resources and their type of contacts in Installedbase , implementation_dba_data: Not implemented in this database ,
View: CS_CONTACTS_V 12.2.2
product: CS - Service , description: Information regarding the Resources and their type of contacts in Installedbase , implementation_dba_data: Not implemented in this database ,