This course covers some primary functionality of the core manufacturing application modules (see list below) and the subsequent flow of data through the major database tables. Given the course audience, Information System Professionals, this course is more functional than technical in nature. It includes functional coverage of much of the material also included in the application technical reference manuals. This course provides a summary of the applications tables in functional order, allowing the technical student to become more efficient at resolving user requirements such as forms customization, data conversion, or extensive reporting requirements.
A typical scenario for this course is as follows: the instructor will demonstrate and describe a manufacturing function such as entering a bill of material (Oracle Engineering functionality). This is followed by a detailed discussion of an entity relationship diagram depicting the database table relationships involved in bills of material entry. Finally, the student is asked to demonstrate their understanding by executing a SQL script to locate a particular bill of material, and answer specific questions, related to the database tables, with regard to that bill of material entry. The functionality of the following modules are covered: Oracle Inventory, Oracle Bills of Material and Engineering, Oracle Cost Management, Oracle Order Management, Oracle Work in Process, Oracle Material Requirements Planning, Oracle Quality, and Oracle Purchasing, with 50 entity relationship diagrams presented and discussed.
Learn to: |
