Enterprise Administration > Implementing Windchill ESI > Implementing Windchill ESI in an ORACLE Applications Environment > Oracle Applications API and OIT Structures > Create and Change Part
  
Create and Change Part
* 
Windchill parts are referred to as Items in Oracle Applications.
The structure table below shows all of the fields that are required to create and change an Item Master record within Oracle Applications. The interface table, field name, and field description are given in the respective columns. If the information is resident within Windchill, the Windchill attribute name is given. This table also characterizes the handling of each field by theWindchill ESI business logic.
Open Item Interface
The Open Item Interface will be used to create/change all item and revision data in Oracle.
The data required for the following scenarios is defined in the Scenario column.
Column A: Create Part
Column B: Change Part
Column C: Create Unit controlled Part
Windchill Attribute Name
Interface Table
Interface Field
Field Description
Value If Default
Source
Transform
A
B
C
TransactionID
N/A (TIBCO field)
TIBCO_KEY
Unique id
N/A
Windchill and date/time
Concat Windchill Transaction ID with date/time
X
X
X
(Part) Number
MTL_SYSTEM _ITEMS_INTER FACE
ITEM_NUMBER
Item number
N/A
Windchill
N/A
X
X
X
partType
MTL_SYSTEM _ITEMS_INTER FACE
ITEM_TYPE
"SA"
"P"
N/A
Windchill
Sub-string
X
X
defaultUnit
MTL_SYSTEM _ITEMS_INTER FACE
PRIMARY_UOM _CODE
Base Unit Of Measure "EA", "KG" "L", "M", "AN"
N/A
Windchill
Cross Reference
X
X
Distribution Target
MTL_SYSTEM _ITEMS_INTER FACE
ORGANIZA TION_CODE
Organization
N/A
Windchill
Cross Reference
X
X
X
Source
MTL_SYSTEM _ITEMS_INTER FACE
PLANNING_ MAKE_BUY_ CODE
Make/Buy flag"1","2"
N/A
Windchill
X
X
Name
MTL_SYSTEM _ITEMS_INTER FACE
DESCRIPTION
Item Description
N/A
Windchill
Cross Reference
X
X
N/A
MTL_SYSTEM _ITEMS_INTER FACE
TEMPLATE_ID
Template for part creation based on part type
N/A
Windchill
Cross Reference (on part type)
X
N/A
MTL_SYSTEM _ITEMS_INTER FACE
TEMPLATE_ NAME
Template for part creation based on part type
N/A
Windchill
Cross Reference (on part type)
X
N/A
MTL_SYSTEM _ITEMS_INTER FACE
TRANSACTION _TYPE
Transaction Type
'CREATE'
Default
N/A
X
X
N/A
MTL_SYSTEM _ITEMS_INTER FACE
TRANSACTION _TYPE
Transaction Type
'UPDATE'
Default
N/A
X
X
N/A
MTL_SYSTEM _ITEMS_INTER FACE
PROCESS_FLAG
Row status
'1' (Pending)
Default
N/A
X
X
X
N/A
MTL_SYSTEM _ITEMS_INTER FACE
SUMMARY_ FLAG
Summary Flag
'N'
Default
N/A
X
X
N/A
MTL_SYSTEM _ITEMS_INTER FACE
SET_PROCESS_ ID
This value is used to tell Oracle which values to process in the Interface Table
'1'
Default
X
X
X
N/A
MTL_SYSTEM _ITEMS_INTER FACE
Effectivity_ Control
Date/Unit
1/2
1
Windchill data and ESIORA Lookups. properties
2
X
N/A
MTL_SYSTEM _ITEMS_INTER FACE
SERIAL_ NUMBER_ CONTROL_ CODE
2 for Predefined, 1 for No control, and 5 for At receipt
1
Windchill data and ESIORA Lookups. properties
Cross Reference
X
N/A
MTL_SYSTEM _ITEMS_INTER FACE
SERIAL_AUTO_ SERIAL_ NUMBER
Serial number prefix
N/A
Windchill data and ESIORA Lookups. properties
Cross Reference
X
N/A
MTL_SYSTEM _ITEMS_INTER FACE
AUTO_SERIAL_ ALPHA_ PREFIX Start Serial Number
Start serial number
N/A
Windchill data and ESIORA Lookups. properties
Cross Reference
X
Open Item Interface - Revision
This program will create a new revision level for the item created/changed with the Open Item Interface. This program is invoked the same call as the Open Item Interface. The revision level creation will be tracked with a change number defined from Windchill.
The data required for the following scenarios is defined in the Scenario column.
A. Create Part No Change Numbers
B. Create Part with Change Numbers
C. Update Part with Change Number
D. Update Part No Change Numbers
Only changes to attributes will be done through the Part Change process.
Windchill Attribute Name
Interface Table
Interface Field
Field Description
Value If Default
Source
Transform
A
B
C
D
TransactionID
N/A (TIBCO field)
TIBCO_KEY
Unique id
N/A
Windchill and date/time
Concatenate Windchill Transaction ID with date/time
X
X
X
Version
MTL_ITEM_ REVISIONS_ INTERFACE
REVISION
Revision
N/A
Windchill
N/A
X
X
X
Distribution Target
MTL_ITEM_ REVISIONS_ INTERFACE
ORGANIZA TION_ CODE
Organization
N/A
Windchill
Substring
X
X
X
(Part) Number
MTL_ITEM_ REVISIONS_ INTERFACE
ITEM_ NUMBER
Item number
N/A
Windchill
N/A
X
X
X
N/A
MTL_ITEM_ REVISIONS_ INTERFACE
SET_ PROCESS_ ID
This value is used to tell Oracle which values to process in the Interface Table
'1'
Default
X
X
X
N/A
MTL_ITEM_ REVISIONS_ INTERFACE
PROCESS_ FLAG
Row status
'1' (Pending)
Default
N/A
X
X
X
N/A
MTL_ SYSTEM _ITEMS_ INTERFACE
TRANS ACTION_ TYPE
Transaction Type
'CREATE'*
Default
N/A
X
X
X
* Revisions are only created. They are never changed - ESI has a Business Rule that states that users need to revise before releasing parts to Oracle.
* 
When creating/updating parts with Change Orders, the revision change will be done through the ECO process.