1. Using Revenue Management
  2. Populate Standalone Selling Price Repository Using a REST API

Populate Standalone Selling Price Repository 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.

You can view the standalone selling prices loaded through the REST API in the Manage Standalone Selling Prices in Spreadsheet page. You can manually update these prices 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.

Enable and Configure Standalone Selling Price Repository Population

Review the REST service definition in the REST API guides to leverage 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.

Tips And Considerations

Use these tips and considerations:
  • Assign items to the Standalone Selling Price 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 haven't been assigned to any promised details yet, you can directly correct them in the repository using the Manage Standalone Selling Prices in Spreadsheet.