BOM_BO_PUB Package Configuration

You can use the BOM_BO_PUB package to create BOM bills.

The following figure shows a sample configuration of the BOM_BO_PUB package:

Note: As defined in Oracle Integration Repository, you can use the BOM_BO_PUB.PROCESS_BOM method for creating, updating, or deleting entities of a single Structure/BOM. The method takes in a single Structure/BOM header as well as all its components, revisions, reference designators, and substitute components.

The BOM_BO_PUB.PROCESS_BOM (Process Single Structure/BOM) procedure has 23 parameters of PL/SQL Table types and PL/SQL Record types defined in the package. The following table lists the main parameters and associated inputs of BOM header, revision, components, reference designators, and substitute components:

	Parameter	Input
P_BOM_HEADER_REC	ASSEMBLY_ITEM_NAME	TIB_MainMachine
	ORGANIZATION_CODE	V1
	TRANSACTION_TYPE	CREATE
P_BOM_REVISION_TBL	REVISION	B
P_COMPONENT_TBL	COMPONENT_ITEM_NAME	TIB_CPU or TIB_HD or TIB_RAM or TIB_MAINBOARD
P_BOM_REF_DESIGNATOR_TBL	REF_DESIGNATOR_COMMENT	This is TIBCO CPU
P_BOM_SUB_COMPONENT_TBL	COMPONENT_ITEM_NAME	TIB_RAM
P_BOM_SUB_COMPONENT_TBL	SUBSTITUTE_COMPONENT_NAME	TIB_RAM1

Note: You can define these parameters manually or automatically by defining a module property. For how to define module properties, see "Using Process and Module Properties" in TIBCO ActiveMatrix BusinessWorks Samples.