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)