Item Catalog

Logical Business Objects

SCM : Product Model : Item Catalog

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type	Object or Service
Handles	Item Category
Handles	Item Catalog Descriptive Flexfield
Handles	Item Catalog
Handles	Item Category Descriptive Flexfield
Handles	Attachment SDO
Handles	Catalog Category Hierarchy SDO
Handles	Item Category Translation
Handles	Item Category Assignment SDO
Handles	Item Catalog SDO
Handles	Item Catalog Translation

copyCategory

Copies a catalog. The attributes for this operation are one to many.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
sourceCatalogCode	string	Code of the source catalog
sourceCategoryCode	string	Code of the source category
targetCatalogCode	string	Code of the target catalog
targetCategoryCode	string	Code of the target category under which the source category would be copied
CopyChildCategoriesFlag	boolean	Indicates if the child categories of the source category will be copied.
CopyItemAssignmentsFlag	boolean	Indicatse if the item assignments of the source catalog category should be copied.

Response Payload

Element Name	Type	Description
result	Item Category	The output this is returned from the copyCategory operation if successful and the error codes if it fails.

addSharedCategories

Operation to reference a specified catalog category into a target category

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
sourceCatalogCode	string	Code of the source catalog
sourceCategoryCode	string	Code of the source category
targetCatalogCode	string	Code of the catalog into which the specified catalog category should be referenced
targetCategoryCode	string	Code of the category into which the specified catalog category should be referenced

Response Payload

Element Name	Type	Description
result	void	The output this is returned from the addSharedCategories operation if successful and the error codes if it fails.

getCatalogCategories

Returns the list of categories for the given catalog

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
catalogId	long	Unique Identifier of the catalog.
catalogCode	string	Code of the catalog.
catalogName	string	Name of the catalog.

Response Payload

Element Name	Type	Description
result	Item Category	The output that is returned from the getCatalogCategories operation if successful and the error codes if it fails.

createCatalog

Creates the catalog

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
catalog	Item Catalog	An attribute value for the Catalog service data object to be created.

Response Payload

Element Name	Type	Description
result	Item Catalog	The output that is returned from the create operation consisting of the Catalog service data object that is created.

updateCatalog

Update a catalog.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
catalog	Item Catalog	An attribute value for the Catalog service data object to be updated

Response Payload

Element Name	Type	Description
result	Item Catalog	The output that is returned from the update operation consisting of the Catalog service data object that is updated

mergeCatalog

Updates a catalog, if it exists, or creates a new catalog if it does not exist.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
catalog	Item Catalog	An attribute value for the Catalog service data object to be merged

Response Payload

Element Name	Type	Description
result	Item Catalog	The output that is returned from the merged operation consisting of the Catalog service data object that is merged

findCatalog

Finds a catalog.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
findCriteria	{http://xmlns.oracle.com/adf/svc/types/}FindCriteria	An attribute that represents the search criteria for the find operation. This parameter value is null initially, the user must add the attribute from the service data object.
findControl	{http://xmlns.oracle.com/adf/svc/types/}FindControl	This parameter value is null and is not used currently.

Response Payload

Element Name	Type	Description
result	Item Catalog	The output that is returned from the find operation with a list of objects that match the find criteria.

processCatalog

Performs create or update on a list of catalogs.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
changeOperation	string	An attribute that indicates the action that will be performed in the process operation. The actions include Create, Update, Merge or Delete.
catalog	Item Catalog	The service data object record for Catalog
processControl	{http://xmlns.oracle.com/adf/svc/types/}ProcessControl	An attribute that controls the bulk upload behavior for the Catalog object. For example, controls if valid data will be committed if there are other invalid data in the same batch and controls if the return will contain only key attributes or full objects.

Response Payload

Element Name	Type	Description
result	Item Catalog	The output this is returned from the process Catalog operation is the service data object for the Catalog

createCategory

Creates a category and associates it to a catalog.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
category	Item Category	An attribute value for the Category service data object to be created.

Response Payload

Element Name	Type	Description
result	Item Category	The output that is returned from the create operation consisting of the Category service data object that is created.

updateCategory

Updates a category.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
category	Item Category	An attribute value for the Category service data object to be updated

Response Payload

Element Name	Type	Description
result	Item Category	The output that is returned from the update operation consisting of the Category service data object that is updated

mergeCategory

Operaton to create or update a category, depending if it exists.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
category	Item Category	An attribute value for the Category service data object to be merged

Response Payload

Element Name	Type	Description
result	Item Category	The output that is returned from the merged operation consisting of the Category service data object that is merged

findCategory

Find a category.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
findCriteria	{http://xmlns.oracle.com/adf/svc/types/}FindCriteria	An attribute that represents the search criteria for the find operation. This parameter value is null initially, the user must add the attribute from the service data object.
findControl	{http://xmlns.oracle.com/adf/svc/types/}FindControl	This parameter value is null and is not used currently.

Response Payload

Element Name	Type	Description
result	Item Category	The output that is returned from the find operation with a list of objects that match the find criteria.

processCategory

Performs create, update, delete or merge operations on a list of categories.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
changeOperation	string	An attribute that indicates the action that will be performed in the process operation. The actions include Create, Update, Merge or Delete.
category	Item Category	The service data object record for Category
processControl	{http://xmlns.oracle.com/adf/svc/types/}ProcessControl	An attribute that controls the bulk upload behavior for the Category object. For example, controls if valid data will be committed if there are other invalid data in the same batch and controls if the return will contain only key attributes or full objects.

Response Payload

Element Name	Type	Description
result	Item Category	The output this is returned from the process Category operation is the service data object for the Category

getCatalogHierarchy

Returns the list of categories for the given catalog

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
catalogId	long	Unique Identifier of the catalog.

Response Payload

Element Name	Type	Description
result	Item Catalog SDO	The output that is returned from the getCatalogHierarchy operation if successful and the error codes if it fails.

findCatalogHierarchy

Returns the catalog hierarchy of the specificed catalog, along with the items assigned to each category.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
findCriteria	{http://xmlns.oracle.com/adf/svc/types/}FindCriteria	An attribute that represents the search criteria for the find operation. This parameter value is null initially, the user must add the attribute from the service data object.
findControl	{http://xmlns.oracle.com/adf/svc/types/}FindControl	This parameter value is null and is not used currently.

Response Payload

Element Name	Type	Description
result	Item Catalog SDO	The output that is returned from the find operation with a list of objects that match the find criteria.

Security

The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

Service Operations to Privileges Mapping

Operation Name	Privilege Code	Privilege Name	Privilege Description
All Operations	EGP_MANAGE_ITEM_CATALOG_PRIV	Manage Item Catalog	Allows access to view and manage item catalogs including categories and category hierarchies.

Privileges to Duty Roles Mapping

Privilege Code	Granted to Duty Role Code	Granted to Duty Role Name	Granted To Duty Role Description
EGP_MANAGE_ITEM_CATALOG_PRIV	ORA_ATC_OFFER_CATALOG_ITEM_MANAGEMENT_FSCM	Offer Catalog Item Management	Creates and manages items and item related information for offer catalog in Product Hub
EGP_MANAGE_ITEM_CATALOG_PRIV	ORA_POS_SUPPLIER_DEMAND_PLANNER_JOB	Supplier Demand Planner	Manages supplier scheduling, supplier managed inventory and consigned inventory for the supplier company.
EGP_MANAGE_ITEM_CATALOG_PRIV	ORA_MSC_PRODUCTION_SCHEDULE_MANAGEMENT_DUTY	Production Schedule Management	Manages, analyzes, runs and releases production schedules
EGP_MANAGE_ITEM_CATALOG_PRIV	ORA_EGP_ITEM_MANAGEMENT_DUTY	Item Management	Creates and manages items including item attributes, item structures, packs, associations, relationships, and catalog assignments.
EGP_MANAGE_ITEM_CATALOG_PRIV	ORA_ATC_OFFER_CATALOG_ITEM_INQUIRY_FSCM	Offer Catalog Item Inquiry	Views items and item related information for offer catalog in Product Hub
EGP_MANAGE_ITEM_CATALOG_PRIV	ORA_EGP_ITEM_INQUIRY_DUTY	Item Inquiry	Queries and views items in the enterprise.
EGP_MANAGE_ITEM_CATALOG_PRIV	ORA_POS_SUPPLIER_ACCOUNTS_RECEIVABLE_SPECIALIST_JOB	Supplier Accounts Receivable Specialist	Manages invoices and payments for the supplier company. Primary tasks include submitting invoices as well as tracking invoice and payment status.
EGP_MANAGE_ITEM_CATALOG_PRIV	ORA_PO_PROCUREMENT_APPLICATION_ADMIN_JOB	Procurement Application Administrator	Responsible for technical aspects of keeping procurement applications systems available as well as configuring the applications to meet the needs of the business.
EGP_MANAGE_ITEM_CATALOG_PRIV	ORA_EGP_PRODUCT_MODEL_ADMINISTRATION_DUTY	Product Model Administration	Administers tasks required to setup Oracle Fusion Product Model. Duty role includes all setup duty roles available for this product.
EGP_MANAGE_ITEM_CATALOG_PRIV	ORA_POS_SUPPLIER_SALES_REPRESENTATIVE_JOB	Supplier Sales Representative	Manages agreements and deliverables for the supplier company. Primary tasks include acknowledging or requesting changes to agreements in addition to adding catalog line items with customer specific pricing and terms. Updates contract deliverables that are assigned to the supplier party and updates progress on contract deliverables for which the supplier is responsible.

Duty Roles to Duty or Job Roles Mapping

Duty Role Code	Granted to Duty or Job Role Code	Granted to Duty or Job Role Name	Granted To Duty or Job Role Description
ORA_PO_PROCUREMENT_APPLICATION_ADMIN_JOB	ORA_CMK_B2B_MESG_ADMIN_DUTY	B2B Messaging Administration	Manages collaboration messaging setup and administration tasks.
ORA_PO_PROCUREMENT_APPLICATION_ADMIN_JOB	ORA_PO_COMPLIANCE_CHECKLIST_ADMINISTRATION_DUTY	Compliance Checklist Administration	Perform compliance checklist administration tasks including managing questions, sections, and templates.
ORA_PO_PROCUREMENT_APPLICATION_ADMIN_JOB	ORA_OKC_CONTRACT_SETUP_DUTY	Contract Setup	Contract Setup
ORA_EGP_PRODUCT_MODEL_ADMINISTRATION_DUTY	ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY	FSCM Load Interface Administration	Manages load interface file for import
ORA_POS_SUPPLIER_SALES_REPRESENTATIVE_JOB	ORA_OKC_SUPPLIER_CONTRACT_MANAGE_DUTY	Manage Supplier Contracts in Supplier Portal	Manage supplier contracts in the Supplier Portal.
ORA_POS_SUPPLIER_DEMAND_PLANNER_JOB	ORA_OKC_SUPPLIER_CONTRACT_MANAGE_DUTY	Manage Supplier Contracts in Supplier Portal	Manage supplier contracts in the Supplier Portal.
ORA_POS_SUPPLIER_ACCOUNTS_RECEIVABLE_SPECIALIST_JOB	ORA_OKC_SUPPLIER_CONTRACT_MANAGE_DUTY	Manage Supplier Contracts in Supplier Portal	Manage supplier contracts in the Supplier Portal.
ORA_PO_PROCUREMENT_APPLICATION_ADMIN_JOB	ORA_PER_MANAGE_USER_AND_ROLES_DUTY_FSCM	Manage Users	Creates and updates users and assigns roles to users.
ORA_PO_PROCUREMENT_APPLICATION_ADMIN_JOB	ORA_AP_PAYABLES_INVOICE_IMPORT_SUBMISSION_DUTY	Payables Invoice Import Submission	Submits Oracle Fusion Payables invoice import program.
ORA_POS_SUPPLIER_ACCOUNTS_RECEIVABLE_SPECIALIST_JOB	ORA_IBY_PAYEE_BANK_ACCOUNT_MANAGEMENT_DUTY	Payee Bank Account Management	Manages supplier bank accounts and other payment details.
ORA_POS_SUPPLIER_SALES_REPRESENTATIVE_JOB	ORA_PO_BPA_CPA_CHG_AS_SUPPLIER_DUTY	Purchase Agreement Management as Supplier	Perform purchase agreement change management tasks as a supplier.
ORA_POS_SUPPLIER_SALES_REPRESENTATIVE_JOB	ORA_PO_PO_CHGS_AS_SUPPLIER_DUTY	Purchase Order Management as Supplier	Perform purchase order change management tasks as a supplier.
ORA_PO_PROCUREMENT_APPLICATION_ADMIN_JOB	ORA_PO_SETUP_DUTY	Purchasing Administration	Perform setup tasks including defining procurement configuration, procurement agents, approved supplier list statuses, document styles, change order templates, line types, carriers, UN numbers, and hazard classes.
ORA_PO_PROCUREMENT_APPLICATION_ADMIN_JOB	ORA_PO_REVIEW_PRC_APPROVAL_TRANSACTIONS	Review Procurement Transactions as Administrator	Allows viewing of basic information for Procurement approval and electronic communication transactions by an administrator.
ORA_POS_SUPPLIER_ACCOUNTS_RECEIVABLE_SPECIALIST_JOB	ORA_AP_SELF_SERVICE_PAYABLES_INVOICE_ENTRY_DUTY	Self Service Payables Invoice Entry	Enters invoices using self-service functionality.
ORA_PO_PROCUREMENT_APPLICATION_ADMIN_JOB	ORA_PON_SOURCING_ADMINISTRATION_DUTY	Sourcing Administration	Set up negotiation templates, negotiation styles, attribute lists, cost factor lists, and other administrative operations.
ORA_POS_SUPPLIER_SALES_REPRESENTATIVE_JOB	ORA_PON_SUPPLIER_BIDDER_ABSTRACT	Supplier Bidder	Sales representative from a potential supplier responsible for responding to requests for quote, requests for proposal, requests for information and reverse auctions.
ORA_POS_SUPPLIER_SALES_REPRESENTATIVE_JOB	ORA_CJM_SUPPLIER_CHANNEL_IN_PORTAL_DUTY	Supplier Channel Management in Supplier Portal	Manages supplier programs from the supplier portal.
ORA_POS_SUPPLIER_SALES_REPRESENTATIVE_JOB	ORA_CJM_SUPPLIER_CHANNEL_IN_PORTAL_VIEW_DUTY	Supplier Channel Viewing in Supplier Portal	Views supplier programs from the supplier portal.
ORA_POS_SUPPLIER_ACCOUNTS_RECEIVABLE_SPECIALIST_JOB	ORA_POZ_PROFILE_INQUIRY_AS_SUPPLIER_DUTY	Supplier Profile Inquiry as Supplier	Views non-bank account related supplier profile information as a supplier.
ORA_PO_PROCUREMENT_APPLICATION_ADMIN_JOB	ORA_POQ_SUPPLIER_QUALIFICATION_ADMINISTRATION_DUTY	Supplier Qualification Administration	An enterprise user can set up supplier qualification questions, areas, and models.
ORA_POS_SUPPLIER_SALES_REPRESENTATIVE_JOB	ORA_POQ_SUPP_QUAL_QUESTIONNAIRE_RESPONSE_MANAGEMENT_AS_SUPPLIER_DUTY	Supplier Qualification Questionnaire Response Management as Supplier	A supplier user can respond to requests for qualification information.