Total Pageviews

March 9, 2016

3/09/2016 11:37:00 PM
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
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


 
Related Posts Plugin for WordPress, Blogger...