1. Applications Administration Guide
  2. Retrieving Archived Data Records

Retrieving Archived Data Records

This section describes how to configure Siebel to expose archived data and retrieve archived attachments for analysis, compliance, or reinstatement.

The Siebel Intelligent Data Archival framework not only archives data securely but also allows controlled retrieval and visibility of archived records within Siebel.

Retrieval can be configured at the UI level (via Archive BCs) for end users and can also be executed at the data level for attachments, depending on the archival target (Database or File System).

Exposing Archived Data in Siebel UI

Archived data can be displayed under its respective parent entities (such as Accounts, Service Requests, or Orders) using Child Archive Business Components (BCs).These BCs are linked to the main parent BC to show historical archived records alongside active records.

Steps to Expose Archived Data:

  1. Determine the parent entity under which archived data needs to be displayed (e.g., show archived Service Requests under Account).

  2. Create a new Business Component (BC) representing the archived data.

    Define its data source as the S_ARCHIVE_DATA table.

    Apply a Search Specification on the Data Entity field to filter archived records relevant to that object.

  3. Create a Link between the Parent BC and the Child Archive BC. The link should be based on the Parent Entity ID defined in the corresponding Archive Rule (for example, Account Id, SR Id).

  4. Add the newly created Child Archive BC to the Parent Business Object (BO). Use the Link created in Step 3 to establish the relationship.

  5. Create a new Applet based on the Child Archive BC to display archived records.- Include relevant fields (e.g., Archive Date, Archived By, Summary, Description).

  6. Add the applet to an existing or new View under the parent object (e.g., Account Service Request List View). This will enable users to see both live and archived records in context.

  7. Add a Retrieve button to the archive applet to allow users to initiate data retrieval.

    Configure the button properties as follows:

    Control: Retrieve

    HTML Type: MiniButtonEdit

    Method Invoked: ShowPopup

    Runtime: Y

    Show Pop-up: Y

  8. Add Control User Property.

    Configure the control with the following user property:

    Mode: Base

    Popup: Data Archive Retrieve Object Popup Applet

Attachment Retrieval

Attachments associated with Siebel business entities, such as Service Requests, Quotes, or Activities, can also be archived and retrieved as part of the Siebel Intelligent Data Archival.

During archival, attachments are stored in Base64-encoded format to preserve data integrity and ensure transportability across storage mediums (Database or File System).

Attachment Retrieval for Database Archive Target

For archival rules that target a Database, all attachments are stored in the S_ARCH_ATT_STORE table.

Steps to follow:

  1. Identify the Target Data Entity.

  2. Use the following SQL command to extract the Base64-encoded attachment data from the archive table: 
    select ATT_OBJ_DATA  from 
S_ARCH_ATT_STORE where ARCH_OBJ_ID 
= <Object ID>

  3. Use a Base64 decoder to decode the ATT_OBJ_DATA value and to obtain the attachment content.

Attachment Retrieval for File System Archive Target

For archival rules that target the File System, attachments are stored as Base64-encoded files under the defined archival destination directory.

Each archived attachment is associated with a Main Job ID, Batch ID, and Object ID that correspond to the archival job execution.

  1. Identify the Target Data Entity and Object ID.

  2. Identify the Main Job ID and Batch ID associated with the Object ID. These values are recorded in:-

    • The Archival Activity Log in Siebel

    • Helidon logs can be viewed in console.

  3. Locate the archive file path in the configured target File System as per the following structure: <FileSystem_Path>\Base_Service_Request_Archival\Main_Job_<MainJobID>\Batch_<BatchID>\<ObjectID>

  4. Use a Base64 decoder to decode the ATT_OBJ_DATA value and to obtain the attachment content.

Data Restoration

Use standard EIM approach to restore the archived data. Refer to, Importing Data