Nested table type of varchar2(32767).

Syntax

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

Action details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_action_t FORCE AUTHID CURRENT_USER IS OBJECT (
  reference_key varchar2(32767),
  action_type varchar2(32767),
  state varchar2(32767),
  description varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_action_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_action_t (
    reference_key varchar2,
    action_type varchar2,
    state varchar2,
    description varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

IDM admin credentials without password

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_admin_user_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  username varchar2(32767),
  email_address varchar2(32767),
  first_name varchar2(32767),
  last_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_admin_user_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_admin_user_summary_t (
    username varchar2,
    email_address varchar2,
    first_name varchar2,
    last_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_fusion_apps_admin_user_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_admin_user_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_admin_user_summary_t) NOT PERSISTABLE;

IDM admin credentials without password

Syntax

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

Fields

A condition to apply to an access control rule.

Syntax

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

Fields

An object that represents an action to apply to a listener.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_fusion_apps_rule_condition_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_rule_condition_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_rule_condition_t) NOT PERSISTABLE;

An object that represents the action of configuring an access control rule. Access control rules permit access to application resources based on user-specified match conditions. This rule applies only to HTTP listeners. **NOTES:** * If you do not specify any access control rules, the default rule is to allow all traffic. * If you add access control rules, the load balancer denies any traffic that does not match the rules. * Maximum of two match conditions can be specified in a rule. * You can specify this rule only with the following `RuleCondition` combinations: * `SOURCE_IP_ADDRESS` * `SOURCE_VCN_ID` * `SOURCE_VCN_ID\", \"SOURCE_VCN_IP_ADDRESS`

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_allow_rule_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_fusion_apps_rule_t (
  conditions dbms_cloud_oci_fusion_apps_rule_condition_tbl,
  description varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_allow_rule_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_allow_rule_t (
    action varchar2,
    conditions dbms_cloud_oci_fusion_apps_rule_condition_tbl,
    description varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_fusion_apps_allow_rule_t is a subtype of the dbms_cloud_oci_fusion_apps_rule_t type.

Fields

Status of capabilities that can be enabled for an environment family.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_capabilities_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_data_masking_enabled number,
  is_break_glass_enabled number,
  is_byok_enabled number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_capabilities_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_capabilities_t (
    is_data_masking_enabled number,
    is_break_glass_enabled number,
    is_byok_enabled number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about the compartment the Fusion environment should move to.

Syntax

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

Fields

Details about the compartment the environment family should be moved to.

Syntax

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

Fields

The information about current data masking request.

Syntax

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

Fields

The credentials for the Fusion Applications service administrator.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_create_fusion_environment_admin_user_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  username varchar2(32767),
  password varchar2(32767),
  email_address varchar2(32767),
  first_name varchar2(32767),
  last_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_create_fusion_environment_admin_user_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_create_fusion_environment_admin_user_details_t (
    username varchar2,
    password varchar2,
    email_address varchar2,
    first_name varchar2,
    last_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The policy that specifies the maintenance and upgrade preferences for an environment. For more information about the options, see Understanding Environment Maintenance.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_fusion_apps_rule_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_rule_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_rule_t) NOT PERSISTABLE;

The configuration details of the FusionEnvironment. For more information about these fields, see Managing Environments.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_create_fusion_environment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  maintenance_policy dbms_cloud_oci_fusion_apps_maintenance_policy_t,
  compartment_id varchar2(32767),
  fusion_environment_family_id varchar2(32767),
  fusion_environment_type varchar2(32767),
  kms_key_id varchar2(32767),
  dns_prefix varchar2(32767),
  additional_language_packs dbms_cloud_oci_fusion_apps_varchar2_tbl,
  rules dbms_cloud_oci_fusion_apps_rule_tbl,
  create_fusion_environment_admin_user_details dbms_cloud_oci_fusion_apps_create_fusion_environment_admin_user_details_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_create_fusion_environment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_create_fusion_environment_details_t (
    display_name varchar2,
    maintenance_policy dbms_cloud_oci_fusion_apps_maintenance_policy_t,
    compartment_id varchar2,
    fusion_environment_family_id varchar2,
    fusion_environment_type varchar2,
    kms_key_id varchar2,
    dns_prefix varchar2,
    additional_language_packs dbms_cloud_oci_fusion_apps_varchar2_tbl,
    rules dbms_cloud_oci_fusion_apps_rule_tbl,
    create_fusion_environment_admin_user_details dbms_cloud_oci_fusion_apps_create_fusion_environment_admin_user_details_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The policy that specifies the maintenance and upgrade preferences for an environment. For more information about the options, see Understanding Environment Maintenance.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_family_maintenance_policy_t FORCE AUTHID CURRENT_USER IS OBJECT (
  quarterly_upgrade_begin_times varchar2(32767),
  is_monthly_patching_enabled number,
  concurrent_maintenance varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_family_maintenance_policy_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_family_maintenance_policy_t (
    quarterly_upgrade_begin_times varchar2,
    is_monthly_patching_enabled number,
    concurrent_maintenance varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about new FusionEnvironmentFamily.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_create_fusion_environment_family_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  family_maintenance_policy dbms_cloud_oci_fusion_apps_family_maintenance_policy_t,
  compartment_id varchar2(32767),
  subscription_ids dbms_cloud_oci_fusion_apps_varchar2_tbl,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_create_fusion_environment_family_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_create_fusion_environment_family_details_t (
    display_name varchar2,
    family_maintenance_policy dbms_cloud_oci_fusion_apps_family_maintenance_policy_t,
    compartment_id varchar2,
    subscription_ids dbms_cloud_oci_fusion_apps_varchar2_tbl,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about current refresh.

Syntax

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

Fields

Information about the service attachment to be created.

Syntax

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

Fields

Details of data masking activity.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_data_masking_activity_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  fusion_environment_id varchar2(32767),
  lifecycle_state varchar2(32767),
  time_masking_start timestamp with time zone,
  time_masking_finish timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_data_masking_activity_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_data_masking_activity_t (
    id varchar2,
    fusion_environment_id varchar2,
    lifecycle_state varchar2,
    time_masking_start timestamp with time zone,
    time_masking_finish timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the data masking activity.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_data_masking_activity_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  lifecycle_state varchar2(32767),
  time_masking_start timestamp with time zone,
  time_masking_finish timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_data_masking_activity_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_data_masking_activity_summary_t (
    id varchar2,
    lifecycle_state varchar2,
    time_masking_start timestamp with time zone,
    time_masking_finish timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_fusion_apps_data_masking_activity_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_data_masking_activity_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_data_masking_activity_summary_t) NOT PERSISTABLE;

Results of data masking activities on a given Fusion Environment.

Syntax

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

Fields

Describes the role of the FA Environment.

Syntax

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

Fields

Error Information.

Syntax

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

Fields

Determines the quarterly upgrade begin times (monthly maintenance group schedule ) of the Fusion environment.

Syntax

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

Fields

The policy that specifies the maintenance and upgrade preferences for an environment. For more information about the options, see Understanding Environment Maintenance.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_get_maintenance_policy_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  quarterly_upgrade_begin_times dbms_cloud_oci_fusion_apps_quarterly_upgrade_begin_times_t,
  monthly_patching_override varchar2(32767),
  environment_maintenance_override varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_get_maintenance_policy_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_get_maintenance_policy_details_t (
    quarterly_upgrade_begin_times dbms_cloud_oci_fusion_apps_quarterly_upgrade_begin_times_t,
    monthly_patching_override varchar2,
    environment_maintenance_override varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Describes a refresh of a fusion environment

Syntax

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

Fields

Description of FusionEnvironment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_fusion_environment_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  maintenance_policy dbms_cloud_oci_fusion_apps_get_maintenance_policy_details_t,
  time_upcoming_maintenance timestamp with time zone,
  compartment_id varchar2(32767),
  fusion_environment_family_id varchar2(32767),
  subscription_ids dbms_cloud_oci_fusion_apps_varchar2_tbl,
  fusion_environment_type varchar2(32767),
  kms_key_id varchar2(32767),
  kms_key_info json_element_t,
  domain_id varchar2(32767),
  idcs_domain_url varchar2(32767),
  applied_patch_bundles dbms_cloud_oci_fusion_apps_varchar2_tbl,
  version varchar2(32767),
  public_url varchar2(32767),
  dns_prefix varchar2(32767),
  additional_language_packs dbms_cloud_oci_fusion_apps_varchar2_tbl,
  lockbox_id varchar2(32767),
  is_break_glass_enabled number,
  refresh dbms_cloud_oci_fusion_apps_refresh_details_t,
  rules dbms_cloud_oci_fusion_apps_rule_tbl,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  system_name varchar2(32767),
  environment_role dbms_cloud_oci_fusion_apps_environment_role_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_fusion_environment_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_fusion_environment_t (
    id varchar2,
    display_name varchar2,
    maintenance_policy dbms_cloud_oci_fusion_apps_get_maintenance_policy_details_t,
    time_upcoming_maintenance timestamp with time zone,
    compartment_id varchar2,
    fusion_environment_family_id varchar2,
    subscription_ids dbms_cloud_oci_fusion_apps_varchar2_tbl,
    fusion_environment_type varchar2,
    kms_key_id varchar2,
    kms_key_info json_element_t,
    domain_id varchar2,
    idcs_domain_url varchar2,
    applied_patch_bundles dbms_cloud_oci_fusion_apps_varchar2_tbl,
    version varchar2,
    public_url varchar2,
    dns_prefix varchar2,
    additional_language_packs dbms_cloud_oci_fusion_apps_varchar2_tbl,
    lockbox_id varchar2,
    is_break_glass_enabled number,
    refresh dbms_cloud_oci_fusion_apps_refresh_details_t,
    rules dbms_cloud_oci_fusion_apps_rule_tbl,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    system_name varchar2,
    environment_role dbms_cloud_oci_fusion_apps_environment_role_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the internal FA Environment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_fusion_environment_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  time_upcoming_maintenance timestamp with time zone,
  maintenance_policy dbms_cloud_oci_fusion_apps_get_maintenance_policy_details_t,
  compartment_id varchar2(32767),
  fusion_environment_family_id varchar2(32767),
  subscription_ids dbms_cloud_oci_fusion_apps_varchar2_tbl,
  applied_patch_bundles dbms_cloud_oci_fusion_apps_varchar2_tbl,
  fusion_environment_type varchar2(32767),
  version varchar2(32767),
  public_url varchar2(32767),
  dns_prefix varchar2(32767),
  additional_language_packs dbms_cloud_oci_fusion_apps_varchar2_tbl,
  lockbox_id varchar2(32767),
  is_break_glass_enabled number,
  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,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_fusion_environment_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_fusion_environment_summary_t (
    id varchar2,
    display_name varchar2,
    time_upcoming_maintenance timestamp with time zone,
    maintenance_policy dbms_cloud_oci_fusion_apps_get_maintenance_policy_details_t,
    compartment_id varchar2,
    fusion_environment_family_id varchar2,
    subscription_ids dbms_cloud_oci_fusion_apps_varchar2_tbl,
    applied_patch_bundles dbms_cloud_oci_fusion_apps_varchar2_tbl,
    fusion_environment_type varchar2,
    version varchar2,
    public_url varchar2,
    dns_prefix varchar2,
    additional_language_packs dbms_cloud_oci_fusion_apps_varchar2_tbl,
    lockbox_id varchar2,
    is_break_glass_enabled number,
    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
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_fusion_apps_fusion_environment_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_fusion_environment_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_fusion_environment_summary_t) NOT PERSISTABLE;

Results of a fusion environment search.

Syntax

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

Fields

Details of a Fusion environment family. An environment family is a logical grouping of environments. The environment family defines a set of characteristics that are shared across the environments to allow consistent management and maintenance across your production, test, and development environments. For more information, see Planning an Environment Family.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_fusion_environment_family_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  family_maintenance_policy dbms_cloud_oci_fusion_apps_family_maintenance_policy_t,
  compartment_id varchar2(32767),
  subscription_ids dbms_cloud_oci_fusion_apps_varchar2_tbl,
  is_subscription_update_needed number,
  time_created timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  system_name varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_fusion_environment_family_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_fusion_environment_family_t (
    id varchar2,
    display_name varchar2,
    family_maintenance_policy dbms_cloud_oci_fusion_apps_family_maintenance_policy_t,
    compartment_id varchar2,
    subscription_ids dbms_cloud_oci_fusion_apps_varchar2_tbl,
    is_subscription_update_needed number,
    time_created timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    system_name varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary information for a Fusion environment family.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_fusion_environment_family_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  family_maintenance_policy dbms_cloud_oci_fusion_apps_family_maintenance_policy_t,
  compartment_id varchar2(32767),
  subscription_ids dbms_cloud_oci_fusion_apps_varchar2_tbl,
  is_subscription_update_needed number,
  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,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_fusion_environment_family_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_fusion_environment_family_summary_t (
    id varchar2,
    display_name varchar2,
    family_maintenance_policy dbms_cloud_oci_fusion_apps_family_maintenance_policy_t,
    compartment_id varchar2,
    subscription_ids dbms_cloud_oci_fusion_apps_varchar2_tbl,
    is_subscription_update_needed number,
    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
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_fusion_apps_fusion_environment_family_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_fusion_environment_family_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_fusion_environment_family_summary_t) NOT PERSISTABLE;

Results of a Fusion environment family search.

Syntax

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

Fields

The limit and usage for a specific environment type, for example, production, development, or test.

Syntax

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

Fields

Details of EnvironmentLimits.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_fusion_environment_family_limits_and_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  production_limit_and_usage dbms_cloud_oci_fusion_apps_limit_and_usage_t,
  test_limit_and_usage dbms_cloud_oci_fusion_apps_limit_and_usage_t,
  development_limit_and_usage dbms_cloud_oci_fusion_apps_limit_and_usage_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_fusion_environment_family_limits_and_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_fusion_environment_family_limits_and_usage_t (
    production_limit_and_usage dbms_cloud_oci_fusion_apps_limit_and_usage_t,
    test_limit_and_usage dbms_cloud_oci_fusion_apps_limit_and_usage_t,
    development_limit_and_usage dbms_cloud_oci_fusion_apps_limit_and_usage_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The health status of the Fusion Applications environment. For more information, see Environment Status.

Syntax

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

Fields

kmsKeyInfo

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_kms_key_info_t FORCE AUTHID CURRENT_USER IS OBJECT (
  active_key_id varchar2(32767),
  active_key_version varchar2(32767),
  scheduled_key_id varchar2(32767),
  scheduled_key_version varchar2(32767),
  current_key_lifecycle_state varchar2(32767),
  scheduled_lifecycle_state varchar2(32767),
  scheduled_key_status varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_kms_key_info_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_kms_key_info_t (
    active_key_id varchar2,
    active_key_version varchar2,
    scheduled_key_id varchar2,
    scheduled_key_version varchar2,
    current_key_lifecycle_state varchar2,
    scheduled_lifecycle_state varchar2,
    scheduled_key_status varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Monthly patch details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_patch_action_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_fusion_apps_action_t (
  l_mode varchar2(32767),
  category varchar2(32767),
  artifact varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_patch_action_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_patch_action_t (
    reference_key varchar2,
    action_type varchar2,
    state varchar2,
    description varchar2,
    l_mode varchar2,
    category varchar2,
    artifact varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_fusion_apps_patch_action_t is a subtype of the dbms_cloud_oci_fusion_apps_action_t type.

Fields

Details of refresh failure or validation failure that needs to be investigated.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_fusion_apps_refresh_issue_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_refresh_issue_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_refresh_issue_details_t) NOT PERSISTABLE;

An environment refresh copies data from a source environment to a target environment, making a copy of the source environment onto the target environment. For more information, see Refreshing an Environment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_refresh_activity_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  source_fusion_environment_id varchar2(32767),
  time_of_restoration_point timestamp with time zone,
  lifecycle_state varchar2(32767),
  service_availability varchar2(32767),
  time_scheduled_start timestamp with time zone,
  time_expected_finish timestamp with time zone,
  time_finished timestamp with time zone,
  time_accepted timestamp with time zone,
  time_updated timestamp with time zone,
  refresh_issue_details_list dbms_cloud_oci_fusion_apps_refresh_issue_details_tbl,
  lifecycle_details varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_refresh_activity_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_refresh_activity_t (
    id varchar2,
    display_name varchar2,
    source_fusion_environment_id varchar2,
    time_of_restoration_point timestamp with time zone,
    lifecycle_state varchar2,
    service_availability varchar2,
    time_scheduled_start timestamp with time zone,
    time_expected_finish timestamp with time zone,
    time_finished timestamp with time zone,
    time_accepted timestamp with time zone,
    time_updated timestamp with time zone,
    refresh_issue_details_list dbms_cloud_oci_fusion_apps_refresh_issue_details_tbl,
    lifecycle_details varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the refresh activity.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_refresh_activity_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  source_fusion_environment_id varchar2(32767),
  time_of_restoration_point timestamp with time zone,
  lifecycle_state varchar2(32767),
  time_scheduled_start timestamp with time zone,
  time_expected_finish timestamp with time zone,
  time_finished timestamp with time zone,
  service_availability varchar2(32767),
  time_accepted timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_details varchar2(32767),
  refresh_issue_details_list dbms_cloud_oci_fusion_apps_refresh_issue_details_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_refresh_activity_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_refresh_activity_summary_t (
    id varchar2,
    display_name varchar2,
    source_fusion_environment_id varchar2,
    time_of_restoration_point timestamp with time zone,
    lifecycle_state varchar2,
    time_scheduled_start timestamp with time zone,
    time_expected_finish timestamp with time zone,
    time_finished timestamp with time zone,
    service_availability varchar2,
    time_accepted timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_details varchar2,
    refresh_issue_details_list dbms_cloud_oci_fusion_apps_refresh_issue_details_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_fusion_apps_refresh_activity_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_refresh_activity_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_refresh_activity_summary_t) NOT PERSISTABLE;

Results of a refresh activity search.

Syntax

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

Fields

IDM admin credentials

Syntax

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

Fields

Nested table type of dbms_cloud_oci_fusion_apps_action_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_action_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_action_t) NOT PERSISTABLE;

Details of scheduled activity.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_scheduled_activity_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  run_cycle varchar2(32767),
  fusion_environment_id varchar2(32767),
  lifecycle_state varchar2(32767),
  actions dbms_cloud_oci_fusion_apps_action_tbl,
  service_availability varchar2(32767),
  time_scheduled_start timestamp with time zone,
  time_expected_finish timestamp with time zone,
  time_finished timestamp with time zone,
  delay_in_hours number,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_details varchar2(32767),
  scheduled_activity_phase varchar2(32767),
  scheduled_activity_association_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_scheduled_activity_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_scheduled_activity_t (
    id varchar2,
    display_name varchar2,
    run_cycle varchar2,
    fusion_environment_id varchar2,
    lifecycle_state varchar2,
    actions dbms_cloud_oci_fusion_apps_action_tbl,
    service_availability varchar2,
    time_scheduled_start timestamp with time zone,
    time_expected_finish timestamp with time zone,
    time_finished timestamp with time zone,
    delay_in_hours number,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_details varchar2,
    scheduled_activity_phase varchar2,
    scheduled_activity_association_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the scheduled activity for a Fusion environment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_scheduled_activity_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  run_cycle varchar2(32767),
  fusion_environment_id varchar2(32767),
  lifecycle_state varchar2(32767),
  actions dbms_cloud_oci_fusion_apps_action_tbl,
  time_scheduled_start timestamp with time zone,
  time_expected_finish timestamp with time zone,
  time_finished timestamp with time zone,
  delay_in_hours number,
  service_availability varchar2(32767),
  time_accepted timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_details varchar2(32767),
  scheduled_activity_phase varchar2(32767),
  scheduled_activity_association_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_scheduled_activity_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_scheduled_activity_summary_t (
    id varchar2,
    display_name varchar2,
    run_cycle varchar2,
    fusion_environment_id varchar2,
    lifecycle_state varchar2,
    actions dbms_cloud_oci_fusion_apps_action_tbl,
    time_scheduled_start timestamp with time zone,
    time_expected_finish timestamp with time zone,
    time_finished timestamp with time zone,
    delay_in_hours number,
    service_availability varchar2,
    time_accepted timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_details varchar2,
    scheduled_activity_phase varchar2,
    scheduled_activity_association_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_fusion_apps_scheduled_activity_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_scheduled_activity_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_scheduled_activity_summary_t) NOT PERSISTABLE;

Results of a scheduled activity search.

Syntax

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

Fields

Description of ServiceAttachment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_service_attachment_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  service_instance_id varchar2(32767),
  display_name varchar2(32767),
  service_instance_type varchar2(32767),
  service_url varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  is_sku_based number,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_service_attachment_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_service_attachment_t (
    id varchar2,
    compartment_id varchar2,
    service_instance_id varchar2,
    display_name varchar2,
    service_instance_type varchar2,
    service_url varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    is_sku_based number,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the ServiceInstance.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_service_attachment_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  service_instance_type varchar2(32767),
  service_instance_id varchar2(32767),
  service_url varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  is_sku_based number,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_service_attachment_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_service_attachment_summary_t (
    id varchar2,
    display_name varchar2,
    service_instance_type varchar2,
    service_instance_id varchar2,
    service_url varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    is_sku_based number,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_fusion_apps_service_attachment_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_service_attachment_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_service_attachment_summary_t) NOT PERSISTABLE;

List of service attachments for a fusion instance.

Syntax

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

Fields

An access control rule condition that requires a match on the specified source IP address or address range.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_source_ip_address_condition_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_fusion_apps_rule_condition_t (
  attribute_value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_source_ip_address_condition_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_source_ip_address_condition_t (
    attribute_name varchar2,
    attribute_value varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_fusion_apps_source_ip_address_condition_t is a subtype of the dbms_cloud_oci_fusion_apps_rule_condition_t type.

Fields

An access control rule condition that requires a match on the specified source VCN OCID.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_source_vcn_id_condition_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_fusion_apps_rule_condition_t (
  attribute_value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_source_vcn_id_condition_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_source_vcn_id_condition_t (
    attribute_name varchar2,
    attribute_value varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_fusion_apps_source_vcn_id_condition_t is a subtype of the dbms_cloud_oci_fusion_apps_rule_condition_t type.

Fields

An access control rule condition that requires a match on the specified source VCN and IP address range. This condition must be used only in conjunction with `SourceVcnIdCondition`.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_source_vcn_ip_address_condition_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_fusion_apps_rule_condition_t (
  attribute_value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_source_vcn_ip_address_condition_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_source_vcn_ip_address_condition_t (
    attribute_name varchar2,
    attribute_value varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_fusion_apps_source_vcn_ip_address_condition_t is a subtype of the dbms_cloud_oci_fusion_apps_rule_condition_t type.

Fields

SKU information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_subscription_sku_t FORCE AUTHID CURRENT_USER IS OBJECT (
  sku varchar2(32767),
  license_part_description varchar2(32767),
  metric_name varchar2(32767),
  quantity number,
  description varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_subscription_sku_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_subscription_sku_t (
    sku varchar2,
    license_part_description varchar2,
    metric_name varchar2,
    quantity number,
    description varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_fusion_apps_subscription_sku_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_subscription_sku_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_subscription_sku_t) NOT PERSISTABLE;

Subscription information for compartmentId. Only root compartments are allowed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_subscription_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  classic_subscription_id varchar2(32767),
  service_name varchar2(32767),
  skus dbms_cloud_oci_fusion_apps_subscription_sku_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_subscription_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_subscription_t (
    id varchar2,
    classic_subscription_id varchar2,
    service_name varchar2,
    skus dbms_cloud_oci_fusion_apps_subscription_sku_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_fusion_apps_subscription_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_subscription_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_subscription_t) NOT PERSISTABLE;

Detail for the FusionEnvironmentFamily subscription.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_subscription_detail_t FORCE AUTHID CURRENT_USER IS OBJECT (
  subscriptions dbms_cloud_oci_fusion_apps_subscription_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_subscription_detail_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_subscription_detail_t (
    subscriptions dbms_cloud_oci_fusion_apps_subscription_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

one available refresh time.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_time_available_for_refresh_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_available_for_refresh timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_time_available_for_refresh_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_time_available_for_refresh_t (
    time_available_for_refresh timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

one available refresh time.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_time_available_for_refresh_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_available_for_refresh timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_time_available_for_refresh_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_time_available_for_refresh_summary_t (
    time_available_for_refresh timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_fusion_apps_time_available_for_refresh_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_time_available_for_refresh_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_time_available_for_refresh_summary_t) NOT PERSISTABLE;

The available refresh times for a fusion environment

Syntax

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

Fields

The editable settings of the policy that specifies the maintenance and upgrade preferences for an environment.

Syntax

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

Fields

The information to be updated.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_update_fusion_environment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  kms_key_id varchar2(32767),
  maintenance_policy dbms_cloud_oci_fusion_apps_maintenance_policy_t,
  additional_language_packs dbms_cloud_oci_fusion_apps_varchar2_tbl,
  rules dbms_cloud_oci_fusion_apps_rule_tbl,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_update_fusion_environment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_update_fusion_environment_details_t (
    display_name varchar2,
    kms_key_id varchar2,
    maintenance_policy dbms_cloud_oci_fusion_apps_maintenance_policy_t,
    additional_language_packs dbms_cloud_oci_fusion_apps_varchar2_tbl,
    rules dbms_cloud_oci_fusion_apps_rule_tbl,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details of the Fusion environment family to be updated.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_update_fusion_environment_family_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  family_maintenance_policy dbms_cloud_oci_fusion_apps_update_family_maintenance_policy_details_t,
  subscription_ids dbms_cloud_oci_fusion_apps_varchar2_tbl,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_update_fusion_environment_family_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_update_fusion_environment_family_details_t (
    display_name varchar2,
    family_maintenance_policy dbms_cloud_oci_fusion_apps_update_family_maintenance_policy_details_t,
    subscription_ids dbms_cloud_oci_fusion_apps_varchar2_tbl,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about scheduled refresh.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_update_refresh_activity_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_scheduled_start timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_update_refresh_activity_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_update_refresh_activity_details_t (
    time_scheduled_start timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Quarterly upgrade details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_upgrade_action_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_fusion_apps_action_t (
  version varchar2(32767),
  qualifier varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_upgrade_action_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_upgrade_action_t (
    reference_key varchar2,
    action_type varchar2,
    state varchar2,
    description varchar2,
    version varchar2,
    qualifier varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_fusion_apps_upgrade_action_t is a subtype of the dbms_cloud_oci_fusion_apps_action_t type.

Fields

Information about the service attachment to be verified.

Syntax

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

Fields

Vertex update action

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_vertex_action_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_fusion_apps_action_t (
  artifact varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_vertex_action_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_vertex_action_t (
    reference_key varchar2,
    action_type varchar2,
    state varchar2,
    description varchar2,
    artifact varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_fusion_apps_vertex_action_t is a subtype of the dbms_cloud_oci_fusion_apps_action_t type.

Fields

A resource created or operated on by a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_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),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_work_request_resource_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_work_request_resource_t (
    entity_type varchar2,
    action_type varchar2,
    identifier varchar2,
    entity_uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_fusion_apps_work_request_resource_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_work_request_resource_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_work_request_resource_t) NOT PERSISTABLE;

A description of workrequest status

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_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_fusion_apps_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_fusion_apps_work_request_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_work_request_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_fusion_apps_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

An error encountered while executing a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_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_fusion_apps_work_request_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_work_request_error_t (
    code varchar2,
    message varchar2,
    l_timestamp timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_fusion_apps_work_request_error_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_work_request_error_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_work_request_error_t) NOT PERSISTABLE;

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

Syntax

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

Fields

A log message from the execution of a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_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_fusion_apps_work_request_log_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_work_request_log_entry_t (
    message varchar2,
    l_timestamp timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_fusion_apps_work_request_log_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_work_request_log_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_work_request_log_entry_t) NOT PERSISTABLE;

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

Syntax

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

Fields

A summary of the status of a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_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_fusion_apps_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_fusion_apps_work_request_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_fusion_apps_work_request_summary_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_fusion_apps_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

Nested table type of dbms_cloud_oci_fusion_apps_work_request_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_fusion_apps_work_request_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_fusion_apps_work_request_summary_t) NOT PERSISTABLE;

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

Syntax

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

Fields