OSP Gateway Invoice Service Functions

Package: DBMS_CLOUD_OCI_OG_INVOICE_SERVICE

DOWNLOAD_PDF_CONTENT Function

Returns an invoice in pdf format

Syntax

FUNCTION download_pdf_content (
  osp_home_region varchar2,
  compartment_id varchar2,
  internal_invoice_id varchar2,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_og_invoice_service_download_pdf_content_response_t;

Parameters

Parameter	Description
`osp_home_region`	(required) The home region's public name of the logged in user.
`compartment_id`	(required) The OCID of the compartment.
`internal_invoice_id`	(required) The identifier of the invoice.
`opc_request_id`	(optional) The 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://ospap.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.

GET_INVOICE Function

Returns an invoice by invoice id

Syntax

FUNCTION get_invoice (
  osp_home_region varchar2,
  compartment_id varchar2,
  internal_invoice_id varchar2,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_og_invoice_service_get_invoice_response_t;

Parameters

Parameter	Description
`osp_home_region`	(required) The home region's public name of the logged in user.
`compartment_id`	(required) The OCID of the compartment.
`internal_invoice_id`	(required) The identifier of the invoice.
`opc_request_id`	(optional) The 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://ospap.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.

LIST_INVOICE_LINES Function

Returns the invoice product list by invoice id

Syntax

FUNCTION list_invoice_lines (
  osp_home_region varchar2,
  compartment_id varchar2,
  internal_invoice_id varchar2,
  opc_request_id varchar2 DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_og_invoice_service_list_invoice_lines_response_t;

Parameters

Parameter	Description
`osp_home_region`	(required) The home region's public name of the logged in user.
`compartment_id`	(required) The OCID of the compartment.
`internal_invoice_id`	(required) The identifier of the invoice.
`opc_request_id`	(optional) The unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`page`	(optional) For list pagination. The value of the opc-next-page response header from the previous \"List\" call.
`limit`	(optional) For list pagination. The maximum number of results per page, or items to return in a paginated \"List\" call.
`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://ospap.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.

LIST_INVOICES Function

Returns a list of invoices

Syntax

FUNCTION list_invoices (
  osp_home_region varchar2,
  compartment_id varchar2,
  opc_request_id varchar2 DEFAULT NULL,
  invoice_id varchar2 DEFAULT NULL,
  l_type dbms_cloud_oci_osp_gateway_varchar2_tbl DEFAULT NULL,
  search_text varchar2 DEFAULT NULL,
  time_invoice_start timestamp with time zone DEFAULT NULL,
  time_invoice_end timestamp with time zone DEFAULT NULL,
  time_payment_start timestamp with time zone DEFAULT NULL,
  time_payment_end timestamp with time zone DEFAULT NULL,
  status dbms_cloud_oci_osp_gateway_varchar2_tbl DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  sort_order varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_og_invoice_service_list_invoices_response_t;

Parameters

Parameter	Description
`osp_home_region`	(required) The home region's public name of the logged in user.
`compartment_id`	(required) The OCID of the compartment.
`opc_request_id`	(optional) The unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`invoice_id`	(optional) The invoice query param (not unique).
`l_type`	(optional) A filter to only return resources that match the given type exactly. Allowed values are: 'HARDWARE', 'SUBSCRIPTION', 'SUPPORT', 'LICENSE', 'EDUCATION', 'CONSULTING', 'SERVICE', 'USAGE'
`search_text`	(optional) A filter to only return resources that match the given value. Looking for partial matches in the following fileds: Invoice No., Reference No. (plan number), Payment Ref, Total Amount(plan number), Balance Due(plan number) and Party/Customer Name
`time_invoice_start`	(optional) description: Start time (UTC) of the target invoice date range for which to fetch invoice data (inclusive).
`time_invoice_end`	(optional) description: End time (UTC) of the target invoice date range for which to fetch invoice data (exclusive).
`time_payment_start`	(optional) description: Start time (UTC) of the target payment date range for which to fetch invoice data (inclusive).
`time_payment_end`	(optional) description: End time (UTC) of the target payment date range for which to fetch invoice data (exclusive).
`status`	(optional) A filter to only return resources that match one of the status elements. Allowed values are: 'OPEN', 'PAST_DUE', 'PAYMENT_SUBMITTED', 'CLOSED'
`page`	(optional) For list pagination. The value of the opc-next-page response header from the previous \"List\" call.
`limit`	(optional) For list pagination. The maximum number of results per page, or items to return in a paginated \"List\" call.
`sort_by`	(optional) The field to sort by. Only one field can be selected for sorting. Allowed values are: 'INVOICE_NO', 'REF_NO', 'STATUS', 'TYPE', 'INVOICE_DATE', 'DUE_DATE', 'PAYM_REF', 'TOTAL_AMOUNT', 'BALANCE_DUE'
`sort_order`	(optional) The sort order to use (ascending or descending). Allowed values are: 'ASC', 'DESC'
`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://ospap.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.

PAY_INVOICE Function

Pay an invoice

Syntax

FUNCTION pay_invoice (
  osp_home_region varchar2,
  internal_invoice_id varchar2,
  compartment_id varchar2,
  pay_invoice_details dbms_cloud_oci_osp_gateway_pay_invoice_details_t,
  if_match varchar2 DEFAULT NULL,
  opc_retry_token varchar2 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_og_invoice_service_pay_invoice_response_t;

Parameters

Parameter	Description
`osp_home_region`	(required) The home region's public name of the logged in user.
`internal_invoice_id`	(required) The identifier of the invoice.
`compartment_id`	(required) The OCID of the compartment.
`pay_invoice_details`	(required) Invoice payment request.
`if_match`	(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value.
`opc_retry_token`	(optional) For requests that are not idempotent (creates being the main place of interest), THE APIs should take a header called opc-retry-token to identify the customer desire across requests, to introduce some level of idempotency.
`opc_request_id`	(optional) The 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://ospap.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.

Oracle Cloud Infrastructure Documentation Try Free Tier

DOWNLOAD_PDF_CONTENT Function 🔗

GET_INVOICE Function 🔗

LIST_INVOICE_LINES Function 🔗

LIST_INVOICES Function 🔗

PAY_INVOICE Function 🔗

Oracle Cloud Infrastructure Documentation
Try Free Tier

DOWNLOAD_PDF_CONTENT Function

GET_INVOICE Function

LIST_INVOICE_LINES Function

LIST_INVOICES Function

PAY_INVOICE Function