In this Document
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
