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.
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