Oracle Apps Techno Functional................

Some important Tables Joins in Oracle apps WIP, BOM, INV 1) BOM : BOM_RESOURCES (BR) BOM_BILL_OF_MATERIALS (BBOM) BOM_DEPARTMENTS (BD) BOM_OPERATIONAL_ROUTINGS (BOR) BOM_OPERATION_SEQUENCES (BOS) BOM_OPERATION_SEQUENCES (BOS) BOM_INVENTORY_COMPONENTS (BIC) BOM_STANDARD_OPERATIONS (BSO) 2) INV :  MTL_PARAMETERS (MP) MTL_SYSTEM_ITEMS_B (MSIB) MTL_MATERIAL_TRANSACTION (MTT) MTL_SERIAL_NUMBERS (MSN) MTL_ITEM_REVISIONS (MIR) MTL_ITEM_CATEGORIES (MIC) MTL_DEMAND (MD) MTL_TRANSACTION_TYPES (MTTY) MTL_CATEGORIES (MC) CST_ITEM_COSTS (CIC) CST_COST_ELEMENTS (CCE) 3) WIP : WIP_PARAMETERS (WP) WIP_DISCRETE_JOBS (WDJ) WIP_ENTITIES (WE) WIP_OPERATIONS (WO) WIP_REQUIREMENT_OPERATIONS (WRO) WIP_OPERATION_RESOURCES (WOR) WIP_TRANSACTIONS (WT) WIP_TRANSACTION_ACCOUNTS (WTA) WIP_LINES (WL) WIP_EAM_WORK_REQUESTS (WEWR) WIP_EAM_PARAMETERS (WEP) 1) JOINS IN BOM and BOM-INV BOM_BILL_OF_MATERIALS (BBOM)                

Invoice Matching 2-Way, 3-Way and 4-Way When Invoices are matched with PO, following 3 options can be used to match the PO. 2-Way Match : In 2-Way Match  PO Quantity  Should Match with  Invoice Quantity  and PO Unit Price should match with Invoice Unit Price. All the matching should be with in the tolerance limits allowed in the Receiving Control options.            PO Unit Price = Invoice Unit Price            PO Quantity = Invoice Quantity 3-Way Match:     In 3-Way Match  PO Quantity  should match with  Invoice Quantity  and  Receipt Quantity . Also PO Unit Price should match with Invoice Unit Price. All the matching should be with in the tolerance limits allowed in the Receiving Control options.            PO Unit Price = Invoice Unit Price            PO Quantity = Invoice Quantity            Invoice Quantity = Receipt Quantity 4-Way Match:  In 4-Way Match  PO Quantity  should match with  Invoice Quantity  and  Receipt Quantity  and also  Accepted Quantit

PO Receipt Accounting entries to GL When a PO Receipt is created in the Receiving Transactions form with destination type as Inventory, 2 entries get created in the RCV_TRANSACTIONS form. One with Transaction type as Deliver and other with Receive. Also accounting is also derived for the 'RECEIVE' transaction. You will see an entry with RECEIVING_INSPECTION and an ACCRUAL entry in the RCV_RECEIVING_SUB_LEDGER table. When " Create Accounting: Receiving " is run, these Accrual Transaction for Receipt is transferred to GL through SLA. In SLA for Receive Transactions "Receiving Inspection" account is Debited and "Accrual" Account is credited. Journal Category will be "Receiving" for these transactions For the Deliver Transaction type the transaction is sourced to Material Transactions as " PO Receipt " Transaction Type. Accounting will be done on this transaction when " Active Cost Worker " program is run. Usually

How to find item cost Another  common issue when  writing  queries is getting an item cost. Here are the  APIs  to use in queries: For discrete manufacturing: cst _cost_ api .get_item_cost(1,inventory_item_id, organization_id,NULL,NULL) here is a sample query: select segment1 item, cst _cost_ api .get_item_cost(1,inventory_item_id, organization_id,NULL,NULL) cost from  mtl _system_items_b If you are in an  OPM  organization the above won't work and instead you need to call select  msi .segment1 item, GMF _ CMCOMMON .get_ cmpt _cost( inventory_item_id, organization_id,  sysdate ,  cmm .cost_type_id ,0) cost from  mtl _system_items_b  msi , CM_ MTHD _MST  cmm where  cmm .cost_ mthd _ desc ='Standard Cost'

This blog provide basic understanding about Oracle Inventory Transactions and Cost processing procedure. SCOPE & APPLICATION ------------------- Oracle manufacturing customers, support, and consulting.    Transactions - Unprocessed Transactions/Closing INV Accounting Period (TRXN-STK) This document will be used to explain the flow of transactions from the MTL_TRANSACTIONS_INTERFACE to the GL_INTERFACE. The aim of this document is to help and assist in resolution of Interface related issues. CONTENTS -------- Q1.  What is the MTL_TRANSACTIONS_INTERFACE table used for? Q2.  What is the MTL_MATERIAL_TRANSACTIONS_TEMP table used for? Q3.  What type of issues will you see with the MTL__TRANSACTIONS_INTERFACE and      MTL_MATERIAL_TRANSACTIONS_TEMP tables? Q4.  What type of issues will you see with the MTL_MATERIAL_TRANSACTIONS table? Q5.  What type of issues will you see with the MTL_TRANSACTION_ACCOUNTS table? Q6.  Where do you find Pending/Errored Inventory Transactions? Q7.