In this Document

Goal

Solution

1. Sample Notes for BOM APIs

2. Datatypes used in these APIs

3. Limitations / ERs

References

---

APPLIES TO:

http://www.wfuyu.com/oracle/ Bills of Material - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
http://www.wfuyu.com/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