The purpose of this deliverable is to document the functional requirements for the Oracle Item Category Conversion between flat file and oracle apps.
The Item Category Assignment Open Interface runs whenever pre-defined categories assigned to required item defined in inventory.
This import will populate related base tables after necessary validations. After successful import data to base tables then the records are deleted from the interface table. This interface can runs daily or once whenever a flat file is available for uploading the data from external system into the target application.
If the item is not defined in Inventory first the item import report is to be run and then assigned to categories.Using INV_ITEM_CATEGORY_PUB interface categories are created for existing Flex field structure.
If the Item Interface successfully processes a row in the item interface table or the revision interface table, the program sets the PROCESS_FLAG to 7 (Import succeeded) for the row.
If the Item Interface cannot insert a row into the production table, the PROCESS_FLAG column for the failed row is set to 4 (Import failed).
If a row in the interface table fails validation, the PROCESS_FLAG column is set to 3 (validation failed).
The PROCESS_FLAG column is set to
1 (for Ready/Pending ) and
2 for Assign Complete.
A row is inserted into the MTL_INTERFACE_ERRORS table for all failed rows. You can review and update any failed rows in each interface table using custom reports and programs.
Passing Parameters:
The run time parameters for the Item Category Assignment Open Interface import are
The Record set id , Upload Processed Records, Delete Processed Records. The recors set id is used to import a group of record sets having same record set.
User Procedures
Create categories using INV_ITEM_CATEGORY_PUB which is used by a user created stored procedure.
After running that following steps to be followed for importing items to those categories.
In ie,a create a temporary staging table as per the data in the data file
-Run the concurrent program by submitting the request Import data from flat file to staging table
-In Inventory responsibility order to import data from flat file you must perform the following steps:
-Creating staging table run import then it prompted for report parameters.
These are run time options for the Item Interface
Navigation Path:
(Items->import-> Item Category Assignment Open Interface).
If needed first run import item interface for creating new items.
-Enter the required parameter for running the program
-See the log file for error if request fails
-After successful of import program then test where the data hits the base table or not by navigate through corresponding forms of inventory
Tables and column information
The Item Category Assignment Open Interface runs whenever pre-defined categories assigned to required item defined in inventory.
This import will populate related base tables after necessary validations. After successful import data to base tables then the records are deleted from the interface table. This interface can runs daily or once whenever a flat file is available for uploading the data from external system into the target application.
If the item is not defined in Inventory first the item import report is to be run and then assigned to categories.Using INV_ITEM_CATEGORY_PUB interface categories are created for existing Flex field structure.
If the Item Interface successfully processes a row in the item interface table or the revision interface table, the program sets the PROCESS_FLAG to 7 (Import succeeded) for the row.
If the Item Interface cannot insert a row into the production table, the PROCESS_FLAG column for the failed row is set to 4 (Import failed).
If a row in the interface table fails validation, the PROCESS_FLAG column is set to 3 (validation failed).
The PROCESS_FLAG column is set to
1 (for Ready/Pending ) and
2 for Assign Complete.
A row is inserted into the MTL_INTERFACE_ERRORS table for all failed rows. You can review and update any failed rows in each interface table using custom reports and programs.
Passing Parameters:
The run time parameters for the Item Category Assignment Open Interface import are
The Record set id , Upload Processed Records, Delete Processed Records. The recors set id is used to import a group of record sets having same record set.
User Procedures
Create categories using INV_ITEM_CATEGORY_PUB which is used by a user created stored procedure.
After running that following steps to be followed for importing items to those categories.
In ie,a create a temporary staging table as per the data in the data file
-Run the concurrent program by submitting the request Import data from flat file to staging table
-In Inventory responsibility order to import data from flat file you must perform the following steps:
-Creating staging table run import then it prompted for report parameters.
These are run time options for the Item Interface
Navigation Path:
(Items->import-> Item Category Assignment Open Interface).
If needed first run import item interface for creating new items.
-Enter the required parameter for running the program
-See the log file for error if request fails
-After successful of import program then test where the data hits the base table or not by navigate through corresponding forms of inventory
Tables and column information
Source Table
|
Source column
|
Table Name
|
Field Name
|
MTL_ITEM_CATEGORIES
_INTERFACE
|
MTL_ITEM
_CATEGORIES
|
||
INVENTORY_ITEM_ID
|
INVENTORY_ITEM_ID
|
||
CATEGORY_SET_ID
|
CATEGORY_SET_ID
|
||
CATEGORY_ID
|
CATEGORY_ID
|
||
LAST_UPDATE_DATE
|
LAST_UPDATE_DATE
|
||
LAST_UPDATED_BY
|
LAST_UPDATED_BY
|
||
CREATION_DATE
|
CREATION_DATE
|
||
CREATED_BY
|
CREATED_BY
|
||
LAST_UPDATE_LOGIN
|
LAST_UPDATE_LOGIN
|
||
REQUEST_ID
|
REQUEST_ID
|
||
PROGRAM_APPLICATION_ID
|
PROGRAM_APPLICATION_ID
|
||
PROGRAM-ID
|
PROGRAM-ID
|
||
PROGRAM_UPDATE_DATE
|
PROGRAM_UPDATE_DATE
|
||
ORGANIZATION_ID
|
ORGANIZATION_ID
|
||
TRANSACTION_ID
|
TRANSACTION_ID
|
||
PROCESS_FLAG
|
PROCESS_FLAG
|
||
CATEGORY_SET_NAME
|
CATEGORY_SET_NAME
|
||
CATEGORY_NAME
|
CATEGORY_NAME
|
||
ORGANIZATION_CODE
|
ORGANIZATION_CODE
|
||
ITEM_NUMBER
|
ITEM_NUMBER
|
||
TRANSACTION_TYPE
|
TRANSACTION_TYPE
|
||
SET_PROCESS_ID
|
SET_PROCESS_ID
|
