Oracle Cloud Infrastructure Documentation
Try Free Tier

CIMS Common Types

DBMS_CLOUD_OCI_CIMS_VARCHAR2_TBL Type

Nested table type of varchar2(32767).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_varchar2_tbl FORCE IS TABLE OF (varchar2(32767)) NOT PERSISTABLE;

DBMS_CLOUD_OCI_CIMS_CATEGORY_T Type

Details about the service category associated with the support ticket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_category_t FORCE AUTHID CURRENT_USER IS OBJECT (
  category_key varchar2(32767),
  name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_category_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_category_t (
    category_key varchar2,
    name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

category_key

(optional) Unique identifier for the service category.

name

(optional) The name of the service category. For example, `Compute` or `Identity`.

DBMS_CLOUD_OCI_CIMS_SUB_CATEGORY_T Type

Details about the service subcategory associated with the support ticket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_sub_category_t FORCE AUTHID CURRENT_USER IS OBJECT (
  sub_category_key varchar2(32767),
  name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_sub_category_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_sub_category_t (
    sub_category_key varchar2,
    name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

sub_category_key

(optional) Unique identifier for the service subcategory.

name

(optional) The name of the service subcategory. For example, `Backup Count` or `Custom Image Count`.

DBMS_CLOUD_OCI_CIMS_ISSUE_TYPE_T Type

Details about the issue type associated with the support ticket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_issue_type_t FORCE AUTHID CURRENT_USER IS OBJECT (
  issue_type_key varchar2(32767),
  label varchar2(32767),
  name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_issue_type_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_issue_type_t (
    issue_type_key varchar2,
    label varchar2,
    name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

issue_type_key

(optional) Unique identifier for the issue type.

label

(optional) The label for the issue type. For example, `Instance Performance`.

name

(optional) The URL for the contextual documentation.

DBMS_CLOUD_OCI_CIMS_ITEM_T Type

Details about the item object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_item_t FORCE AUTHID CURRENT_USER IS OBJECT (
  item_key varchar2(32767),
  name varchar2(32767),
  l_type varchar2(32767),
  category dbms_cloud_oci_cims_category_t,
  sub_category dbms_cloud_oci_cims_sub_category_t,
  issue_type dbms_cloud_oci_cims_issue_type_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_item_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_item_t (
    item_key varchar2,
    name varchar2,
    l_type varchar2,
    category dbms_cloud_oci_cims_category_t,
    sub_category dbms_cloud_oci_cims_sub_category_t,
    issue_type dbms_cloud_oci_cims_issue_type_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Field Description

item_key

(required) Unique identifier for the item.

name

(optional) The display name of the item. Avoid entering confidential information.

l_type

(optional) The type of the item.

category

(optional)

sub_category

(optional)

issue_type

(optional)

DBMS_CLOUD_OCI_CIMS_ACCOUNT_ITEM_T Type

Details about the AccountItem object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_account_item_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_cims_item_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_account_item_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_account_item_t (
    item_key varchar2,
    name varchar2,
    l_type varchar2,
    category dbms_cloud_oci_cims_category_t,
    sub_category dbms_cloud_oci_cims_sub_category_t,
    issue_type dbms_cloud_oci_cims_issue_type_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_cims_account_item_t is a subtype of the dbms_cloud_oci_cims_item_t type.

DBMS_CLOUD_OCI_CIMS_ACTIVITY_ITEM_T Type

Details about the ActivityItem object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_activity_item_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_cims_item_t (
  comments varchar2(32767),
  time_created number,
  time_updated number,
  activity_type varchar2(32767),
  activity_author varchar2(32767),
  item_type varchar2(32767),
  item_status varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_activity_item_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_activity_item_t (
    item_key varchar2,
    name varchar2,
    l_type varchar2,
    category dbms_cloud_oci_cims_category_t,
    sub_category dbms_cloud_oci_cims_sub_category_t,
    issue_type dbms_cloud_oci_cims_issue_type_t,
    comments varchar2,
    time_created number,
    time_updated number,
    activity_type varchar2,
    activity_author varchar2,
    item_type varchar2,
    item_status varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_cims_activity_item_t is a subtype of the dbms_cloud_oci_cims_item_t type.

Fields

Field Description

comments

(required) Comments added with the activity on the support ticket.

time_created

(required) The time when the activity was created, in milliseconds since epoch time.

time_updated

(required) The time when the activity was updated, in milliseconds since epoch time.

activity_type

(required) The type of activity occuring on the support ticket.

Allowed values are: 'NOTES', 'PROBLEM_DESCRIPTION', 'UPDATE', 'CLOSE', 'REOPEN'

activity_author

(required)

Allowed values are: 'CUSTOMER', 'ORACLE'

item_type

(optional)

Allowed values are: 'ATTACHMENTS', 'COMMENTS'

item_status

(optional) Who updates the activity on the support ticket.

Allowed values are: 'PROCESSING', 'ATTACHED', 'REMOVED', 'FAILED'

DBMS_CLOUD_OCI_CIMS_ISSUE_TYPE_TBL Type

Nested table type of dbms_cloud_oci_cims_issue_type_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_issue_type_tbl FORCE IS TABLE OF (dbms_cloud_oci_cims_issue_type_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_CIMS_CLASSIFIER_T Type

Details about the incident classifier object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_classifier_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  name varchar2(32767),
  label varchar2(32767),
  description varchar2(32767),
  issue_type_list dbms_cloud_oci_cims_issue_type_tbl,
  scope varchar2(32767),
  unit varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_classifier_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_classifier_t (
    id varchar2,
    name varchar2,
    label varchar2,
    description varchar2,
    issue_type_list dbms_cloud_oci_cims_issue_type_tbl,
    scope varchar2,
    unit varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

id

(optional) Unique identifier of the classifier.

name

(optional) The display name of the classifier.

label

(optional) The label associated with the classifier.

description

(optional) The description of the classifier.

issue_type_list

(optional) The list of issues.

scope

(optional) The scope of the service category or resource.

Allowed values are: 'AD', 'REGION', 'TENANCY', 'NONE'

unit

(optional) The unit to use to measure the service category or resource.

Allowed values are: 'COUNT', 'GB', 'NONE'

DBMS_CLOUD_OCI_CIMS_CONTACT_T Type

Contact details for the customer. Avoid entering confidential information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_contact_t FORCE AUTHID CURRENT_USER IS OBJECT (
  contact_name varchar2(32767),
  contact_email varchar2(32767),
  email varchar2(32767),
  contact_phone varchar2(32767),
  contact_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_contact_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_contact_t (
    contact_name varchar2,
    contact_email varchar2,
    email varchar2,
    contact_phone varchar2,
    contact_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

contact_name

(optional) The name of the contact person.

contact_email

(optional) The email of the contact person.

email

(optional) The email of the contact person.

contact_phone

(optional) The phone number of the contact person.

contact_type

(optional) The type of contact, such as primary or alternate.

Allowed values are: 'PRIMARY', 'ALTERNATE', 'SECONDARY', 'ADMIN', 'MANAGER'

DBMS_CLOUD_OCI_CIMS_CONTACT_TBL Type

Nested table type of dbms_cloud_oci_cims_contact_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_contact_tbl FORCE IS TABLE OF (dbms_cloud_oci_cims_contact_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_CIMS_CONTACT_LIST_T Type

The list of contacts for the ticket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_contact_list_t FORCE AUTHID CURRENT_USER IS OBJECT (
  contact_list dbms_cloud_oci_cims_contact_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_contact_list_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_contact_list_t (
    contact_list dbms_cloud_oci_cims_contact_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

contact_list

(required) The list of contacts.

DBMS_CLOUD_OCI_CIMS_CONTEXTUAL_DATA_T Type

Information collected from user context during ticket creation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_contextual_data_t FORCE AUTHID CURRENT_USER IS OBJECT (
  client_id varchar2(32767),
  schema_name varchar2(32767),
  schema_version varchar2(32767),
  payload varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_contextual_data_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_contextual_data_t (
    client_id varchar2,
    schema_name varchar2,
    schema_version varchar2,
    payload varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

client_id

(required) The unique identifier for the client.

schema_name

(required) The name assigned to the schema.

schema_version

(required) The version of the schema.

payload

(required) The payload for the contextual data.

DBMS_CLOUD_OCI_CIMS_CREATE_CATEGORY_DETAILS_T Type

Details for creating the category of the support ticket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_create_category_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  category_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_category_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_category_details_t (
    category_key varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

category_key

(optional) Unique identifier for the service category.

DBMS_CLOUD_OCI_CIMS_CREATE_SUB_CATEGORY_DETAILS_T Type

Details for creating the service subcategory of the support ticket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_create_sub_category_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  sub_category_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_sub_category_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_sub_category_details_t (
    sub_category_key varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

sub_category_key

(optional) Unique identifier for the service subcategory.

DBMS_CLOUD_OCI_CIMS_CREATE_ISSUE_TYPE_DETAILS_T Type

Details for creating the issue type of the support ticket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_create_issue_type_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  issue_type_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_issue_type_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_issue_type_details_t (
    issue_type_key varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

issue_type_key

(optional) Unique identifier for the issue type.

DBMS_CLOUD_OCI_CIMS_CREATE_ITEM_DETAILS_T Type

Details gathered during ticket creation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_create_item_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  category dbms_cloud_oci_cims_create_category_details_t,
  sub_category dbms_cloud_oci_cims_create_sub_category_details_t,
  issue_type dbms_cloud_oci_cims_create_issue_type_details_t,
  name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_item_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_item_details_t (
    l_type varchar2,
    category dbms_cloud_oci_cims_create_category_details_t,
    sub_category dbms_cloud_oci_cims_create_sub_category_details_t,
    issue_type dbms_cloud_oci_cims_create_issue_type_details_t,
    name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Field Description

l_type

(optional) The type of the ticket.

category

(optional)

sub_category

(optional)

issue_type

(optional)

name

(optional) The display name of the ticket. Avoid entering confidential information.

DBMS_CLOUD_OCI_CIMS_CREATE_ACCOUNT_ITEM_DETAILS_T Type

Details about the issue that the account support ticket relates to. Avoid entering confidential information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_create_account_item_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_cims_create_item_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_account_item_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_account_item_details_t (
    l_type varchar2,
    category dbms_cloud_oci_cims_create_category_details_t,
    sub_category dbms_cloud_oci_cims_create_sub_category_details_t,
    issue_type dbms_cloud_oci_cims_create_issue_type_details_t,
    name varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_cims_create_account_item_details_t is a subtype of the dbms_cloud_oci_cims_create_item_details_t type.

DBMS_CLOUD_OCI_CIMS_CREATE_RESOURCE_DETAILS_T Type

Details about the resource that the support ticket relates to.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_create_resource_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  item dbms_cloud_oci_cims_create_item_details_t,
  l_region varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_resource_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_resource_details_t (
    item dbms_cloud_oci_cims_create_item_details_t,
    l_region varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

item

(optional)

l_region

(optional) The list of available Oracle Cloud Infrastructure regions.

DBMS_CLOUD_OCI_CIMS_CREATE_RESOURCE_DETAILS_TBL Type

Nested table type of dbms_cloud_oci_cims_create_resource_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_create_resource_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_cims_create_resource_details_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_CIMS_CREATE_TICKET_DETAILS_T Type

Details relevant to the support ticket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_create_ticket_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  severity varchar2(32767),
  resource_list dbms_cloud_oci_cims_create_resource_details_tbl,
  title varchar2(32767),
  description varchar2(32767),
  contextual_data dbms_cloud_oci_cims_contextual_data_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_ticket_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_ticket_details_t (
    severity varchar2,
    resource_list dbms_cloud_oci_cims_create_resource_details_tbl,
    title varchar2,
    description varchar2,
    contextual_data dbms_cloud_oci_cims_contextual_data_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

severity

(required) The severity of the support ticket.

Allowed values are: 'HIGHEST', 'HIGH', 'MEDIUM', 'LOW'

resource_list

(optional) The list of resources.

title

(required) The title of the support ticket. Avoid entering confidential information.

description

(required) The description of the support ticket. Avoid entering confidential information.

contextual_data

(optional)

DBMS_CLOUD_OCI_CIMS_CREATE_INCIDENT_T Type

Details gathered during the creation of the support ticket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_create_incident_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  ticket dbms_cloud_oci_cims_create_ticket_details_t,
  csi varchar2(32767),
  problem_type varchar2(32767),
  contacts dbms_cloud_oci_cims_contact_tbl,
  referrer varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_incident_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_incident_t (
    compartment_id varchar2,
    ticket dbms_cloud_oci_cims_create_ticket_details_t,
    csi varchar2,
    problem_type varchar2,
    contacts dbms_cloud_oci_cims_contact_tbl,
    referrer varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

compartment_id

(required) The OCID of the tenancy.

ticket

(required)

csi

(optional) The Customer Support Identifier (CSI) number associated with the support account. The CSI is required for technical support tickets and optional for limits and billing tickets.

problem_type

(required) The kind of support ticket, such as a technical support request or a limit increase request.

Allowed values are: 'LIMIT', 'LEGACY_LIMIT', 'TECH', 'ACCOUNT', 'TAXONOMY'

contacts

(optional) The list of contacts.

referrer

(optional) The incident referrer. This value is often the URL that the customer used when creating the support ticket.

DBMS_CLOUD_OCI_CIMS_CREATE_LIMIT_ITEM_DETAILS_T Type

Details about the service limit increase request. Avoid entering confidential information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_create_limit_item_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_cims_create_item_details_t (
  current_limit number,
  current_usage number,
  requested_limit number,
  limit_status varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_limit_item_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_limit_item_details_t (
    l_type varchar2,
    category dbms_cloud_oci_cims_create_category_details_t,
    sub_category dbms_cloud_oci_cims_create_sub_category_details_t,
    issue_type dbms_cloud_oci_cims_create_issue_type_details_t,
    name varchar2,
    current_limit number,
    current_usage number,
    requested_limit number,
    limit_status varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_cims_create_limit_item_details_t is a subtype of the dbms_cloud_oci_cims_create_item_details_t type.

Fields

Field Description

current_limit

(optional) The limit of the resource currently available.

current_usage

(optional) The current usage of the resource.

requested_limit

(optional) The new service limit being requested.

limit_status

(optional) The current status of the request.

Allowed values are: 'APPROVED', 'PARTIALLY_APPROVED', 'NOT_APPROVED'

DBMS_CLOUD_OCI_CIMS_CREATE_TECH_SUPPORT_ITEM_DETAILS_T Type

Details about the issue that the technical support ticket relates to. Avoid entering confidential information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_create_tech_support_item_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_cims_create_item_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_tech_support_item_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_tech_support_item_details_t (
    l_type varchar2,
    category dbms_cloud_oci_cims_create_category_details_t,
    sub_category dbms_cloud_oci_cims_create_sub_category_details_t,
    issue_type dbms_cloud_oci_cims_create_issue_type_details_t,
    name varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_cims_create_tech_support_item_details_t is a subtype of the dbms_cloud_oci_cims_create_item_details_t type.

DBMS_CLOUD_OCI_CIMS_CREATE_USER_DETAILS_T Type

Details for creating a new user.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_create_user_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  first_name varchar2(32767),
  last_name varchar2(32767),
  csi varchar2(32767),
  phone varchar2(32767),
  timezone varchar2(32767),
  organization_name varchar2(32767),
  problem_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_user_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_create_user_details_t (
    compartment_id varchar2,
    first_name varchar2,
    last_name varchar2,
    csi varchar2,
    phone varchar2,
    timezone varchar2,
    organization_name varchar2,
    problem_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

compartment_id

(required) The OCID of the tenancy.

first_name

(required) First name of the user.

last_name

(required) Last name of the user.

csi

(required) CSI associated with the user.

phone

(required) Contact number of the user.

timezone

(required) Timezone of the user.

organization_name

(required) Organization of the user.

problem_type

(required) The kind of support ticket, such as a technical support request or a limit increase request.

Allowed values are: 'LIMIT', 'LEGACY_LIMIT', 'TECH', 'ACCOUNT', 'TAXONOMY'

DBMS_CLOUD_OCI_CIMS_ERROR_T Type

Details about an error that occurred.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_error_t (
    code varchar2,
    message varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

code

(required) A short error code that defines the error, meant for programmatic parsing.

Allowed values are: 'CONTENT_EMPTY', 'CLIENT_EXCEPTION', 'INVALID_FORMAT', 'INVALID_JSON_INPUT', 'SSL_AUTHORIZATION', 'AUTH_FAILED', 'AUTHZ_FAILED', 'CSI_NOT_AUTHORIZED', 'USER_POLICY_NOT_AUTHORIZED', 'EMAIL_NOT_VERIFIED', 'EMAIL_NOT_FOUND', 'OCI_EMAIL_NOT_FOUND', 'MOS_EMAIL_NOT_FOUND', 'IDCS_EMAIL_NOT_VALID', 'INVALID_PATH', 'METHOD_NOT_ALLOWED', 'JSON_PROCESSING', 'GENERIC_EXCEPTION', 'EXTERNAL_SERVICE_PROVIDER_UNAVAILABLE', 'EXTERNAL_SERVICE_PROVIDER_TIMEOUT', 'TOO_MANY_REQUESTS', 'IDP_SCIM_NOT_SETUP', 'INCIDENT_NOT_FOUND', 'INVALID_USER_CSI', 'DATA_ALREADY_EXISTS', 'AUTH_USER_NOT_MATCHING', 'CONTACT_NOT_APPROVED', 'CREATE_PROFILE_MOS_FAILURE', 'CREATE_PROFILE_CREATE_OSSO_FAILURE', 'CREATE_PROFILE_IDENTITY_FAILURE', 'CREATE_PROFILE_VERIFY_OSSO_FAILURE', 'PROFILE_ACCOUNT_NOT_VERIFIED', 'SUPPORT_ACCOUNT_NOT_FOUND', 'SUPPORT_ACCOUNT_PENDING_CSI_APPROVAL', 'FREE_TIER_CUSTOMER_SLI_UNSUPPORTED', 'PROFILE_ACCOUNT_VERIFIED', 'PROFILE_VERIFIED_CSI_REQUEST_PENDING', 'PROFILE_VERIFIED_CSI_REQUEST_NOT_FOUND', 'CREATE_PROFILE_ORGANIZATION_NAME_INVALID', 'CREATE_PROFILE_EMAIL_INVALID'

message

(required) A human-readable error string.

DBMS_CLOUD_OCI_CIMS_TENANCY_INFORMATION_T Type

Details about the tenancy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_tenancy_information_t FORCE AUTHID CURRENT_USER IS OBJECT (
  customer_support_key varchar2(32767),
  tenancy_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_tenancy_information_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_tenancy_information_t (
    customer_support_key varchar2,
    tenancy_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

customer_support_key

(required) The Customer Support Identifier (CSI) number associated with the tenancy.

tenancy_id

(required) The OCID of the tenancy.

DBMS_CLOUD_OCI_CIMS_RESOURCE_T Type

Details about the ticket item object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_resource_t FORCE AUTHID CURRENT_USER IS OBJECT (
  item dbms_cloud_oci_cims_item_t,
  l_region varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_resource_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_resource_t (
    item dbms_cloud_oci_cims_item_t,
    l_region varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

item

(optional)

l_region

(optional) The list of available Oracle Cloud Infrastructure regions.

DBMS_CLOUD_OCI_CIMS_RESOURCE_TBL Type

Nested table type of dbms_cloud_oci_cims_resource_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_resource_tbl FORCE IS TABLE OF (dbms_cloud_oci_cims_resource_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_CIMS_TICKET_T Type

Details about the ticket created.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_ticket_t FORCE AUTHID CURRENT_USER IS OBJECT (
  ticket_number varchar2(32767),
  severity varchar2(32767),
  resource_list dbms_cloud_oci_cims_resource_tbl,
  title varchar2(32767),
  description varchar2(32767),
  time_created number,
  time_updated number,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_ticket_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_ticket_t (
    ticket_number varchar2,
    severity varchar2,
    resource_list dbms_cloud_oci_cims_resource_tbl,
    title varchar2,
    description varchar2,
    time_created number,
    time_updated number,
    lifecycle_state varchar2,
    lifecycle_details varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

ticket_number

(optional) Unique identifier for the ticket.

severity

(required) The severity assigned to the ticket.

Allowed values are: 'HIGHEST', 'HIGH', 'MEDIUM', 'LOW'

resource_list

(optional) The list of resources associated with the ticket.

title

(required) The title of the ticket.

description

(required) The description of the issue addressed in the ticket.

time_created

(optional) The time when the ticket was created, in milliseconds since epoch time.

time_updated

(optional) The time when the ticket was updated, in milliseconds since epoch time.

lifecycle_state

(optional) The current state of the ticket.

Allowed values are: 'ACTIVE', 'CLOSED'

lifecycle_details

(optional) Additional information about the current `lifecycleState`.

Allowed values are: 'PENDING_WITH_ORACLE', 'PENDING_WITH_CUSTOMER', 'CLOSE_REQUESTED', 'CLOSED'

DBMS_CLOUD_OCI_CIMS_CLASSIFIER_TBL Type

Nested table type of dbms_cloud_oci_cims_classifier_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_classifier_tbl FORCE IS TABLE OF (dbms_cloud_oci_cims_classifier_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_CIMS_INCIDENT_TYPE_T Type

Details about the incident type associated with the support ticket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_incident_type_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  name varchar2(32767),
  label varchar2(32767),
  description varchar2(32767),
  classifier_list dbms_cloud_oci_cims_classifier_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_incident_type_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_incident_type_t (
    id varchar2,
    name varchar2,
    label varchar2,
    description varchar2,
    classifier_list dbms_cloud_oci_cims_classifier_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

id

(optional) Unique identifier for the incident type.

name

(optional) The name of the incident type.

label

(optional) The label associated with the incident type.

description

(optional) The description of the incident type.

classifier_list

(optional) The list of classifiers.

DBMS_CLOUD_OCI_CIMS_INCIDENT_T Type

Details about the support ticket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_incident_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  compartment_id varchar2(32767),
  contact_list dbms_cloud_oci_cims_contact_list_t,
  tenancy_information dbms_cloud_oci_cims_tenancy_information_t,
  ticket dbms_cloud_oci_cims_ticket_t,
  incident_type dbms_cloud_oci_cims_incident_type_t,
  problem_type varchar2(32767),
  referrer varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_incident_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_incident_t (
    key varchar2,
    compartment_id varchar2,
    contact_list dbms_cloud_oci_cims_contact_list_t,
    tenancy_information dbms_cloud_oci_cims_tenancy_information_t,
    ticket dbms_cloud_oci_cims_ticket_t,
    incident_type dbms_cloud_oci_cims_incident_type_t,
    problem_type varchar2,
    referrer varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

key

(required) Unique identifier for the support ticket.

compartment_id

(optional) The OCID of the tenancy.

contact_list

(optional)

tenancy_information

(optional)

ticket

(optional)

incident_type

(optional)

problem_type

(optional) The kind of support ticket, such as a technical support request or a limit increase request.

Allowed values are: 'LIMIT', 'LEGACY_LIMIT', 'TECH', 'ACCOUNT', 'TAXONOMY'

referrer

(optional) The incident referrer. This value is often the URL that the customer used when creating the support ticket.

DBMS_CLOUD_OCI_CIMS_SERVICE_CATEGORY_T Type

Information about the support ticket classifier.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_service_category_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  name varchar2(32767),
  label varchar2(32767),
  description varchar2(32767),
  issue_type_list dbms_cloud_oci_cims_issue_type_tbl,
  scope varchar2(32767),
  unit varchar2(32767),
  limit_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_service_category_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_service_category_t (
    key varchar2,
    name varchar2,
    label varchar2,
    description varchar2,
    issue_type_list dbms_cloud_oci_cims_issue_type_tbl,
    scope varchar2,
    unit varchar2,
    limit_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

key

(optional) The unique ID that identifies a classifier.

name

(optional) The name of the classifier.

label

(optional) The label for the classifier.

description

(optional) The text describing the classifier.

issue_type_list

(optional) The list of issues.

scope

(optional) The scope of the incident.

Allowed values are: 'AD', 'REGION', 'TENANCY', 'NONE'

unit

(optional) The unit to use to measure the service category or resource.

Allowed values are: 'COUNT', 'GB', 'NONE'

limit_id

(optional) The unique ID for the limit.

DBMS_CLOUD_OCI_CIMS_SERVICE_CATEGORIES_T Type

List of Service Categories of a Service for MOS Taxonomy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_service_categories_t FORCE AUTHID CURRENT_USER IS OBJECT (
  service_category json_element_t,
  schema varchar2(32767),
  issue_type json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_service_categories_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_service_categories_t (
    service_category json_element_t,
    schema varchar2,
    issue_type json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

service_category

(optional) Service Category list.

schema

(optional) Schema of a Service Category.

issue_type

(optional) Issue type list.

DBMS_CLOUD_OCI_CIMS_SERVICE_CATEGORY_TBL Type

Nested table type of dbms_cloud_oci_cims_service_category_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_service_category_tbl FORCE IS TABLE OF (dbms_cloud_oci_cims_service_category_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_CIMS_SERVICE_CATEGORIES_TBL Type

Nested table type of dbms_cloud_oci_cims_service_categories_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_service_categories_tbl FORCE IS TABLE OF (dbms_cloud_oci_cims_service_categories_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_CIMS_INCIDENT_RESOURCE_TYPE_T Type

Details about the resource associated with the support request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_incident_resource_type_t FORCE AUTHID CURRENT_USER IS OBJECT (
  resource_type_key varchar2(32767),
  name varchar2(32767),
  label varchar2(32767),
  description varchar2(32767),
  service_category_list dbms_cloud_oci_cims_service_category_tbl,
  service json_element_t,
  service_categories dbms_cloud_oci_cims_service_categories_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_incident_resource_type_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_incident_resource_type_t (
    resource_type_key varchar2,
    name varchar2,
    label varchar2,
    description varchar2,
    service_category_list dbms_cloud_oci_cims_service_category_tbl,
    service json_element_t,
    service_categories dbms_cloud_oci_cims_service_categories_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

resource_type_key

(optional) A unique identifier for the resource.

name

(optional) The display name of the resource.

label

(required) The label associated with the resource.

description

(optional) The description of the resource.

service_category_list

(optional) The service category list.

service

(optional) The map of services for MOS Taxonomy.

service_categories

(optional) The service categories list for MOS Taxonomy.

DBMS_CLOUD_OCI_CIMS_INCIDENT_SUMMARY_T Type

Details about the support ticket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_incident_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  compartment_id varchar2(32767),
  contact_list dbms_cloud_oci_cims_contact_list_t,
  tenancy_information dbms_cloud_oci_cims_tenancy_information_t,
  ticket dbms_cloud_oci_cims_ticket_t,
  incident_type dbms_cloud_oci_cims_incident_resource_type_t,
  problem_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_incident_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_incident_summary_t (
    key varchar2,
    compartment_id varchar2,
    contact_list dbms_cloud_oci_cims_contact_list_t,
    tenancy_information dbms_cloud_oci_cims_tenancy_information_t,
    ticket dbms_cloud_oci_cims_ticket_t,
    incident_type dbms_cloud_oci_cims_incident_resource_type_t,
    problem_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

key

(required) Unique identifier of the incident.

compartment_id

(optional) The OCID of the tenancy.

contact_list

(optional)

tenancy_information

(optional)

ticket

(optional)

incident_type

(optional)

problem_type

(required) The kind of support ticket, such as a technical support request or a limit increase request.

Allowed values are: 'LIMIT', 'LEGACY_LIMIT', 'TECH', 'ACCOUNT', 'TAXONOMY'

DBMS_CLOUD_OCI_CIMS_LIMIT_ITEM_T Type

Details about the LimitItem object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_limit_item_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_cims_item_t (
  current_limit number,
  current_usage number,
  requested_limit number,
  limit_status varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_limit_item_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_limit_item_t (
    item_key varchar2,
    name varchar2,
    l_type varchar2,
    category dbms_cloud_oci_cims_category_t,
    sub_category dbms_cloud_oci_cims_sub_category_t,
    issue_type dbms_cloud_oci_cims_issue_type_t,
    current_limit number,
    current_usage number,
    requested_limit number,
    limit_status varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_cims_limit_item_t is a subtype of the dbms_cloud_oci_cims_item_t type.

Fields

Field Description

current_limit

(optional) The current service limit for the resource.

current_usage

(optional) The current resource usage.

requested_limit

(optional) The new service limit being requested for the resource.

limit_status

(optional) The status of the request.

Allowed values are: 'APPROVED', 'PARTIALLY_APPROVED', 'NOT_APPROVED'

DBMS_CLOUD_OCI_CIMS_STATUS_T Type

Details about the status of the support ticket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_status_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_status_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_status_t (
    code varchar2,
    message varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

code

(required) The code unique to this ticket status.

message

(required) The status message for this ticket.

DBMS_CLOUD_OCI_CIMS_TECH_SUPPORT_ITEM_T Type

Details about the TechSupportItem object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_tech_support_item_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_cims_item_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_tech_support_item_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_tech_support_item_t (
    item_key varchar2,
    name varchar2,
    l_type varchar2,
    category dbms_cloud_oci_cims_category_t,
    sub_category dbms_cloud_oci_cims_sub_category_t,
    issue_type dbms_cloud_oci_cims_issue_type_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_cims_tech_support_item_t is a subtype of the dbms_cloud_oci_cims_item_t type.

DBMS_CLOUD_OCI_CIMS_UPDATE_ITEM_DETAILS_T Type

Details for updating an item.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_update_item_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_update_item_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_update_item_details_t (
    l_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Field Description

l_type

(optional) The type of the ticket.

DBMS_CLOUD_OCI_CIMS_UPDATE_ACTIVITY_ITEM_DETAILS_T Type

Details for updating the support ticket activity.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_update_activity_item_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_cims_update_item_details_t (
  comments varchar2(32767),
  activity_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_update_activity_item_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_update_activity_item_details_t (
    l_type varchar2,
    comments varchar2,
    activity_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_cims_update_activity_item_details_t is a subtype of the dbms_cloud_oci_cims_update_item_details_t type.

Fields

Field Description

comments

(optional) Comments updated at the time that the activity occurs.

activity_type

(optional) The type of activity occurring.

Allowed values are: 'NOTES', 'PROBLEM_DESCRIPTION', 'UPDATE', 'CLOSE', 'REOPEN'

DBMS_CLOUD_OCI_CIMS_UPDATE_TICKET_DETAILS_T Type

Details about the ticket updated.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_update_ticket_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_resource json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_update_ticket_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_update_ticket_details_t (
    l_resource json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

l_resource

(required) The list of resources.

DBMS_CLOUD_OCI_CIMS_UPDATE_INCIDENT_T Type

Details about the support ticket being updated.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_update_incident_t FORCE AUTHID CURRENT_USER IS OBJECT (
  ticket dbms_cloud_oci_cims_update_ticket_details_t,
  problem_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_update_incident_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_update_incident_t (
    ticket dbms_cloud_oci_cims_update_ticket_details_t,
    problem_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

ticket

(required)

problem_type

(optional) The kind of support ticket, such as a technical support request or a limit increase request.

Allowed values are: 'LIMIT', 'LEGACY_LIMIT', 'TECH', 'ACCOUNT', 'TAXONOMY'

DBMS_CLOUD_OCI_CIMS_UPDATE_RESOURCE_DETAILS_T Type

Details about updates to the resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_update_resource_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  item dbms_cloud_oci_cims_update_item_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_update_resource_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_update_resource_details_t (
    item dbms_cloud_oci_cims_update_item_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

item

(optional)

DBMS_CLOUD_OCI_CIMS_USER_T Type

Details about the user.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_user_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  first_name varchar2(32767),
  last_name varchar2(32767),
  country varchar2(32767),
  csi varchar2(32767),
  phone varchar2(32767),
  timezone varchar2(32767),
  organization_name varchar2(32767),
  compartment_id varchar2(32767),
  contact_email varchar2(32767),
  problem_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_user_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_user_t (
    key varchar2,
    first_name varchar2,
    last_name varchar2,
    country varchar2,
    csi varchar2,
    phone varchar2,
    timezone varchar2,
    organization_name varchar2,
    compartment_id varchar2,
    contact_email varchar2,
    problem_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

key

(required) A unique identifier for the user.

first_name

(optional) The user's first name.

last_name

(optional) The user's last name.

country

(optional) The country of the user.

csi

(optional) The CSI associated with the user.

phone

(optional) The user's contact phone number.

timezone

(optional) The timezone of the user.

organization_name

(optional) The company that the user belongs to.

compartment_id

(optional) The OCID of the tenancy.

contact_email

(optional) The email of the contact person.

problem_type

(optional) The kind of support ticket, such as a technical support request or a limit increase request.

Allowed values are: 'LIMIT', 'LEGACY_LIMIT', 'TECH', 'ACCOUNT', 'TAXONOMY'

DBMS_CLOUD_OCI_CIMS_VALIDATION_RESPONSE_T Type

The validation response returned when checking whether the requested user is valid.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_cims_validation_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_valid_user number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_validation_response_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_cims_validation_response_t (
    is_valid_user number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

is_valid_user

(optional) Boolean value that indicates whether the requested user is valid.

Was this article helpful?