Apr 17, 2013

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

What is Global Temporary Tables


What is Global Temporary Tables???

Applications often use some form of temporary data store for processes that are to complicated to complete in a single pass. Often, these temporary stores are defined as database tables or PL/SQL tables. In Oracle 8i, the maintenance and management of temporary tables can be delegated to the server by using Global Temporary Tables.

Creation of Global Temporary Tables

The data in a global temporary table is private, such that data inserted by a session can only be accessed by that session. The session-specific rows in a global temporary table can be preserved for the whole session, or just for the current transaction. The ON COMMIT DELETE ROWS clause indicates that the data should be deleted at the end of the transaction.
CREATE GLOBAL TEMPORARY TABLE my_temp_table (
  column1  NUMBER,
  column2  NUMBER
) ON COMMIT DELETE ROWS;
In contrast, the ON COMMIT PRESERVE ROWS clause indicates that rows should be preserved until the end of the session.
CREATE GLOBAL TEMPORARY TABLE my_temp_table (
  column1  NUMBER,
  column2  NUMBER
) ON COMMIT PRESERVE ROWS;

Miscellaneous Features

  • If the TRUNCATE statement is issued against a temporary table, only the session specific data is trucated. There is no affect on the data of other sessions.
  • Data in temporary tables is automatically delete at the end of the database session, even if it ends abnormally.
  • Indexes can be created on temporary tables. The content of the index and the scope of the index is that same as the database session.
  • Views can be created against temporary tables and combinations of temporary and permanent tables.
  • Temporary tables can have triggers associated with them.
  • Export and Import utilities can be used to transfer the table definitions, but no data rows are processed.
  • There are a number of restrictions related to temporary tables but these are version specific.

What is FNDLOAD?


What is FNDLOAD: when we are working in oracle application development/implementation project? The equally important AOL data Migration takes place necessary to synchronize the data across databases instance during installation and upgarde.

Using FNDLOAD can download data from an application entity into an editable text file, which can be uploaded to another database.The Conversion between database format and text file format is specified by a configuration file.

It can be done following list
· Concurrent Programs, Executables
· Request Groups, Request Sets
· Profile Options
· Key and Descriptive Flexfields
· Menus and Responsibilities
· Forms and Form Functions
· Attachments
· Messages
· Value Sets and Values
· Lookup Types
· User Responsibilities
· Printer Definitions
· FND Dictionary
· Help Configuration
· Document Sequences
· Concurrent Manager Schedules
 
Advantages when using FNDLOAD
1. Because downloaded data is stored in a text file, version administration is possible
2. No learning curve. this is relief for developer/dbas
3. Fully supported and recommended by Oracle
4. Capture the migrations in a file and use it during installations(log file).
5. Pin-point when something happened and where (database) easily
6. AOL data migration process is now simplified!

Disadvantages
1. Applications patching mechanisms use FNDLOAD heavily possibility of negative impact is not zero
2. No validation against migrating database/instance sensitive data
 
The Syntax
To use FNDLOAD, the following syntax is needed.
FNDLOAD apps/appspwd 0 Y mode configfile datafile entity [parameter1.....]

· The mode is either DOWNLOAD or UPLOAD.
· The configfile is the file that Fndload needs to download on upload data.
· T he data file is the output file, in which the downloaded data is written
· The entity is the entity you want to download

Example of download:
FNDLOAD apps/pwd 0 Y DOWNLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt \ PROGRAM CONCURRENT_PROGRAM_NAME= concurrent_program_short_name> APPLICATION_SHORT_NAME=application_short_name
Example of Upload
FNDLOAD apps/pwd 0 Y UPLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt – CUSTOM_MODE=FORCE undocumented parameter
Where is Config File Located

· Configuration files with extension .lct
o On Unix – all the configuration files are in $FND_TOP/patch/115/import directory
o On Unix Oracle also places the original configuration files in $FND_TOP/admin/import directory
·Data files with extension .ldt
· The configfiles (.lct) are delivered and maintained by Oracle
· It has entity definitions, parent-child relationships and user input parameters identified by :NAME
oDownloading a parent automatically downloads all children – (Example) Concurrent Program download


Sample Script Code for these Objects:
1 – Printer Styles
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME=printer style name
2 – Lookups
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=prod LOOKUP_TYPE=lookup name
3 – Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL=?COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME=prod DESCRIPTIVE_FLEXFIELD_NAME=desc flex name P_CONTEXT_CODE=context name
4 – Key Flexfield Structures
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL=?COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL? APPLICATION_SHORT_NAME=prod ID_FLEX_CODE=key flex code P_STRUCTURE_CODE=structure name
5 – Concurrent Programs
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME=prod CONCURRENT_PROGRAM_NAME=concurrent name
6 – Value Sets
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME=value set name
7 – Value Sets with values
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=value set name
8 – Profile Options
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME=profile option APPLICATION_SHORT_NAME=prod
9 – Requset Group
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME=request group APPLICATION_SHORT_NAME=prod
10 – Request Sets
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME=prod REQUEST_SET_NAME=request set
11 – Responsibilities
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY=responsibility
12 – Menus
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME=menu_name
13 Forms/Functions
FNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES The Upload syntax for all styles: FNDLOAD apps/apps@seed115 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt

14. User/Responsibilities

FNDLOAD apps/apps@seed115 0 Y DOWNLOAD @FND:patch/115/import/afscursp.lct file_name.ldt FND_USER Then UPLOAD FNDLOAD apps/apps@seed115 0 Y UPLOAD [UPLOAD_PARTIAL] @FND:patch/115/import/afscursp.lct file_name.ldt FND_USER []


Oracle Order Management Overview



Oracle Order Management Overview::

High-Quality Customer Service
You can set up customer defaults for shipping and billing preferences. Sales orders and returns defaults expedite the entry process as well as the order copy. Users are allowed to check product availability and optionally reserve inventory during Order Entry/Shipping.

Efficient Sales Order Management
You can define flexible order cycles that meet the routing, approval revenue, and inventory requirements of all your sales channels. Sales orders enter your system immediately and are visible to every branch of your organization.

Effective Order Controls
You can control the order processing by defining when to hold order lines for approval and who can apply or release each hold. Oracle Order Entry/Shipping automatically checks a customer’s credit status against the credit profile. It also automatically prices your orders as you enter them, using the pricing and discounting rules you define.

Flexible Shipping
You can partially or completely ship a delivery to a specific customer. You can also create a departure, assign deliveries to the departure, and ship or backorder the departure.
For Alcoa AEP, shipping functionality will be handled by Oracle and Clear Orbit Software applications.  


Key Features of Order Management::
Order Processing
·           Create order cycles with only the steps needed to control order processing.
·           Use any number of order cycles to meet the needs of your sales channels.
·           Increase control with approval steps.
Sales Orders
·           Speed Order Entry/Shipping with user-defined defaults and order templates.
·           Automate item pricing and discounts.
·           Create a single order for multiple shipments and different dates, Ship To addresses, shipping methods, and shipping sites.
·           Control order updates with security rules.
Pricing and Discounting
·           Create flexible, multilevel, currency-based price lists.
·           Create automatic and manual discounts based on item, item category, customer, customer classes, customer agreement, purchase order, or order type.
·           Create fixed-amount, percentage, dollar, or unit volume discounts.
·           Create rule-based pricing structures.

Key Features of Order Management

Delivery-Based Shipping
·           Ship a delivery partially or completely to a specific customer.
·           Create a departure, assign deliveries to the departure, and ship or backorder the departure.
·           Control the confirmation of partial shipments.
·           Record multiple freight costs for a pick slip.
·           Enter individual and ranges of serial numbers for item control.

Drop Shipments
·           Determine the item to be fulfilled from warehouse or sourced externally at entry time or scheduling.
·           Reduce order fulfillment time by streamlining the process to create purchase orders, releases, or requisitions for the drop shipment order.
·           Track the purchase orders status for the drop shipment order.
·           Invoice your customers after the products have been shipped.
·           Process drop shipment return to supplier or receive products into your inventory.

Order Holds
·           Apply holds to items, customers, sites, or orders.
·           Hold orders at any step of the order process.
·           Control hold updates by user.
·           Track holds that you place and remove.

Key Features of Order Management

Credit Checking
·           Check credit automatically during Order Entry/Shipping and Pick Release.
·           Set customer limits per order and for all orders.
·           Assign tolerances to single-order and total-order limits.

Returns
·           Enter returns by item, order, purchase order, or invoice.
·           Create replacement orders.
·           Automatically create applied credit memos or on-account credits.

Open Interfaces
·           Import sales orders and order changes from other systems (Order Import).
·           Import shipment confirmation and update shipping details from data collection devices or shipping systems (Update Shipping).

OraApps Search

Custom Search

Search This Blog