Oracle Bills of Material and Engineering Application Program Interface (APIs)

In this Document

Goal
  Solution
  1. Sample Notes for BOM APIs
 
2. Datatypes used in these APIs
  3. Limitations / ERs
  References

APPLIES TO:

Oracle Bills of Material - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Oracle Engineering - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

GOAL

The document lists references to notes that show how to use public APIs provided for Bills of Material and Engineering along with sample code for testing purposes.

SOLUTION

Note 729513.1 How to use APIs: This demonstration walks the user through the API specifics, creating the PL/SQL procedure for using an API and also debugging guidelines.

1. Sample Notes for BOM APIs

Note Title
Note 1242524.1 How to Create an Engineering Change Order (ECO) using Eng_Eco_PUB.Process_Eco API [Video] ?
Note 1242665.1 How to Create, Update or Delete a Bill of Material (BOM) using Bom_Bo_Pub.Process_Bom API [Video] ?
Note 1663810.1 How to CREATE / UPDATE / DELETE Product Family Bills using BOM_BO_PUB.Process_BOM API [Video] ?
Note 1244125.1 How to Create a Routing for a Bill using Bom_Rtg_Pub.Process_Rtg API [Video] ?


2. Datatypes used in these APIs

Type Internal Datatype
ECO Header Eng_Eco_Pub.Eco_Rec_Type
ECO Revision Eng_Eco_Pub.Eco_Revision_Tbl_Type
ECO Revised Item Eng_Eco_Pub.Revised_Item_Tbl_Type
ECO Revised Component Bom_Bo_Pub.Rev_Component_Tbl_Type
ECO Revised Operation Bom_Rtg_Pub.Rev_Operation_Tbl_Type
ECO Revised Operation Resource Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
ECO Revised Operation Substitute Resource Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
BOM Header Bom_Bo_Pub.Bom_head_rec_type
BOM Revision Bom_Bo_Pub.Bom_revision_tbl_type
BOM Components Bom_Bo_Pub.Bom_comps_tbl_type
BOM Routing Header Bom_Rtg_Pub.Rtg_Header_Rec_Type
BOM Routing Revision Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
BOM Routing Operation Bom_Rtg_Pub.Operation_Tbl_Type
BOM Routing Operation Resource Bom_Rtg_Pub.Op_Resource_Tbl_Type
BOM Routing Sub-Operation Resource Bom_Rtg_Pub.Sub_Resource_Tbl_Type
BOM Routing Operation Network Bom_Rtg_Pub.Op_Network_Tbl_Type
BOM Substitute Component Bom_Bo_Pub.Sub_Component_Tbl_Type
BOM Reference Designator Bom_Bo_Pub.Ref_Designator_Tbl_Typ


3. Limitations / ERs

Note 1386427.1 - Is there an API to Create BOM Resources?

REFERENCES


NOTE:729513.1 - How to use APIs for Inventory / Product Information Management [Video] ?
NOTE:869386.1 - How to Enable Trace or Debug for APIs executed as SQL Script Outside of the Applications ? [Video]
NOTE:136099.1 - How To Use Bill Of Material Business Object API - An Example
技术分享
技术分享

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。