進階自訂 > Windchill ESI Customization > Windchill ESI Customization—Oracle Applications > EAI Software Components Customizations > XML (eXtensible Markup Language) Schemas > Oracle Applications API Descriptions
Oracle Applications API Descriptions
The Oracle Applications APIs used by Windchill ESI were selected after an exhaustive analysis of business requirements and available Oracle Applications functionality (see list below). The use and characterization of these APIs are critical Windchill ESI implementation assumptions. Any updates to APIs require re-characterization , that is, re- testing to ensure that the appropriate values are entered for each field. Some examples of customizations to APIs include, but are not limited to:
• Increase (or modify) data passed to the out-of-the-box APIs
• Utilizing a different API than the out-of-the-box APIs
• Modifying an API in ERP
• Stringing APIs together to perform a particular function
The Oracle Applications ESI solution also uses in-line SQL queries at times, to determine how to process data for what is not provided by Windchill, and it’s not possible to default. Some examples are, determining if the item already exists in the master organization and retrieving the initial effectivity date of components that need to be disabled. Changes in API characterization may impact how these queries function.
Windchill ESI utilizes the following Oracle Applications APIs and Open Interface Tables (grouped by Windchill ESI function):
Create/Change Part
Open Interface Tables
Description
MTL_SYSTEM_ITEMS_INTERFACE
This interface table is used to create/change all item data in Oracle Applications.
MTL_ITEM_REVISIONS_INTERFACE
This interface table is used to create/change all revision data in Oracle Applications.
Create/Change BOM
API
Description
Bills of Material Business Object Interface
This API is invoked to create or change BOMs in Oracle Applications. This API cannot be called for multiple BOMs in multiple organizations.
Create CN
API
Description
Engineering Change Order Business Object Interface
This API is invoked to create ECOs in Oracle Applications. For CN centric releases, this API is also used to create BOMs, item revisions and routings (Process plan).
Create Process plan (Routing)
API
Description
Routing Business Object Interface
This API is invoked to create Routings in Oracle Applications.
這是否有幫助?