Enterprise Administration > Implementing Windchill ESI > Implementing Windchill ESI in an ORACLE Applications Environment > Oracle Applications API and OIT Structures > Create CN
  
Create CN
The API structure table below shows all of the API fields that are required to create an Engineering Change Order (ECO) within Oracle via the ECO API. The API segment, field name, and field description are provided 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.
API Name = EnggChangeOrder
This API will be used to create an ECO in Oracle. The API is characterized to create a CN that is valid to create or change BOMs and Object Revisions.
The data required for the following scenario is defined.
Column A: Create ECO - Create or modify Part Revision.
Column B: Create ECO - Create or modify BOM.
Column C: Create ECO - Create or modify BOM / Ref Des.
Column D: Create ECO - Create or modify BOM / Substitutes.
Column E.: Create ECO - Create or modify BOM / Ref Des / Substitutes.
Column F. Create ECO - Create or modify BOM/Assign unit effectivity.
Column G: Create ECO - Create or modify Routing Revision.
Column H: Create ECO - Create or modify Routings/Operations/Resources.
Windchill Attribute Name
API Segment/API Structure
API Field
Value If Default
Source
Transform
A
B
C
D
E
F
G
H
Transaction ID
ECO Headers/Tib_Int _eco_engr _change
TIBCO_KEY
N/A
Windchill/ TIBCO
Concatenate Transaction ID with date and time
X
X
X
X
X
X
X
X
Number (Change Number)
ECO Headers/ Tib_Int_ eco_engr _change
ECO_NAME
N/A
X
X
X
X
X
X
X
X
Distribution Target
ECO Headers/ Tib_Int_ eco_engr _change
ORGANIZATION_CODE
N/A
Windchill
Substring
X
X
X
X
X
X
X
X
Action Flag
ECO Headers/ Tib_Int_ eco_engr _change
TRANSACTION_TYPE
“Create”
Windchill/ TIBCO
N/A
X
X
X
X
X
X
X
X
BOM Usage
ECO Headers/ Tib_Int_ eco_engr _change
CHANGE_ TYPE_CODE
Default
Windchill
X
X
X
X
X
X
X
X
N/A
ECO Headers/ Tib_Int_ eco_engr _change
APPROVAL _STATUS_ NAME
Approved
X
X
X
X
X
X
X
X
Description (Change Number)
ECO Headers/ Tib_Int_ eco_engr _change
DESCRIPTION
N/A
X
X
X
X
X
X
X
X
Transaction ID
Revised Items/ Ti b_Int_E CO_Revi se_Itm
TIBCO_KEY
N/A
Windchill/ TIBCO
Concat Transaction on ID with date and time
X
X
X
X
X
X
X
X
Number (Change Number)
Revised Items/ Tib_Int_ ECO_Revise_Itm
ECO_NAME
N/A
X
X
X
X
X
X
X
X
Distribution Target
Revised Items/ Tib_Int_ ECO_Revise_Itm
ORGANIZATION_CODE
N/A
Windchill
Substring
X
X
X
X
X
X
X
X
(Assembly) Part Number
Revised Items/ Tib_Int_ ECO_Revise_Itm
REVISED_ ITEM_ NAME
N/A
Windchill
N/A
X
X
X
X
X
X
X
X
Version
Revised Items/ Tib_Int_ ECO_Revise_Itm
NEW_ROUTING _REVISION
N/A
Windchill
Front Pad with --
X
X
X
X
X
X
X
X
BOM Alternate
Revised Items/ Tib_Int_ ECO_Revise_Itm
Alternate_BOM_CODE
N/A
Windchill
N/A
x
x
x
x
x
x
x
x
Start Effectivity Date
Revised Items/ Tib_Int_ ECO_Revise_Itm
START_ EFFECTIVE_DATE
TIBCO's system date/time
Windchill / TIBCO
Date format
X
X
X
X
X
X
X
X
Action Flag
Revised Items/ Tib_Int_ ECO_Revise_Itm
TRANSACTION_ TYPE
“CREATE
“ Windchill
N/A
X
X
X
X
X
X
X
X
Transaction ID
Revised Operation/Tib_Int _ECO_R ev_Operation
TIBCO_KEY
N/A
Windchill/ TIBCO
Concat Transactionon ID with date and time
X
X
X
X
X
X
Number (Change Number)
Revised Operation/ Tib_Int_ ECO_Re v_Operation
ECO_NAME
N/A
X
X
X
X
X
X
Distribution Target
Revised Operation/ Tib_Int_ ECO_Re v_Operation
ORGANIZATION_CODE
N/A
Windchill
Substring
X
X
X
X
X
X
(Assembly) Part Number
Revised Operation/ Tib_Int_ ECO_Re v_Operation
REVISED_ ITEM_NAME
N/A
Windchill
N/A
X
X
X
X
X
X
Version
Revised Operation/ Tib_Int_ ECO_Re v_Operation
NEW_ROUTING _REVISION
N/A
Windchill
Front Pad with --
X
X
X
X
X
X
Start Effectivity Date
Revised Operation/ Tib_Int_ ECO_Re v_Operation
START_ EFFECTIVE_ DATE
TIBCO's system date/time
Windchill/ TIBCO
Date format
X
X
X
X
X
X
Start Effectivity Date
Revised Operation/ Tib_Int_ ECO_Re v_Operation
OLD_ST ART_EFFECTIV E_DATE '3
TIBCO's system date/time
Windchill/ TIBCO
Date format
X
X
X
X
X
X
Action Flag
Revised Operation/ Tib_Int_ ECO_Re v_Operation
TRANSACTION_TYPE
” CREATE”
Windchill
N/A
X
X
X
X
X
X
Action Flag
Revised Operation/ Tib_Int_ ECO_Re v_Operation
ACD_TYPE
'1' - Add '2' - Change '3' - Disable
X
X
X
X
X
X
Operation Label
Revised Operation/ Tib_Int_ ECO_Re v_Operation
OPERATION_SEQUENCE_NUMBER
N/A
Windchill
N/A
X
X
X
X
X
X
New Operation Label
Revised Operation/ Tib_Int_ ECO_Re v_Operation
NEW_OPERATION_SEQUENCE_ NUMBE R
N/A
Windchill
N/A
X
X
X
X
X
X
Old Operation Label
Revised Operation/ Tib_Int_ ECO_Re v_Operation
OLD_OPERATION_SEQUENCE_NUMBER
N/A
Windchill
N/A
X
X
X
X
X
Operation Workcenter Link- Department
Revised Operation/ Tib_Int_ ECO_Re v_Operation
DEPARTMENT _CODE
N/A
Windchill
N/A
X
X
X
X
X
X
Transaction ID
Revised Resource s/Tib_Int _ECO_O pn_Resources
TIBCO_ KEY
N/A
Windchill /TIBCO
Concat Transaction ID with date and time
X
X
X
X
X
X
Number (Change Number)
Revised Resource s/ Tib_Int_ ECO_Op n_Resou ces
ECO_NAME
N/A
X
X
X
X
X
X
Distribution Target
Revised Resource s/ Tib_Int_ ECO_Op n_Resources
ORGANIZATION_CODE
N/A
Windchill
Substring
X
X
X
X
X
X
(Assembly) Part Number
Revised Resource s/ Tib_Int_ ECO_Op n_Resources
REVISE D_ITEM _ NAME
N/A
X
X
X
X
X
X
Version
Revised Resource s/ Tib_Int_ ECO_Op n_Resources
NEW_ROUTING _REVISION
N/A
Windchill
Front Pad with --
X
X
X
X
X
X
Action Flag
Revised Resource s/ Tib_Int_ ECO_Op n_Resources
TRANS ACTION_TYPE
"CREATE
“ Windchill
N/A
X
X
X
X
X
Action Flag
Revised Resource s/ Tib_Int_ ECO_Op n_Resources
ACD_TYPE
1' -Add '2' - Change '3 ' -Disable'
X
X
X
X
X
Start Effectivity Date
Revised Resource s/ Tib_Int_ ECO_Op n_Resources
OP_STA RT_EFF ECTIVE _DATE
TIBCO's system date/time
Windchill /TIBCO
Date Format
X
X
X
X
X
X
Operation Label
Revised Resource s/ Tib_Int_ ECO_Op n_Resources
OPERATION_SEQUENCE_NUMBER
N/A
Windchill
N/A
X
X
X
X
X
X
Operation Consumable Resource Link- ResourceNUMBER
Revised Resource s/ Tib_Int_ ECO_Op n_Resources
RESOURCE_CODE
N/A
X
X
X
X
X
X
Consumable Resource Link- Allocation Number
Revised Resource s/ Tib_Int_ ECO_Op n_Resources
RESOURCE_SEQUENCE_NUMBER
N/A
X
X
X
X
X
X
* 
Guidelines for ECN Centric Routings
1. ACD_Type value shall be '1' (Add) for added BOM components, '2' (Change) for updated BOM components, or '3' (Disable) for deleted BOM components.
2. Transaction Type should always be 'CREATE' in ECN Centric Transactions, only ACD_TYPE changes, whether creating/updating (Operations) OR disabling the Resources
3. ESI shall map the OLD_START_EFFECTIVE_DATE only when changing/updating the Revised Operations/Revised Resources. (OLD_START_EFFECTIVE_DATE should be mapped with Existing START_EFFECTIVE_DATE)