ORACLE APPS MANUFACTURING TRAINING CURRICULUM

TRAINING AVAILABLE FOR ORACLE APPS TECHNICAL

ORACLE APPS MANUFACTURING CURRICULUM

ORACLE INVENTORY

* Item Master
* Item definition thru Item-type templates
* Setups
* Cross-references
* Multi-Org
* UOM
* Master Organization ~ Child organization setups
* Item
* DFFs Descriptive Flex-Fields with-out /with Value-sets
* KFFs Key Flex-Fields
* Item revision tracking & setup
* Manufacturing Part Number MPNs
* On-hand inventory
* Physical Counting ~ tagging ~ Inventory adjustments
* Material Transactions
* Issues thru Move-Orders
* Miscellaneous Issues / Miscellaneous Receipts
* Item categories / Item sub-inventories
* Report & Requests

ORACLE BILLS OF MATERIAL (BOM)

* Bills of Material Multi-level Multi Org
* BOM Explosion Indented Bills
* BOM Implosion Item Where Used
* Bills copying
* Bills / Items / Routings deletion using Delete Groups
* Reference Designators
* Bills comparisons
* esources
* Departments
* Routings
* OSP Bills / Manufacturing Bills
* Primary Bills & Alternate Bills
* Concepts of Back-Flushing
* Product Costing
* Setups
* Reports & Requests
* Attachments
* Creating BOM Matrix

ORACLE ENGINEERING (ENGINEERING CHANGE MANAGEMENT)

* ECO
* Engineering Item Master
* Prototypes
* Engineering BOM
* Engineering Routing
* Set ups
* ECO Integration with BOM & Oracle Inventory
* Inventory
* ECO Form Customization Using DFFs
* ECO Life Cycle Mgm.
* ECO Implementation
* ECO Cancellation
* ECO Integration with Work Flow

ORACLE WIP (WORK IN PROCESS)
* Discrete Job Orders
* Materials Requirements
* Move Transactions
* WIP Transactions
* Job Completions
* Closing Discrete jobs

ORACLE QUALITY
* Quality Control Plans
* Collection Plans
* Collection Elements
* Setups
* Quality Results
* Quality Data Analysis
* Quality Online Reports

List of PLSQL Web site

List of PLSQL Web site:

http://otn.oracle.co.kr/docs/oracle78/main.htm
http://asktom.oracle.com/pls/ask/f?p=4950:1:
http://www.cse.unsw.edu.au/~cs9804/Oracle/faq.html
http://www.engin.umich.edu/caen/wls/software/oracle/server.901/a90192/ch06.htm#1007544
http://www.orafaq.com/faq2.htm
http://certification.about.com/gi/dynamic/offsite.htm?site=http%3A%2F%2Fwww.oraclefans.com
http://www.oreilly.com/catalog/orsqlpluspr2/chapter/ch01.html
http://www.dbaoncall.net/index_files/index_oracle.html
http://www.oreilly.com/catalog/orsqlloader/chapter/ch01.html
http://www.arikaplan.com/oracle.html
http://www.oracletuning.com/
http://www.techonthenet.com/oracle/functions/index.htm
http://www.dbatoolz.com/scripts_desc.htm
http://www.ss64.com/orasyntax/functions.html
http://www.jusungyang.com/ORACLEfolder/PLSQL.html
http://www.engin.umich.edu/caen/wls/software/oracle/appdev.901/a89856/07_errs.htm
http://www-db.stanford.edu/~ullman/fcdb/oracle/or-plsql.html#basic%20structure%20of%20pl/sql
http://www.unix.org.ua/orelly/oracle/advprog/
http://www.techonthenet.com/Oracle/
http://www.csee.umbc.edu/help/oracle8/server.815/a67792/ch05.htm#1272
http://www.comp.nus.edu.sg/~ooibc/courses/sql/sqlplus.htm
http://otn.oracle.co.kr/docs/oracle78/server71x/SVMSG/ch11.htm#toc127
http://www.csis.gvsu.edu/GeneralInfo/Oracle/appdev.920/a96630/sdo_objload.htm