EM Warehouse Common Types

DBMS_CLOUD_OCI_EM_WAREHOUSE_VARCHAR2_TBL Type

Nested table type of varchar2(32767).

Syntax

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

DBMS_CLOUD_OCI_EM_WAREHOUSE_CHANGE_EM_WAREHOUSE_COMPARTMENT_DETAILS_T Type

The information to be updated.

Syntax

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

Fields

Field	Description
`compartment_id`	(required) The OCID of the compartment into which the resource should be moved.

DBMS_CLOUD_OCI_EM_WAREHOUSE_CREATE_EM_WAREHOUSE_DETAILS_T Type

The information about new EmWarehouse.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_create_em_warehouse_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  em_bridge_id varchar2(32767),
  compartment_id varchar2(32767),
  operations_insights_warehouse_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_create_em_warehouse_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_create_em_warehouse_details_t (
    display_name varchar2,
    em_bridge_id varchar2,
    compartment_id varchar2,
    operations_insights_warehouse_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`display_name`	(optional) EmWarehouse Identifier
`em_bridge_id`	(required) EMBridge Identifier
`compartment_id`	(required) Compartment Identifier
`operations_insights_warehouse_id`	(required) operations Insights Warehouse Identifier
`freeform_tags`	(optional) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: `{\"bar-key\": \"value\"}`
`defined_tags`	(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: `{\"foo-namespace\": {\"bar-key\": \"value\"}}`

DBMS_CLOUD_OCI_EM_WAREHOUSE_EM_INSTANCES_DETAILS_T Type

Results of a emWarehouse search. Contains boh EmWarehouseSummary items and other information, such as metadata.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_em_instances_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  em_id varchar2(32767),
  targets_count number,
  em_host varchar2(32767),
  em_discoverer_url varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_em_instances_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_em_instances_details_t (
    em_id varchar2,
    targets_count number,
    em_host varchar2,
    em_discoverer_url varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`em_id`	(required) operations Insights Warehouse Identifier
`targets_count`	(optional) EmInstance Target count
`em_host`	(optional) emHost name
`em_discoverer_url`	(optional) emdDiscoverer url

DBMS_CLOUD_OCI_EM_WAREHOUSE_EM_WAREHOUSE_T Type

Description of EmWarehouse.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_em_warehouse_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operations_insights_warehouse_id varchar2(32767),
  latest_etl_run_status varchar2(32767),
  latest_etl_run_message varchar2(32767),
  latest_etl_run_time varchar2(32767),
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  em_warehouse_type varchar2(32767),
  em_bridge_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_em_warehouse_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_em_warehouse_t (
    operations_insights_warehouse_id varchar2,
    latest_etl_run_status varchar2,
    latest_etl_run_message varchar2,
    latest_etl_run_time varchar2,
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    em_warehouse_type varchar2,
    em_bridge_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`operations_insights_warehouse_id`	(required) operations Insights Warehouse Identifier
`latest_etl_run_status`	(optional) Data Flow Run Status
`latest_etl_run_message`	(optional) Data Flow Run Status Message
`latest_etl_run_time`	(optional) Data Flow Run Total Time
`id`	(required) Unique identifier that is immutable on creation
`display_name`	(required) EmWarehouse Identifier, can be renamed
`compartment_id`	(required) Compartment Identifier
`em_warehouse_type`	(required) Type of the EmWarehouse.
`em_bridge_id`	(optional) EMBridge Identifier
`time_created`	(required) The time the the EmWarehouse was created. An RFC3339 formatted datetime string
`time_updated`	(optional) The time the EmWarehouse was updated. An RFC3339 formatted datetime string
`lifecycle_state`	(required) The current state of the EmWarehouse. Allowed values are: 'CREATING', 'UPDATING', 'ACTIVE', 'DELETING', 'DELETED', 'FAILED'
`lifecycle_details`	(optional) A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
`freeform_tags`	(required) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: `{\"bar-key\": \"value\"}`
`defined_tags`	(required) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: `{\"foo-namespace\": {\"bar-key\": \"value\"}}`
`system_tags`	(optional) Usage of system tag keys. These predefined keys are scoped to namespaces. Example: `{\"orcl-cloud\": {\"free-tier-retained\": \"true\"}}`

DBMS_CLOUD_OCI_EM_WAREHOUSE_EM_WAREHOUSE_SUMMARY_T Type

Summary of the EmWarehouse.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_em_warehouse_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operations_insights_warehouse_id varchar2(32767),
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  em_warehouse_type varchar2(32767),
  em_bridge_id varchar2(32767),
  latest_etl_run_status varchar2(32767),
  latest_etl_run_message varchar2(32767),
  latest_etl_run_time varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_em_warehouse_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_em_warehouse_summary_t (
    operations_insights_warehouse_id varchar2,
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    em_warehouse_type varchar2,
    em_bridge_id varchar2,
    latest_etl_run_status varchar2,
    latest_etl_run_message varchar2,
    latest_etl_run_time varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`operations_insights_warehouse_id`	(required) operations Insights Warehouse Identifier
`id`	(required) Unique identifier that is immutable on creation
`display_name`	(required) EmWarehouse Identifier, can be renamed
`compartment_id`	(required) Compartment Identifier
`em_warehouse_type`	(required) Type of the EmWarehouse.
`em_bridge_id`	(optional) EMBridge Identifier
`latest_etl_run_status`	(optional) Data Flow Run Status
`latest_etl_run_message`	(optional) Data Flow Run Status Message
`latest_etl_run_time`	(optional) Data Flow Run Total Time
`time_created`	(required) The time the the EmWarehouse was created. An RFC3339 formatted datetime string
`time_updated`	(optional) The time the EmWarehouse was updated. An RFC3339 formatted datetime string
`lifecycle_state`	(required) The current state of the EmWarehouse.
`lifecycle_details`	(optional) A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
`freeform_tags`	(required) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: `{\"bar-key\": \"value\"}`
`defined_tags`	(required) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: `{\"foo-namespace\": {\"bar-key\": \"value\"}}`
`system_tags`	(optional) Usage of system tag keys. These predefined keys are scoped to namespaces. Example: `{\"orcl-cloud\": {\"free-tier-retained\": \"true\"}}`

DBMS_CLOUD_OCI_EM_WAREHOUSE_EM_WAREHOUSE_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_em_warehouse_em_warehouse_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_em_warehouse_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_em_warehouse_em_warehouse_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_EM_WAREHOUSE_EM_WAREHOUSE_COLLECTION_T Type

Results of a emWarehouse search. Contains boh EmWarehouseSummary items and other information, such as metadata.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_em_warehouse_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_em_warehouse_em_warehouse_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_em_warehouse_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_em_warehouse_collection_t (
    items dbms_cloud_oci_em_warehouse_em_warehouse_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`items`	(required) List of emWarehouses.

DBMS_CLOUD_OCI_EM_WAREHOUSE_ERROR_T Type

Error Information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_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.
`message`	(required) A human-readable error string.

DBMS_CLOUD_OCI_EM_WAREHOUSE_ETL_RUN_SUMMARY_T Type

Contains summary of a run.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_etl_run_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  data_read_in_bytes number,
  data_written number,
  lifecycle_state varchar2(32767),
  display_name varchar2(32767),
  lifecycle_details varchar2(32767),
  run_duration_in_milliseconds number,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_etl_run_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_etl_run_summary_t (
    compartment_id varchar2,
    data_read_in_bytes number,
    data_written number,
    lifecycle_state varchar2,
    display_name varchar2,
    lifecycle_details varchar2,
    run_duration_in_milliseconds number,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`compartment_id`	(required) Compartment Identifier
`data_read_in_bytes`	(optional) Data read by the dataflow run
`data_written`	(optional) Data written by the dataflow run
`lifecycle_state`	(optional) The current state of the etlRun. Allowed values are: 'ACCEPTED', 'IN_PROGRESS', 'CANCELING', 'CANCELED', 'FAILED', 'SUCCEEDED'
`display_name`	(optional) The name of the ETLRun.
`lifecycle_details`	(optional) Details of the lifecycle state
`run_duration_in_milliseconds`	(optional) Dataflow run duration
`time_created`	(optional) Time when the dataflow run was created
`time_updated`	(optional) Time when the dataflow run was updated
`freeform_tags`	(optional) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: `{\"bar-key\": \"value\"}`
`defined_tags`	(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: `{\"foo-namespace\": {\"bar-key\": \"value\"}}`

DBMS_CLOUD_OCI_EM_WAREHOUSE_ETL_RUN_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_em_warehouse_etl_run_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_etl_run_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_em_warehouse_etl_run_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_EM_WAREHOUSE_ETL_RUN_COLLECTION_T Type

The runs list.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_etl_run_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_em_warehouse_etl_run_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_etl_run_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_etl_run_collection_t (
    items dbms_cloud_oci_em_warehouse_etl_run_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`items`	(required) List of runs

DBMS_CLOUD_OCI_EM_WAREHOUSE_EM_INSTANCES_DETAILS_TBL Type

Nested table type of dbms_cloud_oci_em_warehouse_em_instances_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_em_instances_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_em_warehouse_em_instances_details_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_EM_WAREHOUSE_RESOURCE_USAGE_T Type

The resource usage information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_resource_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operations_insights_warehouse_id varchar2(32767),
  id varchar2(32767),
  em_instance_count number,
  targets_count number,
  em_instances dbms_cloud_oci_em_warehouse_em_instances_details_tbl,
  schema_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_resource_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_resource_usage_t (
    operations_insights_warehouse_id varchar2,
    id varchar2,
    em_instance_count number,
    targets_count number,
    em_instances dbms_cloud_oci_em_warehouse_em_instances_details_tbl,
    schema_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`operations_insights_warehouse_id`	(required) operations Insights Warehouse Identifier
`id`	(required) Unique identifier that is immutable on creation
`em_instance_count`	(optional) EmInstanceCount
`targets_count`	(optional) EmInstance Target count
`em_instances`	(optional) List of emInstances
`schema_name`	(optional) schema name

DBMS_CLOUD_OCI_EM_WAREHOUSE_UPDATE_EM_WAREHOUSE_DETAILS_T Type

The information to be updated.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_update_em_warehouse_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  em_bridge_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_update_em_warehouse_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_update_em_warehouse_details_t (
    compartment_id varchar2,
    em_bridge_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`compartment_id`	(optional) Compartment Identifier
`em_bridge_id`	(optional) EMBridge Identifier
`freeform_tags`	(optional) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: `{\"bar-key\": \"value\"}`
`defined_tags`	(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: `{\"foo-namespace\": {\"bar-key\": \"value\"}}`

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_RESOURCE_T Type

A resource created or operated on by a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_resource_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entity_type varchar2(32767),
  action_type varchar2(32767),
  identifier varchar2(32767),
  entity_uri varchar2(32767),
  metadata json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_resource_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_resource_t (
    entity_type varchar2,
    action_type varchar2,
    identifier varchar2,
    entity_uri varchar2,
    metadata json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`entity_type`	(required) The resource type the work request affects.
`action_type`	(required) The way in which this resource is affected by the work tracked in the work request. A resource being created, updated, or deleted will remain in the IN_PROGRESS state until work is complete for that resource at which point it will transition to CREATED, UPDATED, or DELETED, respectively. Allowed values are: 'CREATED', 'UPDATED', 'DELETED', 'IN_PROGRESS', 'RELATED', 'FAILED'
`identifier`	(required) The identifier of the resource the work request affects.
`entity_uri`	(optional) The URI path that the user can do a GET on to access the resource metadata
`metadata`	(optional) Additional information that helps to explain the resource.

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_RESOURCE_TBL Type

Nested table type of dbms_cloud_oci_em_warehouse_work_request_resource_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_resource_tbl FORCE IS TABLE OF (dbms_cloud_oci_em_warehouse_work_request_resource_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_T Type

A description of workrequest status

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operation_type varchar2(32767),
  status varchar2(32767),
  id varchar2(32767),
  compartment_id varchar2(32767),
  resources dbms_cloud_oci_em_warehouse_work_request_resource_tbl,
  percent_complete number,
  time_accepted timestamp with time zone,
  time_started timestamp with time zone,
  time_finished timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_em_warehouse_work_request_resource_tbl,
    percent_complete number,
    time_accepted timestamp with time zone,
    time_started timestamp with time zone,
    time_finished timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`operation_type`	(required) Type of the work request Allowed values are: 'CREATE_EM_WAREHOUSE', 'UPDATE_EM_WAREHOUSE', 'DELETE_EM_WAREHOUSE', 'MOVE_EM_WAREHOUSE'
`status`	(required) Status of current work request. Allowed values are: 'ACCEPTED', 'IN_PROGRESS', 'WAITING', 'FAILED', 'SUCCEEDED', 'CANCELING', 'CANCELED'
`id`	(required) The id of the work request.
`compartment_id`	(required) The ocid of the compartment that contains the work request. Work requests should be scoped to the same compartment as the resource the work request affects. If the work request affects multiple resources, and those resources are not in the same compartment, it is up to the service team to pick the primary resource whose compartment should be used
`resources`	(required) The resources affected by this work request.
`percent_complete`	(required) Percentage of the request completed.
`time_accepted`	(required) The date and time the request was created, as described in RFC 3339, section 14.29.
`time_started`	(optional) The date and time the request was started, as described in RFC 3339, section 14.29.
`time_finished`	(optional) The date and time the object was finished, as described in RFC 3339.

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_ERROR_T Type

An error encountered while executing a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  l_timestamp timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_error_t (
    code varchar2,
    message varchar2,
    l_timestamp timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`code`	(required) A machine-usable code for the error that occured. Error codes are listed on (https://docs.cloud.oracle.com/Content/API/References/apierrors.htm)
`message`	(required) A human readable description of the issue encountered.
`l_timestamp`	(required) The time the error occured. An RFC3339 formatted datetime string.

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_ERROR_TBL Type

Nested table type of dbms_cloud_oci_em_warehouse_work_request_error_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_error_tbl FORCE IS TABLE OF (dbms_cloud_oci_em_warehouse_work_request_error_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_ERROR_COLLECTION_T Type

Results of a workRequestError search. Contains both WorkRequestError items and other information, such as metadata.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_error_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_em_warehouse_work_request_error_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_error_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_error_collection_t (
    items dbms_cloud_oci_em_warehouse_work_request_error_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`items`	(required) List of workRequestError objects.

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_LOG_ENTRY_T Type

A log message from the execution of a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_log_entry_t FORCE AUTHID CURRENT_USER IS OBJECT (
  message varchar2(32767),
  l_timestamp timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_log_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_log_entry_t (
    message varchar2,
    l_timestamp timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`message`	(required) Human-readable log message.
`l_timestamp`	(required) The time the log message was written. An RFC3339 formatted datetime string

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_LOG_ENTRY_TBL Type

Nested table type of dbms_cloud_oci_em_warehouse_work_request_log_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_log_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_em_warehouse_work_request_log_entry_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_LOG_ENTRY_COLLECTION_T Type

Results of a workRequestLog search. Contains both workRequestLog items and other information, such as metadata.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_log_entry_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_em_warehouse_work_request_log_entry_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_log_entry_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_log_entry_collection_t (
    items dbms_cloud_oci_em_warehouse_work_request_log_entry_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`items`	(required) List of workRequestLogEntries.

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_SUMMARY_T Type

A summary of the status of a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operation_type varchar2(32767),
  status varchar2(32767),
  id varchar2(32767),
  compartment_id varchar2(32767),
  resources dbms_cloud_oci_em_warehouse_work_request_resource_tbl,
  percent_complete number,
  time_accepted timestamp with time zone,
  time_started timestamp with time zone,
  time_finished timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_summary_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_em_warehouse_work_request_resource_tbl,
    percent_complete number,
    time_accepted timestamp with time zone,
    time_started timestamp with time zone,
    time_finished timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`operation_type`	(required) Type of the work request Allowed values are: 'CREATE_EM_WAREHOUSE', 'UPDATE_EM_WAREHOUSE', 'DELETE_EM_WAREHOUSE', 'MOVE_EM_WAREHOUSE'
`status`	(required) Status of current work request. Allowed values are: 'ACCEPTED', 'IN_PROGRESS', 'WAITING', 'FAILED', 'SUCCEEDED', 'CANCELING', 'CANCELED'
`id`	(required) The id of the work request.
`compartment_id`	(required) The ocid of the compartment that contains the work request. Work requests should be scoped to the same compartment as the resource the work request affects. If the work request affects multiple resources, and those resources are not in the same compartment, it is up to the service team to pick the primary resource whose compartment should be used
`resources`	(required) The resources affected by this work request.
`percent_complete`	(required) Percentage of the request completed.
`time_accepted`	(required) The date and time the request was created, as described in RFC 3339, section 14.29.
`time_started`	(optional) The date and time the request was started, as described in RFC 3339, section 14.29.
`time_finished`	(optional) The date and time the object was finished, as described in RFC 3339.

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_em_warehouse_work_request_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_em_warehouse_work_request_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_SUMMARY_COLLECTION_T Type

Results of a workRequest search. Contains both WorkRequest items and other information, such as metadata.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_summary_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_em_warehouse_work_request_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_summary_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_work_request_summary_collection_t (
    items dbms_cloud_oci_em_warehouse_work_request_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`items`	(required) List of workRequestSummary objects.

Oracle Cloud Infrastructure Documentation