Oracle EBS Learnings

Basic objective of this whitepaper is >Identifying a key setups to complete Demand planning to supply flow >Identifying the role of advanced modules like ASCP to achieve better execution of Supplier scheduling process >Basic flow of ASCP   Setup Step 1: Item creation Note: Item should be ‘Purchased’ and ‘Purchasable’ enabled. Ensure ‘planner’ is entered under general planning tab (At organization level) Ensure it’s a ‘Buy’ item.  In the MPS/MRP Planning tab - the item should have a planning method - MRP Planning (Or method of planning used at the Location) - Create Supply   Step2: Create Blanket Purchase Order and Approve it Step3 : Create Approved Supplier List , Make sure Global parameter is set to Yes   Step4:  Make sure 'Planning schedule' and 'Shipping Schedule' is enabled under planning tab   Step5: Create Sourcing Rule and Assign it     Step6: Cr...

Introduction Period End Processing - Summary 1. A summary of the period-end procedures for each of the Financials applications 2. An indication of the order in which the steps should be undertaken. Steps Payables 1. Complete All Transactions for the Period Being Closed 2. Run the Payables AutoApproval Process for All Invoices / Invoice Batches 3. Review & Resolve Amounts to Post to the General Ledger 4. Reconcile Payments to Bank Statement Activity for the Period 5. Transfer All Approved Invoices Payments, Reconciled Payments to the General Ledger 6. Review the Payables to General Ledger Posting Process After Completion 7. Submit the Unaccounted Transactions Sweep Program 8. Close the Current Oracle Payables Period 9. Accrue Uninvoiced Receipts 10. Reconcile Oracle Payables Activity for the Period 11. Run Mass Additions Transfer to Oracle Assets 12. Open the Next Payables Period 13. Run Reports for Tax Reporting Purposes (Optional) 14. Run the Key Indicators Report (Optional) 15....

PURPOSE This document is meant to assist in the successful completion of the Min-Max Planning Report  SCOPE & APPLICATION The intended use of this document is for the casual user beginning to use the Min-Max Planning feature of Oracle Inventory. MIN MAX PLANNING & REPORT Min-Max planning is a type of order point replenishment system where the minimum is the order point, and the maximum is the "order up to" inventory level. The order quantity is variable and is the result of maximum minus available and on-order inventory. An order is recommended when the sum of the available and the on-order inventory is at or below the minimum. Oracle Inventory enables you to perform min-max planning at two levels: A. Organization B. Subinventory To perform organization-level min-max planning for an item, you must specify organization-level minimum and maximum quantities. To perform subinventory-level min-max planning for an item, you ...

What is Material Status? Material Status control restricts the movement and usage of portions of on-hand inventory. Using material status control enables you to control whether you can pick or ship an internal order or sales order, or issue material for a work order. You can also specify whether material needs to be quarantined until you inspect it. In addition, you can determine whether products with a particular status can be reserved, included in available to promise calculations, or netted in production planning. You assign material statuses at four levels: subinventory, locator, lot, and serial. You assign subinventory and locator statuses in the subinventory and locator windows. The location status applies to the material in the location and not the location itself. To assign a material status to a lot or serial, you must first enable the item attributes Lot Status Enabled, and Serial Status enabled on the item in the Item Master. You can also optionally assign a defa...

1. What are the setups required to have encumbrance accounting in 11i and R12 architecture? For 11i: a) Enable the check box for PO encumbrance,INVOICE encumbrance and REQ encumbrance (if required) with  unique encumbrance types  for REQ,PO and INVOICE. Navigation: Purchasing > Setup > Organization > Financial Options > Encumbrance tab b) Enable the Budgetary Control flag and define the Reserve For Encumbrance (RFE) a/c for the Set of Books. Navigation: General Ledger > Setup > Financials > Books > Define c) It is preferred to enabled the 'Reverse Encumbrance' check box in Inventory > Setup > Organization > Parameters > Costing tab and define the Encumbrance account in Other Accounts tab if requisitions/purchase orders are created with inventory destination for inventory asset items in encumbered environment. d) Purchasing period under which the GL date of purchasing document falls and AP period under which the GL date of invoice falls s...