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.
|