Oracle EBS R12 WIP Component Issue & amp; Return Process

1. Define BOM

BOM is the basis of WIP. BOM defines the structure of a product and the parts and quantity required to produce specific materials. Each part may also have its BOM structure, resulting in a multi-layer product structure tree.

For example, a computer = 1 CPU + 1 memory + 1 hard disk + 1 display + 1 mouse + 1 keyboard + 30 data lines + 50 screws, the computer is a BOM. Another hard disk may be a BOM, for example, one hard disk = four groups of disks + one disk pointer + one hard disk shell. In the same way, the display, memory... all of them have their own BOM definitions. In this way, the computer BOM actually forms a huge BOM tree.

Here is a bicycle BOM tree in Huang Jianhua's document, which is representative.

How to define BOM in EBS, path: Bill Of Materials> Bills

Define a simple BOM here, 1 * pt_assembly01 = 2 * pt_component01

BOM information is stored in the BOM_STRUCTURES_ B and BOM_COMPONENTS_ B tables, BOM_STRUCTURES_ B is used to save BOM Header information, BOM_COMPONENTS_ B is the child table of BOM_STRUCTURES_ B, used to save BOM Component information, two tables are associated through the bill_sequ.

SELECT * FROM BOM_STRUCTURES_ B WHERE ASSEMBLY_ITEM_ID = 242956;

SELECT * FROM BOM_COMPONENTS_ B
WHERE BILL_SEQUENCE_ID in (SELECT BILL_SEQUENCE_ID FROM bom_structures_ B WHERE ASSEMBLY_ITEM_ID = 242956 );

About the sending method (BOM interface, Supply Type in Material Control)

Push and Push refers to materials that must be manually delivered through the interface and must be strictly controlled by quantity or fluctuating materials.
Assembly Pull-type hair, automatic standard consumption triggered when parts are finished or scrapped to consume relatively stable materials
Operation Pull-type material sending. When the process moves To Move, the system automatically triggers the consumption of relatively stable materials according To the standard consumption.

BOM_COMPONENTS_ B .WIP_SUPPLY_TYPE Storage Method

Value	Meaning
1	Push
2	Assembly Pull
3	Operation Pull
4	Bulk
5	Supplier
6	Phantom
7	Based on Bill

1 2 3 4 5 Next Page