One Subscription Invoice Summary Functions

Package: DBMS_CLOUD_OCI_OS_INVOICE_SUMMARY

LIST_INVOICELINE_COMPUTED_USAGES Function

This is a collection API which returns a list of Invoiced Computed Usages for given Invoiceline id.

Syntax

FUNCTION list_invoiceline_computed_usages (
  compartment_id varchar2,
  invoice_line_id varchar2,
  sort_order varchar2 DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  fields dbms_cloud_oci_onesubscription_varchar2_tbl DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_os_invoice_summary_list_invoiceline_computed_usages_response_t;

Parameters

Parameter	Description
`compartment_id`	(required) The OCID of the root compartment.
`invoice_line_id`	(required) Invoice Line Identifier - Primary Key SPM
`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 Invoiced Computed Usages. You can provide one sort order (`sortOrder`). Allowed values are: 'timeCreated', 'meteredOnDate'
`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.
`fields`	(optional) Partial response refers to an optimization technique offered by the RESTful web APIs to return only the information (fields) required by the client. This parameter is used to control what fields to return.
`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.
`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://identity.{region}.oci.{secondLevelDomain}.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.

LIST_INVOICES Function

This is a collection API which returns a list of Invoices for given filters.

Syntax

FUNCTION list_invoices (
  compartment_id varchar2,
  ar_customer_transaction_id varchar2,
  time_from timestamp with time zone DEFAULT NULL,
  time_to timestamp with time zone DEFAULT NULL,
  sort_order varchar2 DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  fields dbms_cloud_oci_onesubscription_varchar2_tbl DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_os_invoice_summary_list_invoices_response_t;

Parameters

Parameter	Description
`compartment_id`	(required) The OCID of the root compartment.
`ar_customer_transaction_id`	(required) AR Unique identifier for an invoice .
`time_from`	(optional) Initial date to filter Invoice data in SPM.
`time_to`	(optional) Final date to filter Invoice data in SPM.
`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'
`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.
`fields`	(optional) Partial response refers to an optimization technique offered by the RESTful web APIs to return only the information (fields) required by the client. This parameter is used to control what fields to return.
`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.
`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://identity.{region}.oci.{secondLevelDomain}.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.

Oracle Cloud Infrastructure Documentation Try Free Tier

LIST_INVOICELINE_COMPUTED_USAGES Function 🔗

LIST_INVOICES Function 🔗

Oracle Cloud Infrastructure Documentation
Try Free Tier

LIST_INVOICELINE_COMPUTED_USAGES Function

LIST_INVOICES Function