Sales Products Business Object Logic

Sales product data follows specific business logic, and at times, as an implementor, you may sometimes need to be aware of how the data maps to other applications or objects.

Here's an example of business logic you may want to be aware of:

• When you create a product in the Sales Products UI, or using web services, the Inventory Item ID is null. However, if you create a product using import, the Inventory Item ID is the same as the Inventory Item ID in the Oracle Supply Chain Management (SCM) Cloud product tables.

This table describes the business logic for various business objects when using sales products. In the table "sales product" means a product created in the sales products UI. "Import" refers to Oracle import.

Sales Products Attribute	Business Logic
Inventory Item ID	Sales product creation through UI or web services: null. Sales product creation through import: Same as the Inventory Item ID for the SCM back-end item that's being created as the sales product. The SCM back-end item attribute should match the sales product Number attribute. Required when a product is updated.
Organization ID	Sales product creation through UI or web services: The value for the profile option QSC_SALES_PRODUCTS_INVENTORY_ORG_ID is set as the default. Sales product creation through import: Same as the organization ID for the SCM Cloud back-end item that's being created in Sales products screens.
Item Master Organization	Sales product creation through UI or web services: The value for the profile option QSC_SALES_PRODUCTS_INVENTORY_ORG_ID is set as the default. Sales product creation through import: Same as the organization ID for the SCM Cloud back-end item that's being created in Sales products screens.
Item Class	Required attribute when creating a new product in the SCM Cloud back-end products application. The value should be Root Item Class.
Template	Required attribute when creating a new product in the SCM Cloud back-end products application. The value should be Finished Goods.
Number	Required attribute when creating a new product or updating an existing product. The value must be unique for an item master. Creating a product with an existing number throws an API unique violation error.
Name	Required attribute when creating a new product. The value should be passed during product update only if changed.
Product Type	Sales products retrieves the list of values for Product Type from the lookup type QSC_SALES_PRODUCT_TYPE. See Significance of the Sales Product Type Fieldfor more information.
Default Unit of Measure (UOM)	Validated against all UOMs that are effective as of current date. Optional for create operation. Update of UOM isn't allowed for saved products.
Eligible to Sell	All Sales products must have this indicator set to yes (checked). For update operation, pass only if changed. When a user sets it to no from yes, the corresponding SCM Cloud item indicators Customer Orders Enabled and Orderable on the Web are set to no. When a user sets it to yes from no, only the corresponding SCM Cloud item indicator Customer Order Enabled is set back to yes.
Eligible for Service	All Service products that will be used in the service request management application must have this indicator set to yes (checked). For update operation, pass only if changed. When a user sets it to no from yes, the corresponding SCM Cloud item indicator Service Request is set to Disabled When a user sets it to yes from no, the corresponding SCM Cloud item indicator Service Request is set to Enabled
Image	Image maps to the SCM Cloud attachment entity ITEM_ENTITY and the category IMAGE. Only one image per product is allowed. Optional for create operation. For update operation, pass only if changed. In the case of errors, API messages are returned.
Attachments	A product can have multiple attachments. Only attachments of type "file" are allowed. Product attachments map to the SCM Cloud items attachment entity ITEM_ENTITY. The attachment category can be one of the following: One of the attachment categories associated with the Root Item Class except IMAGE. Null Optional during product creation. Attachments can be added, updated, or deleted at any time. In the case of errors, SCM Cloud API messages are returned.