Standalone Selling Price Repository Population Using a REST API

Populate the Revenue Management Standalone Selling Price repository with up-to-date prices using the Standalone Selling Price REST API. This supports scalable, API-driven integration for organizations to manage large volumes of standalone selling price updates across multiple dimensions. 

The API can be called during regular revenue processing to upload standalone selling price information. When a POST request is used to create a new standalone selling price, the system validates that all required fields are completed, including item, pricing dimension combination, standalone selling price amount, currency, standalone selling price profile, effective period, SSP type, item classification and unit of measure. If any mandatory information is missing, the request is rejected with a clear validation message.

When the referenced item is not already assigned to a standalone selling price profile, the operation automatically creates the required standalone selling price profile assignment. In addition, the operation also dynamically creates the pricing dimension combination based on the values provided in the API payload, to remove the need for preconfiguring pricing dimension combination prior to upload.

Standalone selling prices loaded through the REST API can be viewed in the Mange Standalone Selling Prices in Spreadsheet page. These prices can be manually updated in the spreadsheet, provided they have not yet been used in the revenue recognition process.

Update and delete actions through REST API are not supported at this time.

Business Benefit:

  • Enable scalable, API-driven data integration for organizations managing high volumes of standalone selling price updates across multiple dimensions.
  • Improve operational efficiency by reducing manual spreadsheet-based uploads.
  • Enhance accuracy and consistency of pricing data in Revenue Management.
  • Ensure timely availability of up-to-date standalone selling prices for revenue allocation and compliance reporting.

Steps to enable and configure

Review the REST service definition in the REST API guides to leverage (available from the Oracle Help Center > your apps service area of interest > APIs & Schema). If you are new to Oracle's REST services you may want to begin with the Quick Start section.

You don't need to do anything to enable this feature.

Tips and considerations

  • Items can be assigned to SSP Profile either before or automatically during REST upload.
  • The API requires values for all mandatory attributes. A validation error is generated if any required field does not have a value.
  • If standalone selling prices uploaded through the REST API are found to be incorrect and have not yet been assigned to any promised details, they can be corrected directly in the repository using the Manage Standalone Selling Prices in Spreadsheet.

Key resources

Access requirements

No new access requirements.