Monthly Archives: June 2011

Oracle ASCP and VCP – Advance Supply chain and Value chain – Presentation


 

Oracle ASCP – Oracle Advanced Supply Chain Planning – Overview


Attending Advanced Supply Chain Planning module’ training so putting few topics and as i will do more hands on , will put more.

Oracle Advanced Supply Chain Planning enables you to run holistic plans that span long term aggregate planning to short term detailed schedules, multiple manufacturing processes (lot based, process, discrete, configure-to-order, and project based), and all organizations across a virtual supply chain. As a single solution for distribution, supply chain, and manufacturing planning, it is based on one supply chain model, one planning engine, and one setup.

Oracle Advanced Supply Chain Planning considers key requirements for a broad range of industries.

For example, for Process the tool supports complex network routings, contiguous operations, resource charges, process effectivity, minimum transfer quantities, fixed and integer ingredient scaling, alternate ingredients, resources, processes, suppliers, facilities, and ship methods, alternate recipes and formulas, co-products and by-products, end item substitution, sequence dependent setups/changeovers, and batch production support (OPM
integration).

For High Technology, including Semiconductor, the planning tool supports alternate components, resources, processes, suppliers, facilities , and ship methods, end item substitution, sequence dependent setups/changeovers, critical items/resources and aggregate resources, lot-based jobs support (OSFM Integration), operation yield, simultaneous product family and item level planning, complex network routings, co-products and by-products, binning, multi-level configure-toorder models, and planned inventory points.

For project-based and Aerospace and Defense companies, the tool supports key capabilities such as project group netting, hard and soft pegging, borrow-payback, project demand and supply views, contract pegging, cross-project allocations, project excess netting, and project specific exception messages.

will publish more useful and ready to learn articles soon… keep learning and keep sharing

Special benefits for Readers and followers -


With great success , Now I am proposing to give you direct benefits from my side.

Benefits:

  • One to One session for your queries , regarding anything technical, functional, business or career related discussion
How to get that: follow below steps
1. Register your email with blog
2. Spread awareness about blog among your friends and collegue.
3. Leave a comment on this article with your name , city,country and brief introduction.
I will surely select 2-3 people every week to do one-2-one session. I will use Direct Phone ( in India, UK, US and canada ) , for rest of countries, I will use Skype or Gtalk. I also use WebConferencing tools if needed.
Let’s join in and keep knowledge flowing… cheers – Shiv

Oracle Support – Metalink – An Overview


What is My Oracle Support?
My Oracle Support provides personalized, proactive, and collaborative support across all Oracle products.

HTML OPTION 
What features are included in the My Oracle Support HTML option?
HT:

  • SR management, including the ability to create and update SRs, attachments, and configuration association
  • Browsing and searching the knowledge base
  • Patch search and download
  • My Oracle Support Communities
  • Certifications and Product Roadmap
  • Favorites
  • User administration
  • Hot Topics
  • Bug summary
  • SR management reports
  • CRM On Demand SR Create
  • Knowledge Searches

The following features are available only in the Flash version of My Oracle Support:

  • Systems
  • Projects
  • Healthchecks
  • Patch Advice and Recommendations
  • Inventory Reporting
  • On Demand Portal Functionality
  • CRM On Demand Service Requests and Knowledge

for more and detail help – https://support.oracle.com/CSP/ui/faq.html

 

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=733241.5

 

 

 

 

 

 

How to enable the attachment button/menu to form


To enable the attachment button/menu to form INVTOMAI perform the following steps..

 

Connect to Oracle Applications with the Application Developer responsibility
1. > Select Document Entities
FORM: ‘Document Entities’

Create a new record and fields should be filled in as below:
Table: MTL_TXN_REQUEST_HEADERS
Entity ID: MTL_TXN_REQUEST_HEADERS
Entity Name: Move Order
Prompt: Move Order
Application: Oracle Inventory
Save and Close Form.

2. > Select Attachment Functions
FORM: ‘Attachment Functions’
Create a new record and fields should be filled in as below:
Type: Select ‘Form’
Name: INVTOMAI
User Name: Move Orders
Save and Close form (Step 4 returns to this form to complete remaining settings)
.
3. > Select Document Categories
FORM: ‘Document Categories’
Create a new Category Record

Create a new record and fields should be filled in as below:
Category: Move Order
Default Data Type: (need to select from list)
From: Select the current date from calendar
To: leave blank
> Click on the Assignments Button
FORM: Category Assignments
Fields should be filled in as below:
Type: Form
Name: Move Orders
Format: leave blank
Enabled: Selected

Save. Close both forms.

4. > Select Attachment Functions
FORM: Attachments Functions
Query up the previously made Record (Using the Name or User Name field) The remaining fields should be filled in as below:
Session Context Field: Optional, leave blank
Enabled: Selected

> Click on the Categories Button

Category should be ‘Move Order’ and should be enabled.
Save and Close Form

>Click on Block Button
FORM: Block Declaration

Fields should be filled in as below:
Block Name: TOMAI_MAIN_HEADER_BLK
Method: Select ‘Allow Change’
Secured by: Select ‘Organization’
Organization: TOMAI_MAIN_HEADER_BLK.ORGANIZATION_ID
Context 1: TOMAI_MAIN_HEADER_BLK.REQUEST_NUMBER
(leave all other fields blank)

> Click on the Entities Button
FORM: Entity Declaration

Fields should be filled in as below:
Entity: Move Order
Displayed Method: Select ‘Main Entity’
Include in Indicator: Selected
Query: ALWAYS
Insert: ALWAYS
Update: ALWAYS
Delete: ALWAYS

> Tab to ‘Primary Key Fields’ Tab
Key 1: TOMAI_MAIN_HEADER_BLK.HEADER_ID

Save and Close all forms

Now switch responsibility to ‘Inventory’ and navigate to
‘Move Orders –> Move Orders’ and you can see the attachment button/menu enabled.

Top Referred Articles on KnowOracle


Data flow for Order-to-Cash cycle
How to insert & character or special character into Database using SQL*Plus.
Oracle A.I.M. Methodology – template list
Oracle Reports (Report 6i) – Technical – Interview – Question Answers
Oracle General Ledger – Functional Interview Questions
Useful AR Tables Informations
Oracle PL/SQL – Calculating Weekdays between two dates
Oracle Applications – Interview Questions (All Modules)
Form Personalization in Oracle Applications
AutoInvoice Program Overview in Oracle Applications – Receivables
Oracle Forms Development (Developer 2000): Part 2
Oracle Payables Useful Tables
Accounts Payable Trial Balance – Reconciliation with GL
Trace a Concurrent Request And Generate TKPROF File
How to use attachments in Oracle Applications?
Oracle Fixed Assets Useful Tables
AR Interview Questions – Technical and Functional
Oracle Forms Development (Developer 2000) : Part 1
Oracle Application – Top useful SQL Queries
Interview Questions for Oracle 11i Apps (Manufacturing)
Oracle General Ledger – Tables
Oracle Financials Accounting – Interview Technical Fucntional Questions
UNIX / Shell Programming Basic – Beginner Questions Answers
Oracle BI Publisher – XML Publisher – General Questions
Oracle Applications – Technical Interview Questions
Oracle Technical Interview Questions and Answers : SQL based questions
Excel output directly from Oracle Application Concurrent Request Output
Oracle Application – General Interview (Technical – Functional Questions)
Shell Script Tutorial for Oracle Applications
Oracle Purchasing – Purchase Order FAQ
Oracle Applications – FNDLOAD Utility
Oracle Receivables – FAQ , Interview Questions ( Functional & Technical)
FAQ on Oracle Workflow Background Engine
Oracle Applications / Financials – Functional Question on General Ledger – Budgeting
Setting up Invoice Approval Workflow
Oracle HRMS Functional Questions
Oracle Applications Documentation AIM Methodology
Oracle SQL / PLSQL Developer – Technical Question Answers – Part 5
Setting your Oracle Applications session: fnd_global.apps_initialize (org_id)
Oracle Applications FND Useful Tables
How to generate a delimiter in spool output (Excel .csv files)
Oracle Applications – Commonly Useful SQL Queries
Oracle Order Management – Technical – Table details
Oracle 11i Application Developer – Technical FAQ – Part 1
What is Oracle Apps (ERP)?
Oracle Timecard (OTL) Automation
Overview – Oracle Projects
Mostly asked questions in Account Payables Modules
Variable Input file handling in Oracle SQL*Loader
Working with CONCSUB
Back-to-Back Order – How to
Oracle 10g Cost Based Optimizer
Oracle & Iron Man – Great Combination
Oracle Applications – Basics – Part 1
Differences between Oracle Technical, Oracle Functional and Oracle Techno-Functional
Video Tutorial : Oracle SOA Suite
Mulitple Reporting Currency – MRC – In Oracle Applications
Oracle Projects Billing Interface with Oracle Receivables
Steps to change the Discoverer Session timeout
Oracle General Ledger and Budgeting
Oracle 11i Concept – Multi Org
Oracle User Management – Password Reset Functionality
Happy Festival Time and Year 2009
Hire to Retire Process Diagram (PDF)
Account Recievables – Conversion – Invoices
Oracle Database – Technical Questions Answers
Oracle Workflow – Tables Description and usage
Oracle Applications – development, customization, extension
Oracle iExpense- What are the tables involved in the credit card process?
Template Form in Oracle Applications
Oracle XML/ BI Publisher – Convert Custom Reports to Oracle Business Intelligence Publisher
Employee Directory in Oracle HRMS
Oracle Alerts – FAQ for Beginners
Oracle Property Manager – Introduction – Overview
Differentiates a Party and Customer
Oracle – OAF – Oracle Application Framework – OA Framework
Dale Carnegie – Golden Rules for Success
To create a customized folder in Oracle Applications
The Function Is Not Available Under The Responsibility
Video – Oracle JDeveloper Introduction
How To Identify Where An Expense Report Is In the Process
DataLoad with Oracle E-business Suites (Oracle Applications/ Financials)
Oracle 11i Application Developer – Technical FAQ – Part 2
Export a concurrent program and executable using FNDLOAD
Oracle AP – Payables Payment Selection Criteria
PLSQL – Basic and Advance Concepts
Oracle System Administration – Oracle Apps DBA – Application Developer
How to use in Oracle – Output files -Comma, Pipe, or Tab Delimited Output
Oracle 10g : Top 10 Oracle PL/SQL Performance Tips
Oracle Interview Questions – Oracle Forms – Custom Development – FAQ
Oracle Payables – Interview FAQ – Invoice Payment
KnowOracle – Top Documents – Most Read articles
Very Common Oracle Apps DBA Questions
Oracle AR -Difference between PARTY and CUSTOMER
Tips For Personalizing The E-Business Suite 11i Login Page (AppsLocalLogin)
Oracle Projects – Revenue Generations and Credit Memo Questions
Oracle AIM Methodology
How do you find or delete duplicate rows in a table?
Understanding Oracle SQL*Loader
Oracle Applications – Technical – Table Joins and structure
Oracle HRMS – Define Organization – Functional and Technical Overview
Oracle Financials – A Case Study
Oracle Receivables Accounting – Overview
Oracle iExpense – How To Enter Internet Expense Reports For Other Persons
Oracle Interview Questions With Answers
Oracle Application – A Brief Introduction
Basic Unix Vi editor command
Oracle ADF Oracle Application Development Framework
Oracle Technical – Improve Import/ Export performance?
Oracle R12 Financials New Features Overview – By iWareLogic Team
Discoverer SQL: Long Running Discoverer Report
Oracle Database related Questions
Oracle Apps – Custom Reports Development & Customization Process
Oracle Applications – A Simple Way
11i Manufacturing Expert – Devendra Gulve
How to Review and Adjust Oracle Project Invoices
Shivmohan – Oracle 11i Multi Org – Definition
Oracle Project Intercompany Invoices to Payables
How to restrict functions and menus available to a user in menus
Few Easy and Common Oracle Apps Questions and Answers
Oracle – Technical FAQ – Part 1
Salary form in Oracle HR
Oracle XML Publisher – Presentation/ training
Oracle Application Workflows FAQ
How Does PO Approval Button Call the PO Approval Workflow
RDBMS Based Interview Questions
Oracle Apps EBS – Technical Common SQL/ Scripts for regular investigations
Difference Between Technical and Functional and Techno Functional
Run Posting (GLPPOS), or other concurrent programs from the Command line
Oracle Projects 11i & R12 – AutoAccounting – Concept & Overview
Oracle Order to Cash Queries
Oracle 11g – PL SQL – New features — Reference
Using Images in Oracle HRMS
Very Common Questions on Oracle SQL
Supplier Open Interface in 11i10 and family pack F
Create a menu function to launch a concurrent request , request group and a request set
Oracle HRMS Payroll Table Overview
WFLOAD – Oracle Workflow Loader utility
How To Customize Standard Oracle Application Using Custom Library – custom.pll
Oracle Workflow – Account Generator Process
How To Fix The Forms Timeout Issue In Oracle Applications 11i
Oracle HRMS- Employee Directory Video Demo
Oracle Insall Base and Service Contracts Overview
Oracle Order Management- Sales Order – Technical Overview
How to enable the attachment button/menu to form
What are the qualities of a good programmer ?
SQL to determine what request groups and concurrent program
Who sells the largest number of cameras in India?
Oracle Applications – FNDLOAD Usage
Oracle HRMS – Some Important Tables
Oracle Payroll Elements and Balances Tutorial
Overview of Concurrent Programs and Requests
Oracle – Technical FAQ – Part 4
Financial Accounting Basics for Oracle Applications
XML Publisher — BI Publisher — Training
How to Create a Link to a Discoverer Workbook in Apps11i
Oracle Apps – How to make a Form as READ ONLY
Shivmohan – Oracle Financials
Table level Data flow for Order to Cash Flow
Oracle Account Payables – Vendor Definition – Overview
How To Open A Worksheet Directly From Oracle Applications Menu ?
Oracle Application – AIM- Application implementation methodology
Oracle E-Business Suite Diagnostics Overview
Implementing ERP – Selection to Rolling out
Oracle Applications – R12 Approvals Management Engine – AME Training
Oracle Service Contracts Lifecycle Management
Oracle E-business Suite – Some thoughts
Eclipsys India in Pune – New Openings – Testing and Apps DBA
Few steps about complete Order to cash flow in Oracle Order Management
How To Add Workflow Worklist To EBusiness Suite Home Page
Oracle Technical – How to compile Oracle Apps Form
Oracle 11i AP – TE040 – Module Test Script
Oracle External Table
Sample PLSQL Code to Call Submit Program using FND_SUBMIT API
How To Make All The Responsibilities Read Only For A User
 Forms Personalization : How to Add a Web Link to the APPS Forms Menu
Oracle EBS – Where are the attachments stored when using the attachment feature within the Applications?
Oracle AP – Separate Invoice Entry and Approval
Removing ”^M” from SQL*Loader datafile
How to Find a Particular Scheduled Workbook’s Result Set Table in Discoverer
Oracle Virtual Private Database ( VPD ) and Label Security Concept
How to Compile Invalid Objects on APPS Schema For Packages & API
AP Invoices Associated with the Given Purchase Order Number
Distinction between configuration, personalization, and extensibility.
Oracle – Technical FAQ – Part 2
Min Max Planning in Oracle Inventory eBS R12
Profile Option values for all levels using SQL*Plus.
Oracle developer Interview tips
Useful Unix Utilities to Data File Management
Modeling of an Organization / firm in Oracle E business Suite
Oracle R12 Integration Architecture
Sample Example on How To Extract Worksheet IDs of a Workbook through Discoverer Desktop via the d51wkdmp utility
ERP Schools – Latest Articles Updates
Sample Example on Viewing Worksheet through Discoverer Plus via URL Link
Oracle EBS – Set the Applications Context (FND_GLOBAL.APPS_INITIALIZE)
‘Expenditure Organization Is Not Active Error’ When Entering Project Related Internet Expense Reports
How to force all Applications users to change their password at the next login?
How to find invalid invoice distributions for a ‘DIST ACCT INVALID’ hold
Oracle Apps Training: Initialize Apps
Oracle iExpense – Approval Limit
Oracle Application Framework OAF — introduction, more coming soon
SCM Process Overview – Supply Chain Management
How To Personalize Home Page With Expanding Menus?
How To Create Value Sets Where One Segment Is Dependent On The Previous Segment Selection
Know Oracle – A Full list of All articles
ERP and SCM Knowledge through books
ERP Strategy post Go Live
E-Business Suite 12.1.2 Release Content Documents Now Available (Oracle E-Business Suite Technology)
An Introduction to Procurement Management
How to remove / hide the ‘Edit Navigator’ button on the Homepage
My Personal Tips on Career Success
During Login Responsibilities Assigned to Users do not Appear in the Navigator Page
Video Tutorial – Oracle BPEL – Hello World Example
Oracle Applications – AP/AR Netting
Forms Personalization – Get It While It’s Hot! (Oracle E-Business Suite Technology)
Oracle Trading Community Architecture (TCA)
Oracle Purchasing Training
Brief guideline for Oracle PL/SQL coding standard
List of all documents published on KnowOracle
Oracle Database -External Table – How to populate/ outbound file creation using External table
How companies get their name ! Interesting
SQL script to assist in the identification of Projects revenue issues
Oracle Apps 11i – Keyboard Shortcuts
Display the number value in Words
Oracle PL/SQL – Introduction – Tutorial
The Invoice does not go on Hold with “Quantity billed exceeds quantity received” when Matched to a Purchase Order
Oracle EBS – Commonly used / basic Unix commands
Oracle – Technical FAQ – Part 3
Oracle workflow – How To Get Workflow Definition Stored In The DB?
Oracle Apps Tuning – How to Run Statement Level/Java trace or a SQL Trace in Self Service Application
Period Close: Critical Steps and Overview of Period Closing Issues
I Wanted To Change The World
How To Enter Internet Expense Reports For Other Persons
Some golden words , In Hindi and translated in English
-Video Tutorial – Oracle Architecture in less than 10 minutes
A Beginner’s Overview on Oracle SQL*Loader
Extra tips – Team Work – Hare and Tortoise Story
Oracle R12 Legal Entity
Convert Custom Reports to BI Publisher
Oracle AR – Trading Community Architecture- Training
HTML Option for My Oracle Support Now Available
Oracle BPEL Presentation
Unix Commonds and their Usage
Shivmohan – A View on Soft Skills
Oracle R12 EBS Tech Essentials
Oracle Apps Interview Questions
Life is Short – Enjoy your coffee
How can we retrieve data from standard Oracle Applications view?
Oracle Business Accelerators for EBS
How To Identify Where An Expense Report Is In the Process
Unix Command Line Productivity Tips and Unix Shell Scripting Basics
How to trace Web Session in Oracle Applications
How To Attach A Document Link To A Self Service Page Via Personalizations?
How to delete a date track change in assignment record?
Oracle Database : External Tables Overview and Usage
Oracle-Developer-in-Eclipsys-Pune-India
How to Remove the Worklist from Appearing on the HomePage
Oracle EBS – Why does Help > Tools > Examine ask for a password?
soccer world cup – FIFA world cup – 2010
Oracle 11g – Replacing Sensitive Data Using the Data Masking Pack
Cost Accounting – An introduction
Best Practices around Oracle E-Business Suite Implementation
Oracle 11i/ R12 – Contact Us Link – in Internet Expenses
14 Steps To Develop Patience – :-) Very useful for me
Important things to focus as you are 0 to 2 Year experience in Oracle Applications Technical
Oracle 11i / R12 – How To : How To Disable The Personal Profiles Form
Oracle Projects Conversion
Oracle Apps Basics – Session Context (via Oracle Apps Tech Blog)
Commong SQL PLUS Commands
Min-Max Planning and Move Orders
Data encryption for ERP sensitive data (HR and Finance)
Oracle EBS– Regularly Asked Interview Question – Good for Beginners
Oracle R12, 11i Navigation – ‘Close Other Forms’ Option ( Tools –> Close other forms – check box )
#1637 (deleted)
Oracle Account Payable Training
Way to become expert – Practice, Practice, Practice & Learn.
Famous quotes in pictures – from slideshare
Oracle DBA handbook
Keep the Spark – Get Inspired
Oracle Jobs in Mumbai, Bangalore, Chennai and Other Cities in India
How To Setup A Custom Concurrent Host Program
Advanced Sql Training
How To Run SQL as An Applications Mode in SQL*PLUS
Shivmohan – Oracle E-Business Suites
How to insert or update a database column based on some calculation using Forms Personalization
Oracle Insall Base and Service Contracts Overview
Oracle Self-Service Framework Information
PL/SQL Best Practices
Oracle EBS – Top Ten List on Navigator form
Oracle iExpense – How To Configure Expense Report Numbers?
Oracle 11i/ R12 – How To Determine If A Company Has Single Business Group/Single Operating Unit
Oracle 11i – Essentials for Oracle Implementers
Oracle Apps – How To Prevent Changing Or Deleting Of An Attachment?
Oracle Training – Navigating in Oracle E-Business Suite R12
Common Mistakes in Oracle PL/SQL Programming
Some Basic questions about Oracle Applications
Oracle iExpense – Expense report with “-1″ suffix
Oracle Time : How to modify the timecard expenditure type LOV
Oracle EBS – Changing Main Form’s Heading – Site Name Profile Option
Important Lessons Learnt From Rocket Singh
Oracle APPS R12 Architecture – Technical Overview
ETL – Discussion from Development Perspective
Learning New Tools – A Perspective
Oracle EBS – Documents Tab on the Navigator
KnowOracle – Starting with Video Tutorials
Opening in My team – Sr. Oracle Developer/ Analyst in Eclipsys, Pune, India
Attitute – You can Choose
Oracle Database locking in detail
Oracle Technical – A Poem using Oracle Concepts
Oracle Purchasing – SQLs to debug / investigate PO issues
How to Set Printing Parameters for a Concurrent Program Run Via CONCSUB
Essential of Financial Accounting
Display the Database Version and Server Operating System Name
The Art of Appraisal – A Close and Real – A funny touch
Overview Session on AME – Approval Management Engine
Deleting a Schedules Request
UTL_FILE: Writing a File to the File System
Oracle Order Management – Sales Order Status – Brief explaination
A Sunday Story – Everyone is working hard, fighting a battle
11i – Oracle E-Business Suite Custom Library – Oracle forms
Oracle HRMS – E-Mail Address or any particular field needs to be Changed For All Employees
Exclusive Document – Download as in PDF
Oracle EBS – Fixed Assets : Overview
Extra tips : Learnings from Good Managers v/s Bad Managers
How To Determine If An Invoice Was Created For A Self Service Expense Report?
AME – Approval Management Engine – Presentation
Extra Tips : Managing team conflict
Oracle iExpense – How to authorize an employee to enter expense reports for another employee
How to be a Programmer: A Short, Comprehensive, and Personal Summary
Oracle Database Startup & Shutdown Process
Oracle Approvals Management (AME)
Oracle Audit Vault – Overview
Steve Job – Presentation Secrets

 

Oracle EBS – Inventory Organization – Overview


Information on multiple types of organizations used to build the business execution structure.

Oracle Inventory Organizations

Oracle Applications uses multiple types of organizations to build the business execution structure. At the top of the structure is the accounting set of books SOB), defined in the General Ledger. Next, different types of organizations are used to further define the organization structure and relationships. All organizations are defined and updated with the Define Organization form.

Set of Books. A General Ledger SOB, linked to the inventory organization, controls the financial accounting of inventory transactions. A SOB is made up of a chart of accounts, a financial calendar, and a currency. The general ledger secures transactions (journal entries, balances) by SOB.

Legal Entity. A legal entity organization defines the tax and fiscal reporting level. The legal entity represents the legal company.

Operating Unit. An operating unit organization defines the Purchasing, Order Entry, Accounts payable and Accounts Receivable level of operation. An operating unit may span multiple manufacturing facilities, distribution points and sales offices, or it may be limited to a single site.

Inventory Organization. Two flavors of inventory organizations are found in Oracle Applications. They are defined the same, and both are assigned a set of books, a legal entity organization, an operating unit organization, and a location. An item master organization is used for item number maintenance and validation. This master organization serves as a data repository storing items
and item attributes, master level categories and category sets, master level cross references, and numerous data defaults. On-hand balances, inventory movements, and other on-going inventory activities are not performed in an item master organization. Generally, the master organization is used as the validation organization for Purchasing and Order Entry. It is recommended that a single item Master organization be defined, even in multiple organization, multiple sets of books environments.

In addition to the item master organization there are one or more non-master inventory organizations. Like the item master inventory organization, the non-master organizations are assigned a set of books, a legal entity organization and an operating unit organization. The non-master inventory organization points to a master organization and looks to the master organization for master level item attributes, master level categories, and other master level controlled data.
Note that each organization has its own set of books/legal entity/operating unit relationship, so inventory organizations with differing SOB’s or operating units may share the same master organization.

These non-master inventory organizations are the execution level organizations. They hold on-hand balances and transaction history. Here is where inventory users execute their daily activities, such as receiving and issuing material, performing cycle counts, and viewing material availability and transaction history. A single organization therefore generally represents a single manufacturing site or distribution center.

Locations. A location code is an address. Each inventory organization must be assigned at least one location code.

Subinventories. A subinventory is used as a holding point for on-hand inventory and generally represents a stockroom, stocking area or cage used for storing material. Subinventories are defined within inventory organizations. An inventory organization may have any number of subinventories, and an asset account is assigned to each subinventory. Since the subinventory entity is logical, as there is not an address or physical location description associated with it, clients may define subinventories for any physical or logical grouping of inventory.

Examples of subinventories:

Stores. Used for the primary stockroom for storing raw materials and sub-assemblies FG. Used for Finished Goods inventory if finished goods are stocked WIP. Used for raw material and sub-assemblies stored in production areas and issued at operation or job completion (backflush). MRB. Used for Material Review Board goods. This is generally material that requires engineering review before disposition as scrap, rework, return to supplier or use as is.

Stock Locators. Stock locators are an optional entity that may be used to represent physical locations within a subinventory. You may choose to use stock locators for selected subinventories or selected items within selected subinventories. If locators are used, subinventory and locator track on-hand balances. Therefore, if locators are defined to represent a shelf within a stockroom, on-hand balances on the system would show the item and quantity down to the physical location within the facility.

Oracle Inventory uses a key flexfield for stock locators. This presents a few limitations for its use. Only one locator flexfield definition is allowed per install. Therefore, if the stockroom (subinventory) wants to track material by row, bin and shelf, it will likely define a three-segment flexfield with segments for row, bin, and shelf. If locators are desired for another subinventory, even in another organization, the structure will again be 3 segments for row, bin and shelf. In addition to this limitation, locators must be unique within an organization; you cannot use the same locator in different subinventories within an organization, but you can use the same locator in subinventories in a different organization.