Friday, September 27, 2013

Oracle Inventory: Material status Control

Materail Status Control allows to track status of materail along with movement of materail. Oracle allows to track materail status at following levels
     1. Lot
     2. Subinventory
     3. Item
     4. Locator

Following are important Setups to enable the tracking of materail status
  1. Define Materail Status
          a. Usage level:
          b. Type of Transactions allowed
  2. At Organization Inv Parameters enable the "Default On Hand Material status".
  3. If Inv Organization has onhand then it can be enabled by running
       "Activate Onhand Level Material Status Tracking"

R12 Features:
1. Separation of Responsibility for Materail Movement and Status Update.
2. Mutliple status of same lots in different Locators
3. Multiple status of different Lots in Same Locator

Notes:
1. Material movement doesnt change the Lot material status, one needs to update material status.

Sunday, September 15, 2013

Oracle Developer 10g: frm-18103:fail to initialize the development Environment

Installed Oracle Developer 10g on windows machine (win 7), all the installation was successful. Now when I click on any Developer tools its not opening
   1. Oracle forms fails with error and doesn’t start
        "frm-18103:fail to initialize the development Environment"
  2. Oracle reports fails to start

Issue:
Oracle Developer 10g though installed successfully it messed up with Oracle Home setting on your machine. The path in ORACLE_HOME environment variable is not correct and its causing all the Developer tools to fail from starting.

Solution:
You need to correct the ORACLE_HOME environment variable
 1. Navigate to Computer>Properties>Advanced System settings> go to Advanced Tab>Environment Variables
2.  Check the path in ORACLE_HOME User variables, if no ORACLE_HOME variable creates one.
     The path should look like this
           C:\DevSuiteHome_1