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