One Subscription Common Types

DBMS_CLOUD_OCI_ONESUBSCRIPTION_VARCHAR2_TBL Type

Nested table type of varchar2(32767).

Syntax

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

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_PRODUCT_T Type

Product description

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_computed_usage_product_t FORCE AUTHID CURRENT_USER IS OBJECT (
  part_number varchar2(32767),
  name varchar2(32767),
  unit_of_measure varchar2(32767),
  provisioning_group varchar2(32767),
  billing_category varchar2(32767),
  product_category varchar2(32767),
  ucm_rate_card_part_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_computed_usage_product_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_computed_usage_product_t (
    part_number varchar2,
    name varchar2,
    unit_of_measure varchar2,
    provisioning_group varchar2,
    billing_category varchar2,
    product_category varchar2,
    ucm_rate_card_part_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`part_number`	(required) Product part number
`name`	(required) Product name
`unit_of_measure`	(optional) Unit of Measure
`provisioning_group`	(optional) Product provisioning group
`billing_category`	(optional) Metered service billing category
`product_category`	(optional) Product category
`ucm_rate_card_part_type`	(optional) Rate card part type of Product

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_AGGREGATION_T Type

Computed Usage Aggregation object

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_computed_usage_aggregation_t FORCE AUTHID CURRENT_USER IS OBJECT (
  quantity varchar2(32767),
  product dbms_cloud_oci_onesubscription_computed_usage_product_t,
  data_center varchar2(32767),
  time_metered_on timestamp with time zone,
  net_unit_price varchar2(32767),
  cost_unrounded varchar2(32767),
  cost varchar2(32767),
  l_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_computed_usage_aggregation_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_computed_usage_aggregation_t (
    quantity varchar2,
    product dbms_cloud_oci_onesubscription_computed_usage_product_t,
    data_center varchar2,
    time_metered_on timestamp with time zone,
    net_unit_price varchar2,
    cost_unrounded varchar2,
    cost varchar2,
    l_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`quantity`	(optional) Total Quantity that was used for computation
`product`	(optional)
`data_center`	(optional) Data Center Attribute as sent by MQS to SPM.
`time_metered_on`	(optional) Metered Service date , expressed in RFC 3339 timestamp format.
`net_unit_price`	(optional) Net Unit Price for the product in consideration.
`cost_unrounded`	(optional) Sum of Computed Line Amount unrounded
`cost`	(optional) Sum of Computed Line Amount rounded
`l_type`	(optional) Usage compute type in SPM. Allowed values are: 'PROMOTION', 'DO_NOT_BILL', 'USAGE', 'COMMIT', 'OVERAGE', 'PAY_AS_YOU_GO', 'MONTHLY_MINIMUM', 'DELAYED_USAGE_INVOICE_TIMING', 'DELAYED_USAGE_COMMITMENT_EXP', 'ON_ACCOUNT_CREDIT', 'SERVICE_CREDIT', 'COMMITMENT_EXPIRATION', 'FUNDED_ALLOCATION', 'DONOT_BILL_USAGE_POST_TERMINATION', 'DELAYED_USAGE_POST_TERMINATION'

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_AGGREGATION_TBL Type

Nested table type of dbms_cloud_oci_onesubscription_computed_usage_aggregation_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_computed_usage_aggregation_tbl FORCE IS TABLE OF (dbms_cloud_oci_onesubscription_computed_usage_aggregation_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_ONESUBSCRIPTION_AGGREGATED_COMPUTED_USAGE_SUMMARY_T Type

Subscribed Service Contract details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_aggregated_computed_usage_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  subscription_id varchar2(32767),
  parent_subscribed_service_id varchar2(32767),
  parent_product dbms_cloud_oci_onesubscription_computed_usage_product_t,
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  plan_number varchar2(32767),
  currency_code varchar2(32767),
  rate_card_id varchar2(32767),
  pricing_model varchar2(32767),
  aggregated_computed_usages dbms_cloud_oci_onesubscription_computed_usage_aggregation_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_aggregated_computed_usage_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_aggregated_computed_usage_summary_t (
    subscription_id varchar2,
    parent_subscribed_service_id varchar2,
    parent_product dbms_cloud_oci_onesubscription_computed_usage_product_t,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    plan_number varchar2,
    currency_code varchar2,
    rate_card_id varchar2,
    pricing_model varchar2,
    aggregated_computed_usages dbms_cloud_oci_onesubscription_computed_usage_aggregation_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`subscription_id`	(required) Subscription Id is an identifier associated to the service used for filter the Computed Usage in SPM
`parent_subscribed_service_id`	(optional) Subscribed service line parent id
`parent_product`	(optional)
`time_start`	(optional) Subscribed services contract line start date, expressed in RFC 3339 timestamp format.
`time_end`	(optional) Subscribed services contract line end date, expressed in RFC 3339 timestamp format.
`plan_number`	(optional) Subscribed service asociated subscription plan number.
`currency_code`	(optional) Currency code
`rate_card_id`	(optional) Inernal SPM Ratecard Id at line level
`pricing_model`	(optional) Subscribed services pricing model Allowed values are: 'PAY_AS_YOU_GO', 'MONTHLY', 'ANNUAL', 'PREPAID', 'FUNDED_ALLOCATION'
`aggregated_computed_usages`	(optional) Aggregation of computed usages for the subscribed service.

DBMS_CLOUD_OCI_ONESUBSCRIPTION_BILLING_SCHEDULE_PRODUCT_T Type

Product description

Syntax

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

Fields

Field	Description
`part_number`	(required) Indicates the associated AR Invoice Number
`name`	(required) Product name

DBMS_CLOUD_OCI_ONESUBSCRIPTION_BILLING_SCHEDULE_SUMMARY_T Type

Billing schedule details related to Subscription Id

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_billing_schedule_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  subscribed_service_id varchar2(32767),
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  time_invoicing timestamp with time zone,
  invoice_status varchar2(32767),
  quantity varchar2(32767),
  net_unit_price varchar2(32767),
  amount varchar2(32767),
  billing_frequency varchar2(32767),
  ar_invoice_number varchar2(32767),
  ar_customer_transaction_id varchar2(32767),
  order_number varchar2(32767),
  product dbms_cloud_oci_onesubscription_billing_schedule_product_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_billing_schedule_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_billing_schedule_summary_t (
    subscribed_service_id varchar2,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    time_invoicing timestamp with time zone,
    invoice_status varchar2,
    quantity varchar2,
    net_unit_price varchar2,
    amount varchar2,
    billing_frequency varchar2,
    ar_invoice_number varchar2,
    ar_customer_transaction_id varchar2,
    order_number varchar2,
    product dbms_cloud_oci_onesubscription_billing_schedule_product_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`subscribed_service_id`	(optional) SPM internal Subscribed Service ID
`time_start`	(optional) Billing schedule start date
`time_end`	(optional) Billing schedule end date
`time_invoicing`	(optional) Billing schedule invoicing date
`invoice_status`	(optional) Billing schedule invoice status Allowed values are: 'INVOICED', 'NOT_INVOICED'
`quantity`	(optional) Billing schedule quantity
`net_unit_price`	(optional) Billing schedule net unit price
`amount`	(optional) Billing schedule line net amount
`billing_frequency`	(optional) Billing frequency
`ar_invoice_number`	(optional) Indicates the associated AR Invoice Number
`ar_customer_transaction_id`	(optional) Indicates the associated AR Customer transaction id a unique identifier existing on AR.
`order_number`	(optional) Order number associated with the Subscribed Service
`product`	(optional)

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMMITMENT_T Type

Subscribed Service commitment summary

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_commitment_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  subscribed_service_id varchar2(32767),
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  quantity varchar2(32767),
  used_amount varchar2(32767),
  available_amount varchar2(32767),
  funded_allocation_value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_commitment_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_commitment_t (
    id varchar2,
    subscribed_service_id varchar2,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    quantity varchar2,
    used_amount varchar2,
    available_amount varchar2,
    funded_allocation_value varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`id`	(required) SPM internal Commitment ID
`subscribed_service_id`	(optional) SPM internal Subscribed Service ID
`time_start`	(optional) Commitment start date
`time_end`	(optional) Commitment end date
`quantity`	(optional) Commitment quantity
`used_amount`	(optional) Commitment used amount
`available_amount`	(optional) Commitment available amount
`funded_allocation_value`	(optional) Funded Allocation line value example: 12000.00

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMMITMENT_SERVICE_T Type

Subscribed service commitment details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_commitment_service_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  quantity varchar2(32767),
  available_amount varchar2(32767),
  line_net_amount varchar2(32767),
  funded_allocation_value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_commitment_service_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_commitment_service_t (
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    quantity varchar2,
    available_amount varchar2,
    line_net_amount varchar2,
    funded_allocation_value varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`time_start`	(optional) Commitment start date
`time_end`	(optional) Commitment end date
`quantity`	(optional) Commitment quantity
`available_amount`	(optional) Commitment available amount
`line_net_amount`	(optional) Commitment line net amount
`funded_allocation_value`	(optional) Funded Allocation line value

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMMITMENT_SUMMARY_T Type

Subscribed Service commitment summary

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_commitment_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  subscribed_service_id varchar2(32767),
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  quantity varchar2(32767),
  used_amount varchar2(32767),
  available_amount varchar2(32767),
  funded_allocation_value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_commitment_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_commitment_summary_t (
    id varchar2,
    subscribed_service_id varchar2,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    quantity varchar2,
    used_amount varchar2,
    available_amount varchar2,
    funded_allocation_value varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`id`	(required) SPM internal Commitment ID
`subscribed_service_id`	(optional) SPM internal Subscribed Service ID
`time_start`	(optional) Commitment start date
`time_end`	(optional) Commitment end date
`quantity`	(optional) Commitment quantity
`used_amount`	(optional) Commitment used amount
`available_amount`	(optional) Commitment available amount
`funded_allocation_value`	(optional) Funded Allocation line value example: 12000.00

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_T Type

Computed Usage Summary object

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_computed_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  parent_subscribed_service_id varchar2(32767),
  parent_product dbms_cloud_oci_onesubscription_computed_usage_product_t,
  plan_number varchar2(32767),
  currency_code varchar2(32767),
  rate_card_tierd_id varchar2(32767),
  rate_card_id varchar2(32767),
  compute_source varchar2(32767),
  data_center varchar2(32767),
  mqs_message_id varchar2(32767),
  id varchar2(32767),
  quantity varchar2(32767),
  usage_number varchar2(32767),
  original_usage_number varchar2(32767),
  commitment_service_id varchar2(32767),
  is_invoiced number,
  l_type varchar2(32767),
  time_of_arrival timestamp with time zone,
  time_metered_on timestamp with time zone,
  net_unit_price varchar2(32767),
  cost_rounded varchar2(32767),
  cost varchar2(32767),
  product dbms_cloud_oci_onesubscription_computed_usage_product_t,
  unit_of_measure varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_computed_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_computed_usage_t (
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    parent_subscribed_service_id varchar2,
    parent_product dbms_cloud_oci_onesubscription_computed_usage_product_t,
    plan_number varchar2,
    currency_code varchar2,
    rate_card_tierd_id varchar2,
    rate_card_id varchar2,
    compute_source varchar2,
    data_center varchar2,
    mqs_message_id varchar2,
    id varchar2,
    quantity varchar2,
    usage_number varchar2,
    original_usage_number varchar2,
    commitment_service_id varchar2,
    is_invoiced number,
    l_type varchar2,
    time_of_arrival timestamp with time zone,
    time_metered_on timestamp with time zone,
    net_unit_price varchar2,
    cost_rounded varchar2,
    cost varchar2,
    product dbms_cloud_oci_onesubscription_computed_usage_product_t,
    unit_of_measure varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`time_created`	(optional) Computed Usage created time, expressed in RFC 3339 timestamp format.
`time_updated`	(optional) Computed Usage updated time, expressed in RFC 3339 timestamp format.
`parent_subscribed_service_id`	(optional) Subscribed service line parent id
`parent_product`	(optional)
`plan_number`	(optional) Subscription plan number
`currency_code`	(optional) Currency code
`rate_card_tierd_id`	(optional) References the tier in the ratecard for that usage (OCI will be using the same reference to cross-reference for correctness on the usage csv report), comes from Entity OBSCNTR_IPT_PRODUCTTIER.
`rate_card_id`	(optional) Ratecard Id at subscribed service level
`compute_source`	(optional) SPM Internal compute records source .
`data_center`	(optional) Data Center Attribute as sent by MQS to SPM.
`mqs_message_id`	(optional) MQS Identfier send to SPM , SPM does not transform this attribute and is received as is.
`id`	(required) SPM Internal computed usage Id , 32 character string
`quantity`	(optional) Total Quantity that was used for computation
`usage_number`	(optional) SPM Internal usage Line number identifier in SPM coming from Metered Services entity.
`original_usage_number`	(optional) SPM Internal Original usage Line number identifier in SPM coming from Metered Services entity.
`commitment_service_id`	(optional) Subscribed service commitmentId.
`is_invoiced`	(optional) Invoicing status for the aggregated compute usage
`l_type`	(optional) Usage compute type in SPM. Allowed values are: 'PROMOTION', 'DO_NOT_BILL', 'USAGE', 'COMMIT', 'OVERAGE', 'PAY_AS_YOU_GO', 'MONTHLY_MINIMUM', 'DELAYED_USAGE_INVOICE_TIMING', 'DELAYED_USAGE_COMMITMENT_EXP', 'ON_ACCOUNT_CREDIT', 'SERVICE_CREDIT', 'COMMITMENT_EXPIRATION', 'FUNDED_ALLOCATION', 'DONOT_BILL_USAGE_POST_TERMINATION', 'DELAYED_USAGE_POST_TERMINATION'
`time_of_arrival`	(optional) Usae computation date, expressed in RFC 3339 timestamp format.
`time_metered_on`	(optional) Metered Service date, expressed in RFC 3339 timestamp format.
`net_unit_price`	(optional) Net Unit Price for the product in consideration, price actual.
`cost_rounded`	(optional) Computed Line Amount rounded.
`cost`	(optional) Computed Line Amount not rounded
`product`	(optional)
`unit_of_measure`	(optional) Unit of Messure

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_SUMMARY_T Type

Computed Usage Summary object

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_computed_usage_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  parent_subscribed_service_id varchar2(32767),
  parent_product dbms_cloud_oci_onesubscription_computed_usage_product_t,
  plan_number varchar2(32767),
  currency_code varchar2(32767),
  rate_card_tierd_id varchar2(32767),
  rate_card_id varchar2(32767),
  compute_source varchar2(32767),
  data_center varchar2(32767),
  mqs_message_id varchar2(32767),
  computed_usage_id varchar2(32767),
  quantity varchar2(32767),
  usage_number varchar2(32767),
  original_usage_number varchar2(32767),
  commitment_service_id varchar2(32767),
  is_invoiced number,
  l_type varchar2(32767),
  time_of_arrival timestamp with time zone,
  time_metered_on timestamp with time zone,
  net_unit_price varchar2(32767),
  cost_rounded varchar2(32767),
  cost varchar2(32767),
  product dbms_cloud_oci_onesubscription_computed_usage_product_t,
  unit_of_measure varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_computed_usage_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_computed_usage_summary_t (
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    parent_subscribed_service_id varchar2,
    parent_product dbms_cloud_oci_onesubscription_computed_usage_product_t,
    plan_number varchar2,
    currency_code varchar2,
    rate_card_tierd_id varchar2,
    rate_card_id varchar2,
    compute_source varchar2,
    data_center varchar2,
    mqs_message_id varchar2,
    computed_usage_id varchar2,
    quantity varchar2,
    usage_number varchar2,
    original_usage_number varchar2,
    commitment_service_id varchar2,
    is_invoiced number,
    l_type varchar2,
    time_of_arrival timestamp with time zone,
    time_metered_on timestamp with time zone,
    net_unit_price varchar2,
    cost_rounded varchar2,
    cost varchar2,
    product dbms_cloud_oci_onesubscription_computed_usage_product_t,
    unit_of_measure varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`time_created`	(optional) Computed Usage created time, expressed in RFC 3339 timestamp format.
`time_updated`	(optional) Computed Usage updated time, expressed in RFC 3339 timestamp format.
`parent_subscribed_service_id`	(optional) Subscribed service line parent id
`parent_product`	(optional)
`plan_number`	(optional) Subscription plan number
`currency_code`	(optional) Currency code
`rate_card_tierd_id`	(optional) References the tier in the ratecard for that usage (OCI will be using the same reference to cross-reference for correctness on the usage csv report), comes from Entity OBSCNTR_IPT_PRODUCTTIER.
`rate_card_id`	(optional) Ratecard Id at subscribed service level
`compute_source`	(optional) SPM Internal compute records source .
`data_center`	(optional) Data Center Attribute as sent by MQS to SPM.
`mqs_message_id`	(optional) MQS Identfier send to SPM , SPM does not transform this attribute and is received as is.
`computed_usage_id`	(required) SPM Internal computed usage Id , 32 character string
`quantity`	(optional) Total Quantity that was used for computation
`usage_number`	(optional) SPM Internal usage Line number identifier in SPM coming from Metered Services entity.
`original_usage_number`	(optional) SPM Internal Original usage Line number identifier in SPM coming from Metered Services entity.
`commitment_service_id`	(optional) Subscribed service commitmentId.
`is_invoiced`	(optional) Invoicing status for the aggregated compute usage
`l_type`	(optional) Usage compute type in SPM. Allowed values are: 'PROMOTION', 'DO_NOT_BILL', 'USAGE', 'COMMIT', 'OVERAGE', 'PAY_AS_YOU_GO', 'MONTHLY_MINIMUM', 'DELAYED_USAGE_INVOICE_TIMING', 'DELAYED_USAGE_COMMITMENT_EXP', 'ON_ACCOUNT_CREDIT', 'SERVICE_CREDIT', 'COMMITMENT_EXPIRATION', 'FUNDED_ALLOCATION', 'DONOT_BILL_USAGE_POST_TERMINATION', 'DELAYED_USAGE_POST_TERMINATION'
`time_of_arrival`	(optional) Usae computation date, expressed in RFC 3339 timestamp format.
`time_metered_on`	(optional) Metered Service date, expressed in RFC 3339 timestamp format.
`net_unit_price`	(optional) Net Unit Price for the product in consideration, price actual.
`cost_rounded`	(optional) Computed Line Amount rounded.
`cost`	(optional) Computed Line Amount not rounded
`product`	(optional)
`unit_of_measure`	(optional) Unit of Messure

DBMS_CLOUD_OCI_ONESUBSCRIPTION_ERROR_T Type

Internal error object model.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_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_ONESUBSCRIPTION_INVOICING_PRODUCT_T Type

Product description

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_invoicing_product_t FORCE AUTHID CURRENT_USER IS OBJECT (
  part_number varchar2(32767),
  name varchar2(32767),
  unit_of_measure varchar2(32767),
  billing_category varchar2(32767),
  product_category varchar2(32767),
  ucm_rate_card_part_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoicing_product_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoicing_product_t (
    part_number varchar2,
    name varchar2,
    unit_of_measure varchar2,
    billing_category varchar2,
    product_category varchar2,
    ucm_rate_card_part_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`part_number`	(required) Product part number
`name`	(required) Product name
`unit_of_measure`	(required) Unit of Measure
`billing_category`	(optional) Metered service billing category
`product_category`	(optional) Product category
`ucm_rate_card_part_type`	(required) Rate card part type of Product

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICE_LINE_SUMMARY_T Type

Invoice Line

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_invoice_line_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  product dbms_cloud_oci_onesubscription_invoicing_product_t,
  ar_invoice_number varchar2(32767),
  data_center varchar2(32767),
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoice_line_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoice_line_summary_t (
    id varchar2,
    product dbms_cloud_oci_onesubscription_invoicing_product_t,
    ar_invoice_number varchar2,
    data_center varchar2,
    time_start timestamp with time zone,
    time_end timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`id`	(required) SPM Invoice Line internal identifier
`product`	(required)
`ar_invoice_number`	(optional) AR Invoice Number for Invoice Line
`data_center`	(required) Data Center Attribute.
`time_start`	(required) Usage start time
`time_end`	(required) Usage end time

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_BUSINESS_PARTNER_T Type

Business partner.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_invoicing_business_partner_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  name_phonetic varchar2(32767),
  tca_customer_account_number varchar2(32767),
  is_public_sector number,
  is_chain_customer number,
  customer_chain_type varchar2(32767),
  tca_party_number varchar2(32767),
  tca_party_id number,
  tca_customer_account_id number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoicing_business_partner_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoicing_business_partner_t (
    name varchar2,
    name_phonetic varchar2,
    tca_customer_account_number varchar2,
    is_public_sector number,
    is_chain_customer number,
    customer_chain_type varchar2,
    tca_party_number varchar2,
    tca_party_id number,
    tca_customer_account_id number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`name`	(optional) Commercial name also called customer name.
`name_phonetic`	(optional) Phonetic name.
`tca_customer_account_number`	(optional) TCA customer account number.
`is_public_sector`	(optional) The business partner is part of the public sector or not.
`is_chain_customer`	(optional) The business partner is chain customer or not.
`customer_chain_type`	(optional) Customer chain type.
`tca_party_number`	(optional) TCA party number.
`tca_party_id`	(optional) TCA party ID.
`tca_customer_account_id`	(optional) TCA customer account ID.

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_USER_T Type

User.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_invoicing_user_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  user_name varchar2(32767),
  first_name varchar2(32767),
  last_name varchar2(32767),
  email varchar2(32767),
  tca_contact_id number,
  tca_cust_accnt_site_id number,
  tca_party_id number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoicing_user_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoicing_user_t (
    name varchar2,
    user_name varchar2,
    first_name varchar2,
    last_name varchar2,
    email varchar2,
    tca_contact_id number,
    tca_cust_accnt_site_id number,
    tca_party_id number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`name`	(optional) Name.
`user_name`	(optional) userName.
`first_name`	(optional) First name.
`last_name`	(optional) Last name.
`email`	(optional) Email.
`tca_contact_id`	(optional) TCA contact ID.
`tca_cust_accnt_site_id`	(optional) TCA customer account site ID.
`tca_party_id`	(optional) TCA party ID.

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_LOCATION_T Type

Address location.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_invoicing_location_t FORCE AUTHID CURRENT_USER IS OBJECT (
  address1 varchar2(32767),
  address2 varchar2(32767),
  postal_code varchar2(32767),
  city varchar2(32767),
  country varchar2(32767),
  l_region varchar2(32767),
  tca_location_id number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoicing_location_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoicing_location_t (
    address1 varchar2,
    address2 varchar2,
    postal_code varchar2,
    city varchar2,
    country varchar2,
    l_region varchar2,
    tca_location_id number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`address1`	(optional) Address first line.
`address2`	(optional) Address second line.
`postal_code`	(optional) Postal code.
`city`	(optional) City.
`country`	(optional) Country.
`l_region`	(optional) Region.
`tca_location_id`	(optional) TCA Location identifier.

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_ADDRESS_T Type

Address.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_invoicing_address_t FORCE AUTHID CURRENT_USER IS OBJECT (
  location dbms_cloud_oci_onesubscription_invoicing_location_t,
  name varchar2(32767),
  phone varchar2(32767),
  is_bill_to number,
  is_ship_to number,
  bill_site_use_id number,
  service2_site_use_id number,
  tca_cust_acct_site_id number,
  tca_party_site_number varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoicing_address_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoicing_address_t (
    location dbms_cloud_oci_onesubscription_invoicing_location_t,
    name varchar2,
    phone varchar2,
    is_bill_to number,
    is_ship_to number,
    bill_site_use_id number,
    service2_site_use_id number,
    tca_cust_acct_site_id number,
    tca_party_site_number varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`location`	(optional)
`name`	(optional) Address name identifier.
`phone`	(optional) Phone.
`is_bill_to`	(optional) Identify as the customer's billing address.
`is_ship_to`	(optional) Identify as the customer's shipping address.
`bill_site_use_id`	(optional) Bill to site use Id.
`service2_site_use_id`	(optional) Service to site use Id.
`tca_cust_acct_site_id`	(optional) TCA customer account site Id.
`tca_party_site_number`	(optional) Party site number.

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_PAYMENT_TERM_T Type

Payment Term details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_invoicing_payment_term_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  value varchar2(32767),
  description varchar2(32767),
  is_active number,
  time_created timestamp with time zone,
  created_by varchar2(32767),
  time_updated timestamp with time zone,
  updated_by varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoicing_payment_term_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoicing_payment_term_t (
    name varchar2,
    value varchar2,
    description varchar2,
    is_active number,
    time_created timestamp with time zone,
    created_by varchar2,
    time_updated timestamp with time zone,
    updated_by varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`name`	(required) Payment Term name
`value`	(optional) Payment Term value
`description`	(optional) Payment term Description
`is_active`	(optional) Payment term active flag
`time_created`	(optional) Payment term last update date
`created_by`	(optional) User that created the Payment term
`time_updated`	(optional) Payment term last update date
`updated_by`	(optional) User that updated the Payment term

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_CURRENCY_T Type

Currency details

Syntax

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

Fields

Field	Description
`name`	(optional) Currency name
`iso_code`	(required) Currency Code
`std_precision`	(optional) Standard Precision of the Currency

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_ORGANIZATION_T Type

Organization details

Syntax

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

Fields

Field	Description
`name`	(required) Organization name
`l_number`	(required) Organization ID

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICE_LINE_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_onesubscription_invoice_line_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_invoice_line_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_onesubscription_invoice_line_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICE_SUMMARY_T Type

Invoice details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_invoice_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  spm_invoice_number varchar2(32767),
  ar_invoices varchar2(32767),
  bill_to_customer dbms_cloud_oci_onesubscription_invoicing_business_partner_t,
  bill_to_contact dbms_cloud_oci_onesubscription_invoicing_user_t,
  bill_to_address dbms_cloud_oci_onesubscription_invoicing_address_t,
  payment_method varchar2(32767),
  payment_term dbms_cloud_oci_onesubscription_invoicing_payment_term_t,
  receipt_method varchar2(32767),
  currency dbms_cloud_oci_onesubscription_invoicing_currency_t,
  organization dbms_cloud_oci_onesubscription_invoicing_organization_t,
  l_type varchar2(32767),
  status varchar2(32767),
  subscription_number varchar2(32767),
  time_invoice_date timestamp with time zone,
  time_created timestamp with time zone,
  created_by varchar2(32767),
  time_updated timestamp with time zone,
  updated_by varchar2(32767),
  invoice_lines dbms_cloud_oci_onesubscription_invoice_line_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoice_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoice_summary_t (
    spm_invoice_number varchar2,
    ar_invoices varchar2,
    bill_to_customer dbms_cloud_oci_onesubscription_invoicing_business_partner_t,
    bill_to_contact dbms_cloud_oci_onesubscription_invoicing_user_t,
    bill_to_address dbms_cloud_oci_onesubscription_invoicing_address_t,
    payment_method varchar2,
    payment_term dbms_cloud_oci_onesubscription_invoicing_payment_term_t,
    receipt_method varchar2,
    currency dbms_cloud_oci_onesubscription_invoicing_currency_t,
    organization dbms_cloud_oci_onesubscription_invoicing_organization_t,
    l_type varchar2,
    status varchar2,
    subscription_number varchar2,
    time_invoice_date timestamp with time zone,
    time_created timestamp with time zone,
    created_by varchar2,
    time_updated timestamp with time zone,
    updated_by varchar2,
    invoice_lines dbms_cloud_oci_onesubscription_invoice_line_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`spm_invoice_number`	(required) SPM Document Number is an functional identifier for invoice in SPM
`ar_invoices`	(optional) AR Invoice Numbers comma separated under one invoice
`bill_to_customer`	(required)
`bill_to_contact`	(required)
`bill_to_address`	(required)
`payment_method`	(required) Payment Method
`payment_term`	(required)
`receipt_method`	(optional) Receipt Method of Payment Mode
`currency`	(required)
`organization`	(required)
`l_type`	(required) Document Type in SPM like SPM Invoice,SPM Credit Memo etc.,
`status`	(required) Document Status in SPM which depicts current state of invoice
`subscription_number`	(required) Invoice associated subscription plan number.
`time_invoice_date`	(required) Invoice Date
`time_created`	(optional) SPM Invocie creation date
`created_by`	(optional) User that executed SPM Invoice process
`time_updated`	(optional) SPM Invoice updated date
`updated_by`	(optional) User that updated SPM Invoice
`invoice_lines`	(optional) Invoice Lines under particular invoice.

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICELINE_COMPUTED_USAGE_SUMMARY_T Type

Computed Usage Summary object

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_invoiceline_computed_usage_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  parent_product dbms_cloud_oci_onesubscription_invoicing_product_t,
  product dbms_cloud_oci_onesubscription_invoicing_product_t,
  quantity number,
  net_unit_price number,
  time_metered_on timestamp with time zone,
  l_type varchar2(32767),
  cost number,
  cost_rounded number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoiceline_computed_usage_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_invoiceline_computed_usage_summary_t (
    parent_product dbms_cloud_oci_onesubscription_invoicing_product_t,
    product dbms_cloud_oci_onesubscription_invoicing_product_t,
    quantity number,
    net_unit_price number,
    time_metered_on timestamp with time zone,
    l_type varchar2,
    cost number,
    cost_rounded number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`parent_product`	(required)
`product`	(optional)
`quantity`	(required) Total Quantity that was used for computation
`net_unit_price`	(required) Net Unit Price for the product in consideration, price actual.
`time_metered_on`	(required) Metered Service date.
`l_type`	(required) Usage compute type in SPM. Allowed values are: 'PROMOTION', 'DO_NOT_BILL', 'USAGE', 'COMMIT', 'OVERAGE', 'PAY_AS_YOU_GO', 'MONTHLY_MINIMUM', 'DELAYED_USAGE_INVOICE_TIMING', 'DELAYED_USAGE_COMMITMENT_EXP', 'ON_ACCOUNT_CREDIT', 'SERVICE_CREDIT'
`cost`	(optional) Sum of Usage/Service Billing Line net Amount
`cost_rounded`	(required) Computed Line Amount rounded.

DBMS_CLOUD_OCI_ONESUBSCRIPTION_ORGNIZATION_SUBS_CURRENCY_T Type

Currency details

Syntax

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

Fields

Field	Description
`name`	(optional) Currency name
`iso_code`	(required) Currency Code
`std_precision`	(optional) Standard Precision of the Currency

DBMS_CLOUD_OCI_ONESUBSCRIPTION_ORGANIZATION_SUBSCRIPTION_SUMMARY_T Type

Subscription summary

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_organization_subscription_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  service_name varchar2(32767),
  l_type varchar2(32767),
  status varchar2(32767),
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  currency dbms_cloud_oci_onesubscription_orgnization_subs_currency_t,
  total_value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_organization_subscription_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_organization_subscription_summary_t (
    id varchar2,
    service_name varchar2,
    l_type varchar2,
    status varchar2,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    currency dbms_cloud_oci_onesubscription_orgnization_subs_currency_t,
    total_value varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`id`	(required) SPM internal Subscription ID
`service_name`	(optional) Customer friendly service name provided by PRG
`l_type`	(optional) Subscription Type i.e. IAAS,SAAS,PAAS
`status`	(optional) Status of the plan
`time_start`	(optional) Represents the date when the first service of the subscription was activated
`time_end`	(optional) Represents the date when the last service of the subscription ends
`currency`	(optional)
`total_value`	(optional) Total aggregate TCLV of all lines for the subscription including expired, active, and signed

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_PRODUCT_T Type

Product description

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_rate_card_product_t FORCE AUTHID CURRENT_USER IS OBJECT (
  part_number varchar2(32767),
  name varchar2(32767),
  unit_of_measure varchar2(32767),
  billing_category varchar2(32767),
  product_category varchar2(32767),
  ucm_rate_card_part_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_rate_card_product_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_rate_card_product_t (
    part_number varchar2,
    name varchar2,
    unit_of_measure varchar2,
    billing_category varchar2,
    product_category varchar2,
    ucm_rate_card_part_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`part_number`	(required) Product part numner
`name`	(required) Product name
`unit_of_measure`	(required) Unit of measure
`billing_category`	(optional) Metered service billing category
`product_category`	(optional) Product category
`ucm_rate_card_part_type`	(optional) Rate card part type of Product

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_CURRENCY_T Type

Currency details

Syntax

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

Fields

Field	Description
`name`	(optional) Currency name
`iso_code`	(required) Currency Code
`std_precision`	(optional) Standard Precision of the Currency

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_TIER_T Type

Rate Card Tier details

Syntax

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

Fields

Field	Description
`up_to_quantity`	(optional) Rate card tier quantity range
`net_unit_price`	(optional) Rate card tier net unit price
`overage_price`	(optional) Rate card tier overage price

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_TIER_TBL Type

Nested table type of dbms_cloud_oci_onesubscription_rate_card_tier_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_rate_card_tier_tbl FORCE IS TABLE OF (dbms_cloud_oci_onesubscription_rate_card_tier_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_SUMMARY_T Type

Rate Card Summary

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_rate_card_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  subscribed_service_id varchar2(32767),
  product dbms_cloud_oci_onesubscription_rate_card_product_t,
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  net_unit_price varchar2(32767),
  discretionary_discount_percentage varchar2(32767),
  overage_price varchar2(32767),
  is_tier number,
  currency dbms_cloud_oci_onesubscription_subscription_currency_t,
  rate_card_tiers dbms_cloud_oci_onesubscription_rate_card_tier_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_rate_card_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_rate_card_summary_t (
    subscribed_service_id varchar2,
    product dbms_cloud_oci_onesubscription_rate_card_product_t,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    net_unit_price varchar2,
    discretionary_discount_percentage varchar2,
    overage_price varchar2,
    is_tier number,
    currency dbms_cloud_oci_onesubscription_subscription_currency_t,
    rate_card_tiers dbms_cloud_oci_onesubscription_rate_card_tier_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`subscribed_service_id`	(optional) SPM internal Subscribed Service ID
`product`	(required)
`time_start`	(optional) Rate card start date
`time_end`	(optional) Rate card end date
`net_unit_price`	(required) Rate card net unit price
`discretionary_discount_percentage`	(optional) Rate card discretionary discount percentage
`overage_price`	(required) Rate card overage price
`is_tier`	(optional) Rate card price tier flag
`currency`	(optional)
`rate_card_tiers`	(optional) List of tiered rate card prices

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_BUSINESS_PARTNER_T Type

Business partner.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  name_phonetic varchar2(32767),
  tca_cust_account_number varchar2(32767),
  is_public_sector number,
  is_chain_customer number,
  customer_chain_type varchar2(32767),
  tca_party_number varchar2(32767),
  tca_party_id number,
  tca_customer_account_id number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t (
    name varchar2,
    name_phonetic varchar2,
    tca_cust_account_number varchar2,
    is_public_sector number,
    is_chain_customer number,
    customer_chain_type varchar2,
    tca_party_number varchar2,
    tca_party_id number,
    tca_customer_account_id number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`name`	(optional) Commercial name also called customer name.
`name_phonetic`	(optional) Phonetic name.
`tca_cust_account_number`	(optional) TCA customer account number.
`is_public_sector`	(optional) The business partner is part of the public sector or not.
`is_chain_customer`	(optional) The business partner is chain customer or not.
`customer_chain_type`	(optional) Customer chain type.
`tca_party_number`	(optional) TCA party number.
`tca_party_id`	(optional) TCA party ID.
`tca_customer_account_id`	(optional) TCA customer account ID.

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_USER_T Type

User.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_subscribed_service_user_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  username varchar2(32767),
  first_name varchar2(32767),
  last_name varchar2(32767),
  email varchar2(32767),
  tca_contact_id number,
  tca_cust_accnt_site_id number,
  tca_party_id number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscribed_service_user_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscribed_service_user_t (
    name varchar2,
    username varchar2,
    first_name varchar2,
    last_name varchar2,
    email varchar2,
    tca_contact_id number,
    tca_cust_accnt_site_id number,
    tca_party_id number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`name`	(optional) Name.
`username`	(optional) Username.
`first_name`	(optional) First name.
`last_name`	(optional) Last name.
`email`	(optional) Email.
`tca_contact_id`	(optional) TCA contact ID.
`tca_cust_accnt_site_id`	(optional) TCA customer account site ID.
`tca_party_id`	(optional) TCA party ID.

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_LOCATION_T Type

Address location.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_subscribed_service_location_t FORCE AUTHID CURRENT_USER IS OBJECT (
  address1 varchar2(32767),
  address2 varchar2(32767),
  postal_code varchar2(32767),
  city varchar2(32767),
  country varchar2(32767),
  l_region varchar2(32767),
  tca_location_id number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscribed_service_location_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscribed_service_location_t (
    address1 varchar2,
    address2 varchar2,
    postal_code varchar2,
    city varchar2,
    country varchar2,
    l_region varchar2,
    tca_location_id number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`address1`	(optional) Address first line.
`address2`	(optional) Address second line.
`postal_code`	(optional) Postal code.
`city`	(optional) City.
`country`	(optional) Country.
`l_region`	(optional) Region.
`tca_location_id`	(optional) Region.

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_ADDRESS_T Type

Address.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_subscribed_service_address_t FORCE AUTHID CURRENT_USER IS OBJECT (
  location dbms_cloud_oci_onesubscription_subscribed_service_location_t,
  name varchar2(32767),
  phone varchar2(32767),
  is_bill_to number,
  is_ship_to number,
  bill_site_use_id number,
  service2_site_use_id number,
  tca_cust_acct_site_id number,
  tca_party_site_number varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscribed_service_address_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscribed_service_address_t (
    location dbms_cloud_oci_onesubscription_subscribed_service_location_t,
    name varchar2,
    phone varchar2,
    is_bill_to number,
    is_ship_to number,
    bill_site_use_id number,
    service2_site_use_id number,
    tca_cust_acct_site_id number,
    tca_party_site_number varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`location`	(optional)
`name`	(optional) Address name identifier.
`phone`	(optional) Phone.
`is_bill_to`	(optional) Identify as the customer shipping address.
`is_ship_to`	(optional) Identify as the customer invoicing address.
`bill_site_use_id`	(optional) Bill to site use Id.
`service2_site_use_id`	(optional) Service to site use Id.
`tca_cust_acct_site_id`	(optional) TCA customer account site Id.
`tca_party_site_number`	(optional) Party site number.

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_PAYMENT_TERM_T Type

Payment Term details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_subscribed_service_payment_term_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  value varchar2(32767),
  description varchar2(32767),
  is_active number,
  time_created timestamp with time zone,
  created_by varchar2(32767),
  time_updated timestamp with time zone,
  updated_by varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscribed_service_payment_term_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscribed_service_payment_term_t (
    name varchar2,
    value varchar2,
    description varchar2,
    is_active number,
    time_created timestamp with time zone,
    created_by varchar2,
    time_updated timestamp with time zone,
    updated_by varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`name`	(optional) Payment Term name
`value`	(optional) Payment Term value
`description`	(optional) Payment term Description
`is_active`	(optional) Payment term active flag
`time_created`	(optional) Payment term last update date
`created_by`	(optional) User that created the Payment term
`time_updated`	(optional) Payment term last update date
`updated_by`	(optional) User that updated the Payment term

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMMITMENT_SERVICE_TBL Type

Nested table type of dbms_cloud_oci_onesubscription_commitment_service_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_commitment_service_tbl FORCE IS TABLE OF (dbms_cloud_oci_onesubscription_commitment_service_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_onesubscription_rate_card_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_rate_card_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_onesubscription_rate_card_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_T Type

Subscribed service contract details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_subscribed_service_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  l_type varchar2(32767),
  serial_number varchar2(32767),
  subscription_id varchar2(32767),
  product dbms_cloud_oci_onesubscription_rate_card_product_t,
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  quantity varchar2(32767),
  status varchar2(32767),
  operation_type varchar2(32767),
  net_unit_price varchar2(32767),
  price_period varchar2(32767),
  line_net_amount varchar2(32767),
  is_variable_commitment number,
  is_allowance number,
  used_amount varchar2(32767),
  available_amount varchar2(32767),
  funded_allocation_value varchar2(32767),
  is_having_usage number,
  is_cap_to_price_list number,
  credit_percentage varchar2(32767),
  partner_transaction_type varchar2(32767),
  is_credit_enabled number,
  overage_policy varchar2(32767),
  overage_bill_to varchar2(32767),
  payg_policy varchar2(32767),
  promo_order_line_id number,
  promotion_pricing_type varchar2(32767),
  rate_card_discount_percentage varchar2(32767),
  overage_discount_percentage varchar2(32767),
  bill_to_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
  bill_to_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
  bill_to_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
  payment_number varchar2(32767),
  time_payment_expiry timestamp with time zone,
  payment_term dbms_cloud_oci_onesubscription_subscribed_service_payment_term_t,
  payment_method varchar2(32767),
  transaction_extension_id number,
  sales_channel varchar2(32767),
  eligible_to_renew varchar2(32767),
  renewed_subscribed_service_id varchar2(32767),
  term_value number,
  term_value_uom varchar2(32767),
  renewal_opty_id number,
  renewal_opty_number varchar2(32767),
  renewal_opty_type varchar2(32767),
  booking_opty_number varchar2(32767),
  revenue_line_id number,
  revenue_line_number varchar2(32767),
  major_set number,
  time_majorset_start timestamp with time zone,
  time_majorset_end timestamp with time zone,
  system_arr_in_lc varchar2(32767),
  system_arr_in_sc varchar2(32767),
  system_atr_arr_in_lc varchar2(32767),
  system_atr_arr_in_sc varchar2(32767),
  revised_arr_in_lc varchar2(32767),
  revised_arr_in_sc varchar2(32767),
  total_value varchar2(32767),
  original_promo_amount varchar2(32767),
  order_header_id number,
  order_number number,
  order_type varchar2(32767),
  order_line_id number,
  order_line_number number,
  commitment_schedule_id varchar2(32767),
  sales_account_party_id number,
  data_center varchar2(32767),
  data_center_region varchar2(32767),
  admin_email varchar2(32767),
  buyer_email varchar2(32767),
  subscription_source varchar2(32767),
  provisioning_source varchar2(32767),
  fulfillment_set varchar2(32767),
  is_intent_to_pay number,
  is_payg number,
  pricing_model varchar2(32767),
  program_type varchar2(32767),
  start_date_type varchar2(32767),
  time_provisioned timestamp with time zone,
  promo_type varchar2(32767),
  service_to_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
  service_to_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
  service_to_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
  sold_to_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
  sold_to_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
  end_user_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
  end_user_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
  end_user_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
  reseller_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
  reseller_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
  reseller_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
  csi number,
  customer_transaction_reference varchar2(32767),
  partner_credit_amount varchar2(32767),
  is_single_rate_card number,
  agreement_id number,
  agreement_name varchar2(32767),
  agreement_type varchar2(32767),
  billing_frequency varchar2(32767),
  time_welcome_email_sent timestamp with time zone,
  time_service_configuration_email_sent timestamp with time zone,
  time_customer_config timestamp with time zone,
  time_agreement_end timestamp with time zone,
  commitment_services dbms_cloud_oci_onesubscription_commitment_service_tbl,
  rate_cards dbms_cloud_oci_onesubscription_rate_card_summary_tbl,
  time_created timestamp with time zone,
  created_by varchar2(32767),
  time_updated timestamp with time zone,
  updated_by varchar2(32767),
  ratecard_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscribed_service_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscribed_service_t (
    id varchar2,
    l_type varchar2,
    serial_number varchar2,
    subscription_id varchar2,
    product dbms_cloud_oci_onesubscription_rate_card_product_t,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    quantity varchar2,
    status varchar2,
    operation_type varchar2,
    net_unit_price varchar2,
    price_period varchar2,
    line_net_amount varchar2,
    is_variable_commitment number,
    is_allowance number,
    used_amount varchar2,
    available_amount varchar2,
    funded_allocation_value varchar2,
    is_having_usage number,
    is_cap_to_price_list number,
    credit_percentage varchar2,
    partner_transaction_type varchar2,
    is_credit_enabled number,
    overage_policy varchar2,
    overage_bill_to varchar2,
    payg_policy varchar2,
    promo_order_line_id number,
    promotion_pricing_type varchar2,
    rate_card_discount_percentage varchar2,
    overage_discount_percentage varchar2,
    bill_to_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
    bill_to_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
    bill_to_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
    payment_number varchar2,
    time_payment_expiry timestamp with time zone,
    payment_term dbms_cloud_oci_onesubscription_subscribed_service_payment_term_t,
    payment_method varchar2,
    transaction_extension_id number,
    sales_channel varchar2,
    eligible_to_renew varchar2,
    renewed_subscribed_service_id varchar2,
    term_value number,
    term_value_uom varchar2,
    renewal_opty_id number,
    renewal_opty_number varchar2,
    renewal_opty_type varchar2,
    booking_opty_number varchar2,
    revenue_line_id number,
    revenue_line_number varchar2,
    major_set number,
    time_majorset_start timestamp with time zone,
    time_majorset_end timestamp with time zone,
    system_arr_in_lc varchar2,
    system_arr_in_sc varchar2,
    system_atr_arr_in_lc varchar2,
    system_atr_arr_in_sc varchar2,
    revised_arr_in_lc varchar2,
    revised_arr_in_sc varchar2,
    total_value varchar2,
    original_promo_amount varchar2,
    order_header_id number,
    order_number number,
    order_type varchar2,
    order_line_id number,
    order_line_number number,
    commitment_schedule_id varchar2,
    sales_account_party_id number,
    data_center varchar2,
    data_center_region varchar2,
    admin_email varchar2,
    buyer_email varchar2,
    subscription_source varchar2,
    provisioning_source varchar2,
    fulfillment_set varchar2,
    is_intent_to_pay number,
    is_payg number,
    pricing_model varchar2,
    program_type varchar2,
    start_date_type varchar2,
    time_provisioned timestamp with time zone,
    promo_type varchar2,
    service_to_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
    service_to_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
    service_to_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
    sold_to_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
    sold_to_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
    end_user_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
    end_user_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
    end_user_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
    reseller_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
    reseller_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
    reseller_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
    csi number,
    customer_transaction_reference varchar2,
    partner_credit_amount varchar2,
    is_single_rate_card number,
    agreement_id number,
    agreement_name varchar2,
    agreement_type varchar2,
    billing_frequency varchar2,
    time_welcome_email_sent timestamp with time zone,
    time_service_configuration_email_sent timestamp with time zone,
    time_customer_config timestamp with time zone,
    time_agreement_end timestamp with time zone,
    commitment_services dbms_cloud_oci_onesubscription_commitment_service_tbl,
    rate_cards dbms_cloud_oci_onesubscription_rate_card_summary_tbl,
    time_created timestamp with time zone,
    created_by varchar2,
    time_updated timestamp with time zone,
    updated_by varchar2,
    ratecard_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`id`	(optional) SPM internal Subscribed Service ID
`l_type`	(optional) Subscribed Service line type
`serial_number`	(optional) Subscribed service line number
`subscription_id`	(optional) Subscription ID associated to the subscribed service
`product`	(optional)
`time_start`	(optional) Subscribed service start date
`time_end`	(optional) Subscribed service end date
`quantity`	(optional) Subscribed service quantity
`status`	(optional) Subscribed service status
`operation_type`	(optional) Subscribed service operation type
`net_unit_price`	(optional) Subscribed service net unit price
`price_period`	(optional) Indicates the period for which the commitment amount can be utilised exceeding which the amount lapses. Also used in calculation of total contract line value
`line_net_amount`	(optional) Subscribed service line net amount
`is_variable_commitment`	(optional) Indicates if the commitment lines can have different quantities
`is_allowance`	(optional) Indicates if a service can recieve usages and consequently have available amounts computed
`used_amount`	(optional) Subscribed service used amount
`available_amount`	(optional) Subscribed sercice available or remaining amount
`funded_allocation_value`	(optional) Funded Allocation line value example: 12000.00
`is_having_usage`	(optional) Indicator on whether or not there has been usage for the subscribed service
`is_cap_to_price_list`	(optional) If true compares rate between ratecard and the active pricelist and minimum rate would be fetched
`credit_percentage`	(optional) Subscribed service credit percentage
`partner_transaction_type`	(optional) This field contains the name of the partner to which the subscription belongs - depending on which the invoicing may differ
`is_credit_enabled`	(optional) Used in context of service credit lines
`overage_policy`	(optional) Overage Policy of Subscribed Service
`overage_bill_to`	(optional) Overage Bill To of Subscribed Service
`payg_policy`	(optional) Pay As You Go policy of Subscribed Service (Can be null - indicating no payg policy)
`promo_order_line_id`	(optional) Not null if this service has an associated promotion line in SPM. Contains the line identifier from Order Management of the associated promo line.
`promotion_pricing_type`	(optional) Promotion Pricing Type of Subscribed Service (Can be null - indicating no promotion pricing)
`rate_card_discount_percentage`	(optional) Subscribed service Rate Card Discount Percentage
`overage_discount_percentage`	(optional) Subscribed service Overage Discount Percentage
`bill_to_customer`	(optional)
`bill_to_contact`	(optional)
`bill_to_address`	(optional)
`payment_number`	(optional) Payment Number of Subscribed Service
`time_payment_expiry`	(optional) Subscribed service payment expiry date
`payment_term`	(optional)
`payment_method`	(optional) Payment Method of Subscribed Service
`transaction_extension_id`	(optional) Subscribed service Transaction Extension Id
`sales_channel`	(optional) Sales Channel of Subscribed Service
`eligible_to_renew`	(optional) Subscribed service eligible to renew field
`renewed_subscribed_service_id`	(optional) SPM renewed Subscription ID
`term_value`	(optional) Term value in Months
`term_value_uom`	(optional) Term value UOM
`renewal_opty_id`	(optional) Subscribed service Opportunity Id
`renewal_opty_number`	(optional) Renewal Opportunity Number of Subscribed Service
`renewal_opty_type`	(optional) Renewal Opportunity Type of Subscribed Service
`booking_opty_number`	(optional) Booking Opportunity Number of Subscribed Service
`revenue_line_id`	(optional) Subscribed service Revenue Line Id
`revenue_line_number`	(optional) Revenue Line NUmber of Subscribed Service
`major_set`	(optional) Subscribed service Major Set
`time_majorset_start`	(optional) Subscribed service Major Set Start date
`time_majorset_end`	(optional) Subscribed service Major Set End date
`system_arr_in_lc`	(optional) Subscribed service System ARR
`system_arr_in_sc`	(optional) Subscribed service System ARR in Standard Currency
`system_atr_arr_in_lc`	(optional) Subscribed service System ATR-ARR
`system_atr_arr_in_sc`	(optional) Subscribed service System ATR-ARR in Standard Currency
`revised_arr_in_lc`	(optional) Subscribed service Revised ARR
`revised_arr_in_sc`	(optional) Subscribed service Revised ARR in Standard Currency
`total_value`	(optional) Subscribed service total value
`original_promo_amount`	(optional) Subscribed service Promotion Amount
`order_header_id`	(optional) Sales Order Header associated to the subscribed service
`order_number`	(optional) Sales Order Number associated to the subscribed service
`order_type`	(optional) Order Type of Subscribed Service
`order_line_id`	(optional) Sales Order Line Id associated to the subscribed service
`order_line_number`	(optional) Sales Order Line Number associated to the subscribed service
`commitment_schedule_id`	(optional) Subscribed service commitment schedule Id
`sales_account_party_id`	(optional) Subscribed service sales account party id
`data_center`	(optional) Subscribed service data center
`data_center_region`	(optional) Subscribed service data center region
`admin_email`	(optional) Subscribed service admin email id
`buyer_email`	(optional) Subscribed service buyer email id
`subscription_source`	(optional) Subscribed service source
`provisioning_source`	(optional) Subscribed service provisioning source
`fulfillment_set`	(optional) Subscribed service fulfillment set
`is_intent_to_pay`	(optional) Subscribed service intent to pay flag
`is_payg`	(optional) Subscribed service payg flag
`pricing_model`	(optional) Subscribed service pricing model
`program_type`	(optional) Subscribed service program type
`start_date_type`	(optional) Subscribed service start date type
`time_provisioned`	(optional) Subscribed service provisioning date
`promo_type`	(optional) Subscribed service promotion type
`service_to_customer`	(optional)
`service_to_contact`	(optional)
`service_to_address`	(optional)
`sold_to_customer`	(optional)
`sold_to_contact`	(optional)
`end_user_customer`	(optional)
`end_user_contact`	(optional)
`end_user_address`	(optional)
`reseller_customer`	(optional)
`reseller_contact`	(optional)
`reseller_address`	(optional)
`csi`	(optional) Subscribed service CSI number
`customer_transaction_reference`	(optional) Identifier for a customer's transactions for purchase of ay oracle services
`partner_credit_amount`	(optional) Subscribed service partner credit amount
`is_single_rate_card`	(optional) Indicates if the Subscribed service has a single ratecard
`agreement_id`	(optional) Subscribed service agreement ID
`agreement_name`	(optional) Subscribed service agrrement name
`agreement_type`	(optional) Subscribed service agrrement type
`billing_frequency`	(optional) Subscribed service invoice frequency
`time_welcome_email_sent`	(optional) Subscribed service welcome email sent date
`time_service_configuration_email_sent`	(optional) Subscribed service service configuration email sent date
`time_customer_config`	(optional) Subscribed service customer config date
`time_agreement_end`	(optional) Subscribed service agrrement end date
`commitment_services`	(optional) List of Commitment services of a line
`rate_cards`	(optional) List of Rate Cards of a Subscribed Service
`time_created`	(optional) Subscribed service creation date
`created_by`	(optional) User that created the subscribed service
`time_updated`	(optional) Subscribed service last update date
`updated_by`	(optional) User that updated the subscribed service
`ratecard_type`	(optional) SPM Ratecard Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_SUMMARY_T Type

Subscribed service contract details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_subscribed_service_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  l_type varchar2(32767),
  serial_number varchar2(32767),
  subscription_id varchar2(32767),
  product dbms_cloud_oci_onesubscription_rate_card_product_t,
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  quantity varchar2(32767),
  status varchar2(32767),
  operation_type varchar2(32767),
  net_unit_price varchar2(32767),
  price_period varchar2(32767),
  line_net_amount varchar2(32767),
  is_variable_commitment number,
  is_allowance number,
  used_amount varchar2(32767),
  available_amount varchar2(32767),
  funded_allocation_value varchar2(32767),
  is_having_usage number,
  is_cap_to_price_list number,
  credit_percentage varchar2(32767),
  partner_transaction_type varchar2(32767),
  is_credit_enabled number,
  overage_policy varchar2(32767),
  overage_bill_to varchar2(32767),
  payg_policy varchar2(32767),
  promo_order_line_id number,
  promotion_pricing_type varchar2(32767),
  rate_card_discount_percentage varchar2(32767),
  overage_discount_percentage varchar2(32767),
  bill_to_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
  bill_to_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
  bill_to_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
  payment_number varchar2(32767),
  time_payment_expiry timestamp with time zone,
  payment_term dbms_cloud_oci_onesubscription_subscribed_service_payment_term_t,
  payment_method varchar2(32767),
  transaction_extension_id number,
  sales_channel varchar2(32767),
  eligible_to_renew varchar2(32767),
  renewed_subscribed_service_id varchar2(32767),
  term_value number,
  term_value_uom varchar2(32767),
  renewal_opty_id number,
  renewal_opty_number varchar2(32767),
  renewal_opty_type varchar2(32767),
  booking_opty_number varchar2(32767),
  revenue_line_id number,
  revenue_line_number varchar2(32767),
  major_set number,
  time_majorset_start timestamp with time zone,
  time_majorset_end timestamp with time zone,
  system_arr_in_lc varchar2(32767),
  system_arr_in_sc varchar2(32767),
  system_atr_arr_in_lc varchar2(32767),
  system_atr_arr_in_sc varchar2(32767),
  revised_arr_in_lc varchar2(32767),
  revised_arr_in_sc varchar2(32767),
  total_value varchar2(32767),
  original_promo_amount varchar2(32767),
  order_header_id number,
  order_number number,
  order_type varchar2(32767),
  order_line_id number,
  order_line_number number,
  commitment_schedule_id varchar2(32767),
  sales_account_party_id number,
  data_center varchar2(32767),
  data_center_region varchar2(32767),
  admin_email varchar2(32767),
  buyer_email varchar2(32767),
  subscription_source varchar2(32767),
  provisioning_source varchar2(32767),
  fulfillment_set varchar2(32767),
  is_intent_to_pay number,
  is_payg number,
  pricing_model varchar2(32767),
  program_type varchar2(32767),
  start_date_type varchar2(32767),
  time_provisioned timestamp with time zone,
  promo_type varchar2(32767),
  service_to_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
  service_to_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
  service_to_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
  sold_to_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
  sold_to_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
  end_user_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
  end_user_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
  end_user_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
  reseller_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
  reseller_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
  reseller_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
  csi number,
  customer_transaction_reference varchar2(32767),
  partner_credit_amount varchar2(32767),
  is_single_rate_card number,
  agreement_id number,
  agreement_name varchar2(32767),
  agreement_type varchar2(32767),
  billing_frequency varchar2(32767),
  time_welcome_email_sent timestamp with time zone,
  time_service_configuration_email_sent timestamp with time zone,
  time_customer_config timestamp with time zone,
  time_agreement_end timestamp with time zone,
  time_created timestamp with time zone,
  created_by varchar2(32767),
  time_updated timestamp with time zone,
  updated_by varchar2(32767),
  ratecard_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscribed_service_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscribed_service_summary_t (
    id varchar2,
    l_type varchar2,
    serial_number varchar2,
    subscription_id varchar2,
    product dbms_cloud_oci_onesubscription_rate_card_product_t,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    quantity varchar2,
    status varchar2,
    operation_type varchar2,
    net_unit_price varchar2,
    price_period varchar2,
    line_net_amount varchar2,
    is_variable_commitment number,
    is_allowance number,
    used_amount varchar2,
    available_amount varchar2,
    funded_allocation_value varchar2,
    is_having_usage number,
    is_cap_to_price_list number,
    credit_percentage varchar2,
    partner_transaction_type varchar2,
    is_credit_enabled number,
    overage_policy varchar2,
    overage_bill_to varchar2,
    payg_policy varchar2,
    promo_order_line_id number,
    promotion_pricing_type varchar2,
    rate_card_discount_percentage varchar2,
    overage_discount_percentage varchar2,
    bill_to_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
    bill_to_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
    bill_to_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
    payment_number varchar2,
    time_payment_expiry timestamp with time zone,
    payment_term dbms_cloud_oci_onesubscription_subscribed_service_payment_term_t,
    payment_method varchar2,
    transaction_extension_id number,
    sales_channel varchar2,
    eligible_to_renew varchar2,
    renewed_subscribed_service_id varchar2,
    term_value number,
    term_value_uom varchar2,
    renewal_opty_id number,
    renewal_opty_number varchar2,
    renewal_opty_type varchar2,
    booking_opty_number varchar2,
    revenue_line_id number,
    revenue_line_number varchar2,
    major_set number,
    time_majorset_start timestamp with time zone,
    time_majorset_end timestamp with time zone,
    system_arr_in_lc varchar2,
    system_arr_in_sc varchar2,
    system_atr_arr_in_lc varchar2,
    system_atr_arr_in_sc varchar2,
    revised_arr_in_lc varchar2,
    revised_arr_in_sc varchar2,
    total_value varchar2,
    original_promo_amount varchar2,
    order_header_id number,
    order_number number,
    order_type varchar2,
    order_line_id number,
    order_line_number number,
    commitment_schedule_id varchar2,
    sales_account_party_id number,
    data_center varchar2,
    data_center_region varchar2,
    admin_email varchar2,
    buyer_email varchar2,
    subscription_source varchar2,
    provisioning_source varchar2,
    fulfillment_set varchar2,
    is_intent_to_pay number,
    is_payg number,
    pricing_model varchar2,
    program_type varchar2,
    start_date_type varchar2,
    time_provisioned timestamp with time zone,
    promo_type varchar2,
    service_to_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
    service_to_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
    service_to_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
    sold_to_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
    sold_to_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
    end_user_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
    end_user_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
    end_user_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
    reseller_customer dbms_cloud_oci_onesubscription_subscribed_service_business_partner_t,
    reseller_contact dbms_cloud_oci_onesubscription_subscribed_service_user_t,
    reseller_address dbms_cloud_oci_onesubscription_subscribed_service_address_t,
    csi number,
    customer_transaction_reference varchar2,
    partner_credit_amount varchar2,
    is_single_rate_card number,
    agreement_id number,
    agreement_name varchar2,
    agreement_type varchar2,
    billing_frequency varchar2,
    time_welcome_email_sent timestamp with time zone,
    time_service_configuration_email_sent timestamp with time zone,
    time_customer_config timestamp with time zone,
    time_agreement_end timestamp with time zone,
    time_created timestamp with time zone,
    created_by varchar2,
    time_updated timestamp with time zone,
    updated_by varchar2,
    ratecard_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`id`	(required) SPM internal Subscribed Service ID
`l_type`	(optional) Subscribed Service line type
`serial_number`	(optional) Subscribed service line number
`subscription_id`	(optional) Subscription ID associated to the subscribed service
`product`	(optional)
`time_start`	(optional) Subscribed service start date
`time_end`	(optional) Subscribed service end date
`quantity`	(optional) Subscribed service quantity
`status`	(optional) Subscribed service status
`operation_type`	(optional) Subscribed service operation type
`net_unit_price`	(optional) Subscribed service net unit price
`price_period`	(optional) Indicates the period for which the commitment amount can be utilised exceeding which the amount lapses. Also used in calculation of total contract line value
`line_net_amount`	(optional) Subscribed service line net amount
`is_variable_commitment`	(optional) Indicates if the commitment lines can have different quantities
`is_allowance`	(optional) Indicates if a service can recieve usages and consequently have available amounts computed
`used_amount`	(optional) Subscribed service used amount
`available_amount`	(optional) Subscribed sercice available or remaining amount
`funded_allocation_value`	(optional) Funded Allocation line value example: 12000.00
`is_having_usage`	(optional) Indicator on whether or not there has been usage for the subscribed service
`is_cap_to_price_list`	(optional) If true compares rate between ratecard and the active pricelist and minimum rate would be fetched
`credit_percentage`	(optional) Subscribed service credit percentage
`partner_transaction_type`	(optional) This field contains the name of the partner to which the subscription belongs - depending on which the invoicing may differ
`is_credit_enabled`	(optional) Used in context of service credit lines
`overage_policy`	(optional) Overage Policy of Subscribed Service
`overage_bill_to`	(optional) Overage Bill To of Subscribed Service
`payg_policy`	(optional) Pay As You Go policy of Subscribed Service (Can be null - indicating no payg policy)
`promo_order_line_id`	(optional) Not null if this service has an associated promotion line in SPM. Contains the line identifier from Order Management of the associated promo line.
`promotion_pricing_type`	(optional) Promotion Pricing Type of Subscribed Service (Can be null - indicating no promotion pricing)
`rate_card_discount_percentage`	(optional) Subscribed service Rate Card Discount Percentage
`overage_discount_percentage`	(optional) Subscribed service Overage Discount Percentage
`bill_to_customer`	(optional)
`bill_to_contact`	(optional)
`bill_to_address`	(optional)
`payment_number`	(optional) Payment Number of Subscribed Service
`time_payment_expiry`	(optional) Subscribed service payment expiry date
`payment_term`	(optional)
`payment_method`	(optional) Payment Method of Subscribed Service
`transaction_extension_id`	(optional) Subscribed service Transaction Extension Id
`sales_channel`	(optional) Sales Channel of Subscribed Service
`eligible_to_renew`	(optional) Subscribed service eligible to renew field
`renewed_subscribed_service_id`	(optional) SPM renewed Subscription ID
`term_value`	(optional) Term value in Months
`term_value_uom`	(optional) Term value UOM
`renewal_opty_id`	(optional) Subscribed service Opportunity Id
`renewal_opty_number`	(optional) Renewal Opportunity Number of Subscribed Service
`renewal_opty_type`	(optional) Renewal Opportunity Type of Subscribed Service
`booking_opty_number`	(optional) Booking Opportunity Number of Subscribed Service
`revenue_line_id`	(optional) Subscribed service Revenue Line Id
`revenue_line_number`	(optional) Revenue Line NUmber of Subscribed Service
`major_set`	(optional) Subscribed service Major Set
`time_majorset_start`	(optional) Subscribed service Major Set Start date
`time_majorset_end`	(optional) Subscribed service Major Set End date
`system_arr_in_lc`	(optional) Subscribed service System ARR
`system_arr_in_sc`	(optional) Subscribed service System ARR in Standard Currency
`system_atr_arr_in_lc`	(optional) Subscribed service System ATR-ARR
`system_atr_arr_in_sc`	(optional) Subscribed service System ATR-ARR in Standard Currency
`revised_arr_in_lc`	(optional) Subscribed service Revised ARR
`revised_arr_in_sc`	(optional) Subscribed service Revised ARR in Standard Currency
`total_value`	(optional) Subscribed service total value
`original_promo_amount`	(optional) Subscribed service Promotion Amount
`order_header_id`	(optional) Sales Order Header associated to the subscribed service
`order_number`	(optional) Sales Order Number associated to the subscribed service
`order_type`	(optional) Order Type of Subscribed Service
`order_line_id`	(optional) Sales Order Line Id associated to the subscribed service
`order_line_number`	(optional) Sales Order Line Number associated to the subscribed service
`commitment_schedule_id`	(optional) Subscribed service commitment schedule Id
`sales_account_party_id`	(optional) Subscribed service sales account party id
`data_center`	(optional) Subscribed service data center
`data_center_region`	(optional) Subscribed service data center region
`admin_email`	(optional) Subscribed service admin email id
`buyer_email`	(optional) Subscribed service buyer email id
`subscription_source`	(optional) Subscribed service source
`provisioning_source`	(optional) Subscribed service provisioning source
`fulfillment_set`	(optional) Subscribed service fulfillment set
`is_intent_to_pay`	(optional) Subscribed service intent to pay flag
`is_payg`	(optional) Subscribed service payg flag
`pricing_model`	(optional) Subscribed service pricing model
`program_type`	(optional) Subscribed service program type
`start_date_type`	(optional) Subscribed service start date type
`time_provisioned`	(optional) Subscribed service provisioning date
`promo_type`	(optional) Subscribed service promotion type
`service_to_customer`	(optional)
`service_to_contact`	(optional)
`service_to_address`	(optional)
`sold_to_customer`	(optional)
`sold_to_contact`	(optional)
`end_user_customer`	(optional)
`end_user_contact`	(optional)
`end_user_address`	(optional)
`reseller_customer`	(optional)
`reseller_contact`	(optional)
`reseller_address`	(optional)
`csi`	(optional) Subscribed service CSI number
`customer_transaction_reference`	(optional) Identifier for a customer's transactions for purchase of ay oracle services
`partner_credit_amount`	(optional) Subscribed service partner credit amount
`is_single_rate_card`	(optional) Indicates if the Subscribed service has a single ratecard
`agreement_id`	(optional) Subscribed service agreement ID
`agreement_name`	(optional) Subscribed service agrrement name
`agreement_type`	(optional) Subscribed service agrrement type
`billing_frequency`	(optional) Subscribed service invoice frequency
`time_welcome_email_sent`	(optional) Subscribed service welcome email sent date
`time_service_configuration_email_sent`	(optional) Subscribed service service configuration email sent date
`time_customer_config`	(optional) Subscribed service customer config date
`time_agreement_end`	(optional) Subscribed service agrrement end date
`time_created`	(optional) Subscribed service creation date
`created_by`	(optional) User that created the subscribed service
`time_updated`	(optional) Subscribed service last update date
`updated_by`	(optional) User that updated the subscribed service
`ratecard_type`	(optional) SPM Ratecard Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_PRODUCT_T Type

Product description

Syntax

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

Fields

Field	Description
`part_number`	(required) Product part numner
`name`	(required) Product name
`unit_of_measure`	(required) Unit of measure
`provisioning_group`	(optional) Product provisioning group

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_SUBSCRIBED_SERVICE_T Type

Subscribed Service summary

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_subscription_subscribed_service_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  product dbms_cloud_oci_onesubscription_subscription_product_t,
  quantity varchar2(32767),
  status varchar2(32767),
  operation_type varchar2(32767),
  net_unit_price varchar2(32767),
  used_amount varchar2(32767),
  available_amount varchar2(32767),
  funded_allocation_value varchar2(32767),
  partner_transaction_type varchar2(32767),
  term_value number,
  term_value_uom varchar2(32767),
  booking_opty_number varchar2(32767),
  total_value varchar2(32767),
  original_promo_amount varchar2(32767),
  order_number number,
  data_center_region varchar2(32767),
  pricing_model varchar2(32767),
  program_type varchar2(32767),
  promo_type varchar2(32767),
  csi number,
  is_intent_to_pay number,
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  commitment_services dbms_cloud_oci_onesubscription_commitment_service_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscription_subscribed_service_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscription_subscribed_service_t (
    id varchar2,
    product dbms_cloud_oci_onesubscription_subscription_product_t,
    quantity varchar2,
    status varchar2,
    operation_type varchar2,
    net_unit_price varchar2,
    used_amount varchar2,
    available_amount varchar2,
    funded_allocation_value varchar2,
    partner_transaction_type varchar2,
    term_value number,
    term_value_uom varchar2,
    booking_opty_number varchar2,
    total_value varchar2,
    original_promo_amount varchar2,
    order_number number,
    data_center_region varchar2,
    pricing_model varchar2,
    program_type varchar2,
    promo_type varchar2,
    csi number,
    is_intent_to_pay number,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    commitment_services dbms_cloud_oci_onesubscription_commitment_service_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`id`	(required) SPM internal Subscribed Service ID
`product`	(optional)
`quantity`	(optional) Subscribed service quantity
`status`	(optional) Subscribed service status
`operation_type`	(optional) Subscribed service operation type
`net_unit_price`	(optional) Subscribed service net unit price
`used_amount`	(optional) Subscribed service used amount
`available_amount`	(optional) Subscribed sercice available or remaining amount
`funded_allocation_value`	(optional) Funded Allocation line value example: 12000.00
`partner_transaction_type`	(optional) This field contains the name of the partner to which the subscription belongs - depending on which the invoicing may differ
`term_value`	(optional) Term value in Months
`term_value_uom`	(optional) Term value UOM
`booking_opty_number`	(optional) Booking Opportunity Number of Subscribed Service
`total_value`	(optional) Subscribed service total value
`original_promo_amount`	(optional) Subscribed service Promotion Amount
`order_number`	(optional) Sales Order Number associated to the subscribed service
`data_center_region`	(optional) Subscribed service data center region
`pricing_model`	(optional) Subscribed service pricing model
`program_type`	(optional) Subscribed service program type
`promo_type`	(optional) Subscribed service promotion type
`csi`	(optional) Subscribed service CSI number
`is_intent_to_pay`	(optional) Subscribed service intent to pay flag
`time_start`	(optional) Subscribed service start date
`time_end`	(optional) Subscribed service end date
`commitment_services`	(optional) List of Commitment services of a line

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_SUBSCRIBED_SERVICE_TBL Type

Nested table type of dbms_cloud_oci_onesubscription_subscription_subscribed_service_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_subscription_subscribed_service_tbl FORCE IS TABLE OF (dbms_cloud_oci_onesubscription_subscription_subscribed_service_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_SUMMARY_T Type

Subscription summary

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_onesubscription_subscription_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  status varchar2(32767),
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  currency dbms_cloud_oci_onesubscription_subscription_currency_t,
  service_name varchar2(32767),
  hold_reason varchar2(32767),
  time_hold_release_eta timestamp with time zone,
  subscribed_services dbms_cloud_oci_onesubscription_subscription_subscribed_service_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscription_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_onesubscription_subscription_summary_t (
    status varchar2,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    currency dbms_cloud_oci_onesubscription_subscription_currency_t,
    service_name varchar2,
    hold_reason varchar2,
    time_hold_release_eta timestamp with time zone,
    subscribed_services dbms_cloud_oci_onesubscription_subscription_subscribed_service_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field	Description
`status`	(optional) Status of the plan
`time_start`	(optional) Represents the date when the first service of the subscription was activated
`time_end`	(optional) Represents the date when the last service of the subscription ends
`currency`	(optional)
`service_name`	(optional) Customer friendly service name provided by PRG
`hold_reason`	(optional) Hold reason of the plan
`time_hold_release_eta`	(optional) Represents the date of the hold release
`subscribed_services`	(optional) List of Subscribed Services of the plan

Oracle Cloud Infrastructure Documentation Try Free Tier

DBMS_CLOUD_OCI_ONESUBSCRIPTION_VARCHAR2_TBL Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_PRODUCT_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_AGGREGATION_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_AGGREGATION_TBL Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_AGGREGATED_COMPUTED_USAGE_SUMMARY_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_BILLING_SCHEDULE_PRODUCT_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_BILLING_SCHEDULE_SUMMARY_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMMITMENT_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMMITMENT_SERVICE_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMMITMENT_SUMMARY_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_SUMMARY_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_ERROR_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_PRODUCT_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICE_LINE_SUMMARY_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_BUSINESS_PARTNER_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_USER_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_LOCATION_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_ADDRESS_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_PAYMENT_TERM_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_CURRENCY_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_ORGANIZATION_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICE_LINE_SUMMARY_TBL Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICE_SUMMARY_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICELINE_COMPUTED_USAGE_SUMMARY_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_ORGNIZATION_SUBS_CURRENCY_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_ORGANIZATION_SUBSCRIPTION_SUMMARY_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_PRODUCT_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_CURRENCY_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_TIER_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_TIER_TBL Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_SUMMARY_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_BUSINESS_PARTNER_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_USER_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_LOCATION_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_ADDRESS_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_PAYMENT_TERM_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMMITMENT_SERVICE_TBL Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_SUMMARY_TBL Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_SUMMARY_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_PRODUCT_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_SUBSCRIBED_SERVICE_T Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_SUBSCRIBED_SERVICE_TBL Type 🔗

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_SUMMARY_T Type 🔗

Oracle Cloud Infrastructure Documentation
Try Free Tier

DBMS_CLOUD_OCI_ONESUBSCRIPTION_VARCHAR2_TBL Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_PRODUCT_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_AGGREGATION_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_AGGREGATION_TBL Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_AGGREGATED_COMPUTED_USAGE_SUMMARY_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_BILLING_SCHEDULE_PRODUCT_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_BILLING_SCHEDULE_SUMMARY_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMMITMENT_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMMITMENT_SERVICE_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMMITMENT_SUMMARY_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMPUTED_USAGE_SUMMARY_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_ERROR_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_PRODUCT_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICE_LINE_SUMMARY_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_BUSINESS_PARTNER_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_USER_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_LOCATION_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_ADDRESS_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_PAYMENT_TERM_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_CURRENCY_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICING_ORGANIZATION_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICE_LINE_SUMMARY_TBL Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICE_SUMMARY_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_INVOICELINE_COMPUTED_USAGE_SUMMARY_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_ORGNIZATION_SUBS_CURRENCY_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_ORGANIZATION_SUBSCRIPTION_SUMMARY_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_PRODUCT_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_CURRENCY_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_TIER_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_TIER_TBL Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_SUMMARY_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_BUSINESS_PARTNER_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_USER_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_LOCATION_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_ADDRESS_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_PAYMENT_TERM_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_COMMITMENT_SERVICE_TBL Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_RATE_CARD_SUMMARY_TBL Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIBED_SERVICE_SUMMARY_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_PRODUCT_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_SUBSCRIBED_SERVICE_T Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_SUBSCRIBED_SERVICE_TBL Type

DBMS_CLOUD_OCI_ONESUBSCRIPTION_SUBSCRIPTION_SUMMARY_T Type