Enterprise Administration > Implementing Windchill ESI > Implementing Windchill ESI in an ORACLE Applications Environment > Oracle Applications API and OIT Structures > Create and Change Part > Open Item Interface - Revision
  
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.