tag:blogger.com,1999:blog-91787199860906910342012-01-27T20:34:31.736+05:30Knowledge increases with sharing! If you would like to contribute, please drop an email on applearn@gmail.comOracleOnDemandnoreply@blogger.comBlogger1621100tag:blogger.com,1999:blog-9178719986090691034.post-45976324662638485432011-12-26T23:21:00.002+05:302011-12-26T23:34:27.125+05:30

ERP market is abuzz with the recent news of Oracle waiving the extended support fee for E-Business Suite 11i, this time until November 2013. Few unhappy ones are calling it as putting ketchup on burnt steak. The fees for Extended Support on 11i was initially set to start in November 2010 but was post-poned for year in November 2010 and then now for another 2 years taking it to all the way through

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-42416456217730407812011-11-09T06:17:00.000+05:302011-11-09T06:17:50.456+05:30

Changes to existing tables PO_HEADERS_ALL Added columns (SUPPLIER_NOTIF_METHOD, FAX, EMAIL_ADDRESS) for capturing the Communication Details specified for a PO on the Create/Update Order page Added the STYLE_ID column for capturing the style of each document Added new columns: created_language cpa_reference last_updated_program Added column SUBMIT_DATE to record the date when purchase order is

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-16003705697640024322011-03-28T09:26:00.002+05:302011-04-02T03:55:36.761+05:30

Accurate demand forecasting is vital for holding optimal inventory.  The better you forecast your demand, the less residual inventory you will hold. Forecasting your demands is the key to plan your capacity, inventory & pricing. No forecasting method is 100% correct. Multiple forecast methods are used - based on judgement & based on data. I don't intend to write a long one on forecasting in this

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-74742538186679207432011-03-16T03:04:00.000+05:302011-03-16T03:04:35.576+05:30

In average costing, each receipt of material to inventory updates the unit cost of the item received. Issues from inventory use the current average cost as the unit cost.  Perpetual Inventory value = Avg unit cost X Quantity In Oracle Inventory, Inventory balances can be driven negative if the Allow Negative Balances parameter isset in the Organization Parameters. Inventory calculates the costs

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-10443562241784771452011-03-11T01:53:00.000+05:302011-03-11T01:53:45.318+05:30

Given the increased attention and scrutiny your investors are applying to the supply chain’s impact on a company’s financial performance, you need a yardstick to clearly measure your Supply Chain performance. One of the most followed and detailed performance metrics are encompassed in the Supply Chain Operations Reference (SCOR) model. The SCOR model provides an industry-standard approach to

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-2764798469969612442011-03-10T02:52:00.000+05:302011-03-10T02:52:49.853+05:30

It has become vital for every business that has to deal with necessary evil of inventory management to maximize inventory turns and have less of stock to manage. Crossdocking functionality in Oracle WMS allows warehouses to improve its operational efficiency by transferring material as soon as it's received to outbound location. In the process, it avoids the inventory holding function thereby

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-57706277982498006592011-03-08T03:23:00.000+05:302011-03-08T03:23:53.606+05:30

Forecasting is predicting the future using some proven methods. There is no single right forecasting method to use. Selection of a method should be based on your objectives and your conditions. To understand how Forecasting functionality works in Oracle, we need to be aware of few terms as below: In Oracle, Forecasts are defined within a three-level hierarchical structure. It goes from the most

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-40686341841116496892011-03-01T03:08:00.001+05:302011-03-01T03:13:58.728+05:30

Lets say we have a requirement where in every manufacturing job of 100 quantity ends up producing 80 quantity. You can define a shrinkage rate to describe expected scrap or other loss. Using this factor, the planning process creates additional demand for shrinkage requirements for the item to compensate for the loss and maintain supply. For example, if you have a demand for 100 quantity and a

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-18478218115226748872011-02-20T12:18:00.000+05:302011-02-20T12:18:54.432+05:30

EDI stands for Electronic Data Interchange To understand the need for EDI, lets take a business flow and transactions involved. Company "C" is a manufacturer and regularly buys raw material from Supplier "S" that would typically involve below transactions for each purchase done.  1. Buyer at Customer "C" enters a Purchase Order in his computer system 2. Buyer sends the PO through email or fax

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-59625563141682763962011-02-02T08:19:00.000+05:302011-02-02T08:19:29.354+05:30

When individuals or business buy products or equipments, manufacturers provide free warranty coverage for certain period of time. Oracle Applications provides a functionality to create warranty contracts on each serviceable products shipped from the manufacturer.  To achieve the above functionality, you need to setup on the below: 1. Define Coverage (Service Contracts)2. Mark the finished product

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-41152143816278182032010-11-11T02:30:00.000+05:302010-11-11T02:30:53.449+05:30

Move Orders allow transaction of material transfer from one subinventory to another in the same inventory organization.  At a high level, Move Order process have two basic steps: a) Creation of the Move Order b) Move Order transfer transaction Move Order can be manually created or it can be automatically created from various replenishment and material demand processes.  Move Order can be

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-74181546245335939552010-06-29T19:16:00.001+05:302010-06-29T19:17:16.162+05:30

Leaned out process  Ownership by business process owners Effort estimation - Schedule, Resources Clear ownership on requirements & in detailed description of each requirement Understand the impact of Customizations   No change requests after requirement gathering freeze; unless absolute show stoppers Data migration - Start very early in the game - Volume, data cleansing, Minimum 4

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-78419026862102526182010-06-26T02:07:00.000+05:302010-06-26T02:07:31.075+05:30

If the profile option "OM: Assign new set for each line" is set as "Yes", then 1. Enter value as "Ship" for the field "Line Set" in Sales Order form (Tab: Others) 2. Enter Sales Order line information (ordered item, quantity) 3. Unique Ship set numbers would be auto-populated in the "Ship set" field at SO line level Use the above if, a. Multiple shipments are allowed per order b. Each SO line

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-49286891661445195712010-05-19T10:08:00.002+05:302010-05-19T10:29:50.510+05:30

Please send in your comments on applearn@gmail.com

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-51013518587869087182009-11-23T05:51:00.006+05:302009-11-23T06:13:52.698+05:30

Specifications define the requirements to which the product must conform. You can define specifications for the key characteristics of the products that you produce or for the materials that you receive from suppliers. You can attach illustrative or explanatory files to specifications, such as text, images, word processing documents, spreadsheets, video, and so on. Attachments can be used to

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-43632902551614483522009-11-12T09:23:00.002+05:302009-11-12T10:04:35.728+05:30

A man who dares to waste one hour of time has not discovered the value of life.-- Charles DarwinAll the art of living lies in a fine mingling of letting go and holding on.-- Henry EllisAny idiot can face a crisis - it's day to day living that wears you out.-- Anton ChekhovBelieve that life is worth living and your belief will help create the fact.-- William JamesDon't go around saying the world

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-27204807854375777292009-11-12T05:09:00.005+05:302009-11-12T05:21:36.046+05:30

Collection elements are the basic building blocks of collection plans, which are the data structures that you use to collect Quality results. Before you can collect Quality data, you must first create a collection plan. You begin by creating collection elements, which define the characteristics of the product or process that you want to monitor, record and analyze.Collection elements are

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-48159670848808207032009-07-28T08:55:00.003+05:302009-07-28T09:14:52.319+05:30

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-7694235314906523052009-07-28T08:38:00.004+05:302009-07-28T08:54:11.720+05:30

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-20363184324699707562009-07-06T01:32:00.002+05:302009-07-06T01:49:27.605+05:30

"Each time our customers order us, its different configuration from the earlier product we supplied them earlier. It eats up our time in analyzing if what they ask is a possible combination of components that we can supply and we also loose a good time in quoting our customers. Sometimes we end up knowing from our manufacturing team that the requested configuration is not at all possible to

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-19341748412410465392009-04-26T13:02:00.002+05:302009-04-26T13:11:49.716+05:30

-Hello Friends,Here are few slides on understanding the basics of Oracle MSCA. To view the slides, please visit http://applearn.blogspot.comThanks,-

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-60965252994639640532009-04-21T12:32:00.002+05:302009-04-21T12:36:00.244+05:30

-Hello Friends,Here are few slides on understanding the basics of Oracle ASCP. To view the slides, please visit http://applearn.blogspot.comThanks,-

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-73140851696054206122009-04-13T17:37:00.003+05:302009-04-13T17:47:58.935+05:30

Using the Organization Parameters window, user can choose the type of serial number uniqueness for the organization. You can choose to enforce uniqueness within inventory items, within an organization or across organizations.However, system stops you from creating the same serial number for the same item in a different operating unit. Obvious reason for this being that the base table

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-87043676915596184342009-03-30T23:52:00.003+05:302009-03-31T00:09:00.954+05:30

-Here are few slides on implementing Kanban using Oracle Applications. Please note that slides can be viewed on http://applearn.blogspot.com-

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-49617512127125586162009-03-24T07:08:00.001+05:302009-03-24T07:30:22.838+05:30

-Available to Promise (ATP) in Oracle Applications-

OracleOnDemandnoreply@blogger.com3tag:blogger.com,1999:blog-9178719986090691034.post-49944920924011969782009-03-11T00:48:00.003+05:302009-03-11T01:01:33.738+05:30

Oracle Quality can be used to gather user-defined quality data. Data collected and input into Oracle Quality may come from functions such as purchasing, service, shopfloor inspection or directly from the customer.The data collection structure in Oracle Quality comprises ofa) Collection Elementsb) Specificationsc) Collection PlansThe basic building block of this structure is the collection element

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-51365959114780513412009-03-09T23:54:00.002+05:302009-03-10T00:21:20.906+05:30

Oracle WIP

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-76333426010326922792009-03-04T12:22:00.001+05:302009-03-04T12:24:41.724+05:30

ERP market in Year 2009

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-31412483211539917952009-03-04T12:10:00.000+05:302009-03-04T12:14:45.050+05:30

Inventory Management - An Introduction

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-81080597944555466302009-02-28T01:43:00.003+05:302009-02-28T02:04:20.516+05:30

Hope the above helps to understand the process of Internal Requisition to Internal Order cycle in Oracle Applications-

OracleOnDemandnoreply@blogger.com2tag:blogger.com,1999:blog-9178719986090691034.post-48986138702273263622009-02-15T15:51:00.007+05:302009-02-17T00:39:33.533+05:30

Please let us know if you would like to contribute in preparing similar slides on certain key areas in Oracle Projects. To view the presentation, please visit applearn.blogspot.com-

OracleOnDemandnoreply@blogger.com2tag:blogger.com,1999:blog-9178719986090691034.post-82064697875634875432009-02-14T01:08:00.001+05:302009-02-14T01:10:15.355+05:30

ERP - An Introduction-

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-55567854198361002212009-02-11T10:55:00.002+05:302009-02-11T11:45:03.893+05:30

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-85837747779371294042009-02-05T23:06:00.002+05:302009-02-05T23:15:45.624+05:30

Oracle Purchasing provides initial line types of Goods and Services. If Oracle Work in Process is installed, Oracle Purchasing also provides the line type Outside Processing. If Oracle Services Procurement is installed, Oracle Purchasing also provides Rate Based Temp Labor and Fixed Price Temp Labor line types. You can modify these line types or create new line types in the Line Types window. The

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-28372155362732046512009-02-05T22:43:00.003+05:302009-02-05T22:59:21.965+05:30

Min-Max Planning determines the size and timing of item replenishment orders and creates a purchase order/move order to replenish items stock. This purchase order/move order to restock items is created based upon the Min-Max Planning report. The planning report provides the item and quantity to be ordered or manufactured. Items are required to be restocked when the quantity of an item in stock

OracleOnDemandnoreply@blogger.com5tag:blogger.com,1999:blog-9178719986090691034.post-63933800330638802122009-01-29T12:06:00.002+05:302009-01-29T12:12:45.428+05:30

Requisitions Setup Checklist for iProcurement1) Foreign Currency Support2) Information Templates3) Suggested Buyer 4) One-Time Address5) Purchase Order Grouping for Requisition Lines with One-Time Addresses6) Hazard Information7) Global Requester8) Express Setup Tool9) Charge Account Displays Billing Optional Charge Account Displays10) Expense Charge Account Rules11) Employee PCards12) Supplier

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-65417665681113285372009-01-27T23:51:00.001+05:302009-01-27T23:55:23.134+05:30

Different line types in Oracle Purchasing are as follows:a) Quantity–Based PurchasingQuantity–based line types let you order and receive and/or invoice based on the quantity of goods or services provided. You can use quantity–based line types when you want to specify the quantity, unit of measure, and unit price for the items you are ordering. Purchasing module provides 'Goods' as an initial

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-8423649711068871262009-01-26T23:34:00.003+05:302009-01-26T23:49:49.636+05:30

You can define encumbrance accounting or budgetary control in Financial options window: Navigation: AP or PO ----> Setup--> Organizations --> Financial Options.In order to use encumbrance accounting or budgetary control, you must install Payables, Purchasing, and General Ledger modules. You may go to encunbrance region to enable encumbrance accounting and to specify the default encumbrance types

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-406328855870150562009-01-26T23:26:00.002+05:302009-01-26T23:30:59.171+05:30

"GL: Archive Journal Import Data" profile option of General ledger module decides whether you want your Journal Import to save your journal import data from the GL INTERFACE table to the GL INTERFACE HISTORY table at the end of each Journal Import run. You could select the values of "Yes" or "No" for this profile option.If you choose 'Yes', Journal Import will save your journal import data to the

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-91350558234358696212009-01-26T23:21:00.001+05:302009-01-26T23:24:44.105+05:30

1) The preparer completed the requisition and submitted to the approval process. However, no one with sufficient authority has approved the requisition. Requisition status will be 'in-process' 2) If in the Approve Document window you forward to an approver who does not have a logon user name, Purchasing module alerts you right away. If an approver without a logon user name is already included in

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-27637384792980150062009-01-26T23:09:00.003+05:302009-01-26T23:16:40.520+05:30

Line types in Oracle PurchasingOracle Purchasing module provides the line type feature for clearly differentiating orders for goods from those for services or outside processing orders. The line type governs the type of requisition, purchase order, RFQ, and quotation lines you create. You can select a default Line Type for requisition, RFQ, quotation, and purchase order lines. When you create any

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-18921206137473337312009-01-14T22:35:00.003+05:302009-01-14T22:40:04.102+05:30

Shortnames for Oracle Applications products1)ABM - Activity Based Management2)AD - Applications DBA 3)AHL - Oracle Advanced Service Online 4)AK - Oracle Common Modules-AK 5)ALR - Oracle Alert6)AMF - Oracle Fulfillment Services 7)AMS - Oracle Marketing 8)AP - Oracle Payables 9)AR - Oracle Receivables 10)AS - Oracle Sales 11)ASG - Oracle CRM Gateway for Mobile Services 12)ASL - Oracle Mobile Field

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-35834073549578386972009-01-11T16:43:00.002+05:302009-01-11T17:38:51.338+05:30

Which are different Inventory Planning methods?There are 5 inventory Planning methods as mentioned below:1) Subinventory Replenishment planning2) Min-max planning3) Re-order point planning4) Kanban planning 5) Periodic Automatic Replenishment(PAR)Subinventory Replenishment planningOracle Inventory provides additional methods for planning and replenishing inventories. Even if you are not

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-29871514842708894242009-01-11T16:15:00.002+05:302009-01-11T16:37:59.474+05:30

Which are different process flows in Oracle eAM module?There are 2 types of process flows in eAM module as follows:1) Work Execution Implementation FlowFirst, You have to create a Maintenance Work in Process (WIP) Accounting Classes and then you need to define Resources and Maintenance Departments. Afterwards, you decide if employee association is required with resource. If employee and resource

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-72443921396847977632009-01-11T15:51:00.002+05:302009-01-11T16:00:57.078+05:30

Explain the different types of assets?There are 2 types of assetsa) Capital or financial Assets b) Maintenanace assetsMaintenance Assets can be classified into the following two types: 1) Linear AssetsLinear Assets have linear properties and are connected with each other by their relationship with the linear infrastructure itself. i.e. NetworksFor example a metropolitan city which has a huge

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-42930504719336150202009-01-05T00:23:00.004+05:302009-01-05T00:31:36.783+05:30

'Push' and 'Pull' systems of controlling resources in Inventory planningThe push system pushes the resources in to manufacturing based on resource planning. It is also more commonly known as the Materials Requirements Planning (MRP) system. This system is based on the Planning Department setting up a long-term production schedule which is then analysed to give a detailed production schedule for

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-72609142918604439652009-01-01T21:17:00.001+05:302009-01-01T21:34:07.842+05:30

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-27346079552447869732009-01-01T21:06:00.005+05:302009-01-01T21:14:40.314+05:30

When does the PO status shows as 'Pre- Approved'?Pre–Approved document is one in which a person with the final authority to approve the purchasing document approves it, but then forwards it to someone else for additional approval, thus changing its status to Pre–Approved.ORYour organization uses encumbrance budgeting (reserves funds for documents), and the purchasing document is eligible for

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-23044606875408763992008-12-30T22:21:00.002+05:302008-12-30T22:31:20.236+05:30

List all the implementation steps for Oracle eAM module ?1) Setting Up Organizations2) Enabling Organizations for Enterprise Asset Management3) Defining eAM Parameters4) Setting Up Areas5) Defining Departments and Resources6) Defining Department Approvers7) Defining Miscellaneous Documents8) Defining Lookups including - Activity Types- Activity Causes- Activity Sources- Asset Activity Priorities-

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-18803980580311089872008-12-30T21:04:00.002+05:302008-12-30T21:08:58.302+05:30

Which responsibilities are automatically created during installation process of EAM ?When installing Oracle Enterprise Asset Management, the installation process automatically creates the following five responsibilities:a) Oracle Enterprise Asset Managementb) Maintenance User Workbenchc) Maintenance Super Userd) Self-Service Work Requestse) Self Service Time and ExpensesThe 'Oracle Enterprise

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-78151236368436976622008-12-30T21:00:00.002+05:302008-12-30T21:02:40.091+05:30

Which are pre-requisites for installing EAM module ? a) Configuring Concurrent Managers and Printersb) Set up Responsibilities and assigning responsibilities as per requirements c) Setting up Workflow module if work request(s) require approval from a maintenance department user

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-39521028152574404972008-12-30T20:54:00.002+05:302008-12-30T20:58:57.834+05:30

To work with EAM, which are the Mandatory and Optional Oracle Applications modules/products?Mandatory modules are a) Inventoryb) Bills of Materialc) Cost Management d) Work in Processe) Manufacturing Schedulingf) Qualityg) Human ResourceOptional modules area) MS/MRP b) Fixed Assetsc) Oracle Financials modulesd) iProcuremente) Purchasingf) Order managementg) Oracle Projectsh) Property Manageri)

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-71662176987410128302008-12-29T21:49:00.004+05:302008-12-29T21:55:01.715+05:30

What is a kit ? How does it differ from PTO ? A kit is a PTO item which consists of a standard list of mandatory components (or included items) i.e standard bills of material which you pick, pack and ship when you process a customer sales order for that item. A kit is similar to a pick–to–order model because it has shippable components, but it has no available options to choose like PTO model and

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-9202720587892138012008-12-29T21:42:00.002+05:302008-12-29T21:47:51.669+05:30

What is Configure to order (CTO) ? It is a method of manufacturing which allows you, or your customer, to choose a base product at the very moment of ordering and then configure all the variable parameters (features) associated with that product from defined/available options. Based on these selections, configurable items on each quote or order typically generates the unique product configuration

OracleOnDemandnoreply@blogger.com2tag:blogger.com,1999:blog-9178719986090691034.post-23770697500749125902008-12-29T21:29:00.002+05:302008-12-29T21:40:11.165+05:30

What is Pick to Order (PTO) ?It is a configure-to-order environment where the options and included items in a PTO model (finished good) appear on pick slips after you receive the sales order from customer. Pickers gather the options (based on selection rules), the predefined shippable products parts/components or service from their predefined locations using pick slip and then ship the order. It

OracleOnDemandnoreply@blogger.com2tag:blogger.com,1999:blog-9178719986090691034.post-37689762773608041712008-12-29T21:06:00.003+05:302008-12-29T21:26:55.808+05:30

What is Assemble-to-Order (ATO) Manufacturing ? ATO simplifies the process of manufacturing finished goods. These goods are standard products and are often configured by customers from Bills of material, where you can define available options for unique product configurations. Based on forecasting, subassemblies are manufactured prior to receiving the customer order and when the order is received

OracleOnDemandnoreply@blogger.com2tag:blogger.com,1999:blog-9178719986090691034.post-43414616496317593132008-12-28T23:45:00.002+05:302008-12-29T00:13:02.939+05:30

What are aims, objects and benefits of Oracle Enterprise Asset Management (EAM) module ?1) An asset is an entity for which users can report problems. Assets can be cooling towers, cranes, buses, buildings, conveyors, or anything that needs work.2) eAM creates and implements maintenance procedures for both assets and rebuildable Inventory items and takes care of comprehensive and routine

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-74535017405738144322008-12-28T23:12:00.003+05:302008-12-28T23:39:31.220+05:30

Which are different types of discrete jobs ?There are 2 types of discrete jobs 1) Standard and 2) Non-StandardNon Standard discrete jobs are further devided in to Non standard Asset jobs and non-standard expense jobs. Standard discrete jobs control the material, resources, and operations which are required to build an assembly and collect its manufacturing cost.Some comparison is done as below:1)

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-22405968524435792212008-12-28T23:03:00.003+05:302008-12-28T23:09:12.446+05:30

Which are the different methods for creating Discrete jobs in Oracle WIP ?You can create discrete jobs in the following ways:a) Manually (both standard and non-standard discrete jobs)b) Manually from a simulation of job (standard discrete jobs only)c) Automatically using Oracle MRP module to plan your standard discrete production requirementsd) Automatically using Advanced Planning and Scheduling

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-23237512459121139472008-12-28T22:43:00.002+05:302008-12-28T22:57:21.574+05:30

When I link a sales order to a job in the Discrete Job screen, after I complete this Discrete Job I have my Finish good item reserved in a "Subinventory 1", but I need to transfer it to "Subinventory 2", but I can't transfer because the material is reserved. I use 2 subinventories because one is for inspection and the second is the Sales Subinventory. What should I do?You may set the Profile

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-24573578906639305072008-12-28T22:31:00.003+05:302008-12-28T22:40:01.669+05:30

What is a Scheduled Group ?A schedule group is group of flow schedules and discrete jobs which can be sequenced for the purpose of giving priority. Schedule groups are defined in the Define Schedule Groups window and can be optionally assigned to jobs, in the Discrete Jobs window, or to Flow schedules, in the Line Scheduling Workbench Options window. The schedule group assigned in the Line

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-35576668104723437932008-12-28T22:10:00.002+05:302008-12-28T22:29:30.516+05:30

What are shop floor statuses in Oracle WIP ?You define shop floor statuses in WIP and assign these statuses to intraoperation steps of the work in process routing operations. Shop floor statuses can be used to control/stopping shop floor move transactions due to various reasons. For example there could be some quality problem in the materials being used in manufacturing. You can view these

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-86091790458430857712008-12-28T11:15:00.005+05:302008-12-28T11:59:05.816+05:30

What is WIP accounting class ?Which are different accounting classes in WIP ? Which different accounts are associated with it ? An accounting class is a group of various General Ledger accounts which allows you to arrive at job cost, production cost and maintenance costs.The following are different accounting classes in Oracle WIP:1) Standard discreteStandard discrete accounting classes can be

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-91561010841301909142008-12-27T00:04:00.002+05:302008-12-27T00:12:53.525+05:30

Explain the field 'Respond to sales order changes' in Oracle WIP parameters ?This field is applicable to configure-to-Order (CTO) sales orders and their related discrete jobs. It determines whether and how the system responds to changes to CTO sales orders and their linked and reserved discrete jobs/work orders (Both standard and Non-standard).You can set the following options if a configured

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-10219029061238184532008-12-26T23:50:00.003+05:302008-12-26T23:57:44.101+05:30

What are intraoperation steps in Oracle WIP ?There are 5 intra operation steps in WIP. The options are Queue, Run, To Move, Reject and Scrap. You can select intraoperation steps in WIP parameters by checking check boxes. It determines which intraoperation steps are enabled in WIP routing operations. The 'Queue' intraoperation step is automatically enabled for all operations and it cannot be

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-43101717861073406742008-12-26T23:32:00.002+05:302008-12-26T23:42:39.193+05:30

What is Assemble-to-Order(ATO) Manufacturing ?You can define available options in Bills of Material for unique product configurations. You can master schedule models and options and then create work orders to build these unique product configuration in WIP while maintaining control of inventory, planning and cost accounting. Bills of Material, WIP and Order Management/Shipping modules support

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-5685321151196825532008-12-26T23:10:00.002+05:302008-12-26T23:22:05.256+05:30

What is Flow Manufacturing ?Flow Manufacturing is an innovative manufacturing method which synchronizes production with customer demand. The characteristics of flow processes are:a) Straight and short product flow patternsb) Make to order strategyc) Single-piece productiond) Just-In-Time materials/pull/dependent demand schedulinge) Short production cycle timesf) Highly flexible and responsive

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-39572007278435872812008-12-26T23:00:00.003+05:302008-12-26T23:22:45.188+05:30

What is Project Manufacturing ?Large contracts or projects received by the companies can not be completely fulfilled by process manufacturing or disrete or repetitive manufacturing methods. It requires a separate manufacturing method known as project manufacturing. Project manufacturing meets demand driven production requirements for large contracts or projects. It allows you to plan, schedule,

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-75934821053524970022008-12-26T12:02:00.005+05:302008-12-26T12:27:27.230+05:30

Explain move transaction parameters in Oracle WIP?a) Require Scrap AccountThis check box determines whether a scrap account is required when you use the Move Transactions window to move job and repetitive assemblies into and out of the Scrap intraoperation step of an operation. It also determines whether a scrap account is required when flow schedule assemblies are scrapped or returned from scrap

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-31853800521894124622008-12-25T00:06:00.002+05:302008-12-25T00:15:33.678+05:30

Which parameters affect backflush Transactions?a) Supply Subinventoryb) Supply Locatorc) Lot Selection Methodd) Alternate Lot Selection Methode) Lot Verificationf) Release Backflush Componentsg) Allow Quantity Changes During BackflushHow lot numbers are assigned to discrete jobs?a) By Job Name: Lot numbers are based on the job name you enter when you define the job. This is the default.b) Based

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-25613734648222378972008-12-24T23:10:00.003+05:302008-12-24T23:25:10.356+05:30

What is meant by backflush? When exactly backflush happens? How can we detect that backflush is happening?In Bills of Material module when you create a bill for any assembly or sub assembly or a finished good, you define component supply type for each component in a bill. These supply types are push, operation pull, assembly pull, Bulk, vendor/supplier, phantom etc. This Bills of material is

OracleOnDemandnoreply@blogger.com5tag:blogger.com,1999:blog-9178719986090691034.post-79613345956304417022008-12-23T12:37:00.002+05:302008-12-23T12:44:08.798+05:30

Workflow Backgroud Process parametersWhat is Process Deferred =Yes, Process Timed Out= No ?When the Workflow Engine initiates and performs a process in any Oracle applications module, it completes all necessary activities before continuing to the next eligible activity. In some cases, an activity being processed may require a large amount of processing resource or time to complete. Workflow

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-31054840836170630692008-12-21T22:36:00.003+05:302008-12-21T23:07:59.047+05:30

Describe WIP related Item attributes ?a) Build in WIPIf you check this attribute, it indicates whether to create discrete jobs or repetitive assemblies in Work in Process module. This attribute must be turned off if the Inventory Item attribute is turned off or if the BOM item Type attribute is not set to Standard. You can not manufacture any item if item is not an inventory item and BOM item

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-39704096672057928932008-12-20T19:24:00.001+05:302008-12-20T19:25:47.923+05:30

Menswear brand Turtle has selected Oracle e-Business Suite R12 (Oracle Applications) to manage its operations in IndiaOracle Financial Services Software (formerly known as i-flex solutions), a majority owned subsidiary of Oracle, on Wednesday announced Saudi Home Loans (SHL), the first fully specialized Islamic home finance company in the kingdom of Saudi Arabia, had gone live on Oracle

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-23071440723235987062008-12-20T16:05:00.004+05:302008-12-20T16:22:42.867+05:30

Member of the Month - December 2008Pleased to announce that Vidyutkumar Desai is applearn 'member of the month' for December 2008. Vidyutkumar is a Bachelor of Textile Technology and DMS (Diploma in Management Studies). With core expertise in Oracle Supply Chain and Manufacturing modules - Inventory, Purchasing, Order Management, Shipping, Bills of Material, Engineering, Work in Process, MS/MRP,

OracleOnDemandnoreply@blogger.com6tag:blogger.com,1999:blog-9178719986090691034.post-44462852775700777902008-12-20T14:31:00.005+05:302008-12-20T15:33:40.243+05:30

Explain the concept of Supply types in Oracle WIP? Describe each supply type in detail?Supply types decides the method of supplying component materials to discrete jobs and repetitive schedules in WIP module. It also controls how materials are planned in MS/MRP module and how materials are costed in Cost Management module.You can assign supply types to the items when you define in Inventory

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-79183361357530452992008-12-18T22:07:00.003+05:302008-12-18T22:19:49.236+05:30

Why do you need to define WIP parameters?You can use WIP parameters to define modes of operation and to assign default values for various work in process functions. You can only define one set of WIP parameters per inventory organization.Which are optional implementation steps for WIP?Define Production LinesDefine Repetitive AssembliesDefine Scheduled GroupsDefine EmployeesDefine Employee Labor

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-45666497174116190852008-12-18T00:51:00.004+05:302008-12-18T01:07:43.843+05:30

What is Process Manufacturing?Process manufacturing is different from Discrete manufacturing.Manufacturing is not in discrete batches but is a process of pressing/mixing/chemical processing/heating/boiling liquid/semi liquid/solid and powder or raw materials. Once you manufacture a product by using process manufacturing, the output can not be brought to it's original basic form. For example

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-47472326834461801092008-12-14T11:59:00.004+05:302008-12-14T12:10:05.589+05:30

Which are different manufacturing strategies?There are 4 manufacturing strategiesa) Make to stock(MTS)b) Make to Order(MTO)c) Assemble to Order(ATO)d) Engineer to order(ETO)In MTS, stock is created by companies for items without receiving an order from customer. Examples are manufacturing of refrigerators, washing nachines and Television sets. They are manufactured in a flow shop based on master

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-88593557322141178152008-12-13T10:44:00.002+05:302008-12-13T10:52:14.071+05:30

What is Discrete Manufacturing? 1) Discrete manufacturing is a manufacturing process in which distinct items/products(which you can easily count, see and touch) are built or manufactured in discrete batches on manufacturing floor. It creates physical products which go directly to business and consumers, and assemblies that are used by other manufacturers. The resulting

OracleOnDemandnoreply@blogger.com2tag:blogger.com,1999:blog-9178719986090691034.post-90526850884270207132008-12-06T23:17:00.003+05:302008-12-06T23:47:59.626+05:30

1) Which are required steps in Inventory module set up? Answer: a) All the 6 key flexfields i.e Items, Item Catalog, Account Alias, Sales Order, Locator and Item Category b) Organizationsc) Change Organizationsd) Intercompany Relationse) Unit of Measure Classesf)Subunventoriesg)Item Attribute Controls, Categoriesh)Default Category seti)Item Statusesj) Cost typesk)Profile Optionsl)Inventory

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-24343520216737526602008-11-29T15:05:00.007+05:302008-11-29T15:51:21.884+05:30

Defining Purchasing OptionsPurchasing Options window is used to define default values and controls for functions in Oracle Purchasing. You can often override purchasing options when you are creating documents. Defining Purchasing Option is required step to use Orale Purhasing.NavigationPurchasing Responsibility=> Setup=> Organization=>Purchasing OptionsThere are 6 tabs in purchasing options as

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-88145139730403272712008-11-27T12:32:00.000+05:302008-11-27T00:46:23.534+05:30

Oracle Order Management and Shipping Execution provides line status to best reflect the stage of the process for the order line and delivery line.Line statuses can be seen in the 'status' field of the 'Line Items' Main tab in the Sales Order form. It can also be noted from the Shipping transaction form. Below are the most commonly observed line statuses and what they mean:Awaiting Shipping: Order

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-39018127123585043662008-11-22T13:20:00.004+05:302008-11-27T00:41:55.372+05:30

Serial Controlled ItemsA Serial Number is a unique number assigned to each discrete unit of an item that is stored in inventory. A serial number can also be defined as a set of characters that uniquely identifies a single unit and can be used for traceability and warranty purposes.Serial numbers are valuable in quality control, as once a defect is found in the production of a particular batch of

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-21998533900347721022008-11-18T00:27:00.002+05:302008-11-18T00:36:07.979+05:30

Accrual Basis vs Cash Basis Accounting for Non AccountantsThere are two basic accounting methods available in business - Cash or Accrual.With the cash method of accounting, income is recorded only when you receive cash from your customers. You record an expense only when you write the check to the vendor.With the accrual method, income is recorded when the sale occurs, whether it be the delivery

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-44924891544749574712008-11-16T23:40:00.003+05:302008-11-16T23:49:29.446+05:30

Oracle Purchasing Setup ChecklistPlease refer to above setup checklist which show the steps out of which some are Required and some are Optional. Required Step With Defaults means that the setup functionality comes with seeded default values; however, you should review those defaults and decide whether to change them to suit your business needs.For more details, it is recommended to refer Oracle

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-32689856907720479292008-11-15T21:53:00.003+05:302008-11-15T21:57:48.663+05:30

Oracle General Ledger (OGL) Oracle Financial comprises of the following core Finance Modules:1) General Ledger2) Accounts Payable3) Accounts Receivables4) Fixed Assets5) Cash ManagementOracle General Ledger (OGL) is accounting back bone for Oracle Financial Modules. It is the central repository of all financial transactions and can be called as the heart of the accounting system. OGL is a tool

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-69873855806549191792008-11-15T11:11:00.003+05:302008-11-15T11:21:16.429+05:30

Member of the Month - November 2008Please to announce that Saravanan Rajamanickam is our 'member of the month' for November 2008. Saravanan is a Chemical Engineer and completed his MBA from UK.With core expertise in Oracle Supply Chain modules, his contribution to applearn community has been very helpful. Saravanan likes to read history, especially about great leaders; likes to watch & play

OracleOnDemandnoreply@blogger.com4tag:blogger.com,1999:blog-9178719986090691034.post-74887117383404542312008-11-12T22:37:00.002+05:302008-11-12T22:40:57.140+05:30

Oracle Purchasing - Interview Questions1. Can we automatically 'Close' the Purchase order without receiving the full quantity?2. When does a Purchase Order line get the Status 'Closed for Receiving'?3. What is the difference between the control actions 'On Hold' and 'Freeze' for a Purchase order?4. What are the different document statuses used in Oracle Purchasing?5. If a Purchase Order/

OracleOnDemandnoreply@blogger.com6tag:blogger.com,1999:blog-9178719986090691034.post-66386697259931979662008-11-11T00:38:00.003+05:302008-11-11T01:01:16.329+05:30

Did you know that Oracle Purchasing also has to choose the approver to whom it has to forward the approval notification?If Position Hierarchy is used and two employees are attached to a particular position, then the application will select the forward-to person based on alphabetical name order.Below is an example for better understanding.Albert Christopher (Clerk) and couple of more clearks

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-52418289072314184292008-11-08T01:09:00.004+05:302008-11-08T16:03:29.817+05:30

WIP Parameters - Lot Selection MethodLot Selection Method appears under the backflush default parameter and affect backflush transactions. Determines how lot controlled Assembly Pull and Component Pull component items are selected during backflush transactions.User can select from any of the below options:1. Expiration Date2. Manual3. Receipt Date4. Transaction HistoryThis parameter does not

OracleOnDemandnoreply@blogger.com4tag:blogger.com,1999:blog-9178719986090691034.post-69181246512513533592008-11-06T12:06:00.003+05:302008-11-08T16:03:29.818+05:30

Physical Inventory Adjustments for Reserved ItemsWhile performing Physical Inventory activities using Oracle Inventory, user performs the following steps:1. Physical Inventory setup to define tolerances, subinventories etc.2. Physical Inventory snapshot3. Tag generation4. Tag count entry5. Approve Physical Inventory6. Post Physical Inventory adjustmentsWhile approving the physical inventory, user

OracleOnDemandnoreply@blogger.com3tag:blogger.com,1999:blog-9178719986090691034.post-86671345808451706582008-11-02T07:56:00.002+05:302008-11-08T16:03:29.819+05:30

Oracle WIP - Questions1. Client wants to put the WIP job on hold whenever the related Sales Order demand is cancelled. How to achieve this?2. What is assembly pull and operation pull?3. Where do we define the supply subinventory/locator for backflushing? 4. Client wants to backflush all the lot controlled items based on FIFO (First in, First Out). How to meet this requirement?5. Client wants to

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-35454276597726620622008-10-31T00:42:00.003+05:302008-11-08T16:03:29.820+05:30

Discrete and Repetitive ManufacturingThere are two basic kinds of factory layouts: the flow shop and the job shop. In a flow shop, the machines are set up and the floor is laid out so that items flow uninterrupted from one operation to the next, hence the name. An assembly line is the standard example for a flow shop. In a job shop, the movement between operations is not as seamless; there may be

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-1860748858876118762008-10-30T01:20:00.003+05:302008-11-08T16:03:29.821+05:30

Key Profile option in Order ManagementOM: Discounting PrivilegeThis profile option provides the choice of controlling user’s ability to applydiscounts on an order or order line.Either of the below 3 values can be selected for the profile optionFull:Ability to apply any valid discount against an order or order line, as long asthe order type of the order does not enforce list prices (Default value)

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-54709188266030327172008-10-28T11:52:00.000+05:302008-11-08T16:03:29.821+05:30

Business processes revolve around routing information through various users through set of constantly changing rules. The flow of information is governed by various conditions and checking for outcome of previous steps. An established process of routing will be subject to continuous monitoring and rounting. Each organization follows a different set of business practices.Workflow gets the right

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-13462984685265668302008-10-28T11:35:00.003+05:302008-11-08T16:03:29.822+05:30

Business processes revolve around routing information through various users through set of constantly changing rules. The flow of information is governed by various conditions and checking for outcome of previous steps. An established process of routing will be subject to continuous monitoring and rounting. Each organization follows a different set of business practices.Workflow gets the right

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-19449315255512818902008-10-27T00:48:00.003+05:302008-11-08T16:03:29.823+05:30

If a single function is attached to a inventory organization sensitive function such as subinventory transfer (in Inventory), please beware that the function would open in a wrong inventory organization. This might result in user entering transactions in wrong inventory organization.For example, User "A" is attached to 3 Inventory responsibilities - "INV User X", "INV User Y" and "INV User Z".

OracleOnDemandnoreply@blogger.com0tag:blogger.com,1999:blog-9178719986090691034.post-85451382546037382642008-10-21T11:30:00.002+05:302008-10-21T11:46:59.498+05:30

Hello Friends,Recently BearingPoint announced the sucessful deployment of Demantra at renowned wireless manufacturer 'Kyocera', the San Diego, California- based company. Looking at the growing interest in Demantra, applearn team is looking for 'Demantra' professionals who would help us all understand the basics, how it integrates & fits in the E-business suite. If anyone from you have either got

OracleOnDemandnoreply@blogger.com1tag:blogger.com,1999:blog-9178719986090691034.post-39412127249004098672008-10-03T00:51:00.000+05:302008-11-08T16:03:29.824+05:30

Costs of items can be shared across organizations using standard costing. This is a unique feature of Standard Costing method.If standard costs are shared across multiple organizations, costs are maintained by the cost master organization and shared by the child cost organizations. Costs cannot be entered into the child cost organizations. All reports, inquiries, and processes use the shared

OracleOnDemandnoreply@blogger.com2