Message

This object stores information about every communication update to the Service request, both from the internal agent and from the customer. An example stored message could be: We have credited your account for the value of the call. You should see a credit in your next monthly bill. We have notified the billing department about the issue. This issue should not recur.

QName: {http://xmlns.oracle.com/apps/crm/service/svcMgmt/srMgmt/srMgmtService/}SrMessage

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Message

Contained by

HR Help Desk Request

Contained by

Message

Contained by

Internal Service Request

Contained by

Service Request

Handled by

Service Request Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

ChannelId

long

The unique ID of the channel.

ChannelTypeCd

string

Indicates the channel type. For example, email, phone, social, etc.

CreatedBy

string

The user who created the message.

CreatedByEmailAddress

string

Indicates the e-mail ID of the person who created the service request message.

CreatedByPartyId

string

Indicates the party ID of the person who created the service request message.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date and time when the message was created.

DeleteFlag

boolean

This flag controls if the user has access to delete the record

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date and time when the message was last updated.

LastUpdateLogin

string

The user who last updated the message.

LastUpdatedBy

string

The user who last updated the message.

MessageContent

{http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler

Indicates the content of the service request message.

MessageCreatedBy

string

The user who created the message in the original source system. This is applicable if the service request message was imported from another system.

MessageExpandingState

int

Indicates the message expanding state.

MessageId

long

The unique ID of the service request message.
  • Primary Key

MessageLastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The last updated date of the message in the original source system. This is applicable if the service request message was imported from another system.

MessageLastUpdateLogin

string

The login of the user who last updated the message in the original source system. This is applicable if the service request message was imported from another system.

MessageLastUpdatedBy

string

The user who last updated the message in the original source system. This is applicable if the service request message was imported from another system.

MessageNumber

string

Indicates the service request message number.

MessageSubTypeCd

string

The service request message subtype.

MessageTypeCd

string

Indicates the message type. The accepted values are Response, Customer Entry, System Note, System Response, and Internal Note.

NetworkTypeCd

string

Indicates the type of social network.

NotificationProcessingStatusCd

string

Indicates the notification processing status code.

NotificationRetryCount

int

Indicates the notification retry count.

ObjectId

long

Indicates the object ID.

OriginalSystemReference

string

The ID of the message record in the original source system from where the message was imported. This is applicable if the service request message was imported from another system.

OriginationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date the message was created in the original source system. This is applicable if the service request message was imported from another system.

ParentMessageId

long

Indicates the parent service request message ID.

PartyName

string

The party name of the user who posted the message. The user can be an internal resource or a customer contact.

PostedByPartyId

long

The unique ID of the user who the posted the message. The user can be an internal resource or a customer contact.

PrivateInformationFlag

boolean

Indicates whether the message contains private information.

ProcessingId

long

Indicates the processing ID.

ProcessingStatusCd

string

Indicates the processing status of the message. The accepted values are Ready, Processing, Error, and Success.

ReplyToMessageId

long

Indicates the customer message ID to which the agent is replying to.

RichTextFlag

boolean

Indicates whether the message content is in rich text format. If the format is rich text, then the value is Y, else the value is N.

RootMessageId

long

Indicates the identifier of the root message.

RootThreadCount

long

Indicates the number of messages under a root message in a service request.

RootThreadLastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Indicates the latest updated date for all messages under the root message in a service request.

RootThreadMessageLastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Indicates the date when all messages under the root message in a service request were last updated.

SentDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date and time when the message was sent.

SocialPrivateFlag

boolean

Indicates if the service request was created from a private social post.

SourceCd

string

Indicates the source of the message.

SrBUOrgId

long

The identifier of the business unit associated with the service request.

SrId

long

The unique ID of the service request to which the message is associated.

SrInlineAttachmentIds

string

Indicates the list of inline attachments associated with the service request

SrStripeCd

string

The application stripe of the service request.

StatusCd

string

Indicates the status of the message. The accepted values are Draft, Committed, and Corrected.

Subject

string

Indicates the subject of the service request message.

TemplateName

string

Indicates the name of the template that is used for outbound communication of the message.

ThreadCount

long

Indicates the number of threads in a service request message.

ThreadHierarchyLevel

int

Indicates the thread hierarchy level.

ThreadId

long

The unique ID of the service request message thread.

ThreadLastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Indicates the date the thread was last updated.

ThreadMessageLastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Indicates the date when the thread message was last updated.

UpdateFlag

boolean

This flag controls if the user has access to update the record

VisibilityCd

string

Indicates the privacy level of the message. The accepted values are Internal and External. Null value indicates that the message is External.

childMessages

Message

The list of child messages for a given service request message.