Friday, April 27, 2012

Oracle Business Accelerators reference Note

References

NOTE:1050253.1 - How Do I Qualify for Access to Oracle Business Accelerator for Business Intelligence Applications?
NOTE:1050267.1 - Training Requirements for Oracle Business Accelerator for Business Intelligence Applications
NOTE:409133.1 - How Do I Qualify for Oracle Business Accelerator Access for E-Business Suite?
NOTE:604885.1 - How to Attach Screen Shot of My OBA Training Completion Certificate?
NOTE:760414.1 - How Do I Qualify for Access to Oracle Business Accelerator for Agile?
NOTE:789175.1 - How Do I Qualify for Access to Oracle Business Accelerator for Supply Chain Planning with Demantra?
NOTE:793268.1 - How Do I Qualify for Access to Oracle Business Accelerator for Oracle Transportation Management?
NOTE:1144664.1 - How Do I Qualify for Oracle Business Accelerator Access for JD Edwards EnterpriseOne?

Thursday, April 26, 2012

AIM Methodology Documents


AIM


Definition
Operations
Analysis

Solution Design
Build

Transition

Production

Business Process Architecture














Business Requirements Definition














Business Requirements Mapping














Application and Technical Architecture














Module Design and Build














Data Conversion














Documentation














Business System Testing














Performance T esting













Adoption and Learning













Production Migration














Three Types Of Implementation
1] Firm Implementation : When u r implementing a new system i.e. From Scratch.
2] Roll Out : When u r implementing for a New OU for an existing BG.
3] Up gradation : when the co. is going for an up grdation eg. From 11.5.9 to 11.5.10

Phases In AIM

Definition : The project management team plans the implementation project. The goals are to identify business and system requirements, propose the future business model, and propose the application and information technology architecture.

Operations Analysis : During the Operations Analysis phase, the project team collects management, technical, and end-user business process information and requirements. The
project team develops business requirements scenarios used to assess the level of fit between the detailed business requirements and standard application functionality.

Solution Design : The goal of Solution Design is to create the optimal business process solution to
meet the future business requirements. During Solution Design, project team members design application configuration options and detailed business procedure documentation.

Build : During the Build phase, the development team codes and tests all custom extensions including application enhancements, conversions, and interfaces. The team creates and executes performance, integration and business system tests.

Transition : During transition, the project team deploys the finished application into the organization. Transition depends on the Build phase for the fully tested business system. The project team fully executes data conversion and uses the developed documentation to train end users and support staff.

Production : The Production phase starts immediately with the production cutover.
Production marks the last phase of the implementation and the beginning of the system support cycle.

Business Process Architecture (BP) : Business Process Architecture addresses the need to understand organization business processes and alignment with business requirements and target applications. The team analyzes business processes to determine the degree of change required to bring them into alignment with organization business objectives, and designs new or improved business processes.

BP.040 - Develop Current Process Model (Optional) : In this task, you examine the current business processes and practices to identify how the existing business system meets current business requirements.

BP.080 - Develop Future Process Model (Core) : In this task, you define the future business model in the form of integrated process flows built on the business processes supported by the new applications.

Business Requirements Definition (RD) : The Business Requirements Definition process defines the business needs that must be met for the successful implementation of the application and technical suite. The project team documents business processes by identifying business events and describing the steps the organization takes to respond to those events.

RD.020 - Conduct Current Business Baseline (Core) : In this task, you examine current processes and practices to understand and document the main activities that keep the organization operating today.

RD.050 - Gather Business Requirements (Core) : In this task, you define detailed business requirements and perform an initial assessment of application fit to these requirements.

Business Requirements Mapping (BR) : The Business Requirements Mapping process produces and documents an acceptable, feasible solution to business requirements. As gaps between requirements and functionality emerge, the team resolves the gaps by documenting alternative solutions, designing application extensions, or changing the underlying business process.

BR.010 - Analyze High-Level Gaps (Core) : The differences (gaps) revealed by this analysis need to be resolved by producing alternatives that balance change in the application against
change in processes and organization.

BR.030 - Map Business Requirements (Core) : In this task, you assess the fit of standard application and system features to detailed business requirements.

BR.040 - Map Business Data (Core) : In this task, you map the data elements from the legacy system to the target application modules, business objects, and attributes.

BR.070 - Conduct Reporting Fit Analysis (Core) : In this task, you are required to analyze and map every reporting requirement to both a future business process and standard application
report. This analysis determines the final disposition of every report requirement.

BR.100 - Define Application Setups (Core) : In this task, you capture the setup decisions and implement them in the appropriate environment

BR.110 - Design Security Profiles (Core) : In this task, you gather role and function information and relate them to application security and responsibilities. As business requirements are
established and mapped to application features, you also begin to define the user security necessary to support the selected alternative in a controlled environment.

Application and Technical Architecture (TA) : During the Application and Technical Architecture process, the project team designs an information systems architecture around the organization’s business vision. Included are Oracle, third-party and custom applications; computing hardware; and networks and data communications infrastructure.

Module Design and Build (MD) : The Module Design and Build process produces custom application extensions to fill gaps in functionality identified during Business Requirements Mapping. Custom systems include program modules (forms, reports, alerts, database triggers, and so on) that must be designed, built, and tested before they can be incorporated into the new system. Module Design and Build addresses the design and development of the custom modules; the Business System Testing process supports testing of custom modules.

Data Conversion (CV) : The Conversion process defines the tasks and deliverables required to convert legacy data to the Oracle Application tables. The first step of this process is to explicitly define the data business objects identified for conversion along with the legacy source systems. System testing, training, and acceptance testing require converted data before production cutover.

Documentation (DO) : The Documentation process begins with documentation standards materials created early in the project to build quality operation support reference materials. Documentation requirements and implementation complexity are closely correlated, and the amount and level of detail of documentation varies by project.

Business System Testing (TE) : The Business System Testing process is a integrated approach to testing the quality of all application system elements. It focuses on preparing for testing early in the project life cycle, linking testing requirements back to business requirements, and securing project testing resources.

TE.010 - Define Testing Requirements and Strategy (Core) : In this task, you identify the Business System Testing requirements and strategy to be used for the testing of the system.

TE.020 - Develop Unit Test Script (Optional) : In this task, you develop the script to test individual application extension components. The tests validate that the application extension
inputs, outputs, and processing logic function as designed.

TE.040 - Develop System Test Script (Core) : In this task, you develop the script to test the integration of application extensions with Oracle Applications modules. A system test script
contains detailed steps which testers follow to verify the system setup and the integrity of custom application extensions for supporting business processes.

TE.060 - Prepare Testing Environments (Core) : In this task, you install and configure one or more testing environments to support all testing activities.

TE.100 - Prepare Key Users for Testing (Core) : In this task, you provide basic training to key users participating in Business System Testing. A test environment is used to prepare key
users for testing.

TE.130 - Perform Acceptance Test (Core) : In this task, you support users in performing their acceptance test of the new production system. The acceptance test is performed in the
Production Environment. This task also involves scheduling the acceptance test team, support staff, and user facilities.

Performance Testing (PT) : The Performance Testing process helps the project team define, build, and execute a performance test on specific system configurations. This process provides a powerful and direct means of assessing the performance quality of your system. This assessment enables you to determine whether performance is acceptable, and to propose changes and perform tuning to correct any initial performance shortfall.

Adoption and Learning (AP) : The Adoption and Learning process accelerates the implementation team’s ability to work together through team building and organization-specific application learning. This process also helps determine human support requirements so that the organization structure and job roles align to meet new performance expectations resulting from the technology change. Learning needs of all personnel impacted by the implementation are considered, and appropriate training materials and learning events are developed and conducted.

AP.030 - Develop Project Team Learning Plan (Core) : In this task, you assess the learning requirements for the entire project team based on the project vision, charter, and scope in order to develop the learning paths aligned to project roles.

AP.040 - Prepare Project Team Learning Environment (Core) : In this task, you establish the technical and physical infrastructure required for the actual project team learning, including either installing a new application environment or preparing an existing application
environment.

AP.140 - Develop User Learning Plan (Core) : In this task, you create learning path approaches that allow users to become skilled in the new technologies, apply new/updated procedures, and fulfill their new roles.

AP.160 - Prepare User Learning Environment (Core) : In this task, you establish the technical and physical infrastructure required for the actual user learning, including preparing an environment that reflects the production applications environment.

Production Migration (PM) : The objective of the Production Migration process is to migrate the
organization, systems, and people to the new enterprise system. Following production cutover, additional objectives include monitoring and refining the production system and planning for the future. The Production Migration process encompasses transition to production readiness, production cutover, and post-production support.

PM.010 - Define Transition Strategy (Core) : In this task, you outline the business transition approach for migrating the system, organization, and people to production status.

PM.030 - Develop Transition and Contingency Plan (Core) : In this task, you develop the detailed transition plan for moving onto the production system, as well as an implementation contingency plan.

PM.040 - Prepare Production Environment (Core) : In this task, you set up, configure, and install the database and application software for the Production Environment.

PM.050 - Set Up Applications (Core) : In this task, you implement the required setups in all of the applications as part of your configuration.

PM.080 - Begin Production (Core) : In this task, you confirm that organization-wide use of all aspects of the production system is in place.

PM.100 - Maintain System (Core) : In this task, you execute the system management procedures. This task is performed in perpetuity.

Key Flexfields in Oracle E-Business Suite

The Oracle E-Business Suite products provide many key flexfields as integral parts of the products.

Note: Do not modify the registration of any key flexfield supplied with Oracle E-Business Suite. Doing so can cause serious application errors.

Key Flexfields by Flexfield Name

Here is a table listing many of the key flexfields in Oracle E-Business Suite, ordered by the name of the key flexfield.

Name Code Owning Application
Account Aliases MDSP Oracle Inventory
Accounting Flexfield GL# Oracle General Ledger
Activity Flexfield FEAC Enterprise Performance Foundation
AHL Route AHLR Complex Maintenance, Repair, and Overhaul
Asset Key Flexfield KEY# Oracle Assets
Bank Details KeyFlexField BANK Oracle Payroll
CAGR Flexfield CAGR Oracle Human Resources
Category Flexfield CAT# Oracle Assets
Competence Flexfield CMP Oracle Human Resources
Cost Allocation Flexfield COST Oracle Payroll
Grade Flexfield GRD Oracle Human Resources
Item Catalogs MICG Oracle Inventory
Item Categories MCAT Oracle Inventory
Job Flexfield JOB Oracle Human Resources
Location Flexfield LOC# Oracle Assets
Oracle Service Item Flexfield SERV Oracle Inventory
People Group Flexfield GRP Oracle Payroll
Personal Analysis Flexfield PEA Oracle Human Resources
Position Flexfield POS Oracle Human Resources
Public Sector Budgeting BPS Oracle Public Sector Budgeting
Sales Orders MKTS Oracle Inventory
Sales Tax Location Flexfield RLOC Oracle Receivables
Soft Coded KeyFlexfield SCL Oracle Human Resources
Stock Locators MTLL Oracle Inventory
System Items MSTK Oracle Inventory
Territory Flexfield CT# Oracle Receivables
Training Resources RES Oracle Learning Management
You use the flexfield code and the owning application to identify a flexfield when you call it from a custom form.

Note: that the following flexfields are single-structure seeded key flexfields: Account Aliases, Item Catalogs, Oracle Service Item Flexfield, Stock Locators, and System Items.

Key Flexfields by Owning Application

Here is a table listing many of the key flexfields in Oracle E-Business Suite, ordered by the application that "owns" the key flexfield. Note that other applications may also use a particular flexfield.

Owner Name Code
Oracle Assets Asset Key Flexfield KEY#
Oracle Assets Category Flexfield CAT#
Oracle Assets Location Flexfield LOC#
Oracle Complex Maintenance, Repair, and Overhaul AHL Route AHLR
Oracle Enterprise Performance Foundation Activity Flexfield FEAC
Oracle General Ledger Accounting Flexfield GL#
Oracle Human Resources CAGR Flexfield CAGR
Oracle Human Resources Competence Flexfield CMP
Oracle Human Resources Grade Flexfield GRD
Oracle Human Resources Job Flexfield JOB
Oracle Human Resources Personal Analysis Flexfield PEA
Oracle Human Resources Position Flexfield POS
Oracle Human Resources Soft Coded KeyFlexfield SCL
Oracle Inventory Account Aliases MDSP
Oracle Inventory Item Catalogs MICG
Oracle Inventory Item Categories MCAT
Oracle Inventory Sales Orders MKTS
Oracle Inventory Stock Locators MTLL
Oracle Inventory Oracle Service Item Flexfield SERV
Oracle Inventory System Items MSTK
Oracle Learning Management Training Resources RES
Oracle Payroll Bank Details KeyFlexField BANK
Oracle Payroll Cost Allocation Flexfield COST
Oracle Payroll People Group Flexfield GRP
Oracle Public Sectory Budgeting PSB Position Flexfield BPS
Oracle Receivables Sales Tax Location Flexfield RLOC
Oracle Receivables Territory Flexfield CT#

Tables of Individual Key Flexfields in Oracle E-Business Suite

The following sections contain a table for individual key flexfields in the Oracle E-Business Suite. These tables provide you with useful information, including:
  • Which application owns the key flexfield
  • The flexfield code (used by forms and routines that call a flexfield)
  • The name of the code combinations table
  • How many segment columns it has
  • The width of the segment columns
  • The name of the unique ID column (the CCID column)
  • The name of the structure ID column
  • Whether it is possible to use dynamic insertion with this key flexfield
Many of these key flexfield sections also contain information on the uses and purpose of the flexfield, as well as suggestions for how you might want to implement it at your site.

Account Aliases

The following table lists details for this key flexfield.

Owner Oracle Inventory
Flexfield Code MDSP
Table Name MTL_GENERIC_DISPOSITIONS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column DISPOSITION_ID
Structure Column ORGANIZATION_ID
This key flexfield supports only one structure.

Accounting Flexfield

The following table lists details for this key flexfield.

Owner Oracle General Ledger
Flexfield Code GL#
Table Name GL_CODE_COMBINATIONS
Number of Columns 30
Width of Columns 25
Dynamic Inserts Possible Yes
Unique ID Column CODE_COMBINATION_ID
Structure Column CHART_OF_ACCOUNTS_ID
The Accounting Flexfield is fully described in the Oracle General Ledger documentation.

Asset Key Flexfield

The following table lists details for this key flexfield.

Owner Oracle Assets
Flexfield Code KEY#
Table Name FA_ASSET_KEYWORDS
Number of Columns 10
Width of Columns 30
Dynamic Inserts Possible Yes
Unique ID Column CODE_COMBINATION_ID
Structure Column None
Oracle Assets uses the asset key flexfield to group your assets by non-financial information. You design your asset key flexfield to record the information you want. Then you group your assets by asset key so you can find them without an asset number.

Warning: Plan your flexfield carefully. Once you have started entering assets using the flexfield, you cannot change it.

Bank Details KeyFlexField

The following table lists details for this key flexfield.

Owner Oracle Payroll
Flexfield Code BANK
Table Name PAY_EXTERNAL_ACCOUNTS
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column EXTERNAL_ACCOUNT_ID
Structure Column ID_FLEX_NUM
The Bank Details KeyFlexfield [sic] holds legislation specific bank account information. The Bank Details structure that you see is determined by the legislation of your Business Group.
Localization teams determine the data that is held in this flexfield. Each localization team defines a flexfield structure that allows you to record the bank account information relevant to each legislation.
If you are using a legislation for which a Bank KeyFlexfield structure has been defined you should not modify the predefined structure.

Warning: You should not attempt to alter the definitions of the Bank Details Flexfield which are supplied. These definitions are a fundamental part of the package. Any change to these definitions may lead to errors in the operating of the system.
It is possible that Oracle Human Resources will use the other segments of this flexfield in the future. Therefore, you should not try to add other segments to this Flexfield. This may affect your ability to upgrade the system in the future.
Consult your Oracle Human Resources National Supplement for the full definition of your Bank Details Flexfield.

Category Flexfield

The following table lists details for this key flexfield.

Owner Oracle Assets
Flexfield Code CAT#
Table Name FA_CATEGORIES
Number of Columns 7
Width of Columns 30
Dynamic Inserts Possible No
Unique ID Column CATEGORY_ID
Structure Column None
Oracle Assets uses the category flexfield to group your assets by financial information. You design your category flexfield to record the information you want. Then you group your assets by category and provide default information that is usually the same for assets in that category.

Warning: Plan your flexfield carefully. Once you have started entering assets using the flexfield, you cannot change it.

Cost Allocation Flexfield

The following table lists details for this key flexfield.

Owner Oracle Payroll
Flexfield Code COST
Table Name PAY_COST_ALLOCATION_KEYFLEX
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column COST_ALLOCATION_KEYFLEX_ID
Structure Column ID_FLEX_NUM
You must be able to get information on labor costs from your payrolls, and send this information to other systems. Payroll costs must of course go to the general ledger. Additionally, you may need to send them to labor distribution or project management systems.
The Cost Allocation Flexfield lets you record, accumulate and report your payroll costs in a way which meets the needs of your enterprise.

Grade Flexfield

The following table lists details for this key flexfield.

Owner Oracle Human Resources
Flexfield Code GRD
Table Name PER_GRADE_DEFINITIONS
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column GRADE_DEFINITION_ID
Structure Column ID_FLEX_NUM
Grades are used to represent relative status of employees within an enterprise, or work group. They are also used as the basis of many Compensation and Benefit policies.

Item Catalogs

The following table lists details for this key flexfield.

Owner Oracle Inventory
Flexfield Code MICG
Table Name MTL_ITEM_CATALOG_GROUPS
Number of Columns 15
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column ITEM_CATALOG_GROUP_ID
Structure Column None
This key flexfield supports only one structure.

Item Categories

The following table lists details for this key flexfield.

Owner Oracle Inventory
Flexfield Code MCAT
Table Name MTL_CATEGORIES
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column CATEGORY_ID
Structure Column STRUCTURE_ID
You must design and configure your Item Categories Flexfield before you can start defining items since all items must be assigned to categories.
You can define multiple structures for your Item Categories Flexfield, each structure corresponding to a different category grouping scheme. You can then associate these structures with the categories and category sets you define.

Job Flexfield

The following table lists details for this key flexfield.

Owner Oracle Human Resources
Flexfield Code JOB
Table Name PER_JOB_DEFINITIONS
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column JOB_DEFINITION_ID
Structure Column ID_FLEX_NUM
The Job is one possible component of the Employee Assignment in Oracle Human Resources. The Job is used to define the working roles which are performed by your employees. Jobs are independent of Organizations. With Organizations and Jobs you can manage employee assignments in which employees commonly move between Organizations but keep the same Job.
You use the Job Flexfield to create Job Names which are a unique combination of segments. You can identify employee groups using the individual segments of the Job whenever you run a report or define a QuickPaint.

Location Flexfield

The following table lists details for this key flexfield.

Owner Oracle Assets
Flexfield Code LOC#
Table Name FA_LOCATIONS
Number of Columns 7
Width of Columns 30
Dynamic Inserts Possible Yes
Unique ID Column LOCATION_ID
Structure Column None
Oracle Assets uses the location flexfield to group your assets by physical location. You design your location flexfield to record the information you want. Then you can report on your assets by location. You can also transfer assets that share location information as a group, such as when you move an office to a new location.
Warning: Plan your flexfield carefully. Once you have started entering assets using the flexfield, you cannot change it.

People Group Flexfield

The following table lists details for this key flexfield.

Owner Oracle Payroll
Flexfield Code GRP
Table Name PAY_PEOPLE_GROUPS
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column PEOPLE_GROUP_ID
Structure Column ID_FLEX_NUM
The People Group flexfield lets you add your own key information to the Employee Assignment. You use each segment to define the different groups of employees which exist within your own enterprise. These may be groups which are not identified by your definitions of other Work Structures.

Personal Analysis Flexfield

The following table lists details for this key flexfield.

Owner Oracle Human Resources
Flexfield Code PEA
Table Name PER_ANALYSIS_CRITERIA
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column ANALYSIS_CRITERIA_ID
Structure Column ID_FLEX_NUM
The Personal Analysis Key Flexfield lets you add any number of Special Information Types for people. Each Special Information Type is defined as a separate flexfield structure for the Personal Analysis Flexfield.
Some common types of information you might want to hold are:
  • Qualifications
  • Language Skills
  • Medical Details
  • Performance Reviews
  • Training Records
Each structure can have up to 30 different segments of information.

Position Flexfield

The following table lists details for this key flexfield.

Owner Oracle Human Resources
Flexfield Code POS
Table Name PER_POSITION_DEFINITIONS
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column POSITION_DEFINITION_ID
Structure Column ID_FLEX_NUM
Positions, like Jobs, are used to define employee roles within Oracle Human Resources. Like Jobs, a Position is an optional component of the Employee Assignment. However, unlike Jobs, a Position is defined within a single Organization and belongs to it.
Positions are independent of the employees who are assigned to those positions. You can record and report on information which is directly related to a specific position rather than to the employee.

Sales Orders

The following table lists details for this key flexfield.

Owner Oracle Inventory
Flexfield Code MKTS
Table Name MTL_SALES_ORDERS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible Yes
Unique ID Column SALES_ORDER_ID
Structure Column None
The Sales Orders Flexfield is a key flexfield used by Oracle Inventory to uniquely identify sales order transactions Oracle Order Management interfaces to Oracle Inventory.
Your Sales Orders Flexfield should be defined as Order Number, Order Type, and Order Source. This combination guarantees each transaction to Inventory is unique.
You must define this flexfield before placing demand or making reservations in Oracle Order Management.

Sales Tax Location Flexfield

The following table lists details for this key flexfield.

Owner Oracle Receivables
Flexfield Code RLOC
Table Name AR_LOCATION_COMBINATIONS
Number of Columns 10
Width of Columns 22
Dynamic Inserts Possible Yes
Unique ID Column LOCATION_ID
Structure Column LOCATION_STRUCTURE_ID
The Sales Tax Location Flexfield is used to calculate tax based on different components of your customers' shipping addresses for all addresses in your home country.

Oracle Service Item Flexfield

The following table lists details for this key flexfield.

Owner Oracle Service
Flexfield Code SERV
Table Name MTL_SYSTEM_ITEMS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column INVENTORY_ITEM_ID
Structure Column ORGANIZATION_ID
The Service Item flexfield uses the same table as the System Item Flexfield. However, you can set up your segments differently with the Service Item Flexfield.

Soft Coded KeyFlexfield

The following table lists details for this key flexfield.

Owner Oracle Human Resources
Flexfield Code SCL
Table Name HR_SOFT_CODING_KEYFLEX
Number of Columns 30
Width of Columns 60
Dynamic Inserts Possible Yes
Unique ID Column SOFT_CODING_KEYFLEX_ID
Structure Column ID_FLEX_NUM
The Soft Coded KeyFlexfield holds legislation specific information. The Soft Coded KeyFlexfield structure that a user will see is determined by the legislation of the Business Group.
Localization teams determine the data that is held in this flexfield. Each localization team defines a flexfield structure and uses qualifiers to define the level at which each segment is visible. Segments can be seen at business group, payroll or assignment level. The type of information that is held in this key flexfield varies from legislation to legislation.
If you are using a legislation for which a Soft Coded KeyFlexfield structure has been defined you should not modify the predefined structure.

Stock Locators

The following table lists details for this key flexfield.

Owner Oracle Inventory
Flexfield Code MTLL
Table Name MTL_ITEM_LOCATIONS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible Yes
Unique ID Column INVENTORY_LOCATION_ID
Structure Column ORGANIZATION_ID
You can use the Stock Locators Flexfield to capture more information about stock locators in inventory. If you do not have Oracle Inventory installed, or none of your items have locator control, it is not necessary to set up this flexfield.
If you keep track of specific locators such as aisle, row, bin indicators for your items, you need to configure your Stock Locators Flexfield and implement locator control in your organization.
This key flexfield supports only one structure.

System Items (Item Flexfield)

The following table lists details for this key flexfield.

Owner Oracle Inventory
Flexfield Code MSTK
Table Name MTL_SYSTEM_ITEMS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column INVENTORY_ITEM_ID
Structure Column ORGANIZATION_ID
You can use the System Items Flexfield (also called the Item Flexfield) for recording and reporting your item information. You must design and configure your Item Flexfield before you can start defining items.
All Oracle E-Business Suite products that reference items share the Item Flexfield and support multiple-segment implementations. However, this flexfield supports only one structure.

Territory Flexfield

The following table lists details for this key flexfield.

Owner Oracle Receivables
Flexfield Code CT#
Table Name RA_TERRITORIES
Number of Columns 20
Width of Columns 25
Dynamic Inserts Possible Yes
Unique ID Column TERRITORY_ID
Structure Column None
You can use the Territory Flexfield for recording and customized reporting on your territory information. Territory Flexfields are also displayed in the Transaction Detail and Customer Detail reports in Oracle Receivables.

Oracle Inventory Key Flexfields

Oracle Inventory provides the following flexfields:
  1. System Items
  2. Item Catalogs
  3. Item Categories
  4. Stock Locators
  5. Account Aliases
  6. Sales Orders
  7. Service Items
Depending on your system's setup, Inventory may also use some or all of the following
flexfields provided by other Oracle products:
  • Accounting (Oracle General Ledger)
  • Sales Tax Location (Oracle Receivables)
  • Territory (Oracle Receivables)
1. System Items
You can use the System Items Flexfield (also called the Item Flexfield) for recording and reporting your item information. You must design and configure your Item Flexfield before you can start defining items.


Owner Oracle Inventory
Flexfield Code MSTK
Table Name MTL_SYSTEM_ITEMS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column INVENTORY_ITEM_ID
Structure Column ORGANIZATION_ID



All Oracle Applications products that reference items share the Item Flexfield and support multiple-segment implementations. However, this flexfield supports only one structure.
You must set up your OE: Item Flexfield profile option to specify the Item Flexfield structure that you will use for your Oracle applications.
Users can also set up the OE: Item Flexfield Entry Method profile option to specify your preferred method of entry for this flexfield.
You can optionally use the item flexfield to default item information for invoice, debit memo, and credit memo lines or you can enter your own line information.
2. Item Catalogs
This key flexfield supports only one structure.


Owner Oracle Inventory
Flexfield Code MICG
Table Name MTL_ITEM_CATALOG_GROUPS
Number of Columns 15
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column ITEM_CATALOG_GROUP_ID
Structure Column None

 3. Item Categories
You must design and configure your Item Categories Flexfield before you can start defining items since all items must be assigned to categories. You can define multiple structures for your Item Categories Flexfield, each structure corresponding to a different category grouping scheme. You can then associate these structures with the categories and category sets you define.


Owner Oracle Inventory
Flexfield Code MCAT
Table Name MTL_CATEGORIES
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column CATEGORY_ID
Structure Column STRUCTURE_ID



4. Stock Locators
You can use the Stock Locators Flexfield to capture more information about stock locators in inventory. If you do not have Oracle Inventory installed, or none of your items have locator control, it is not necessary to set up this flexfield.
 
Owner Oracle Inventory
Flexfield Code MTLL
Table Name MTL_ITEM_LOCATIONS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible Yes
Unique ID Column INVENTORY_LOCATION_ID
Structure Column ORGANIZATION_ID

If you keep track of specific locators such as aisle, row, bin indicators for your items, you need to configure your Stock Locators Flexfield and implement locator control in your organization.
This key flexfield supports only one structure.
 
5. Account Aliases
This key flexfield supports only one structure.
 
Owner Oracle Inventory
Flexfield Code MDSP
Table Name MTL_GENERIC_DISPOSITIONS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column DISPOSITION_ID
Structure Column ORGANIZATION_ID
 
6. Sales Order
The Sales Order Flexfield is a key flexfield used by Oracle Inventory to uniquely identify sales order transactions Oracle Order Management interfaces to Oracle Inventory.

Owner Oracle Inventory
Flexfield Code MKTS
Table Name MTL_SALES_ORDERS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible Yes
Unique ID Column SALES_ORDER_ID
Structure Column None

Your Sales Order Flexfield should be defined as Order Number, Order Type, and Order Source. This combination guarantees each transaction to Inventory is unique. You must define this flexfield before placing demand or making reservations in Oracle Order Management.
You must set up the OM: Source Code profile option to determine the source code you will use in for the third segment of this flexfield to guarantee that each transaction is unique. (Oracle Inventory defaults the value of the OM: Source Code profile option to 'ORDER MANAGEMENT'.)
For your value sets, you must use Dynamic Inserts. The Validation Type should be None. Value Required should be Yes to improve performance of concurrent programs. The value set must be alphanumeric. The value set maximum size must be 40.
You should set the Required field to Yes in the Validation Information region when enabling the flexfield segments. Setting this field to Yes, improves performance when updating existing demand or reservations by guaranteeing that Oracle Order Management always supplies a value.
Set Right-justify Zero-fill Numbers to No so sales order numbers are not padded with zeros.
Oracle Inventory defines a unique ID for each order in MTL_SALES_ORDERS based on this flexfield. The Inventory unique ID, as opposed to the Order Management unique ID, is used throughout Oracle Manufacturing applications.

7. Service Items

The following table lists details for this key flexfield.

Owner Oracle Service
Flexfield Code SERV
Table Name MTL_SYSTEM_ITEMS
Number of Columns 20
Width of Columns 40
Dynamic Inserts Possible No
Unique ID Column INVENTORY_ITEM_ID
Structure Column ORGANIZATION_ID
The Service Item flexfield uses the same table as the System Item Flexfield. However, you can set up your segments differently with the Service Item Flexfield.