Construct the URL Strings

Once you have the parameter ID values for Oracle CPQ, you can construct the URL strings. This section provides the base strings you can use to construct the end point URLs that launch embedded Oracle CPQ pages with SAML and OpenID Connect SSO.

When using the URLs, copy the base strings to a text editor, add parameters, and replace the portion of each of the following end points with the parameter values in Oracle CPQ. Paste the edited URLs into the Value field. See Create the Integration URLs.

Note: When you copy-paste the URL constructions, remove any leading or trailing spaces. The application integration can fail with extra spaces.

The following sections show you how to construct the URLs.

On completion, you need to have just one integration created, because the integration currently only supports a single sales order instance.

How to Construct the SAML SSO URLs

Here's how to construct the SAML SSO URLs:

Action: Create the quote

URL String Format:

#{'/sso/saml_request.jsp?RelayState=/commerce/buyside/document.jsp?_partnerIdentifier=fusion%26formaction=create%26process={process}%26search_id=-1%26_bm_cm_new_transaction_currency=' + (osc_param_CurrencyCode ?: '') + '%26_partnerOpportunityId=' + (osc_param_OptyId ?: '') + '%26_partnerOpportunityNumber=' + (osc_param_OptyNumber ?: '') + '%26_partnerAccountId=' + (osc_param_AccountId ?: '')}

URL String Example:

#{'/sso/saml_request.jsp?RelayState=/commerce/buyside/document.jsp?_partnerIdentifier=fusion%26formaction=create%26process=oraclecpqo%26search_id=-1%26_bm_cm_new_transaction_currency=' + (osc_param_CurrencyCode ?: '') + '%26_partnerOpportunityId=' + (osc_param_OptyId ?: '') + '%26_partnerOpportunityNumber=' + (osc_param_OptyNumber ?: '') + '%26_partnerAccountId=' + (osc_param_AccountId ?: '')}

Action: Edit the quote

URL String Format:

#{'/sso/saml_request.jsp?RelayState=/commerce/buyside/document.jsp?_partnerIdentifier=fusion%26formaction=performAction%26action_id={action_id_open}%26document_id={document_id}%26bs_id=' +osc_quote_ExternalReferenceNumber+'%26bm_cm_process_id={process_id}'}

URL String Example:

#{'/sso/saml_request.jsp?RelayState=/commerce/buyside/document.jsp?_partnerIdentifier=fusion%26formaction=performAction%26action_id=36244076%26document_id=36244074%26bs_id=' +osc_quote_ExternalReferenceNumber+'%26bm_cm_process_id=36244034'}

Action: Copy the quote

URL String Format:

#{'/sso/saml_request.jsp?RelayState=/commerce/buyside/copy_processing.jsp?_partnerIdentifier=fusion%26action_id={action_id_copy}%26version_id={version_id}%26bs_id=' + osc_quote_ExternalReferenceNumber + '%26document_id={document_id}'}

URL String Example:

#{'/sso/saml_request.jsp?RelayState=/commerce/buyside/copy_processing.jsp?_partnerIdentifier=fusion%26action_id=36244038%26version_id=36282630%26bs_id=' + osc_quote_ExternalReferenceNumber + '%26document_id=36244074'}

Action: Create new version of the quote

URL String Format:

#{'/sso/saml_request.jsp?RelayState=/commerce/buyside/document.jsp?_partnerIdentifier=fusion%26process={process}%26formaction=version%26action_id={action_id_version}%26bs_id=' + osc_quote_ExternalReferenceNumber}

URL String Example:

#{'/sso/saml_request.jsp?RelayState=/commerce/buyside/document.jsp?_partnerIdentifier=fusion%26process=oraclecpqo%26formaction=version%26action_id=36269741%26bs_id=' + osc_quote_ExternalReferenceNumber}

Action: Get the proposal for the quote

URL String Format:

#{'/sso/saml_request.jsp?RelayState=/rest/v10/commerceProcesses/{process}/transactions/' +osc_quote_ExternalReferenceNumber+ '/attachments/oRCL_OSC_FileAttachment_t'}

URL String Example:

#{'/sso/saml_request.jsp?RelayState=/rest/v10/commerceProcesses/oraclecpqo/transactions/' +osc_quote_ExternalReferenceNumber + '/attachments/oRCL_OSC_FileAttachment_t'}

How to Construct the OpenID Connect URLs

Here's how to construct the OpenID Connect URLs:

Action: Create the quote

URL String Format:

#{'/sso/openid_connect_request.jsp?RelayState=/commerce/buyside/document.jsp?_partnerIdentifier=fusion%26formaction=create%26process={process}%26search_id=-1%26_bm_cm_new_transaction_currency=' + (osc_param_CurrencyCode ?: '') + '%26_partnerOpportunityId=' + (osc_param_OptyId ?: '') + '%26_partnerOpportunityNumber=' + (osc_param_OptyNumber ?: '') + '%26_partnerAccountId=' + (osc_param_AccountId ?: '')}

URL String Example:

#{'/sso/openid_connect_request.jsp?RelayState=/commerce/buyside/document.jsp?_partnerIdentifier=fusion%26formaction=create%26process=oraclecpqo%26search_id=-1%26_bm_cm_new_transaction_currency=' + (osc_param_CurrencyCode ?: '') + '%26_partnerOpportunityId=' + (osc_param_OptyId ?: '') + '%26_partnerOpportunityNumber=' + (osc_param_OptyNumber ?: '') + '%26_partnerAccountId=' + (osc_param_AccountId ?: '')}

Action: Edit the quote

URL String Format:

#{'/sso/openid_connect_request.jsp?RelayState=/commerce/buyside/document.jsp?_partnerIdentifier=fusion%26formaction=performAction%26action_id={action_id_open}%26document_id={document_id}%26bs_id=' +osc_quote_ExternalReferenceNumber+'%26bm_cm_process_id={process_id}'}

URL String Example:

#{'/sso/openid_connect_request.jsp?RelayState=/commerce/buyside/document.jsp?_partnerIdentifier=fusion%26formaction=performAction%26action_id=36244076%26document_id=36244074%26bs_id=' +osc_quote_ExternalReferenceNumber+'%26bm_cm_process_id=36244034'}

Action: Create the quote

URL String Format:

#{'/sso/openid_connect_request.jsp?RelayState=/commerce/buyside/document.jsp?_partnerIdentifier=fusion%26formaction=create%26process={process}%26search_id=-1%26_bm_cm_new_transaction_currency=' + (osc_param_CurrencyCode ?: '') + '%26_partnerOpportunityId=' + (osc_param_OptyId ?: '') + '%26_partnerOpportunityNumber=' + (osc_param_OptyNumber ?: '') + '%26_partnerAccountId=' + (osc_param_AccountId ?: '')}

URL String Example:

#{'/sso/openid_connect_request.jsp?RelayState=/commerce/buyside/document.jsp?_partnerIdentifier=fusion%26formaction=create%26process=oraclecpqo%26search_id=-1%26_bm_cm_new_transaction_currency=' + (osc_param_CurrencyCode ?: '') + '%26_partnerOpportunityId=' + (osc_param_OptyId ?: '') + '%26_partnerOpportunityNumber=' + (osc_param_OptyNumber ?: '') + '%26_partnerAccountId=' + (osc_param_AccountId ?: '')}

Action: Copy the quote

URL String Format:

#{'/sso/openid_connect_request.jsp?RelayState=/commerce/buyside/copy_processing.jsp?_partnerIdentifier=fusion%26action_id={action_id_copy}%26version_id={action_id_version}%26bs_id=' + osc_quote_ExternalReferenceNumber + '%26document_id={document_id}'}

URL String Example:

#{'/sso/openid_connect_request.jsp?RelayState=/commerce/buyside/copy_processing.jsp?_partnerIdentifier=fusion%26action_id=36244038%26version_id=36282630%26bs_id=' + osc_quote_ExternalReferenceNumber + '%26document_id=36244074'}

Action: Create new version of the quote

URL String Format:

#{'/sso/openid_connect_request.jsp?RelayState=/commerce/buyside/document.jsp?_partnerIdentifier=fusion%26process={process}%26formaction=version%26action_id={action_id_version}%26bs_id=' + osc_quote_ExternalReferenceNumber}

URL String Example:

#{'/sso/openid_connect_request.jsp?RelayState=/commerce/buyside/document.jsp?_partnerIdentifier=fusion%26process=oraclecpqo%26formaction=version%26action_id=36269741%26bs_id=' + osc_quote_ExternalReferenceNumber}

Action: Get the proposal for the quote

URL String Format:

#{'/sso/openid_connect_request.jsp?RelayState=/rest/v10/commerceProcesses/{process}/transactions/' +osc_quote_ExternalReferenceNumber+ '/attachments/oRCL_OSC_FileAttachment_t'}

URL String Example:

#{'/sso/openid_connect_request.jsp?RelayState=/rest/v10/commerceProcesses/oraclecpqo/transactions/' +osc_quote_ExternalReferenceNumber + '/attachments/oRCL_OSC_FileAttachment_t'}