Bill of Materials - Open Interface

|
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
 262 views
of 28

Please download to get full document.

View again

Description
OPEN BILLS OF MATERIAL INTERFACE Sanjeev Kale Oracle Corporation Introduction Bills of material can be imported into Oracle Bills of Material or Oracle Engineering from any source using Bills and Routing Interface. Existing Bills and product families can also be updated or deleted. Oracle Bills of Material and Oracle Engineering validates the data, ensuring that the imported bills of material contain the same bill detail as those manually entered by Define Bill of Material form. This paper focu
Share
Tags
Transcript
  Open Bill of Material Interface 1 OPEN BILLS OF MATERIAL INTERFACE Sanjeev Kale Oracle Corporation Introduction Bills of material can be imported into Oracle Bills of Material or Oracle Engineering from any source using Bills andRouting Interface. Existing Bills and product families can also be updated or deleted. Oracle Bills of Material andOracle Engineering validates the data, ensuring that the imported bills of material contain the same bill detail as thosemanually entered by Define Bill of Material form.This paper focuses on understanding of importing Bills and routings from legacy system to Oracle Bills of Materialand Oracle Engineering. This paper is designed to supplement Oracle Manufacturing, Distribution, Sales and ServiceOpen Interface Manual , User manual and BOM training class notes.The Bill and Routing Interface program can be run from BOM responsibility Bills à Import Bills.When the Bills and Routing program is run, a number of runtime options must be specified.All OrganizationsYesRun the interface for all organization codes inthe bill of material and routing interfacetables.NoRun the Interface program only for theorganization the user is in. The interfaceprogram only processes bill of material androuting interface records in the currentorganization.  Open Bill of Material Interface 2 Import RoutingYesImport records from the routing interfacetables for the current organization or allorganizations.NoDo not import records from the routinginterface tables.Import Bills of MaterialYesImport records from the bills of materialinterface tables for the current organization orall organization.NoDo not import records from the bills of material interface tables.Delete Processed RowsYesDelete successfully processed rows from thebill of material and routing interface tables.NoLeave all records in the bill of material androuting interface tables for successfullyprocessed rows.Each  Interface table’s required  columns and derived  columns are discussed in detail in the following pages. Look atthe following example for updating a bill component. The required data for updating a bill component is ã PROCESS_FLAG = 1   1 = Pending   3 = Assign/Validation failed   4 = Import Failed   7 = Import Succeeded ã TRANSACTION_TYPE = Update ã COMPONENT_SEQUENCE_IDThere are two ways at looking at this information:a) You can provide the COMPONENT_SEQUENCE_ID for updating the bill component, or  Open Bill of Material Interface 3 b) You can update the bill component by populating the following fields ã Component_Item_Id, ã Operation_Seq_Num, ã Effectivity_date, ã Assembly_Item_Id and ã Organization_IdSince Component_Sequence_Id is a derived column if the following columns are populated. ã Bill_Sequence_Id, ã Component_Item_Id, ã Operation_Seq_Num and ã Effectivity_dateand Bill_Sequence_Id is a derived column if the following columns are populated ã Assembly_Item_Id , ã Organization_Id and ã Alternate_Bom_Designator (if a alternate bill exists) Functional Overview Before using the Bill and Routing Interface, a custom program must be written to extract bill of material andcomponent details from the source system and this program must insert rows in the following tables for eachextracted bill of material: ã BOM_BILL_OF_MTLS_INTERFACE ã BOM_INVENTORY_COMPS_INTERFACE ã BOM_ASSY_COMMENTS_INTERFACE ã BOM_SUB_COMPS_INTERFACE ã MTL_ITEM_REVISIONS_INTERFACE ã BOM_OP_ROUTINGS_INTERFACE ã BOM_OP_SEQUENCES_INTERFACE ã BOM_OP_RESOURCES_INTERFACE ã MTL_RTG_ITEMS_REVS_INTERFACE ã BOM_INTERFACE_DELETE_GROUPS After the data is loaded in the interface table, the Bill and Routing interface program can be launched from the ImportBills and Routings form in Oracle Bills of Material or Oracle Engineering. The interface program assigns values,validates the data and then creates, updates, or deletes bills of material, product family or a routing.To import a bill of material with components, the BOM_BILL_OF_MTLS_INTERFACE andBOM_INVENTORY_COMPS_INTERFACE tables must be populated. Using the bill of material header informationand components from these two tables, details can be created. Similarly BOM_REF_DESGS_INTERFACE andBOM_SUB_COMPS_INTERFACE tables can be populated to assign reference designators and substitutecomponents to bills of material. To import a routing with operations and resources, the BOM_OP_ROUTINGS_INTERFACE,BOM_OP_SEQUENCES_INTERFACE and BOM_OP_RESOURCES_INTERFACE tables must be populated. Usingthe routing header information from these three tables, operation and resource details can be created.Although bill and routing can be imported simultaneously, all routing operations must exist before a component isassigned to an operation. Primary and alternate bills of material can be simultaneously imported. Since the Bill andRouting Interface program validate data the same way the Define Routing or Define Engineering Routing form verifiesdata, the alternate bill cannot be defined if the primary bill does not exist. Therefore the primary bill must be importedbefore importing the alternate bill.  Open Bill of Material Interface 4 Using the Bill and Routing Interface program, manufacturing and engineering bills of material / routing can beimported. Specify a value in the ASSEMBLY_TYPE column to determine the type of bill to be imported. Specify avalue in the ROUTING_TYPE column to determine the type of routing to be imported. Setting up for Bills of Material / Routing Import There are no additional setup steps in Oracle Bills of Material or Oracle Engineering beyond those already required tomanually define manufacturing and engineering bills of material. ã All items and standard comments must be defined before they can be assigned to a manufacturing orengineering bill of material. ã Standard operations, resources and standard instructions must be defined in Oracle Bills of Material beforethey can be assigned to a manufacturing or engineering routing. ã Since the Bill and Routing Interface program is launched and managed through the concurrent manager, itmust be ensured that the concurrent manager is running before importing any bills. Transaction Type Transaction_Type column determines the action to be taken to taken. It has following possible values: ã Create - To create bill of material or a Product family. ã Insert - To create a routings with operations and resources. ã Update - To update bill of material or routing. ã Delete - To Delete bill of material or routing. Packages Used in Open Interface All the code for open interface is written in PL/SQL and database-resident stored procedures and packages. ã BOM_BILL_API – This package is used to Assign, validate and transact bill data in theBOM_BILL_OF_MTLS_INTERFACE table. ã BOM_COMPONENTS_API - Assigns, validates and transacts component data in theBOM_INVENTORY_COMPS_INTERFACE table.  ã BOM_REFERENCE_DESIGNATOR_API - Assigns, validates and transacts reference designator data in theBOM_REF_DESGS_INTERFACE table. ã BOM_REVISION_API - Assigns, validates and transacts revision data in theMTL_ITEM_REVISIONS_INTERFACE table. ã BOM_ROUTINGINTERFACE_PUB ã BOM_SUBSTITUTE_COMPONENT_API - Assigns, validates and transacts substitute component data inthe BOM_SUB_COMPS_INTERFACE table. Process Flow Routing Data ã Assign routing data – all the rows in the BOM_OP_ROUTINGS_INTERFACE table are processed withPROCESS_FLAG = 1 ♦ Assign routing sequence Id ♦ Assign common routing ♦ Populate mandatory columns with default values. ♦ Set PROCESS_FLAG = 2 if assigning is successful.
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks