item category assignment in oracle apps

eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

TABLE: INV.MTL_ITEM_CATEGORIES

Object details.

MTL_ITEM_CATEGORIES stores inventory item assignments to categories within a category set. For each category assignment, this table stores the item, the category set, and the category. Items always may be assigned to multiple category sets. However, depending on the Multiple Assignments Allowed attribute value in a given category set definition, an item can be assigned to either many or only one category in that category set. . This table may be populated through the Master Items and Organization Items windows. It can also be populated by performing item assignments when a category set is defined. It is also populated when an item is transferred from engineering to manufacturing. The table may also be populated through the Item Category Open Interface.

Storage Details

Cut, paste (and edit) the following text to query this object:

Dependencies

[top of page]

Assigning Items to Categories

Share this:, leave a reply, leave a reply cancel reply, recent comments.

• Guru on R12 Supplier Contact creation API
• himanshu dawra on Oracle E-Business Suite 12 Free Vision Instance
• Saqib ali Ali Khan on FRM-92050 Failed to Connect to Server
• Swapnil Dandgvhal on Inventory Organization and corresponding Operating Unit, Ledger and Legal Entity
• Sakshi Dhokale on HZ tables in Oracle Receivables

Latest Posts

• R12 – How to Handle NULL for :$FLEX$.VALUE_SET_NAME In Oracle ERP August 25, 2023 - 1:20 pm
• R12 – How to Delete Oracle AR Transactions March 22, 2019 - 8:37 pm
• How to Define Custom Key Flexfield (KFF) in R12 January 19, 2018 - 5:43 pm
• AutoLock Box Concepts In R12 November 10, 2017 - 8:30 am
• R12 – java.sql.SQLException: Invalid column type in OAF September 15, 2017 - 9:39 am

Ads Blocker Detected!!!

This site uses cookies and other tracking technologies to assist with navigation and your ability to provide feedback, analyse your use of our services, and provide content from third parties. By continuing to browse the site, you are agreeing to our use of cookies.

Cookie and Privacy Settings

We may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website.

Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.

These cookies are strictly necessary to provide you with services available through our website and to use some of its features.

Because these cookies are strictly necessary to deliver the website, refusing them will have impact how our site functions. You always can block or delete cookies by changing your browser settings and force blocking all cookies on this website. But this will always prompt you to accept/refuse cookies when revisiting our site.

We fully respect if you want to refuse cookies but to avoid asking you again and again kindly allow us to store a cookie for that. You are free to opt out any time or opt in for other cookies to get a better experience. If you refuse cookies we will remove all set cookies in our domain.

We provide you with a list of stored cookies on your computer in our domain so you can check what we stored. Due to security reasons we are not able to show or modify cookies from other domains. You can check these in your browser security settings.

These cookies collect information that is used either in aggregate form to help us understand how our website is being used or how effective our marketing campaigns are, or to help us customize our website and application for you in order to enhance your experience.

If you do not want that we track your visit to our site you can disable tracking in your browser here:

We also use different external services like Google Webfonts, Google Maps, and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.

Google Webfont Settings:

Google Map Settings:

Google reCaptcha Settings:

Vimeo and Youtube video embeds:

The following cookies are also needed - You can choose if you want to allow them:

You can read about our cookies and privacy settings in detail on our Privacy Policy Page.

• Site-Wide Activity

by oracleguru

Item Category Assignment Open Interface

NAME: Item Category Assignment Open Interface SHORT CODE: INV_ITEM_CAT_ASSIGN_OI MODULE: Oracle Inventory

Description: Import item category assignments from the Open Interface table Navigation: Oracle Inventory Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_rec_set_id : Record set to be processed
• p_upload_rec_flag : Upload processed records
• p_delete_rec_flag : Delete processed records

Tags: INV_ITEM_CAT_ASSIGN_OI  

Leave a reply Cancel reply

Your email address will not be published. Required fields are marked *

All copy rights reserved by oracleappscommunity.com

Oracle Apps Knowledge Sharing

Meant for sharing our knowledge related to Oracle E-Business Suite

• TECHNICAL TUTORIALS
• USEFUL LINKS
• ARTICLE INDEX
• VIDEO INDEX

Thursday, June 3, 2010

Item category assignment open interface in r12.

• The user needs to populate the following mandatory columns in item categories interface table: Either INVENTORY_ITEM_ID or ITEM_NUMBER. When item and category are being imported together the user can only specify the ITEM_NUMBER since the import process will generate INVENTORY_ITEM_ID.
• Either ORGANIZATION_ID or ORGANIZATION_CODE or both
• The TRANSACTION_TYPE column should be 'CREATE' or 'DELETE' or ‘UPDATE’
• Either CATEGORY_SET_ID or CATEGORY_SET_NAME or both.
• Either CATEGORY_ID or CATEGORY_NAME or both
• PROCESS_FLAG column as 1. 
• Populate the SET_PROCESS_ID column.
• If TRANSACTION_TYPE = ‘UPDATE’ then we need to populate OLD_CATEGORY_ID or OLD_CATEGORY_NAME column also.

Do you think this Article is useful?

3 Responses to “Item category assignment open interface in R12”

just want to know what this item category interface does when we provide transaction_type as update

FYI - a Typo in the above: 'INSERT' should be 'CREATE'

Post a Comment

Stay connected.

Popular Posts

• Query to get basic AP Invoice and Payment information from Oracle Apps R12
• Query to fetch Purchase Receipt and its related Purchase order, Vendor details in Oracle Apps R12 (RCV_TRANSACTIONS, RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES)
• Query to Fetch Employee Details in Oracle Apps R12 (PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_JOBS, PER_ALL_POSITIONS, PER_PHONES)
• Query to get active Customer and their Profile Details (HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUSTOMER_PROFILES, HZ_CUST_PROFILE_AMTS)
• WSH_DELIVERY_DETAILS.RELEASED_STATUS ( Pick Release Status)
• Query To Fetch Customer Account/Site Contact Details in R12
• API to find AP INVOICE Status (AP_INVOICES_PKG.GET_APPROVAL_STATUS)
• Query to fetch Purchase Requisition, BPA, Purchase Order and Vendor Details in Oracle Apps R12 (PO_REQUISITION_HEADERS_ALL, PO_HEADERS_ALL)
• Query to fetch Legal Entity, Business group details in Oracle Apps R12 - per_business_groups,xle_firstparty_information_v
• How to find Order types in R12 (Script for Order types)

Blog Archive

shareoracleapps.com

Site Stats (Last 30 Days)

• REST API for Oracle Fusion Cloud SCM
• Product Lifecycle Management
• Item Catalog Assignments

Get one assignment

/fscmRestApi/resources/11.13.18.05/itemCategoryAssignments/{itemCategoryAssignmentsUniqID}

• itemCategoryAssignmentsUniqID(required): string This is the hash key of the attributes which make up the composite key for the Item Catalog Assignments resource and used to uniquely identify an instance of Item Catalog Assignments. The client should not generate the hash key value. Instead, the client should query on the Item Catalog Assignments collection resource in order to navigate to a specific instance of Item Catalog Assignments to get the hash key.
• dependency: string This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2 Format: <attr1>=<val1>,<attr2>=<value2>
• expand: string When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
• fields: string This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered. Format: ?fields=Attribute1,Attribute2 Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2
• links: string This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation> Example: self,canonical
• onlyData: boolean The resource item payload will be filtered in order to contain only data (no links section, for example).
• 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.

There's no request body for this operation.

• application/json

Default Response

• CatalogCode: string Read Only: true Maximum Length: 30 Abbreviation that identifies the catalog.
• CatalogId: integer (int64) Title: Catalog Read Only: true Value that uniquely identifies the catalog.
• CatalogName: string Read Only: true Maximum Length: 30 Name of the catalog. Review and update the value for this attribute using the Items work area, and the Manage Catalogs task.
• CategoryCode: string Read Only: true Maximum Length: 820 Abbreviation that identifies the category.
• CategoryId: integer (int64) Title: Category Read Only: true Value that uniquely identifies the category.
• CategoryName: string Read Only: true Maximum Length: 250 Name of the category. Review and update the value for this attribute using the Items work area, and the Manage Catalogs task.
• EndDate: string (date) Read Only: true Date when the item category assignment becomes inactive.
• Item: string Read Only: true Maximum Length: 1000 Value that uniquely identifies the part, item, product, or service.
• ItemClassId: integer (int64) Read Only: true Value that uniquely identifies the item class.
• ItemClassName: string Title: Item Class Read Only: true Maximum Length: 250 Name of the item class. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Classes task.
• ItemDescription: string Read Only: true Maximum Length: 240 Description of the item.
• ItemId: integer (int64) Read Only: true Value that uniquely identifies the item.
• links: array Links Title: Links The link relations associated with the resource instance.
• OrganizationCode: string Read Only: true Maximum Length: 18 Abbreviation that identifies the organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
• OrganizationId: integer (int64) Read Only: true Value that uniquely identifies the organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
• StartDate: string (date) Read Only: true Date when the item category assignment becomes active.
• Array of: object link
• href: string Title: hyperlink reference The URI to the related resource.
• kind: string Title: kind Allowed Values: [ "collection", "item", "describe", "other" ] The kind of the related resource.
• name: string Title: name The name of the link to the related resource.
• properties: object properties
• rel: string Title: relation Allowed Values: [ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ] The name of the relation to the resource instance. Example: self.
• changeIndicator: string Change indicator or the ETag value of the resource instance.

Oracle Application's Blog

The purpose of this blog , is to do Knowledge sharing with my Followers through my own Experiences. Contact us for Oracle Applications Job Support , Project Support and any other freelancing work.

• Fusion E-Books
• Fusion Technical
• Fusion Financial

Thursday 19 December 2019

Query to find item category in oracle apps r12.

Most Important Table used by Query to find item Category in oracle apps r12

Detail sql query to find item category in oracle apps r12, 0 comments:, post a comment, contact us for any collaboration, project support & on job support work.

Know More About Us

• Products & Offerings

Learn Fusion Financials' (Online Book)

Oracle Fusion Self Paced Trainings in Discounted Prices

Buy Oracle Cloud Instance Access (Click to Know More)

Oracle Fusion/EBS Interview's Question Answer Series

• Top 33 Oracle Fusion Order Management Interview Questions
• TOP 31 Oracle Fusion SCM Cloud Interview Questions
• TOP 21 Oracle Fusion HCM Interview Questions
• Complete Tax Setups in Oracle Fusion
• Top 50 oracle reports interview questions
• 33 Most Important Oracle Fusion fixed assets interview questions
• TOP 33 Most Important Oracle Apps Technical Interview Questions
• 25 Most Important Oracle receivable interview questions
• 21 Most Important Oracle r12 Payables Interview Questions
• TOP 20 general ledger interview questions in oracle apps r12
• TOP 23 Most Important Oracle Fusion Interview Questions
• TOP 23 Most Important oaf interview questions

Online Oracle Courses (Free of Cost)

• Learn Tax Implementation in Oracle Fusion
• Learn P2P Cycle in Oracle Fusion
• Learn Oracle Reports XML Tutorial
• Learn Oracle Fusion Custom Roles Tutorial
• Learn Oracle Fusion Technical Online
• Learn Oracle Fusion/cloud Financials Online
• Learn Oracle Cloud BPM Online
• Learn Complete OAF Step by Step Online
• Learn Oracle Workflow Builder Online

Online Fusion Application Composer/Customization Book

Oracle Fusion Technical Book

Oracle Fusion Web Services(REST& SOAP API's) / Integration Book

Most Viewed Posts