Update one price book
patch
/fscmRestApi/resources/11.13.18.05/priceBooks/{PriceBookNumber}
Request
Path Parameters
-
PriceBookNumber(required): string
The value of this parameter could be a hash of the key that is used to uniquely identify the resource item. The client should not generate the hash key value. Instead, the client should query on the collection resource with a filter to navigate to a specific resource item. For example: products?q=InventoryItemId=
Header Parameters
-
Metadata-Context: string
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version: string
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Supported Media Types
- application/json
Root Schema : schema
Type:
Show Source
object-
BusinessUnit: string
Maximum Length:
255The business unit for which the price book can be used for sales. -
BusinessUnitId(required): integer
(int64)
Value that uniquely identifies the business unit for which the price book can be used for sales.
-
Currency: string
Maximum Length:
255The code for the currency used in the price book. -
CurrencyCode(required): string
Maximum Length:
15The currency used in the price book. -
Description: string
Maximum Length:
1000The description of the price book. -
dimensions: array
Price Book Dimension
Title:
Price Book DimensionInformation about the parameters used in filtering items or calculating the prices that appear in the price book. -
EndDate: string
(date-time)
The date and time on which the price book is no longer effective.
-
lines: array
Price Book Line
Title:
Price Book LineInformation about the items that are priced in a price book. -
Name(required): string
Maximum Length:
80The name of the price book. -
PriceBookId: integer
(int64)
Value that uniquely identifies the price book. This value is automatically assigned by Oracle Pricing.
-
PriceBookNumber(required): string
Maximum Length:
30The number for the price book. -
PricingDate(required): string
(date-time)
The date and time when price book values are calculated.
-
publications: array
Price Book Publication
Title:
Price Book PublicationInformation about the parameters used to publish price book data. -
StartDate(required): string
(date-time)
The date and time when the price book goes into effect.
-
StatusCode: string
Maximum Length:
30The generation status of the price book.
Nested Schema : Price Book Dimension
Type:
arrayTitle:
Price Book DimensionInformation about the parameters used in filtering items or calculating the prices that appear in the price book.
Show Source
Nested Schema : Price Book Line
Type:
arrayTitle:
Price Book LineInformation about the items that are priced in a price book.
Show Source
Nested Schema : Price Book Publication
Type:
arrayTitle:
Price Book PublicationInformation about the parameters used to publish price book data.
Show Source
Nested Schema : schema
Type:
Show Source
object-
DimensionCriteria: string
(byte)
Criteria used to generate the price book.
-
PriceBookDimensionId: integer
(int64)
Value that uniquely identifies the price book dimension.
-
PriceBookId: integer
(int64)
Value that uniquely identifies the price book.
-
ProductCriteria: string
(byte)
Product criteria used to generate the price book.
-
Version: integer
(int32)
Version of the price book.
Nested Schema : priceBooks-lines-item-patch-request
Type:
Show Source
object-
chargeComponents: array
Price Book Charge Component
Title:
Price Book Charge ComponentInformation about the types of charges that are used to price a line in a price book.
Nested Schema : Price Book Charge Component
Type:
arrayTitle:
Price Book Charge ComponentInformation about the types of charges that are used to price a line in a price book.
Show Source
Nested Schema : schema
Type:
Show Source
object-
Description: string
Maximum Length:
1000Description of the price book publication. -
DimensionCriteria: string
(byte)
Criteria used to generate the price book.
-
Name: string
Maximum Length:
80Name of the price book publication. -
PriceBookId: integer
Value that uniquely identifies the price book. This value is automatically assigned by Oracle Pricing.
-
ProductCriteria: string
(byte)
Product criteria used to generate the price book.
-
PublicationDate: string
(date-time)
The date and time the document was published.
-
PublicationFormat: string
Maximum Length:
30Format used for creating the price book publication.
Response
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : priceBooks-item-response
Type:
Show Source
object-
BusinessUnit: string
Maximum Length:
255The business unit for which the price book can be used for sales. -
BusinessUnitId: integer
(int64)
Value that uniquely identifies the business unit for which the price book can be used for sales.
-
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the record. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the record was created. -
Currency: string
Maximum Length:
255The code for the currency used in the price book. -
CurrencyCode: string
Maximum Length:
15The currency used in the price book. -
Description: string
Maximum Length:
1000The description of the price book. -
dimensions: array
Price Book Dimension
Title:
Price Book DimensionInformation about the parameters used in filtering items or calculating the prices that appear in the price book. -
EndDate: string
(date-time)
The date and time on which the price book is no longer effective.
-
LastUpdateDate: string
(date-time)
Read Only:
trueDate and time when the record was last updated. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who last updated the record. -
LastUpdateLogin: string
Read Only:
trueMaximum Length:32The session login associated with the user who last updated the record. -
lines: array
Price Book Line
Title:
Price Book LineInformation about the items that are priced in a price book. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Name: string
Maximum Length:
80The name of the price book. -
PriceBookId: integer
(int64)
Value that uniquely identifies the price book. This value is automatically assigned by Oracle Pricing.
-
PriceBookNumber: string
Maximum Length:
30The number for the price book. -
PricingDate: string
(date-time)
The date and time when price book values are calculated.
-
publications: array
Price Book Publication
Title:
Price Book PublicationInformation about the parameters used to publish price book data. -
StartDate: string
(date-time)
The date and time when the price book goes into effect.
-
StatusCode: string
Maximum Length:
30The generation status of the price book.
Nested Schema : Price Book Dimension
Type:
arrayTitle:
Price Book DimensionInformation about the parameters used in filtering items or calculating the prices that appear in the price book.
Show Source
Nested Schema : Price Book Line
Type:
arrayTitle:
Price Book LineInformation about the items that are priced in a price book.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Price Book Publication
Type:
arrayTitle:
Price Book PublicationInformation about the parameters used to publish price book data.
Show Source
Nested Schema : priceBooks-dimensions-item-response
Type:
Show Source
object-
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the record. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the record was created. -
DimensionCriteria: string
(byte)
Criteria used to generate the price book.
-
LastUpdateDate: string
(date-time)
Read Only:
trueDate and time when the record was last updated. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the record. -
LastUpdateLogin: string
Read Only:
trueMaximum Length:32The session login associated with the user who last updated the record. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
PriceBookDimensionId: integer
(int64)
Value that uniquely identifies the price book dimension.
-
PriceBookId: integer
(int64)
Value that uniquely identifies the price book.
-
ProductCriteria: string
(byte)
Product criteria used to generate the price book.
-
Version: integer
(int32)
Version of the price book.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : priceBooks-lines-item-response
Type:
Show Source
object-
Charge: string
Read Only:
trueMaximum Length:80Component of price for an item. Multiple charges are possible, such as sales, shipping, tax. -
chargeComponents: array
Price Book Charge Component
Title:
Price Book Charge ComponentInformation about the types of charges that are used to price a line in a price book. -
ChargeDefinitionCode: string
Read Only:
trueMaximum Length:30Code that identifies the definition for the pricing charge. -
Description: string
Read Only:
trueMaximum Length:240Item Description. -
InventoryItemId: integer
(int64)
Read Only:
trueValue that uniquely identifies the item. -
InventoryOrgId: integer
(int64)
Read Only:
trueValue that uniquely identifies the organization. -
Item: string
Read Only:
trueMaximum Length:300Number used on the price book line to refer to the item. -
ItemType: string
Read Only:
trueMaximum Length:30Type of item. -
ItemTypeCode: string
Read Only:
trueMaximum Length:30BOM item type. Values include 1, 2, and 4. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
ListPrice: number
Read Only:
trueStarting unit price in the price book. -
NetPrice: number
Read Only:
truePrice that's adjusted for discounts after calculation in generating the price book. -
PriceBookChargeId: integer
(int64)
Read Only:
trueValue that uniquely identifies the price book charge. Oracle Pricing automatically assigns this value. -
PriceBookId: integer
Read Only:
trueValue that uniquely identifies the price book. -
PriceBookLineId: integer
(int64)
Read Only:
trueValue that uniquely identifies the price book line. -
ShipMethod: string
Read Only:
trueMaximum Length:522Name of the ship method. -
ShipMethodId: integer
(int64)
Read Only:
trueValue that uniquely identifies the shipping method. -
Strategy: string
Read Only:
trueMaximum Length:80Combination for factors used to segment population of customers for pricing. -
StrategyId: integer
(int64)
Read Only:
trueValue that uniquely identifies the pricing strategy. Oracle Pricing automatically assigns this value. -
UOM: string
Read Only:
trueMaximum Length:25Unit of measure for item which the price is calculated in the price book. -
UOMCode: string
Read Only:
trueMaximum Length:3Unit of measure for which the price is calculated.
Nested Schema : Price Book Charge Component
Type:
arrayTitle:
Price Book Charge ComponentInformation about the types of charges that are used to price a line in a price book.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : priceBooks-lines-chargeComponents-item-response
Type:
Show Source
object-
ExplanationMessage: string
Read Only:
trueMaximum Length:1000Explanation message. Stores the pricing message based on the values for the component, the calculation type, and the calculation component fields. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Price: number
Read Only:
trueValue for which one will be charged for an item. -
PriceBookChargeComponentId: integer
Read Only:
trueValue that uniquely identifies the price book charge component. Oracle Pricing automatically assigns this value. -
PriceBookChargeId: integer
(int64)
Read Only:
trueValue that uniquely identifies the price book charge. Oracle Pricing automatically assigns this value. -
PriceElement: string
Read Only:
trueMaximum Length:1000Reference used to designate a type of charge. -
PriceElementCode: string
Read Only:
trueMaximum Length:30Code that identifies the element reference to the price elements setup. For example, QP_LIST_PRICE, QP_NET_PRICE. -
PriceElementName: string
Read Only:
trueMaximum Length:80Name of pricing element for a charge component. -
PricingSourceId: string
Read Only:
trueMaximum Length:30Value that uniquely identifies the lowest level pricing source. For example, price list or discount rule. -
PricingSourceTypeCode: string
Read Only:
trueMaximum Length:30Code that identifies the type of the pricing source. For example, price list charge, rate plan charge, tiered pricing rule. A list of accepted values is defined in the lookup type ORA_QP_SOURCE_TYPES.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : priceBooks-publications-item-response
Type:
Show Source
object-
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the record. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the record was created. -
Description: string
Maximum Length:
1000Description of the price book publication. -
DimensionCriteria: string
(byte)
Criteria used to generate the price book.
-
LastUpdateDate: string
(date-time)
Read Only:
trueDate and time when the record was last updated. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the record. -
LastUpdateLogin: string
Read Only:
trueMaximum Length:32The session login associated with the user who last updated the record. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Name: string
Maximum Length:
80Name of the price book publication. -
PriceBookId: integer
Value that uniquely identifies the price book. This value is automatically assigned by Oracle Pricing.
-
PriceBookPublicationId: integer
Value that uniquely identifies the price book publication.
-
ProductCriteria: string
(byte)
Product criteria used to generate the price book.
-
PublicationDate: string
(date-time)
The date and time the document was published.
-
PublicationFormat: string
Maximum Length:
30Format used for creating the price book publication. -
StatusCode: string
Read Only:
trueMaximum Length:30Abbreviation that identifies the status of the publication.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Links
- deletePriceBook
-
Parameters:
- PriceBookNumber:
$request.path.PriceBookNumber
Deletes one price book and its contents based on a set of parameters. - PriceBookNumber:
- dimensions
-
Parameters:
- PriceBookNumber:
$request.path.PriceBookNumber
Information about the parameters used in filtering items or calculating the prices that appear in the price book. - PriceBookNumber:
- generatePriceBook
-
Parameters:
- PriceBookNumber:
$request.path.PriceBookNumber
Generates a precalculated collection of prices based on a set of input parameters. - PriceBookNumber:
- lines
-
Parameters:
- PriceBookNumber:
$request.path.PriceBookNumber
Information about the items that are priced in a price book. - PriceBookNumber:
- publications
-
Parameters:
- PriceBookNumber:
$request.path.PriceBookNumber
Information about the parameters used to publish price book data. - PriceBookNumber:
Examples
This example describes how to update one price book.
Example cURL Command
Use the following cURL command to submit a request on the REST resource.
curl -X PATCH -u "username:password" -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" -d 'request payload' "https://servername/fscmRestApi/resources/version/priceBooks/PriceBookNumber"
Example Request Body
The following example includes the contents of the request body in JSON format. You replace the request payload in the cURL command with the contents of the Example Request Body. The request payload specifies attribute values that the command will use in the record that it updates.
{
"BusinessUnit": "Vision Operations",
"BusinessUnitId": "204",
"CurrencyCode": "USD",
"Description": "RM_PB_TEST Testing updated",
"EndDate": null,
"Name": "RM_TEST",
"PriceBookNumber": "RM_PB_TEST",
"StartDate": "2025-07-07T00:00:00+00:00",
"StatusCode": "ORA_QP_PB_DRAFT",
"PricingDate": "2025-07-07T00:00:00+00:00"
}
Example Response Body
The following example includes the contents of the response
body in JSON format:
{
"PriceBookId": "300100639346697",
"Name": "RM_TEST",
"PriceBookNumber": "RM_PB_TEST",
"Description": "RM_PB_TEST Testing updated",
"BusinessUnitId": "204",
"BusinessUnit": "Vision Operations",
"CurrencyCode": "USD",
"Currency": "US Dollar",
"StartDate": "2025-07-07T00:00:00+00:00",
"CreatedBy": "PRICING_MGR_OPERATIONS",
"EndDate": null,
"PricingDate": "2025-07-07T00:00:00+00:00",
"CreationDate": "2025-07-24T05:20:00+00:00",
"LastUpdateDate": "2025-07-31T11:33:56.004+00:00",
"LastUpdateLogin": "39AD42326F4268BDE063FC79060ADF5A",
"LastUpdatedBy": "SCMOPERATIONS",
"StatusCode": "ORA_QP_PB_DRAFT"
}