Tuesday, March 30, 2010

Oracle 12i functionalities in depth


In the next few weeks I will be focusing on new functionalities introduced by Oracle 12i in the following areas:
1.       Financial Management
a.       Across Financials
                                                               i.      Oracle Financials Concepts and Implementation
b.       Assets and Real Estate
                                                               i.      Oracle Assets
                                                             ii.      Oracle iAssets
c.        Cash and Treasury
                                                               i.      Oracle Cash Management
                                                             ii.      Oracle Treasury Management
d.       Credit to Cash (Receivables)
                                                               i.      Oracle Receivables
                                                             ii.      Oracle iReceivables
                                                           iii.      Oracle Advanced Collections
                                                           iv.      Oracle Trading Community Architecture
e.        Financial Control and Reporting
                                                               i.      Oracle Advanced Global Intercompany System
                                                             ii.      Oracle Financial Consolidation Hub
                                                           iii.      Oracle Financial Accounting Hub
                                                           iv.      Oracle General Ledger
f.         Financial Common Modules
                                                               i.      Oracle E-Business Tax
                                                             ii.      Oracle Subledger Accounting
g.       Oracle Internet Expenses
h.       Procure to Pay (Payables)
                                                               i.      Oracle Payables
                                                             ii.      Oracle Payments
2.       Projects
a.       Oracle Projects Fundamentals
b.       Oracle Project Costing
c.        Oracle Project Billing
d.       Oracle Project Management
e.        Oracle Project Portfolio Analysis
f.         Oracle Project Resource Management

Wednesday, March 3, 2010

Project Manufacturing Fundamentals - Part 2

8. What is the use of Profile INV: Project Miscellaneous Transaction Expenditure Type?
This profile Governs the entry of expenditure types for project miscellaneous transactions.
Values that are available are:
User Entered (Default value): If the profile is set to User Entered, the user has to enter expenditure types for project miscellaneous transactions.
System derived from cost elements If the profile is set to this value, user cannot enter the expenditure types for project miscellaneous transactions.

9. Parameters that are to be given or can be used to verify if an organization is PJM enabled or not?
1. Organization has ‘Project Manufacturing Organization’ classification defined in Organization form.



2. Check that Project Cost Collection Enabled (check box) is enabled in Organization Parameters form under Costing Tab. This indicates whether subinventories can be associated with a given project and task.




3. And Enable Project References check box, located in the Project Manufacturing Parameters form, is also selected. So the cost collector process can transfer costs to project accounting.




10. How can we create User defined transaction types for a project?
At the time of creation of User defined transaction type we need to check the Project Check box.





11. What are the Project locators and common locators ?

Oracle Project Manufacturing reserves segment19 and segment20 of the Stock Locator key flexfield to store the project and task numbers.

Project Locator A project locator is a locator with a project or project and task reference. It is also a logical partition of a physical location. Project locators are used to track project hard pegged material. Project inventory needs to be stocked in a project locator and needs to be transacted in and out of a project locator. Since locators can be dynamically created, it is not necessary to predefine project locators.

A project locator must be tied to the same subinventory as its corresponding physical locator. For non-project Locators, physical_locator_id and inventory_locator_id are supposed to be same or physical_locator_id may be null , but inventory_locator_id is populated always.




Common Locator
A common locator is a locator without a project or project and task reference. It is also a
real, physical location. Common locators are used to track common (soft pegged)
material.




12. What is the common validation done for Project locators ?

The system validates the project and task segments of a locator based on the value of the
Project Control Level parameter you set up in Organization Parameter as described in the following
table –

Project Control = Null,  Level Project Segment = Cannot enter any value, Task Segment = Cannot enter any value

Project Control = Project,  Level Project Segment = Optional,  Task Segment = If Project is entered, Task is optional. If Project is not entered, Task cannot be entered.

Project Control =Task,  Level Project Segment =  Optional, Task Segment =   If Project is entered, Task is mandatory.If Project is not entered, Task cannot be entered.

Project Manufacturing Fundamentals - Part 1


1. What is PJM Manufacturing and what kind of industries it is employed in ?
Oracle Project Manufacturing supports companies in the Engineer-To-Order, Make-To-Order, Seiban, and Aerospace and Defense industries. These industries  plan, track, procure, and cost based on project, contract, or Seiban numbers.

2. Project Setup
A project is a primary unit of work that you can break down into one or more tasks. You charge the transactions you enter in Oracle Projects to a project and a task. When you set up a project, you must set up the work breakdown structure (WBS), and enter project and task information. 


After your project structure and budgeting have been defined in Oracle Projects, you need to define the Project Manufacturing parameters for your project.

3. What activities are involved during Project Manufacturing execution phase ?
The execution system addresses the inventory, shop floor, and procurement activities.
 
 
4. What are the diff. flows which can be performed for PJM org in Order Management ?

Oracle Project Manufacturing supports:
Project Sales Orders Oracle Order Management enables user to link sales order lines to projects and project tasks.
Project Return Material Authorization (RMA) Oracle Order Management enables user to process Project RMAs using the line type category ‘Return.’ Examples of the line types available are return for credit without receipt of goods, return for credit with receipt of goods, and return for replacement.

Project Assemble-To-Order (ATO) and Pick-To-Order (PTO) Oracle Project Manufacturing enables user to use Oracle Configurator with Oracle Order Management with propagation of project and task on the configured
model, options, and included items. For ATO, the Final Assembly Schedule process creates a WIP Job with the configuration’s project and task.
Project Drop Shipments You can specify a project and task on a sales order line and use drop shipment to automatically create a project purchase requisition. Drop-shipped materials ship directly from supplier to customer.
Project Fulfillment Oracle Order Management and Oracle Shipping Execution support delivery-based shipping with user-definable picking rules for order fulfillment. After manufacturing is complete, finished goods are picked automatically from the project inventory upon pick release. You can also pick all items for a project and task.

Project Order Import If you use external systems to capture order information you can use Order Import to import external sales orders or quotations, including project and task references.

5. What are the various activities which can be performed in WIP for PJM org ?
Project WIP Jobs You can create WIP Jobs with project/task references. Project Manufacturing supports standard and non-standard WIP Jobs. You can create Standard Project WIP Jobs automatically.
Project Outside Processing You can use existing outside processing functionality to support Project Outside Processing. The system transfers the project/task on the work order once the outside processed purchase requisition generates.
Project Repair Orders You can link non-standard WIP Jobs to a project / task to capture project repair.
Project Flow Schedules You can use flow schedules in a work order-less production environment.

6. What features are supported for Project Procurement ?

Project Requisitions You can create requisitions with project/task references. You can define project requisitions for inventory and expense destination types.
Project Purchase Orders You can create purchase orders with project/task references. You can define project purchase orders for inventory and expense destination types.
Project Blanket Releases You can create purchase blanket releases with project/task references.
Project RFQs You can create purchase Request For Quotations (RFQ) manually or auto-create an RFQ from a requisition.
  
7. What different types of Project Material transactions one can perform in Inventory ?

Tracking inventory by project and dealing with permanent and temporary transfers from one project to another or from common inventory to project inventory is essential for a project-based environment. Oracle Project Manufacturing supports:
Project Inventory You can use project locators to segregate inventory by project. Purchase order receipt locators validate automatically for project purchase orders. You can reference existing project locators or dynamically create project locators upon receipt. The issue, back-flush, and completion locators validate automatically for project WIP jobs and associated material. Similar logic applies in processing flow schedules using work order-less completions.
Project Material Transactions You can use existing material transactions such as Miscellaneous Issue/Receipt, Move Orders, PO Receipt, WIP Issue, WIP Return, and WIP Completion.

Permanent Project to Project Transfers You can use project transfer transactions to transfer material from one project to another with appropriate transfer of inventory value.
Temporary Project to Project Transfers You can use borrow payback transactions to borrow material from one project to another, and ensure payback against the original value.
Common-to-Project and Project-to-Common Transfers You can use project transfer transactions to transfer material from common inventory to project inventory and vice versa, with the appropriate transfer of inventory value.
Project Mass Transfers You can use the mass transfer wizard to initiate the mass transfer of material from one project to another based on criteria you define, with the appropriate transfer of inventory value.
Consigned Material from Supplier You can perform implicit and explicit consumption of consigned items to demand/supply documents with project references, with appropriate transfer of inventory value into a project.