This book is based on my experiences as a consultant over a period of thirteen years, the first four of them working for Oracle. In those years I had the titles Manufacturing and Financials Consultant on different sites. The essays in this book are largely designed to cover the more complex areas of the system, including intercompany and internal sales orders, outside processing and consignment stock. They also cover procedures which may be needed in every factory - how to check stock, or how to investigate stock losses. The SQL scripts to give easy-to-use reports which can be downloaded into Excel. So many Oracle reports are difficult to use, especially where there is a lot of data. The SQL scripts also deal with the problems which occur after a site has gone live, such as clearing up ahead of the inventory monthend. Some queries, notably in BOM and Routing, validate data.This sets off a concurrent request. If you want to move items about between classes etc, you can do this manually by pressing Update Items on the Assignment Groups screen. Note that an item can change its class each time a compile is run (say because there have been new transactions and new items added); it is not fixed in any way, unlike an item attribute. Create Cycle Count The next thing to doanbsp;...
|Title||:||Oracle e-Business Consultancy Handbook|
|Publisher||:||Lulu.com - 2012-04-01|