Scribd
Upload
799 views

Category Assignment Interface

This document provides instructions for using an open interface to assign item categories in Oracle Inventory. It outlines the mandatory columns that must be populated in the interface table, including item ID, category ID, and transaction type. It also describes parameters for processing the records, including a record set ID and options for uploading and deleting processed records. Sample SQL scripts are provided for inserting data into the interface tables for create, delete, and update transactions.

Uploaded by

mohammad_ayub_3
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
799 views

Category Assignment Interface

This document provides instructions for using an open interface to assign item categories in Oracle Inventory. It outlines the mandatory columns that must be populated in the interface table, including item ID, category ID, and transaction type. It also describes parameters for processing the records, including a record set ID and options for uploading and deleting processed records. Sample SQL scripts are provided for inserting data into the interface tables for create, delete, and update transactions.

Uploaded by

mohammad_ayub_3
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

Program: Item category assignment open interface Interface Table: MTL_ITEM_CATEGORIES_INTERFACE

Interface Error Table: MTL_INTERFACE_ERRORS Base Tables: Mandatory Columns: The user needs to populate the following mandatory columns in item categories in terface table: Either INVENTORY_ITEM_ID or ITEM_NUMBER. When item and category are being import ed together the user can only specify the ITEM_NUMBER since the import process w ill 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_CATEG ORY_NAME column also. Parameters: Record Set Id Enter a set id number for the set of records in the interface table that you wan t to process. The program picks up the records having that id in the SET_PROCESS _ID column. This column value cannot be NULL. In order to avoid set id value con flicts between record sets imported by different users, you should use the seque nce MTL_SYSTEM_ITEMS_INTF_SETS_S when populating the SET_PROCESS_ID column. Upload Processed Records Yes --> All qualifying item category assignment records in the interface table a re inserted into Oracle Inventory. No --> Do not insert item category assignments into Oracle Inventory. Use this o ption if you want to validate items without any processing. Delete Processed Records Yes --> Delete successfully processed item category assignment records from the item categories interface table. No --> Leave all records in the item categories interface table. Program Navigation: MTL_ITEM_CATEGORIES

Script for Inserting Data into Interface Tables: INSERT INTO MTL_ITEM_CATEGORIES_INTERFACE ( INVENTORY_ITEM_ID , CATEGORY_SET_ID , CATEGORY_ID , PROCESS_FLAG ,

ORGANIZATION_ID , SET_PROCESS_ID , TRANSACTION_TYPE ) VALUES ( 26092 1 9233 1 103 1 'DELETE' );

, , , , , ,

INSERT INTO MTL_ITEM_CATEGORIES_INTERFACE ( INVENTORY_ITEM_ID , CATEGORY_SET_ID , CATEGORY_ID , PROCESS_FLAG , ORGANIZATION_ID , SET_PROCESS_ID , TRANSACTION_TYPE ) VALUES ( 26092 , 1 , 9233 , 1 , 103 , 1 , 'INSERT' ); INSERT INTO MTL_ITEM_CATEGORIES_INTERFACE ( INVENTORY_ITEM_ID , CATEGORY_SET_ID , OLD_CATEGORY_ID , CATEGORY_ID , PROCESS_FLAG , ORGANIZATION_ID , SET_PROCESS_ID , TRANSACTION_TYPE ) VALUES ( 26092 , 1 , 4567 , 9233 , 1 , 103 , 1 , 'UPDATE' );

You might also like