Oracle e-Business Consultancy Handbook

This second edition of the book includes ALL the SQL Queries available in the hard copy book.

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.