Record Validation Messages

• It is not recommended that you use this view to determine why a given message was posted for a given record. The number of messages that may exist for a given staging table may be overwhelming. Use the Staging Table Summary view for that purpose, whereas you can use this view for debugging purposes.

The following list defines every field available in the record validation message (md_valid_msg) resource in alphabetical order:

• Column Name - this field is not maintainable. The name of the column to which the record belongs.
  • This field is left blank for record-level errors or warnings, or for system-generated messages (i.e. messages of type Child Error, Child Warning, or Child Warning and Error) that serve to indicate that messages exist for a child table of the current root node.

  • The column name is used in the staging tables by the Has Record Validation Messages, Has Error Messages and Has Warning Messages fields, along with the Group by Key field, to determine if validation messages exist for a given staging record and then to group the messages together and list them in a message navigation tree displayed on the right-hand side of the Search and Details pages of the staging view.

• Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

• Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

• Database Name - this field is not maintainable. The name of the database to which the record belongs.

• Group by Key - this field is not maintainable. The literal key of a given message that is used to group messages together.
  • The group by key is used in the staging tables by the Has Record Validation Messages, Has Error Messages and Has Warning Messages fields, along with the Column Name field, to determine if validation messages exist for a given staging record and then to group the messages together and list them in a message navigation tree displayed on the right-hand side of the Search and Details pages of the staging view.

• Message Group - this field is not maintainable. An expression column that provides a preview of the group of records grouped for a given view by the message literal key specified in the Group by Key field, as well as a hyperlink for direct access to the view's search results for that group of records.

• Message Sequence - this field is not maintainable. The sequence number associated with the message.
  • Every message is stored under a given root node.

  • A sequence number can only be used once for a given root node. If warning and/or error messages were posted for a child table, then an additional message was generated by the system to indicate that such child messages exist. Such additional messages are generated only once all of the tables in the identifying tree have been processed. Consequently, the sequence numbers assigned to system-generated messages will follow the last sequence assigned to a message belonging to one of the tables in the tree.

  • The message sequence is one of the two columns that represent this table's primary key. The other part of the key is Root MUID.

• Message Text - this field is not maintainable. The message's display value, which is defined as an attribute value macro to be resolved dynamically according to the current locale.
  • The value represents a combination of the literal and each of its values. Each value can itself be a literal of the same format.

  • When the message type is Child Error, Child Warning or Child Warning and Error, the message text includes a literal value that represents the description of the child table.

  • Examples:
    {literal.rcrd_not_exist}
    {literal.msg_%1|{literal.staging_sales_ord_line_instr}}

• Message Type - this field is not maintainable. The message type. The following options are available:
  • Warning - indicates that the message is a warning. This is acquired through the literal type associated with the literal identified in the Message Text field.

  • Error - indicates that the message is an error. This is acquired through the literal type associated with the literal identified in the Message Text field.

  • Information - indicates that the message is an information message. This is acquired through the literal type associated with the literal identified in the Message Text field.

  • Child Warning - identifies a system-generated warning message for a child record of the current record.

  • Child Error - identifies a system-generated error message for a child record of the current record.

  • Child Warning and Error - identifies a system-generated warning or error message for a child record of the current record.

• Owner MUID - this field is not maintainable. The unique identifier associated with the record to which the validation message belongs.
  • The identifier contains the three following elements, separated by a pipe:
    • The database name;
    • The table name; and,
    • The value of the record's primary key.

  • Example: ice|sales_order|7

• Owner Record - this field is not maintainable. An expression column that provides a preview of the owner record as well as a hyperlink for direct access.

• Parent MUID - this field is not maintainable. The unique identifier associated with the parent of the record to which the validation message belongs.
  • The identifier contains the following three elements, each separated by a pipe:
    • The database name;
    • The table name; and,
    • The value of the record's primary key.

  • Example: ice|sales_order|7

  Note: This field is left blank if the current record is the root node.

• Root MUID - this field is not maintainable. The unique identifier associated with the root node of the record to which the validation message belongs.
  • The identifier contains the following three elements, each separated by a pipe:
    • The database name;
    • The table name; and,
    • The value of the record's primary key.

  • Example: ice|sales_order|7

  • The root node MUID (Meta Universal Identifier) is one of the two columns that represent this table's primary key. The other part of the key is Message Sequence.

• Table Name - this field is not maintainable. The name of the table to which the record belongs.

• View Name - this field is not maintainable. The name of the view to which the record belongs.