Difference between Oracle apps 11i
& R12
Summary of Changes:
|
Component
|
Release 11i
|
Release 12
|
|
Database
|
9.2
|
10.2
|
|
Developer
|
6i
|
10i
|
|
Application Server
|
1.0
|
10.1
|
|
Client Plug-in
|
Jinitiator
|
SUN JRE
|
|
Java Containers
|
Jserv
|
OC4J
|
Changes in Detail :
|
APPMGR
|
||
|
OLD
|
NEW
|
|
|
APPL_TOP
|
$HOME/
|
$HOME/apps/apps_st/appl
|
|
COMMON_TOP
|
$HOME/
|
$HOME/apps/apps_st/comn
|
|
ORACLE_HOME
|
$HOME/
|
$HOME/apps/tech_st/10.1.2
|
|
IAS_ORACLE_HOME
|
$HOME/
|
$HOME/apps/tech_st/10.1.3
|
|
ORACLE
|
||
|
OLD
|
NEW
|
|
|
ORACLE_HOME
|
$HOME/
|
$HOME/db/tech_st/10.2.0
|
|
ORADATA
|
$HOME/
|
$HOME/db/apps_st/data
|
|
INST_TOP (New Addition)
|
||
|
OLD
|
NEW
|
|
|
INST_TOP
|
NA
|
$HOME/inst/apps/
|
What’s new in Oracle Apps R12
Key points to Note:
Key points to Note:
1. Oracle Applications Release 12 is the
latest release in the chain of E-Business Suite Releases by Oracle.
3. Autoconfig will not write anything in
APPL_TOP, COMMON_TOP area in R12.
4. All instance specific configurations,
log files are written in INST_TOP area. This home provides the ability to share
Applications and technology stack.
R12 new features
1. Applications Server 9i is replaced by
10g (10.1.3.X)
2. Forms & Reports Version 6i
(8.0.6) are replaced by Forms & Reports Version 10g i.e. 10.1.2.X
3. mod_jserv is replaced by oc4j
4. Java/ JDK version 1.3.X or 1.4.X will
be replaced by JDK 1.5.X
Techstack Components Changes
·
Database (RDBMS_ORACLE_HOME) - 10.2.0.2
·
FORMS ORACLE_HOME (8.0.6 ORACLE HOME equivalence) - 10.1.2
·
OC4J_ORACLE_HOME (iAS ORACLE_HOME equivalence) - 10.1.3
File system level changes
·
A new top INSTANCE_TOP is introduced in Release 12 for
configuration and log files along with the other TOP's in existing in 11i.
·
All instance specific configurations, log files are written in
INST_TOP area.
·
This home provides the ability to share Applications and
technology stack.
What is INSTANCE TOP
·
Instance home is the top-level directory for an applications
instance which is known as Instance Home and is denoted the environment
variable $INST_TOP.
·
This contains all the config files, log files, SSL certificates
etc.
Advantages of new INSTANCE HOME
·
The additional Instance Home makes the middle tier easier to
manage and organized since the data is kept separate from the config files.
·
The Instance Home also has the ability to share the Applications
and Technology stack code across multiple instances.
·
Another advantage of the Instance Home is that the autoconfig
writes only in INST_TOP so APPL_TOP and ORACLE_HOME can also be made read only
file system if required.
what are the major difference between oracle 11i and R12 ?
Que: what are the major difference
between oracle 11i and R12 ?
Ans :
Ø 11i only forms basis application but R12 is
now forms and HTML pages.
Ø 11i is particularly in responsibility and
operating unit basis but R12 is multi operating unit basis.
Ø 11i is particularly in set of books using
and R12 using in ledgers.
Ø 11i in MRC Reporting level set of books
called reporting set of books but in R12 reporting ledgers called as reporting
currency. Banks are using at single operating unit level in 11i and ledgers
level using in R12.
Differences
between R12 & 11i.5.10 New R12 Upgrade to R12 – Pros and Cons Pros:
o Sub-ledger Accounting – The new Oracle
Sub-ledger Accounting (SLA) architecture allows users to customize the standard
Oracle accounting entries. As a result of Cost Management's uptake of this new
architecture, users can customize their accounting for Receiving, Inventory and
Manufacturing transactions.
o Enhanced Reporting Currency (MRC)
Functionality – Multiple Reporting Currencies functionality is enhanced to
support all journal sources. Reporting sets of books in R12 are now simply
reporting currencies. Every journal that is posted in the primary currency of a
ledger can be automatically converted into one or more reporting currencies.
o Deferred COGS and Revenue Matching – R12
provides the ability to automatically maintain the same recognition rules for
COGS and revenue for each sales order line for each period. Deferred COGS and
Deferred Revenue are thus kept in synch.
Cons:
o Resources – Availability of knowledgeable
resources
o Maturity – Though R12 is around since 2007,
not all the modules are mature enough meaning modules like E-B Tax have many
bugs being fixed by Oracle development.
o Integration with customized applications –
In a customized environment, all the extensions & interfaces need to be
analyzed because of the architectural changes in R12
R12 Features and differences with 11.5.10 –
Inventory / Cost Management
o Multi-Organization Access Control (MOAC) -
Multi-Org Access Control enables uses to access multiple operating units data
from single responsibility. Users can access reports , Concurrent programs ,
all setup screens of multiple operating units from single responsibility
without switching responsibilities.
o Unified Inventory - R12 merges Oracle
Process Manufacturing OPM Inventory and Oracle Inventory applications into a
single version . So OPM users can leverage the functionalities such as
consigned & VMI and center led procurement which were available only to discrete
inventory in 11i.5.10.
o Inventory valuation Reports -There are a
significant number of reports which have been enhanced in the area of Inventory
Value Reporting
o Inventory Genealogy - Enhanced genealogy
tracking with simplified, complete access at the component level to critical
lot and serial information for material throughout production.
o Fixed Component Usage Materials Enhancement
– Enhanced BOM setup screen and WIP Material Requirement screen that support
materials having a fixed usage irrespective of the job size for WIP Jobs, OSFM
lot-based jobs, or Flow Manufacturing
o Component Yield Enhancements - New
functionality that provides flexibility to control the value of component yield
factors at WIP job level. This feature allows the user to include or exclude
yield factor while calculating back flush transactions.
o Periodic Average Cost Absorption
Enhancements – Enhanced functionality for WIP Final Completion, WIP Scrap
Absorption, PAC WIP Value Report, Material Overhead Absorption Rule, EAM work
order, and PAC EAM Work Order Cost Estimate Processor Report.
o Component Yield benefits - Component yield
functionality user have the flexibility to control the value of component yield
factors and use those factors for back flush transactions. Of course if the
yield factor is not used, yield losses can be accounted for using the manual
component issue transaction.
New Features:
R12 Features and differences with 11.5.10 –
Advanced Procurement Suite
o Professional Buyer’s Work Center – To speed
up buyers’ daily purchasing tasks – view & act upon requisition demand,
create & manage orders and agreements, run negotiation events, manage
supplier information.
o Freight and Miscellaneous Charges – New
page for viewing acquisition cost to track freight & miscellaneous delivery
cost components while receiving. Actual delivery costs are tracked during
invoice matching.
o Complex Contract Payments – Support for
payments for services related procurement including progress payments,
recoupment of advances, and retainage.
o Unified Inventory – Support for the
converged inventory between Oracle Process Manufacturing – OPM Inventory &
Oracle Inventory.
o Document Publishing Enhancements – Support
for RTF & PDF layouts and publish contracts using user specified layouts
o Support for Contractor Purchasing Users –
Support for contingent workers to create & maintain requisitions, conduct
negotiations, and purchase orders.
New Features:
R12 Features and differences with 11.5.10 –
Order Management
o Multi-Organization Access Control (MOAC) -
Multi-Org Access Control enables uses to access multiple operating units data
from single responsibility. Users can access reports , Concurrent programs ,
all setup screens of multiple operating units from single responsibility
without switching responsibilities. They can also use Order Import to bring in
orders for different Operating Units from within a single responsibility. The
same applies to the Oracle Order Management Public Application Program
Interfaces (APIs).
o Post Booking Item Substitution - Item
Substitution functionality support has been extended to post-Booking through
Scheduling/re-scheduling in Sales Order, Quick Sales Order, and Scheduling
Order Organizer forms. Item Substitution functionality is also supported from
Planner’s Workbench (loop-back functionality) till the line is pick-released.
o Item Orderability - Businesses need the
ability to define which customers are allowed to order which products, and the
ability to apply the business logic when the order is created.
o Mass Scheduling Enhancements – Mass
Scheduling can now schedule lines that never been scheduled or those that have
failed manual scheduling. Mass Scheduling also supports unscheduling and
rescheduling
o Exception Management Enhancements –
Improved visibility to workflow errors and eases the process of retrying
workflows that have experienced processing errors
o Sales Order Reservation for Lot-Based Jobs
– Lot-Based Jobs as a Source of Supply to Reserve Against Sales Order(s). OSFM
Displays Sales Order Information on Reserved Jobs
o Cascading Attributes – Cascading means that
if the Order header attributes change, the corresponding line attributes change
o Customer Credit Check Hold Source Support
across Operating Units - Order Management honors credit holds placed on
customers from AR across operating Units. When Receivables places a customer on
credit hold a hold source will be created in all operating units which have:
§
A site defined for that customer
§
An order placed against that
customer.
New
Features:
R12 Features and differences with 11.5.10 –
Shipping
o Pick Release/Confirm Features
§
Pick Release enhancements -
Enhancements will be made to the Release Sales Order Form and the Release Rules
Form to support planned crossdocking and task priority for Oracle Warehouse
Management (WMS) organizations. Pick release will allow a user to specify
location methods and if crossdocking is required, a cross-dock rule. The task
priority will be able to be set for each task in a sales order picking wave
when that wave is pick released. The priority indicated at pick release will be
defaulted to every Oracle WMS task created
§
Parallel Pick Release Submission
- This new feature will allow users to run multiple pick release processes in
parallel to improve overall performance. By distributing the workload across
multiple processors, users can reduce the overall time required for a single
pick release run.
o Workflow Shipping Transaction Enhancement –
Oracle has enabled Workflow in the Shipping process for: workflow, process
workflow, activity and notification workflow, and business event
o Support for Miscellaneous Shipping
Transactions - Oracle Shipping Execution users will now be able to create a
delivery for a shipment that is not tied to a sales order via XML
(XML-equivalent of EDI 940 IN). Once this delivery has been created, users will
be able to print shipping documents, plan, rate, tender, audit and record the
issuance out of inventory. Additionally, an XML Shipment Advice (XML- equivalent
of EDI 945 OUT) will be supported to record the outbound transactions.
o Flexible Documents: With this new feature
,Shipping Execution users will be able to create template-based, easy-to-use
formats to quickly produce and easily maintain shipping documents unique to
their business. Additional attributes will be added to the XML templates for
each report for added flexibility
o Enhanced LPN Support - Oracle Shipping
Execution users will now have improved visibility to the Oracle WMS packing hierarchy
at Pick Confirmation. The packing hierarchy, including the License Plate Number
(LPN), will be visible in the Shipping Transactions form as well as in the
Quick Ship user interface.
New
Features:
R12 Features and differences with 11.5.10 –
Warehouse Management
o Crossdock Execution – WMS allow you to
determine final staging lane, merge with existing delivery or create a new
delivery, synchronize inbound operation plan with outbound consolidation plan,
enhance outbound consolidation plans and manage crossdock tasks.
o Labor Management – WMS provides labor
analysis. It gives the warehouse manager increased visibility to resource
requirements. Detailed information for the productivity of individual employees
and warehouses is provided
o Warehouse Control Board Additions -
Additional Task selection criteria
o User Extensible Label Fields – WMS, users
are now able to add their own variables without customizing the application, by
simply defining in SQL the way to get to that data element
o Material Consolidation across deliveries –
WMS allows you to consolidate material across deliveries in a staging lane
New Features:
R12 Features and differences with 11.5.10 –
OSFM
o Lot and Serial Controlled Assembly– Lot
controlled job can now be associated with serial numbers to track and trace
serialized lot/item during shop floor transactions as well as post
manufacturing and beyond
o Fixed Component Usage Support for Lot Based
Jobs – OSFM now supports fixed component usage defined in the Bill of Material
of an end it.
o Support for Partial Move Transactions –
Users are able to execute movement of a partial job quantity interoperation
o Enhanced BOM to Capture Inverse Usage –
Users can now capture the inverse component usage through the new inverse usage
field in BOM UI
o Support for Rosetta Net Transaction -
comprising of 7B1 (work in process) and 7B5 (manufacturing work order).
New Features:
R12 – Further Info…
o The latest RCD (Release Content Documents)
can be accessed from the metalink note 404152.1 (requires user name &
password).
o The TOI (Transfer Of Information) sessions released
by Oracle Learning can be accessed from its portal at http://
www.oracle.com/education/oukc/ebs.html
o Oracle
White papers – Extending the value of Your Oracle E-Business Suite 11i.10
Investment & Application Upgrades and Service Oriented Architecture
No comments:
Post a Comment