Oracle Cloud Infrastructure Documentation

OSub Billing Schedule Functions

Package: DBMS_CLOUD_OCI_OSB_BILLING_SCHEDULE

LIST_BILLING_SCHEDULES Function

This list API returns all billing schedules for given subscription id and for a particular Subscribed Service if provided

Syntax

FUNCTION list_billing_schedules (
  compartment_id varchar2,
  subscription_id varchar2,
  subscribed_service_id varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  sort_order varchar2 DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  x_one_origin_region varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_osb_billing_schedule_list_billing_schedules_response_t;

Parameters

Parameter Description

compartment_id

(required) The OCID of the compartment.

subscription_id

(required) This param is used to get only the billing schedules for a particular Subscription Id

subscribed_service_id

(optional) This param is used to get only the billing schedules for a particular Subscribed Service

limit

(optional) The maximum number of items to return in a paginated \"List\" call. Default: (`50`) Example: '500'

page

(optional) The value of the 'opc-next-page' response header from the previous \"List\" call.

sort_order

(optional) The sort order to use, either ascending ('ASC') or descending ('DESC').

Allowed values are: 'ASC', 'DESC'

sort_by

(optional) The field to sort by. You can provide one sort order ('sortOrder').

Allowed values are: 'ORDERNUMBER', 'TIMEINVOICING'

opc_request_id

(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.

x_one_origin_region

(optional) The OCI home region name in case home region is not us-ashburn-1 (IAD), e.g. ap-mumbai-1, us-phoenix-1 etc.

region

(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).

endpoint

(optional) The endpoint of the service to call using this function. e.g https://csaap-e.oracle.com.If both endpoint and region are given, then endpoint takes precedence.

credential_name

(optional) The name of the credential for authenticating with the corresponding cloud native API.