Defining Resource Setup Information

You can create a performance model for machine and resource setups to include time from one setup to another, including the time required to perform…

Bill Of Material Open Interface

Firstly I create a custom table. I write an insert sql for the BOM_BILL_OF_MTLS_INTERFACE table for assembly item. I write an insert sql for the…

Record not found in WIP_PERIOD_BALANCE (metalink note ID 1080033.6)

Unable to close EAM Work Orders because Resource transactions are not being processed by the Cost Manager. Records are stuck in the wip_cost_txn_interface (WCTI)  table…

Creating Maintenance Routes with BOM_RTG_PUB API (You can use this API for discrete manufacturing)

Firstly I create a custom table then I insert the datas from excel sheet. [sql]CREATE TABLE XXINN_MAINTENANCE_ROUTES( ASSEMBLY_ITEM_NAME VARCHAR2(240 BYTE), ORGANIZATION_CODE VARCHAR2(3 BYTE), LONG_DESCRIPTION VARCHAR2(4000…

Creating Maintenance Activities with MTL_SYSTEM_ITEMS_INTERFACE

We create custom table for inserting datas into the mtl_system_items_iterface table. I create an excel sheet and it has same columns with “xx_item_create” table. Then…

Supply Types on Oracle Bill Of Material

Bulk Bulk component requirements can be viewed and are displayed on reports. They can be used to communicate to the shop floor that bulk components…

Creating and Managing a Stability Study (OPM Quality)

The Stability Study window lets you create and manage a stability study. Refer to the “Managing the Stability Study Lifecycle” topic for an overview of…